Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
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.