01Define the report population and versions
State buyer legal entity, purchasing organization, supplier population, facilities, currencies, order types, status rules, as-of date, extraction time and time zone. Include blanket orders, call-offs, changes, partial closes, blocked and cancel-pending lines as controlled populations where relevant. Freeze the extract and capture PO number, line, schedule, item, unit, original and current quantity, price, currency, destination, required date, status and last change. Identify the authoritative approved version and change history. Exclude drafts or requisitions only through explicit logic. Reconcile report counts and values with the purchasing system or approved commitment source. A header marked open can contain completed lines, while a header marked complete may still have financial exceptions; review at line and schedule level.
02Confirm buyer authorization and supplier response
Trace each current line to the approved order and change request. Separate original order, buyer change, supplier acknowledgement, acceptance, proposed amendment and rejection. UNECE ORDERS structures purchase-order information; ORDRSP allows a seller to accept, propose amendment or reject all or part. A supplier response does not automatically change buyer authorization unless the agreed process accepts it. Compare item, quantity, unit, price, currency, delivery date, destination, terms and substitute. Record unacknowledged and conditionally accepted schedules. Preserve superseded versions so a quantity reduction cannot erase earlier despatch or receipt. Resolve a supplier promising a different date or quantity through the change workflow, not a free-text note that leaves the system commitment unchanged.
03Build the quantity bridge
For each line and delivery schedule, begin with current authorized quantity. Show approved canceled or reduced quantity, advised or despatched quantity, in-transit quantity, physically received, accepted, rejected, returned, replacement and remaining quantity. Use the same base unit and verified pack factors. Distinguish receipt from acceptance and return shipment from supplier receipt. Link DESADV, receiving advice, warehouse receipt, return authorization and transfer evidence as applicable. Prevent one receipt from applying to two lines and one cancellation from reducing a quantity already received. Review over-receipt and allowed tolerance separately. A zero remaining quantity can still have rejected goods or replacement obligation; a positive remaining quantity can be stale when the supplier and buyer agreed cancellation outside the system.
04Build the value and document bridge
Calculate authorized line value from approved quantity, price, currency and permitted charges or discounts. Compare receipt or accrual value, supplier invoice, debit or credit note, payment and remaining commitment under finance policy. Keep tax, freight and other charges visible according to the order structure instead of hiding them in product quantity. An invoice can arrive before receipt and a receipt can remain uninvoiced; neither alone determines remaining supply. Reconcile partial invoice and credit applications by line where possible. Separate foreign-currency commitment from ledger translation. Do not close an order merely because it is fully invoiced or paid, and do not keep full cash commitment after an approved quantity cancellation. Use qualified finance owners for accounting, tax and exchange-rate treatment.
05Classify and prioritize each open balance
Assign a state: valid future schedule, supplier-confirmed backlog, due or overdue delivery, despatched or in transit, received-not-posted, accepted-not-invoiced, invoice-only exception, return or replacement open, quality or price dispute, cancellation pending, complete pending administrative close, or stale unknown. Record exact remaining quantity and value, evidence, owner and next date. Prioritize from supply risk, required date, production or sales dependency, value, age, supplier response and unresolved exception—not age alone. Review old low-value lines as a population because they can distort planning and system performance. Avoid mass closure without source evidence. Contact suppliers using validated account and order references and record their position without exposing unrelated purchase data.
06Execute retain, change, cancel or close decisions
For a valid commitment, refresh delivery schedule and owner. For a change or cancellation, issue the approved buyer document and obtain the required response. For unposted receipt or return, correct the source transaction. For invoice or credit exception, link the finance case. Close a line only when remaining delivery is zero or explicitly canceled, receipt and return states are complete, open invoice or credit dependencies are resolved or assigned, and no replacement or claim remains hidden. Use named authority for final close and preserve the order history. Do not backdate a cancellation to precede a real shipment or delete a schedule to improve backlog. Test downstream demand, inventory, accrual, cash forecast and supplier scorecard after the change.
07Reconcile totals and prevent stale commitments
Sum line and schedule bridges to PO, supplier, currency and business-unit totals and reconcile them with the open-commitment report. Compare buyer position with supplier order status or statement where available and document differences. Monitor unacknowledged orders, past-due schedules, received-not-posted, invoice-only lines, cancel pending, no-activity age, administrative-close backlog, quantity and value mismatch and reopened orders. Sample closed POs to receipt and invoice evidence and sample open receipts, invoices and supplier responses back to POs. Use recurring causes to fix approval, change communication, receiving, return, invoice matching, master data or system status design. Schedule review frequently enough for planning needs but do not replace event-driven controls with a monthly cleanup.