Why you can have stock on hand and still miss committed orders

A warehouse count is useful, but it does not answer every sales question. The important question is often: can we promise this quantity to this customer for this date?

Answering that requires the stock record, open orders, existing commitments and reliable supplier dates to agree. When those records sit in separate systems, a positive stock balance can hide a shortage. This is one of the problems our inventory and demand planning work addresses.

Three numbers that answer different questions

• Stock on hand: the physical quantity recorded at a location. Some units may be damaged, reserved or unavailable for sale.
• Allocated stock: units already committed under the business's allocation rules. An allocation may have a required date, not just a quantity.
• Available-to-sell: the quantity that can safely be offered for a particular date, after the relevant commitments and constraints are considered.

Platforms use these terms differently. Define the rules in your own system before comparing reports. A promise that includes future supplier deliveries is not the same as a count of unallocated stock physically available today.

A simple example

Illustrative example, not a client result: a warehouse records 100 units. Existing orders need 60 units tomorrow, and five units are damaged. A new customer asks for 50 units tomorrow.

For this example, the usable uncommitted quantity is 100 minus 60 minus 5: 35 units. Accepting the full new order creates a shortage of 15, despite the warehouse report showing 100.

A supplier delivery of 30 units arriving next week does not solve tomorrow's shortage. It may make a later delivery date possible. That distinction should appear in the decision sales makes, rather than being left for the warehouse to discover.

Future commitments need dates

A distant customer order can lock stock unnecessarily if the system treats every commitment as equally urgent. Conversely, releasing an allocation without checking replacement supply can create a later shortage.

Put the promised customer date beside the confirmed supplier date. Include the time needed to receive, inspect and dispatch the goods. Then agree which commitments reserve stock immediately, which can use expected receipts and who approves an exception.

Start with these records

• SKU, location and usable quantity, with damaged or quarantined stock separated.
• Open order quantity, promised date and current allocation.
• Open purchase orders, expected receipt dates and supplier lead times.
• Order history, cancellations and returns, using consistent SKU identifiers.
• Minimum order quantities, pack sizes and any operational constraints on buying.

Reconcile the inputs before automating a buy list. A forecast built on mismatched units or duplicated orders will simply repeat those errors faster.

What the team should see

Sales needs a reliable quantity and date it can promise. The buyer needs exceptions, recommended quantities and buy-by dates. The warehouse needs the current allocation and any change to the dispatch plan. These views should use the same underlying records.

In the RMA customer story, the published result is 81 committed-order stockouts at diagnosis and none recorded since go-live. The comparison is diagnosis versus since go-live, rather than a claimed pair of matched 90-day windows.

For the implementation inputs and handover process, read demand planning inside an existing inventory system. To evaluate the outcome consistently, use the stockout measurement guide.