if we applied a payment for multiple invoices how we can track the overpayment per invoice

AI generated answer (using internal Slack threads):

In NetSuite, if a customer overpays an invoice and you want to track the overpayment per invoice, you can do this by creating a saved search for invoices with applied transactions. This will allow you to see all invoices and if a payment has been applied, you will see the child payment(s) / credit memo(s). Here are the steps to create a saved search: 1. Go to Reports > Saved Searches > All Saved Searches > New. 2. Select Transaction. 3. In the Criteria subtab, set the Type to Invoice. 4. In the Results subtab, add the following fields: - Name (this will display the customer's name) - Document Number (this will display the invoice number) - Amount (this will display the invoice amount) - Applying Transaction (this will display the payment that was applied to the invoice) - Applying Transaction Amount (this will display the amount of the payment that was applied to the invoice) 5. Save the search. This saved search will show you all invoices and the payments that were applied to them. If a payment was greater than the invoice amount, you will see the overpayment amount in the Applying Transaction Amount field. You can also use formulas, conditional highlighting, and filters to make the saved search more robust and easier to read. For example, you could use a formula to calculate the overpayment amount (Applying Transaction Amount - Amount) and highlight any rows where this value is greater than 0. Remember, you can apply one payment to multiple invoices. If the payment is greater than the total amount of the invoices, the overpayment will be applied to the oldest open invoice by default. However, you can choose to refund the overpayment instead. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******