OrderAirlock[ ≡ ] ANSI X12 355 PO AIRLOCK
← All 15 Wholesale ERP & EDI Import Error Guides · QuickBooks Enterprise
ERR-14 • QBD-SDK-3140-INVALID-ITEM-UM-REF • GATE 2 & GATE 3 — SKU ALIAS + UOM PACK RESOLUTION

QuickBooks Enterprise Status 3140 / 0x80040404: 'Invalid Reference to Item or UnitOfMeasureSet'

Target ERP / Standard: QuickBooks Desktop Enterprise (Advanced Inventory) · Deterministic Compiler Profile: quickbooks

AUTOMATED PRE-ERP QUARANTINE & TRANSPARENT PRICING

OrderAirlock blocks QBD-SDK-3140-INVALID-ITEM-UM-REF deterministically with zero LLM calls before bad quantities or prices enter QuickBooks Desktop Enterprise (Advanced Inventory). Starter: $249/mo ($2,490/yr annual, 500 POs/mo) · Distributor & FDE Pro: $499/mo ($4,990/yr annual, 2,500 POs/mo) — 0% transaction cut.

Run <60s Broken-PO Sandbox (/desk)Inspect Live Split-Screen WorkbenchView $249 / $499 Plans
Automated Fix & Pricing (`OrderAirlock`): Starter $249/mo ($2,490/yr annual, 500 POs/mo) · Distributor/FDE Pro $499/mo ($4,990/yr annual, 2,500 POs/mo) — maps buyer part codes to full Parent:Subitem QuickBooks SKUs and expands pack quantities into base EA.

Direct Root Cause & Fix: QuickBooks Desktop Enterprise rejects SalesOrderLineAdd (Status 3140) or batch CSV/IIF imports whenever Item contains a buyer's part number (missing Parent:Subitem hierarchy) or U/M (CS, BX) does not match an active RelatedUnit in that item's QuickBooks UnitOfMeasureSet.

Why QuickBooks Single U/M Per Item vs Multiple U/M Traps Distributors

  • Many QuickBooks Enterprise company files run in Single U/M mode or assign inconsistent U/M Set names (Count in box of 12 vs CS), so passing raw CS from a customer PO immediately throws Invalid reference to UnitOfMeasure.
  • Subitems require exact colon-delimited Category:PartCode strings (Valves:APX-BV-200LF).

Deterministic Fix

Store the full QuickBooks internal_sku (Parent:Subitem) in OrderAirlock's Master Catalog, expand pack factors deterministically at Gate 3, and emit base EA quantities in <po_number>_quickbooks_so.csv.

RAW BROKEN INBOUND PAYLOAD (QUARANTINED)
Apex Mechanical,PO-410,2026-11-11,60607,BV-200,2in Valve,3,CASE,180.00,540.00
ORDERAIRLOCK VERIFIED QUICKBOOKS OUTPUT
Apex Mechanical,PO-410,2026-11-11,60607,Valves:APX-BV-200LF,2in Valve,12,EA,45.0000,540.00
COMMON PRACTITIONER DIAGNOSTIC QUERIES
  • QuickBooks status code 3140 invalid reference to QuickBooks Item SalesOrderLineAdd
  • QuickBooks Enterprise UnitOfMeasureSet U/M mismatch CSV IIF import
  • map customer part numbers to QuickBooks Enterprise Inventory Assembly Item
RELATED QUICKBOOKS ENTERPRISE IMPORT GUIDES
ERR-13: QuickBooks Enterprise Error 0x80040400: Fixing QBXML Parse Crashes on SalesOrderAddRqERR-15: QuickBooks Enterprise Sales Order .IIF / CSV Lockup: 'Transaction Is Not in Balance' & Qty*Rate DriftBrowse all 15 ERP & EDI Import Error Guides →