RPT-28 — Procurement Commitments & Match Exceptions
Certified report for Procurement, Finance and Budget owners: requisitions, POs, receipts, invoices, tolerances and 2/3-way match exceptions. Metric owner: Fatima Rashid (Finance Manager) · procurement co-owner: Daniel Chen (Accountant).
RPT-28
WF-16
§9.2
Report certification & governance
Certified
- Report owner
- Fatima Rashid — Finance Manager
- Business definition
- RPT-28 definition v1.6 (approved 12 Jun 2026)
- Authoritative dataset
procurement.match_event_v2→ martmart_p2p_match- Dimensions
- Supplier · cost center · exception type · branch · match mode (2/3-way)
- Currency / time zone
- AED · Asia/Dubai (GST)
- Refresh cadence
- Near-real-time exceptions (≤5 min) · daily certified 06:30 GST
- Last refresh
- 17 Jul 2026 13:55 GST (NRT) · certified slice 06:32 On time
- Next certified refresh
- 18 Jul 2026 06:30 GST
- Governing policy versions
- P2P policy P2P-2026 v3.2 · tolerance table TOL-2026-02 · authority matrix AUTH-2026-05 v7
- Reconciliation
- Open commitments = GL commitment control 2150 · diff AED 0.00 Pass
Open commitments
AED 1,872,450
38 open POs · ties to GL 2150
POs awaiting receipt
12
3 overdue > 14 days
Match exceptions open
7
▼ blocking AED 214,830.50 of invoices
Auto-passed in tolerance
94%
312 of 331 matches this quarter
Duplicate suspects
2
Flagged by anomaly intel (AI-06) · human review
Budget consumed — CC-110
71%
Commitments + actuals vs approved budget v3
Open exceptions by type7 open · QTD 19
| Exception type | Open | Blocked value (AED) | Median age |
|---|---|---|---|
| Price variance above tolerance | 2 | 92,610.00 | 4d |
| Missing receipt (GRN) | 2 | 78,750.00 | 9d |
| Duplicate invoice suspect | 1 | 18,900.00 | 1d |
| Quantity variance | 1 | 12,970.50 | 3d |
| Tax / TRN mismatch | 1 | 11,600.00 | 2d |
| Total blocked | 7 | 214,830.50 | 4d |
Lineage — source to report (§9.2)Payables
procurement.requisition_v1→
procurement.po_v2→
inventory.grn_v1 · ap.invoice_v3→
match engine v3.2 · TOL-2026-02→
transform mart_p2p_match v1.6→
RPT-28
| Source | Version | Refreshed | State |
|---|---|---|---|
procurement.requisition_v1 / po_v2 | schema v2.1 | 17 Jul 2026 13:50 | Fresh |
inventory.grn_v1 | schema v1.4 | 17 Jul 2026 13:50 | Fresh |
ap.invoice_v3 (incl. AI-04 extraction) | schema v3.0 | 17 Jul 2026 13:52 | Fresh |
gl.posted_journal (acct 2150 commitments) | period Jul-2026 open | 17 Jul 2026 06:30 | Reconciled |
Budget context joins the approved budget version v3 (Budgets & Cost Centers); commitments reconcile to GL control account 2150.
Match exceptions & notable open commitments — 17 Jul 2026
Rows 1–10 of 45
| Requisition / PO · supplier | Matched documents | Exception | Variance | Amount (AED) | Status | Owner action |
|---|---|---|---|---|---|---|
REQ-2026-0512 → PO-2026-0341 GulfTech Facilities LLC · CC-110 Facilities · 3-way |
PO ✓ · GRN-0788 ✓ · INV-GT-8841 ✓ | Price variance +3.8% (tolerance 2% per TOL-2026-02) | +2,905.20 | 79,410.00 | Blocked — approval required | Fatima Rashid · price re-negotiation or change order (WF-16) |
REQ-2026-0498 → PO-2026-0327 Emirates Office Supplies · CC-200 IT · 3-way |
PO ✓ · GRN missing · INV-EOS-2210 ✓ | Missing receipt — goods not confirmed 9 days after invoice | — | 44,250.00 | Held — awaiting GRN | Receiver: Elena Petrova · chase delivery note |
REQ-2026-0521 → PO-2026-0349 GulfTech Facilities LLC · CC-110 · 3-way · AC maintenance Prototype Residences B |
PO ✓ · GRN-0801 ✓ · INV-GT-8852 ✓ | Duplicate suspect — 97% similarity to INV-GT-8841 (AI-06 alert AN-2311) | — | 18,900.00 | Blocked — human review | Daniel Chen · confirm distinct service period; alert cites both records |
REQ-2026-0533 → PO-2026-0355 Noor Development Group · CC-110 · 2-way (service) |
PO ✓ · INV-ND-0441 ✓ (no GRN — service class) | Tax mismatch — supplier TRN on invoice ≠ master 1004●●●●●●0003 | — | 11,600.00 | Blocked — vendor master fix | Daniel Chen · correct via WF-12 master-data change, not on invoice |
REQ-2026-0489 → PO-2026-0322 GulfTech Facilities LLC · CC-110 · 3-way |
PO ✓ · GRN-0779 ✓ (qty 42) · INV-GT-8830 (qty 48) | Quantity variance +6 units above 0 tolerance | +1,620.50 | 12,970.50 | Supplier dispute open | Return or credit note requested 15 Jul (WF-16 exception path) |
REQ-2026-0540 → PO-2026-0360 Marina Print House · CC-140 Marketing · 3-way |
PO ✓ · GRN missing · INV-MPH-118 ✓ | Missing receipt — campaign material delivery unconfirmed | — | 34,500.00 | Held — awaiting GRN | Receiver: Layla Hassan · confirm at Dubai HQ store |
REQ-2026-0536 → PO-2026-0358 GulfTech Facilities LLC · CC-110 · 3-way |
PO ✓ · GRN-0805 ✓ · INV-GT-8859 ✓ | Price variance +2.4% (tolerance 2%) | +312.00 | 13,200.00 | Blocked — approval required | Within escalation band ≤5% → Finance Manager may approve with reason |
REQ-2026-0525 → PO-2026-0351 Emirates Office Supplies · CC-200 IT · 3-way |
PO ✓ · GRN-0797 ✓ · INV-EOS-2216 ✓ | SoD conflict — requester = receiver (Vikram Nair) | — | 8,940.00 | Blocked — SoD review | Independent re-receipt required · flagged to Grace Okafor (Audit) |
REQ-2026-0544 → PO-2026-0363 GulfTech Facilities LLC · CC-110 · annual FM contract renewal |
PO ✓ · receipts scheduled monthly | — (open commitment, in tolerance) | — | 648,000.00 | Committed — budget checked | Budget owner CC-110 confirmed against approved budget v3 |
REQ-2026-0546 → PO-2026-0365 Noor Development Group · CC-110 · snagging works Building A |
PO ✓ · GRN pending (due 25 Jul) | — (open commitment, in tolerance) | — | 225,000.00 | Committed | — |
| Reconciliation — open commitments 38 POs = AED 1,872,450.00 · GL control 2150 = AED 1,872,450.00 | 1,872,450.00 | Unexplained difference AED 0.00 — Pass | ||||
Rows 1–10 of 45 · exceptions sorted first · drill-down opens source documents
Report definition of done (§9.2)All items evidenced
| §9.2 item | Evidence on this report | State |
|---|---|---|
| Named owner & business definition | Fatima Rashid · definition RPT-28 v1.6 | Done |
| Authoritative dataset & lineage | mart_p2p_match · lineage panel above | Done |
| Filters, dimensions, currency/TZ, refresh & certification | AED · GST · NRT + daily certified · Certified | Done |
| Permission-aware drill-down & controlled export | Source-doc drill-down scoped by role · watermarked export | Done |
| Reconciliation totals & tolerances | Commitments tie to GL 2150 · tolerance verdicts cite TOL-2026-02 | Done |
| Accessible table/chart alternative · EN/AR labels | Chart has table twin · labels approved OPS-01 | Done |
Static render mockup — no live data. Source: ERP Modern Development Specification v2.0 · Covers: RPT-28, WF-16, §9.2.