Hello Community! I am looking to find a way to view which Sales Orders in a time frame (next 30/60/90 days, or a set timeframe, etc) have line items that do not have sufficient inventory in stock at time the report is generated. For example, if I have 100 pieces of Item A in inventory, and each of the next three weeks has a Sales Order with 50 pieces scheduled to ship, I want to be able to look at “Next 30 days SO without Inventory” and see that third SO show up as lacking inventory. Basically, I’m looking for a quick summarized way to remind us to schedule certain production orders.
Currently, this is done manually in a couple ways, firstly by noting at time of SO creation whether there is sufficient inventory and flagging items that require production, and secondly by periodically reviewing the Inventory Allocation Details report for high-volume parts to ensure multiple at-the-time-stocked items don’t get added to multiple Sales Orders leaving us short on some.
We are building up to a more comprehensive implementation of MRP, and this is somewhat of a workaround until then, with the added benefit that a Production or Quality team member could look ahead at the next “due date”. We generally make most product for-stock and not to-order. I’m hoping that there is an Inventory or Sales Order report that I overlooked, or that I can make a simple GI for this, so thought I’d ask if anybody else looked ahead based on booked orders as opposed to or in addition to using the MRP module to it’s full effect.
Thanks in advance!