Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Invoice - Installments - CustomerPayment
Hello, everyone!
I hope you're well!
We're creating a saved search based on Invoices, which will also show installment and payment transaction information.
The report aims to show what was paid and when.
The report is fine for showing invoices and installment information. However, when adding the payment transaction date, for example, the lines are multiplied by the number of payments.
In this case, as we have 3 payments, 9 lines are displayed, and the 3 lines of installments are multiplied by the 3 payments.
We don't have installment record to create it via analytics, and I haven't found the table to create via SQL either.