Data Quality

Eight cross-table checks for inconsistencies the ERP can't catch.

Each check runs a specific query and lists records that fail it. Mark records as reviewed, explained, or ignored to remove them from the list. Annotations live in twin_state.db — nothing is written back to the ERP.

All checks Material qty leak Aged Returnable Gate Pass Stale Order Acceptance Aged Production Hold Production without inspection Negative qty in production Dispatch lot has no production Invoice without lot detail Refresh

Negative qty in production

product1 with negative qtyinpic / acptqty / rejqty / scrapqty
Flagged
23
Hidden · annotated
0
Compute time
602ms
As of
2026-05-18

Flagged records

23
SeverityTypeKeyDetailAction
error prodno 826356 prodno: 826356  proddate: 2024-12-06T00:00:00  itemcode: FLANGB  qtyinpic: 1760.0  acptqty: 1760.0  rejqty: 10.0  scrapqty: -10.0  
error prodno 808414 prodno: 808414  proddate: 2024-10-25T00:00:00  itemcode: OUTERRIN  qtyinpic: 1874.0  acptqty: 1874.0  rejqty: 30.0  scrapqty: -30.0  
error prodno 588151 prodno: 588151  proddate: 2023-04-13T00:00:00  itemcode: LEVERCBS  qtyinpic: 12771.0  acptqty: 12771.0  rejqty: 30.0  scrapqty: -30.0  
error prodno 586123 prodno: 586123  proddate: 2023-04-08T00:00:00  itemcode: CP-037  qtyinpic: 3923.0  acptqty: 3923.0  rejqty: 10.0  scrapqty: -10.0  
error prodno 519558 prodno: 519558  proddate: 2022-10-20T00:00:00  itemcode: SPIDER02  qtyinpic: 1200.0  acptqty: 1200.0  rejqty: 1200.0  scrapqty: -1200.0  
error prodno 394967 prodno: 394967  proddate: 2021-10-21T00:00:00  itemcode: SPROCKETNEW  qtyinpic: 92.0  acptqty: 0.0  rejqty: 9292.0  scrapqty: -9200.0  
error prodno 387655 prodno: 387655  proddate: 2021-09-27T00:00:00  itemcode: CP-002  qtyinpic: 775.0  acptqty: 775.0  rejqty: 10.0  scrapqty: -10.0  
error prodno 384516 prodno: 384516  proddate: 2021-09-17T00:00:00  itemcode: CP-003  qtyinpic: 450.0  acptqty: 450.0  rejqty: 1.0  scrapqty: -1.0  
error prodno 317122 prodno: 317122  proddate: 2021-02-12T00:00:00  itemcode: CP-030  qtyinpic: 2600.0  acptqty: 2600.0  rejqty: 30.0  scrapqty: -30.0  
error prodno 317120 prodno: 317120  proddate: 2021-02-12T00:00:00  itemcode: CP-030  qtyinpic: 4500.0  acptqty: 4500.0  rejqty: 30.0  scrapqty: -30.0  
error prodno 238213 prodno: 238213  proddate: 2020-07-20T00:00:00  itemcode: LEVERCBS  qtyinpic: 5024.0  acptqty: 5024.0  rejqty: 30.0  scrapqty: -30.0  
error prodno 224012 prodno: 224012  proddate: 2020-03-20T00:00:00  itemcode: CP-179  qtyinpic: 682.0  acptqty: 0.0  rejqty: 682682.0  scrapqty: -682000.0  
error prodno 223032 prodno: 223032  proddate: 2020-03-17T00:00:00  itemcode: OUTERRING  qtyinpic: 285.0  acptqty: 285.0  rejqty: 285.0  scrapqty: -285.0  
error prodno 210680 prodno: 210680  proddate: 2020-01-31T00:00:00  itemcode: CP-030  qtyinpic: 2848.0  acptqty: 2848.0  rejqty: 30.0  scrapqty: -30.0  
error prodno 187961 prodno: 187961  proddate: 2019-10-19T00:00:00  itemcode: CP-179  qtyinpic: 750.0  acptqty: 0.0  rejqty: 750750.0  scrapqty: -750000.0  
error prodno 119317 prodno: 119317  proddate: 2017-05-25T00:00:00  itemcode: CP-005  qtyinpic: 900.0  acptqty: 895.0  rejqty: 50.0  scrapqty: -45.0  
error prodno 107711 prodno: 107711  proddate: 2017-03-02T00:00:00  itemcode: H0030  qtyinpic: 405.0  acptqty: 404.0  rejqty: 10.0  scrapqty: -9.0  
error prodno 75105 prodno: 75105  proddate: 2016-06-08T00:00:00  itemcode: CP-079  qtyinpic: 1000.0  acptqty: 1000.0  rejqty: 10.0  scrapqty: -10.0  
error prodno 45562 prodno: 45562  proddate: 2015-05-06T00:00:00  itemcode: 128  qtyinpic: 1025.0  acptqty: 1025.0  rejqty: 1.0  scrapqty: -1.0  
error prodno 43734 prodno: 43734  proddate: 2015-04-13T00:00:00  itemcode: CP-024  qtyinpic: 1.0  acptqty: 1.0  rejqty: 10.0  scrapqty: -10.0  
error prodno 42253 prodno: 42253  proddate: 2015-03-25T00:00:00  itemcode: CP-027  qtyinpic: 500.0  acptqty: 500.0  rejqty: 30.0  scrapqty: -30.0  
error prodno 36339 prodno: 36339  proddate: 2015-01-19T00:00:00  itemcode: CP-024  qtyinpic: 1650.0  acptqty: 1650.0  rejqty: 10.0  scrapqty: -10.0  
error prodno 91566 prodno: 91566  proddate: 2014-07-01T00:00:00  itemcode: CP-004  qtyinpic: 153.0  acptqty: 153.0  rejqty: 10.0  scrapqty: -10.0