This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi all! I've got a custom field on invoices, populated from a saved search which is supposed to return a sum of applied line amounts from paying transactions, but it's giving me duplicates for the lines on some invoices. What is the correct way to get a sum of funds actually applied to an invoice regardless of whether it's from a payment, credit memo, journal entry, etc?

add a criteria to your search that when it joins to the transaction it gets only the mainline

i.e. if your vendor bill has more than 1 line and you have 2 payments against it you'll get doubled results based on the number of lines on the bill instead of 2.

Yeah that's pretty much what I'm seeing but it doesn't work in all use cases, for example a credit applied to multiple transactions

the main line amount will not be the applied amount

I think I'm going to need to script the field value instead of just getting it from the search summary