How does Netsuite link a payment to its installment when there is more than one installment? How does it always show the right payment date on the invoice page? What happens to not show multiple lines since there isn't an apparent installment id referencing to an individual payment?

AI generated answer (using internal Slack threads):

In NetSuite, when an invoice has multiple installments, each payment is linked to its respective installment based on the payment schedule defined in the invoice. The payment schedule is determined by the terms set on the invoice, which can be manually adjusted using the

Override Installments

checkbox. This allows for the due date and amount of each installment to be editable in the UI. The payment date displayed on the invoice page is the date when the payment was received or recorded in NetSuite. This date is automatically updated when a payment is applied to the invoice. To prevent multiple lines from showing up for each installment, NetSuite uses a combination of the invoice ID and the installment number to uniquely identify each payment. This way, each payment is linked to a specific installment of an invoice, and not to the invoice as a whole. In terms of scripting, while the installment due dates are not directly editable in the invoice, they can be manipulated via SuiteScript by leveraging the

Override Installments

checkbox. This allows for greater flexibility and customization in managing payment schedules. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

How can I use this logic to develop a query on SuiteQL and link the payment to its due installment?