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!

Rookie Asked on December 21, 2022 in Reports.



I am also trying to connect via ODBC to DBeaver but I keep getting error messages. Can help me how  you have made the connection?


Many thanks,


on June 27, 2023.
Add Comment
1 Answer(s)

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.

Rookie Answered on January 25, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor