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

I have a saved search with the following criteria:
```Type is Credit Memo
Main Line is True
Applied To Transaction is Invoice #XXXXXXX```
And the following result columns:
```Amount (Foreign Currency)```
This search returns only one row and the value in that row is 2833.31.

When I add a summary type of SUM to that column on the Results tab and run the search, the value is 5666.62. Anyone know why the value is being doubled when SUMming a single result?

It’s pretty common to have these strange effects when a summarized save search also has a join in it (Applied to Transaction).

Or use another rule that would eliminate duplicates. Perhaps Applying Transaction is NULL

Thanks for this.  I was unaware of the complication.  MAX did work for me, but I went with changing it to use Main Line is No and that seemed to work as well.

Sum(distinct {amount}) is also a consideration when you will have multiple but different results that you want summed. 