Is there a way to link a Payment to its Installment using SuiteQL? I've been struggling for a while to find a way to do this query. I can get most of my needed fields from the InvoiceInstallment table, but the Payment Date doesn't belong to this table. The only thing I've accomplished so far is to return the date, but with an error that returns me as many rows as the square of the Installment Number.

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that linking a Payment to its Installment using SuiteQL might be a complex task. The Installment is related to the Invoice, not the Payment. Therefore, pulling in Installment data by starting from the Payment record with a Saved Search might not be possible. However, it might be achievable with SuiteQL. One of the users suggested that there is an

Override Installments

checkbox that makes due date and amount editable in the UI. This could potentially be used to alter the invoice after creation to fit your business logic. However, it's important to note that this was a suggestion and might not work in all cases. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******