Module · sales
Sales / Order Acceptance
OA headers + line items, customer linkage, schedule integrity, customer PO trail.
Source tables: oahdr / oadtl / cust
Overall hygiene score
43.6/100
Band
poor
< 60 — fix soon
Metrics
5
checks against source tables
Trend (8 snapshots)
2026-03-18 → 2026-05-18
AI assessment
What the data is telling us
Asking Claude (Haiku) for a focused assessment of this module…
Metric breakdown
5Customer PO recorded
Open OAs (last 6 months) with a non-blank customer PO number.
0.0/100
0 of 247 records pass
247 bad records
247 bad records
Valid schedule window
OAs whose schdateto >= oadate (no negative or null windows).
79.3/100
388 of 489 records pass
101 bad records
101 bad records
Customer in master
OAs whose custcode exists in cust master table.
100.0/100
489 of 489 records pass
Item in master
OA line-items whose itemcode exists in itemmas.
12.8/100
507 of 3,968 records pass
3,461 bad records
3,461 bad records
Overdue OAs amended
Of OAs whose schdateto has passed, % that have an amendment record.
0.0/100
0 of 671 records pass
671 bad records
671 bad records