Hi all - ODBC Question. We're pulling data lines through, we can see all the lines but on any "cost of sales adjustment" made by -system- there is no net amount (or monetary value of any kind). On the UI I can see the value on the GL Impact but it's not pulling anywhere. Any one else get this? Any ideas what I'm missing?

You need to join to

TransactionAccountingLine

table, see https://timdietrich.me/blog/netsuite-suiteql-gl-impact/