I'm trying to create a commission saved search from paid invoices, but running into trouble with returning too many rows. You can see my basic criteria below. The problem is that if multiple payments (including credit memos) are applied to an invoice, i get a row for every payment, where i only want one row for each paid invoice. I don't know if setting summary fields in the criteria or results will work - i've tried with no luck. Any suggestions would be welcome! thanks.

If you are joining to another record in the results, you might wanna try adding

Main Line is true

on the join as well, not sure the exact relationship you are pulling in.