Module · invoice
Invoicing
Invoice traceability — lot detail, heat number, customer linkage.
Source tables: invhdr / invlotdetail / cust
Overall hygiene score
71.0/100
Band
watch
60-79 — needs attention
Metrics
3
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
3Invoice has lot detail
Invoices (last 3m) with at least one invlotdetail row — required for traceability.
99.0/100
9,551 of 9,647 records pass
96 bad records
96 bad records
Heat number on lot
invlotdetail rows with non-blank HeatNo.
0.0/100
0 of 11,728 records pass
11,728 bad records
11,728 bad records
Customer in master
Invoices whose custcode exists in cust master.
100.0/100
20,035 of 20,037 records pass
2 bad records
2 bad records