Is it possible to sum the value of unique transactions in a saved search? For example, in the saved search below, I want to sum the total bill payment amount per unique bill but the lines are duplicated (multiple bill lines), hence the sum are also duplicated. Is it by using DISTINCT? though I can’t figure out how to use it in this scenario

@Luis you may have duplicate lines because main line is not set to false, you can do what you are asking. You may also need to limit your criteria by "Applying Transaction Fields". A sample of your sum may be "case when {type} = 'Bill' then {amount} else null end"

I need the lines duplicated because I want to know the billed amount of the PO, and that won't work if main line is true

The total billed amount of the PO, or the billed per line, even so there's a way to do it, we can look today for a moment if you want.