Industry Use Cases

How to Build an Open Purchase Order Follow-Up List in Excel

The PO header says Friday. A customer order needs 80 units tomorrow morning. The previous delivery covered part of the order, but those units are allocated elsewhere. A weekly report organized around the PO header can leave the coordinator looking at the wrong line.

Track open quantities at PO line or delivery-schedule level, then compare revised supplier dates with the demand they cover. Rank action items by the customer or production commitment at risk.

Which line gets the first phone call?

The buyer is reviewing open receipts on May 11. The first line has 200 ordered and 120 accepted; the remaining units are the only supply assigned to the May 12 demand.

PO lineOpen unitsSupplier confirmationDemand need dateNext step
PO-501 / 1080May 14May 12Call about a split or expedite
PO-503 / 2060May 13May 15Monitor confirmation
PO-504 / 1040UnconfirmedMay 18Request a firm date

The 80 units on PO-501 get the first call. PO-504 belongs in the confirmation queue. Its blank ETA cannot support a promised date.

Use accepted receipts and open schedule lines

Export the outstanding PO lines, receipt history and delivery schedule. Join by PO and line, including schedule identifiers where available. Calculate open units after accepted receipts and cancellations when the export doesn’t already provide them. Keep rejected and disputed receipts visible.

Bring customer or production demand into the same review

Use explicit allocations where available. For unallocated supply, state the priority rule and avoid assigning the same stock to several demands. Keep original requested date, latest confirmed date, and required date in separate columns.

Run the call list again before the next buying meeting

Keep the original confirmation and latest supplier update. That makes it possible to tell whether a previously flagged line cleared or simply had its ETA changed.

Which open PO schedules arrive after the demand they cover, and which urgent lines have no confirmed ETA? Show remaining units, the affected orders, and source rows.

Call on the line-level quantity and date. Ask the supplier to confirm the partial shipment explicitly before revising the customer promise.

NetSuite open purchase orders · Dynamics 365 purchase order delivery schedules

The figures and identifiers in this example are synthetic. The displayed arithmetic was checked independently. A live Jolene.pro result could not be verified.

Try this with your own spreadsheet at Jolene.pro. Follow Jolene.pro on LinkedIn for more spreadsheet guides.

For more checked examples, see Jolene.pro Workbook Studies.

Related checks: How to Find Open Purchase Orders for an Old BOM Revision · How to Review MRP Reschedule-Out Messages for Open Purchase Orders.

Leave a comment