PO Invoice & Receipt Exception Report
Exact cumulative comparison of supplied purchase, invoice and receipt lines.
Exact supplied-record comparison only. Coverage flags are caller assertions. No invoice approval, payment, tax or accounting compliance determination. No currencies or units are combined across PO lines. Missing receipt evidence does not prove goods never arrived. A no-exceptions result is limited to these checks and the submitted records.
Scope and tolerances
Historical invoices asserted complete: true. Receipts asserted complete: true. Absolute quantity tolerance: 0 in each line's unit. Absolute unit-price tolerance: 0 in each line's currency. Differences equal to tolerance are not flagged.
Findings
| ID / severity | Exception | Supplier / PO / line | Document / line | Evidence references | Observed | Expected | Difference | Unit / currency | Reason |
|---|---|---|---|---|---|---|---|---|---|
| F00001 / warning | RECEIPT_SHORTFALL | 001 / PO-100 / 01 | / | purchaseOrders:1 | 70 | 60 | 10 | EA / USD | Comparable cumulative invoice quantity exceeds comparable supplied receipt quantity beyond tolerance. Excluded or missing records can change the result. |
Purchase-line reconciliation
| Source / status | Supplier / PO / line | Unit / currency | Ordered | Receipts | Current invoices | Historical invoices | Cumulative invoices | Receipt shortfall | Over-invoiced | Ordered unreceived | PO unit price | Ordered value | Current value | Historical value | Cumulative value | Price variance | Accepted references | Excluded references | Findings | Reason |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| purchaseOrders:1 / exceptions | 001 / PO-100 / 01 | EA / USD | 100 | 60 | 30 | 40 | 70 | 10 | 0 | 40 | 4 | 400 | 120 | 160 | 280 | 0 | purchaseOrders:1; invoices:1; historicalInvoices:1; receipts:1; receipts:2 | F00001 | Review the linked findings against supplied evidence and tolerance settings. |
Reading evidence
References use the table name and a 1-based data-row index, excluding CSV headers. Aggregate findings reference the purchase row; its accepted and excluded references identify the contributing input lines. Duplicate-document findings list every excluded occurrence. Amounts are exact quantity × unit price, before tax, discounts, freight or rounding. Quantities and money in incomplete rows describe accepted records only.
Engine 0.1.0 · Schema 1.0 · Input fingerprint aa85d74bd6f8475b8465a9ba88c7ecd738b58e3dd8bd263666e35ed7dcdc9d4e