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) — compiles verifiedIMPHDR/IMPLNESISM drops in base stocking UOMs with zero paid Epicor Transaction API license required.
Direct Root Cause & Fix: Epicor Prophet 21's Scheduled Import Service Manager (SISM) rejects an entire IMPHDR/IMPLNE sales order batch when unit_of_measure on an IMPLNE row (e.g., BX or CS) is not explicitly attached to that item_id inside P21 inv_mast / item_uom. Convert pack quantities into P21's base stocking unit_of_measure (unit_quantity + 4-decimal unit_price) prior to dropping the SISM file.
Why SISM Fails Silently in Batch Drops
When SISM polls a watched folder, a single IMPLNE line carrying unit_of_measure=CA when P21 only defines EA (unit_size=1) and CS (unit_size=24) moves the import file into the .err directory and leaves inside sales unaware until the contractor calls for a tracking number.
Deterministic Fix for IMPLNE Drops
- Map customer UOM synonyms (
CA,CTN,CASE) to the exact P21 stocking UOM (EA) or configureditem_uomcode. - Populate
record_type=IMPLNE,company_id,customer_id,po_no,item_id,unit_quantity(base units),unit_of_measure,unit_price(toFixed(4)),extended_price(toFixed(2)), and preserve the buyer's raw SKU incustomer_part_no.