I'm trying to create a saved search to view the amount that's been billed and the amount that's been received of a related purchase order but for a unknown reason the summarize duplicates the summed amount in the overview. In the detail view the lines and the amount are what they are supposed to be. What am I missing?

share your result columns

always worth putting the line type in the column to see if a certain type of line is duping the results

message has been deleted

Duped as in it's 200 when it should be 100, or the line shows twice?

Summarize

id guess the different joins used in the filters are causing issues

You mean both the bill and the receipt or the applying and system notes?

applying transaction and system notes

Removing the system notes indeed fixes the issue

cant help you there, i've spent enough time with this kind of thing to say that my preferred solution would be to update all the purchase orders with a date closed field and then use that

That can be a viable solution as well

Yeah, battk's solution is probably best, otherwise you end up hours down the saved search rabbit hole wanting to cry