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.

Hi,

 

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,

Jeroen

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. https://timdietrich.me/blog/netsuite-inventory-balance-history-suitelet/

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