how to solve this issue • Example: o Invoice 1001 = $1,000 o Invoice 1002 = $2,000 o Customer Payment = $3,200 • NetSuite Behavior: o $1,000 applied to Invoice 1001 (fully paid) o $2,000 applied to Invoice 1002 (fully paid) o $200 remains as Unapplied at the customer level • Issue: o The $200 relates to Invoice 1002, but NetSuite does not show this link. o Reporting only shows $200 as a customer overpayment, with no invoice-level detail

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like the issue of linking payments to invoices in NetSuite can be quite complex due to the way NetSuite handles transactions. However, there are a few potential solutions that were discussed: 1. For the issue of linking payments to invoices, one user suggested pulling in currency revaluations, credit memos, and journals and adjusting the main line criteria based on the transaction type. This might help in getting a payment report that shows how much was paid to the applied invoice (in USD). 2. For automating customer payment against credit amount, it was suggested to create a customer payment transaction to apply all those different transactions to the invoice. This can be done using the

record.transform

function in SuiteScript to mimic the effect of the

Accept Payment

button. Then, use

Record.setSublistValue

to mark the same checkboxes you would in the UI. This will usually involve using

Record.findSublistLineWithValue

or

Record.getSublistValue

to find which line you want to mark. 3. For the issue of partial PO bill, a workaround suggested was to go to the original PO, edit and split the line so that you have two lines for the partial amounts, then only receive/bill the partial amount line. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******