Sorry, I need to ask the question again. I have an IF with 2 lines. When I select * from transactionline, I received 7 lines. As we all know, Suiteql return all lines, COGS, TAX, etc.. Do you know the trick to select only the lines like on the IF ? Same thing for the SO

my personal favorite is using the previouslinks join

Previouslinks join ? What is it ? I just did : Select * from previouslinks and it return nothing.

use the record catalog to see see the joins you have available for transaction line

Thanks