has anyone had an issue where there are duplicates main line transactions in a saved search? I cant do main line true because i need line detail, but a couple of invoices are duplicated and I cant figure out how to get them out

Tax Line = false and Shipping Line = false

Try with criteria : System note..context : select create

@Eric B that did not seem to work

Sorry System note..type

That did not work 😞

do you use joins on your results?

yes

I usually set account type = income and that takes most of the duplicates away

If i do the account type income it erases all of my data

Oh. I guess I’d need to see your complete criteria to help troubleshoot more

Add cogs line false

Are you joining to the Payment related to the invoice in your results? Like with applying transaction joins?

COGS did not work.

Ok that is probably why you get the duplicates. You probably have 2 payments applied to those invoices

As Mavencloud says, joins create duplication. It might be necessary to summarize and use distinct for sum amount maybe

Yeah i dont know if it will work with the results that I have, but I appreciate the help!

Are you building a commissions report based on date of payment

here are my results for the search:

Oof. This will be tough. Which values are causing issue that they are duplicated?

Turns out it was the paying transaction:memo field. I made it into a text formula field and it removed the duplicates 🙂