Hello Hope you are well. Is there a way to query invoice and bill line items via the Suite Query language? We are looking for this data as shown in the screenshot.

@Diogo You'll need to query the Transaction and TransactionLine tables. There are a few example queries in this blog post that might be helpful: https://timdietrich.me/blog/netsuite-suiteql-querying-transactions/

Thanks Tim for your reply. Please see the screenshot. We did a very simply select all query for an Invoice with 1 line item (product). However we retrieved 3 rows as result to our SQL query. 1 is referring to the product, 1 is for tax code on the product and the top line is something we are not sure of. Do you know what it may reflect/represent?

The top line is the "main line" which includes header level information about the transaction (order total etc)