Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
Determining Demand / Inventory Usage
I'd like to get a report that would allow me to see the quantity of inventory leaving a given location for a given time period. This is very useful for projecting Min/Max levels and seasonal ordering.
The closest canned Netsuite report is the Inventory Activity Detail. However, this doesn't fully summarize what I need, because it takes into account inventory INPUTS like Item Receipts. I have to sit there with a calculator to filter out the Item Receipts.
The Item Forecast report looked promising, but it doesn't take into account Assembly Builds.
I started creating a saved search (on transactions) to give me this information, but I realized it is a more complicated problem than I originally thought. For example, there are a multitude of transactions that can remove inventory from our stock. Normally for us it is an Item Fulfillment, but you can also remove inventory via a Cash Sale or an Invoice.