I'm creating a saved search for commission amount which is based on invoice amount net of tax, shipping fee and credits. The problem is that NetSuite creates multiple lines because of my Commission Amount formula that uses Applying Transaction join. Criteria are Type = Invoice, Posting = True and Main Line is True. Adding the Applying Transaction Type = Credit Memo removes the Invoices without Payment/Credit Memo yet. Also, if there are two credit memos, they are presented as two lines instead of one only. I tried to add SUM before the CASE formula but it excludes the column on the saved search results.

Not sure I 100% follow, but perhaps try adding

Applying Transaction fields... Main is T

as well?

I'll try this and will let you know. Thank you!