Automated Fix & Pricing (`OrderAirlock`): Starter$249/mo($2,490/yrannual, 500 POs/mo) · Distributor/FDE Pro$499/mo($4,990/yrannual, 2,500 POs/mo) — verifiesM(1,000) andC(100) price-basis math in integer micro-dollars before ERP import.
Direct Root Cause & Fix: In electrical wire and industrial fastener wholesale, buyers frequently send PO102=5000, PO103=EA, and PO104=18.50 while pricing per thousand (M / PO105=TP) for a true line total of $92.50—causing naive ERP imports to calculate 5,000 * $18.50 = $92,500.00 (a 1,000x credit-limit lockup). Fix by dividing PO104 by the M/C basis ($18.50 / 1000 = $0.0185) in micro-dollar precision.
Root Cause in PO1 Segments
DE 355codesC(PER 100,100-PK,CW) andM(PER 1000,1000-PK,TH) represent count multiples, whilePO105(DE 639Basis of Unit Price Code:PEPrice Each,HPPrice per Hundred,TPPrice per Thousand) is frequently omitted or hardcoded toPEby customer procurement portals.
Deterministic Resolution Steps
- Compare
(raw_qty * raw_unit_price)againstraw_line_totalon the incoming PO. - When
PO103isM(factor = 1000) orC(factor = 100), convert unit price to integer micros (18.50 / 1000 = $0.0185->18,500micros) rather than 2-decimal floats that round$0.0185to$0.02($100.00vs$92.50). - Emit
PO1*1*5000*EA*0.0185*PEwith exactCTThash totals.