REVIEW ONLY: This rules-based report does not approve payments, certify inventory, reconcile taxes/freight, or write to ERP/Shopify. Review source rows and mappings before decisions. The published example uses invented data.
| PO | SKU | Ordered | Received | Invoiced | Status | Exceptions | Source rows (PO / receipts / invoices) |
|---|---|---|---|---|---|---|---|
| PO100 | MATCH | 6 | 6 | 6 | MATCHED | 2 / 2 / 2 | |
| PO101 | PARTIAL | 10 | 8 | 8 | REVIEW | PARTIAL_OR_MISSING_RECEIPT | 3 / 3 / 3 |
| PO102 | PRICE | 5 | 5 | 5 | REVIEW | PRICE_VARIANCE | 4 / 4 / 4 |
| PO103 | PREBILL | 3 | 0 | 3 | REVIEW | PARTIAL_OR_MISSING_RECEIPT; INVOICED_OVER_RECEIPTED | 5 / / 5 |
| PO104 | NOINV | 4 | 4 | 0 | REVIEW | MISSING_INVOICE; RECEIVED_NOT_FULLY_INVOICED | 6 / 5 / |
| PO105 | OVERBILL | 2 | 2 | 3 | REVIEW | INVOICED_OVER_RECEIPTED; INVOICED_OVER_ORDERED | 7 / 6 / 6 |
| PO999 | UNKNOWN | 0 | 0 | 1 | REVIEW | UNKNOWN_PO_LINE | / / 7 |