Hello All, I'm fairly new to NetSuite and even more so to Suite Anayltics Connect. I have a query where I am trying to pull details from the header as well as the line items of invoices and credit memos but I am having a problem where it is also returning all of the GL records too and I don't want those. How do I filter out the GL results and only have details of the line item? Any help is greatly appreciated.

While on the dataset, just search for

posting

at the top of the columns, there should be a column called

is posting

... perhaps you want to set that to false.

Thanks for the assist but I am working with the Suite Analytics Connect ODBC driver where it is just an SQL query. I believe that I may have figured it out on my own just moments ago though. It looks like there is an Account_ID field in the Transaction_Lines table where I am just checking to make sure that isn't NULL. I have to go through and look at some more records to verify though.