Hi everyone 👋 I’m having some difficulty pulling COGS and Sales data from NetSuite backend tables using ODBC in Power BI. I’m not sure which tables contain the COGS details, and I’m also struggling to understand how to join the right tables to get both sales and COGS data together in a report. Has anyone worked on something similar? Any guidance on the table structure, or best practices for joins in this case, would be really appreciated!

I was working with an internal analyst a couple of years ago. From memory the COGS & Sales are from the transaction tables (forgive if i'm not using the right terminolgy). For us, linking the COGS to the Sales data, we used the SO reference on the Invoice to link the Sales invoice (sales) to the Itemfulfilment (COGS). Can't comment on best practices, but hopefully the above helps a little :)