Imagine an order for 30 cartons sitting beside a stock report that says 60. The arithmetic looks comfortable. Then somebody opens the warehouse column.
In this fictional example, East has 18 uncommitted cartons ready to pick. West has 42 uncommitted cartons. The customer needs all 30 dispatched from East tomorrow. A transfer from West is possible, but nobody has confirmed when it would arrive.
There are 60 cartons across the two buildings. East is still 12 short for this dispatch.
We like totals because they fit in one cell. The trouble starts when the decision needs a location and a date that the total has quietly dropped.
Ask the narrower question
For this order, write the requirement before choosing the inventory number:
Need: 30 cartons, East warehouse, ready for tomorrow’s dispatch.
Confirmed ready at East: 18 cartons.
Gap: 30 - 18 = 12 cartons.
Possible source: West warehouse.
Transfer arrival: unconfirmed.
Do not fill the gap with the word “available” until the transfer timing is established. West’s stock is real. Its ability to meet East’s deadline is a separate question.
This distinction is useful when preparing an automated summary, too. A system can correctly add 18 and 42 while answering the wrong operating question. A tidy total does not tell the person booking the dispatch which twelve cartons will actually be there.
Give the transfer its own row
A proposed move needs a quantity, an owner and an arrival status. Keep it separate from confirmed local stock while those details are unresolved. Otherwise the next report can inherit the proposed transfer as though it has already happened.
For the fictional order, the next decision is to confirm whether 12 cartons can reach East in time. If that cannot be established, the dispatch owner needs to decide what to promise the customer. Keep that unresolved decision in the record.
Today’s useful check takes one existing stock summary. Add the location and required date beside the number someone is about to use. If the summary combines buildings, keep the local quantity visible before making a commitment.
Related reading: Two equal totals, two different deadlines.
The Rebuild Editorial


