Hello all. I am trying to get a list of inventory adjustments where the total transaction amount is 0 but the sum of the line amounts is not 0. i.e. I do not want the inventory adjustment if it is -125 on line one and +125 on line 2 to net 0 for the total adjustment. I want the list of true 0 inventory adjustments. This is my criteria but it still brings in adjustment with lines that net to ) (it just excludes the lines and keeps the header (lineid=0)) Hve tried summary and cannot get that to work either.

you will probably end up having to use that summary criteria

I wanted the mainline to come in. Doesn't make sense for it to exclude since I am saying both amount and transaction total both need to be 0.

the sum of your lines will include the amount of each adjustment line, and the amount on the header

I know. I am trying io make it more like a report. I am highlighting line = 0 to a different color and showing the lines below it.

not that i know how a inventory adjustment's lines dont sum up to the total