Count an Open Purchase Order Only Once in Replenishment Plans

An open purchase order can contain quantities already received, quantities removed by an accepted change and quantities still due. Passing the original order quantity into a reorder plan would treat those different states as additional supply. Reconcile the remaining commitment first, then check which part belongs in the chosen date window.

The deliverable is an open-order remaining-supply reconciliation for an identified commitment. This article does not decide whether a framework agreement creates that commitment in the first place. It uses completed receipt and change records as inputs, without recounting goods or settling a shortage dispute. No real orders, acknowledgements or dates have been supplied; the method and worked figures are illustrative.

Choose one line, one unit and one snapshot

Identify the purchase order, line, item revision and selling unit. Record the controlling order issue and all applicable accepted changes. If the line is in packs while receipts are in pieces, use an already approved conversion and preserve both units. An unexplained conversion should remain an open question rather than a rounded estimate.

Choose a snapshot time for the reconciliation. Every receipt and amendment included must be traceable to that point. A receipt posted after the snapshot belongs in a refreshed version or an explicit later-event note, not in an unexplained mixture of old and new figures.

Set the planning window separately, including its start, end, time zone where relevant, destination and availability event. “Due this month” is insufficient if one record means dispatch from the supplier and the buyer needs stock available at a receiving location. Ask for the supported event; do not add an assumed transit or processing duration.

Establish whether the order figure is gross or already amended

There are two valid arithmetic presentations when their inputs are consistently defined. Starting from an original gross quantity, subtract completed receipts and accepted reductions that have not already changed that gross figure. Starting from a current revised total that already includes those reductions, subtract the applicable receipts without deducting the reductions a second time.

Record which presentation is being used. Do not subtract both a cancellation and the same cancellation embedded in the revised total. Also do not treat a requested cancellation as an accepted reduction merely because the buyer no longer wants the goods. Keep the request visible and refer its effect to the authorized purchasing owner.

A receipt is deducted from unreceived supply even if the received goods are not yet eligible for use. Their eligibility belongs in the stock calculation. Leaving a received but held quantity in inbound supply as well as in the physical ledger would conceal its actual state and invite duplicate counting.

Reconcile transaction identities before totals

Use the actual order-line and transaction references to distinguish an event from another record of that event. A supplier acknowledgement, a dispatch update and a purchasing export may describe the same promised quantity. They are supporting records for one supply line, not three separate commitments.

Keep a correction trail when a duplicate is found. Record the retained event, the duplicate reference and why it is not additive. If the relationship is uncertain, ask the record owner to clarify it. Do not delete a possible commitment merely because its quantity resembles another line.

A negative residual signals a record problem to investigate. Do not silently replace it with zero and erase the inconsistency. Check units, overlapping receipts, revised totals and amendment scope, then obtain the authorized correction.

Work through a fictional 100-unit order

Assume a fictional order starts at 100 individual passive parts. Completed receipts account for 40. An acknowledged cancellation removes 20 different, unreceived parts. These are mutually exclusive quantities, all expressed in the same unit at the same snapshot. Remaining supply is 100 − 40 − 20 = 40.

The current amended total could instead be displayed as 80, already reflecting the 20-unit cancellation. On that basis the calculation is 80 − 40 = 40. Subtracting the cancellation again would incorrectly produce 20. The reconciliation should show both the chosen basis and the references so a reviewer can follow why the result is 40.

Assume the buyer’s fictional window runs from 1 November through 14 November, inclusive, for availability at its named planning location. Of the 40 remaining units, attributable example records support 25 available within that window and 15 only afterward. The supported input for this window is 25, while the remaining-order total stays 40. The later 15 are not cancelled or lost.

These dates and quantities are hypothetical. They establish no lead time, arrival guarantee or actual supplier obligation. If the only supporting date were dispatch on 14 November, the example would not support availability at the buyer’s location within the same window. That missing timing relationship would need an answer before inclusion.

Keep receipt and inbound updates synchronized

When a later receipt is recognized, move its quantity out of remaining inbound in the same refreshed reconciliation used by planning. The corresponding stock entry has its own eligibility decision. Do not leave the old inbound snapshot beside a new stock snapshot without a bridge identifying the intervening event.

For example, if 10 of the hypothetical 25 in-window units are subsequently received, the refreshed unreceived in-window quantity becomes 15. The received 10 may enter eligible stock only under the existing status decisions. Counting all 25 as still inbound and adding those 10 as stock would overstate supply by 10.

Returns, rejected receipts and replacement promises need explicit transaction treatment from their owners. A return does not automatically recreate the original unreceived balance in this method. Record what was received, what later changed and what separate replacement commitment, if any, is supported. Keep dispute closure outside this reconciliation.

Hand over the supported quantity and its limitations

Provide the replenishment owner with the order-line reference, snapshot, remaining total, in-window supported portion, later portion and unresolved exceptions. The receiving location and date event should travel with the number. “Forty open” without those qualifiers is not the same planning input as “twenty-five supported within this window.”

Confirm whether any inbound quantity is already allocated or otherwise netted in the receiving worksheet. A broader inventory-position calculation must not add the same order again under another supplier confirmation, or deduct an already netted commitment twice. The handoff closes one supply-input question; it does not approve a reorder quantity or promise that every outstanding unit will arrive.

Frequently asked questions

Should I subtract cancelled units from the latest revised order total?

Only if that total has not already incorporated the same accepted reduction. Record whether the baseline is original gross or current revised quantity, and reconcile the amendment references. For an original 100 reduced by 20 with 40 received, both 100 − 20 − 40 and 80 − 40 give 40 remaining.

Do received goods on hold still count as inbound?

In this reconciliation they leave unreceived supply when the completed receipt is recognized. Their hold remains an independent eligibility restriction in the stock record. Do not retain the quantity in inbound merely because it cannot yet satisfy demand; that would misrepresent the same goods in two places.

What if the supplier gives a dispatch date rather than an availability date?

Preserve the event exactly. A dispatch date alone does not answer when goods can support demand at another location. Request the missing dated commitment or keep the quantity outside the supported in-window input. Do not supply a default transport or processing duration.

Can I treat a cancellation request as reduced supply?

Keep the request as an unresolved change unless the applicable records support its accepted effect. Ask the purchasing owner to resolve the commitment and terms. This worksheet does not establish cancellation rights or relieve payment obligations; it records the supported order state.