This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

How does one go about reporting on Inventory by Date?  What I mean is I need to be able to determine what quantity of I an item was available on a given day in the past?   Any ideas?

Have you tried using the Inventory Snapshot report?

This report appears to be current status...  I need to look into the past?

I must be looking at the wrong report....  Or I am being dumb.  The Current Inventory Snapshot does not have a date filter and I looked to customized to put on there and I don't have that option....

Post *Dated* Transactions on Current *Inventory* *Snapshot* Report
Published 07/25/2013 01:41 PM  |   Updated 05/22/2020 08:07 AM  |   Answer Id: 31667
Applies To
*Product:* NetSuite 2020.1
Scenario
The Current Inventory Snapshot report mirrors whatever is currently shown on the Item Records thus Future Dated or Post Dated Transactions are included/reflected when running the Current Inventory Snapshot report.
Solution
As an option, the user may use the following report to show inventory levels as of the current date only:
1. Inventory Valuation report as of today
2. Physical Inventory Worksheet as of today


try one of the other report as listed in this SA

I will take a look.  Thanks for the input

I am thinking there is not a good way to do this out of the box.

There is, the report is definitely sitting there with a date filter at the bottom

I didn’t know which one but inventory valuation is one the report mentioned in SA

<@UCV4TNZQS> There's a "Running Inventory Balance" SuiteQl query in this blog post that might help: <https://timdietrich.me/blog/netsuite-suiteql-item-transactions/>

There is a Saved Search solution which I’ve been using to add a Subtab to item records. <https://blog.prolecto.com/2015/05/26/solving-the-netsuite-cumulative-saved-search-tally-challenge/|https://blog.prolecto.com/2015/05/26/solving-the-netsuite-cumulative-saved-search-tally-challenge/>

Super hard to see historical inventory qtys. There is a report that lets you choose date ranges, but you are limited in what you can select. Instead, I pull all transactions into PowerBI and aggregate inventory tranasactions to determine things like qty on hand by any historical date (sometimes even time within a day). But again - I only do it in Power BI with our Satori Reporting Suiteapp