RE: Inventory Activity Detail Report SuiteQL
Hi, I’m using DBeaver and connected via ODBC driver to Netsuite. I want to recreate the Inventory Activity Detail Report on Tableau via Snowflake. I was wondering if anyone has done this before or similarly using SuiteQL to recreate a Netsuite report. Thank you!
Have you seen Tim Dietrich’s Inventory Balance Suitelet? That is the basics of the query you need – the challenge is the NS report also has a start date filter (vs just end date) and thus calculates the starting quantity to put at the top of each list of transactions for each item. https://timdietrich.me/blog/netsuite-inventory-balance-history-suitelet/