Hi All,
I'm building a Transaction Saved Search in NetSuite to report on Customer Payments (CustPymt). The search is set to Type = Payment and Main Line = False.
My goal is to list:
- Each payment
- The total payment amount
- The invoice(s) the payment is applied to
- The amount of the payment applied to each invoice
The challenge I'm facing is that the Amount field from either the root transaction or the "Applied To Transaction" group doesn't reliably show the portion of the payment applied to each invoice. It often shows the full invoice amount or the full payment amount, which is misleading when:
- A single payment is applied to multiple invoices
- Multiple payments are applied to a single invoice
Is there a way to accurately capture the applied amount per invoice in a Saved Search? Or do I need to create two separate Saved Searches — one from the payment side and one from the invoice side — and join them externally?
Any guidance or best practices would be greatly appreciated!
Here are different Amount fields that I have tried without any success.
Thanks,
Shahzad - Houston