Sample report
Open PO Exception & Resolution Queue
Sample report generated from an open PO export, inventory snapshot, supplier master, and supplier communication history.
Dummy data for demonstration purposes.
Executive summary
Where exceptions are showing up.
Top risks this week
What deserves attention now.
- 3 critical SKUs are below buffer and linked to late or unconfirmed POs.
- 6 partial POs have residual quantities open for more than 21 days.
- 4 supplier-promised dates differ from ERP delivery dates.
- 5 shipments are due soon but missing required shipping or closeout documents.
Buyer action queue
Open PO lines that need buyer action.
| Priority | Status | PO / Line | Supplier | Exception | Why it matters | Recommended resolution | Owner | Due by | Draft | Confidence | Action |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Critical | Escalated | PO-10482 / Line 1 | Andina Plastics | Overdue | RESIN-PP-220 is a production-critical input. Stock coverage is estimated at 4 days. A further slip will halt the line. | Escalate ETA today. Ask supplier to confirm ship date or partial shipment. | Maria Lopez | Today | Ready | High | |
| High | Action required | PO-10511 / Line 2 | Delta Packaging | Stale partial | Stale residuals distort replenishment forecasts. ERP still expects supply that may not arrive. | Confirm whether residual will ship; otherwise close/cancel balance. | Maria Lopez | Today | Ready | High | |
| High | Action required | PO-10602 / Line 1 | Nova Supply Co. | Missing confirmation | Without acknowledgment, the buyer cannot rely on the ERP date. Delivery is due in 7 days. | Request written confirmation of receipt, price, quantity, and ETA. | James Chen | Today | Ready | Medium | |
| Medium | Buyer review | PO-10644 / Line 3 | Vertex Components | Date mismatch | Planning is using the ERP date. A 7-day slip changes the line schedule and will distort inbound forecasts. | Confirm latest promised date and update ERP after buyer approval. | Priya Shah | Tomorrow | Ready | High | |
| High | Action required | PO-10701 / Line 1 | Eastline Trading | Closeout blocker | Without shipping documents, customs clearance and receiving will stall. PO cannot be cleanly closed. | Request commercial invoice, packing list, booking, and BOL. | James Chen | Today | Ready | Medium | |
| Medium | Buyer review | PO-10788 / Line 4 | Pacific Industrial | Price/quantity issue | Receipt at the higher price would fail three-way match. AP cannot pay without buyer approval. | Ask supplier to confirm agreed price; route price change for approval if valid. | Priya Shah | Tomorrow | Ready | High | |
| Medium | Action required | PO-10813 / Line 1 | Northstar Goods | Price/quantity issue | Short receipt impacts the May packing run. Planning needs the available quantity and split-shipment dates. | Confirm available quantity, ask for split shipment, and alert planning. | Maria Lopez | Today | Ready | High | |
| Medium | Action required | PO-10877 / Line 5 | OceanBridge Manufacturing | RMA / receiving issue | Damaged units affect the May replenishment for the assembly line and need credit or replacement. | Request credit/replacement and open RMA workflow. | James Chen | This week | Ready | Medium |
Illustrative data. Real reports use your PO numbers, suppliers, item SKUs, and supplier email examples.
Exception breakdown
37 exceptions by category.
- Missing confirmations 12
- Overdue 9
- Stale partials 6
- Date mismatches 4
- Closeout blockers 6
- Price/quantity issues 5
- RMA / receiving issues 2
Supplier risk rollup
Where exceptions cluster by supplier.
| Supplier | Open PO lines | Exceptions | Missing confirmations | Overdue lines | Avg days late | Recommended management action |
|---|---|---|---|---|---|---|
| Andina Plastics | 14 | 5 | 1 | 3 | 5.2 | Quarterly review on chronic delays for production-critical resin lines. |
| Delta Packaging | 22 | 4 | 0 | 1 | 1.8 | Tighten residual closeout SLA on partial deliveries. |
| Nova Supply Co. | 9 | 3 | 3 | 0 | 0.0 | Require written acknowledgment within 2 business days of PO issue. |
| Vertex Components | 11 | 2 | 0 | 0 | 2.1 | Sync ERP delivery dates weekly; supplier sends updates over email. |
| Eastline Trading | 7 | 2 | 0 | 0 | 0.0 | Standardize shipping document handover with freight forwarder. |
Detailed resolution examples
Two worked examples from the queue.
PO-10482 / Line 1 — Andina Plastics
Overdue · Critical · Owner Maria Lopez · Due Today
Why it matters. RESIN-PP-220 is a production-critical input. Stock coverage is estimated at 4 days. A further slip will halt the line.
Recommended resolution. Escalate ETA today. Ask supplier to confirm ship date or partial shipment.
- Send the drafted escalation email to Andina Plastics today.
- Request confirmation of ship date, delivery date, and partial-shipment availability.
- If supplier confirms a new date, update latest promised date in ERP after buyer approval.
- If supplier offers a partial, confirm quantity and ETA with planning before accepting.
- If no response by end of day, call the supplier and escalate internally to operations.
Draft email. To orders@andinaplastics.example, CC planning@democo.example. Subject: Urgent ETA confirmation needed — PO-10482 / RESIN-PP-220.
Hi Andina Plastics team, We are escalating PO-10482 for item RESIN-PP-220. The original delivery date was April 24, 2026, and our records show the order has not yet been received. This item is currently production-critical on our side. Could you please confirm: 1. Current order status 2. Confirmed ship date 3. Confirmed delivery date 4. Whether a partial shipment is available immediately 5. Whether expedited freight is possible Please reply today if possible so we can update our production plan. Thank you, Maria
Suggested system update.
| Follow-up status | Escalated |
| Next follow-up date | Today |
| Buyer note | Production-critical SKU. Stock coverage estimated at 4 days. Supplier ETA unconfirmed. |
PO-10511 / Line 2 — Delta Packaging
Stale partial · High · Owner Maria Lopez · Due Today
Why it matters. Stale residuals distort replenishment forecasts. ERP still expects supply that may not arrive.
Recommended resolution. Confirm whether residual will ship; otherwise close/cancel balance.
- Send the drafted residual-balance email to Delta Packaging.
- Request confirmation that the remaining 4,800 units will ship.
- If yes, capture ship date and delivery date in ERP.
- If no, close/cancel residual on the PO line and notify planning.
- If no response within 2 business days, escalate to account manager.
Draft email. To csr@deltapackaging.example, CC planning@democo.example. Subject: Confirmation needed — PO-10511 residual balance.
Hi Delta Packaging team, We are reviewing PO-10511 for item PET-CLAM-24OZ. Our records show that 115,200 units have been received against the original order quantity of 120,000 units, leaving a remaining open balance of 4,800 units. Could you please confirm whether the remaining 4,800 units are still expected to ship? If yes, please confirm the expected ship date and delivery date. If no, please confirm that the remaining balance should be cancelled/closed on our side. Thank you, Maria
Suggested system update.
| Follow-up status | Awaiting supplier confirmation |
| Next follow-up date | April 30, 2026 |
| Buyer note | Partial receipt complete. Residual quantity open for 31 days. Awaiting supplier confirmation before closing balance. |
Run this on your open PO report.
Share an anonymized open PO export and we'll return a sample exception report showing missing confirmations, overdue lines, stale partials, supplier-date mismatches, and buyer-ready resolution drafts.