Sorry to ask the same question a second time, I have an IF with one line. When I select using Suiteql, it return 3 lines. I changed it to not select mainline, I'm down to 2 lines. Anyone has a trick to get only the that is on the IF ?

what is your query?

you are probably getting the "taxLine" as well. Try

AND taxline is 'F'

Item Fulfillments return 3 lines per item - for saved searches, I use the following formula:

MOD({linesequencenumber}, 3)

and only permit when values equal 0. You should be able to adapt this for your query.

yeah, IF's are weird, the first item is also on the "mainline" you can use Clay's modulo solution. I tend to filter on

accountinglinetype