Slack Newbie here. SuiteAnalytics has turned into my life though. SQL Server data warehouse loading invoices from Netsuite every night.

Yep doing the same with another customer!

Nice to "meet" you! It's nice to know there's someone else doing what I do. My current challenge is applying the GL Impact COGS to each Invoice line in the data warehouse.

Haven't gotten there yet with my projects, but I'm pretty sure Item Fulfillment transaction "houses" the COGS activity, not the Invoice (afaik).

That was it. IF transactions contain COGS account records in the TRANSACTION_LINES table.