I have a Invoices with 2 lines. When I select invoiceline of the invoices, I get 8 lines. What should I add to the select to return only the 2 lines ? I did AND mainline = 'F' AND taxline = 'F' AND donotdisplayline ='F' But I still see too many lines ?

Are you selecting any columns that might join in from another transaction or record that would lead to duplicates?

For invoices there always other line, mainly the GL impact. I don't want those lines

use

iscogs

for standalone invoices