Articles and guides on purchase order data extraction, PO-to-Excel conversion, AP three-way matching, ERP import, and procurement automation.
CMiC is a construction ERP on a single database; Procore is a project management platform with no general ledger. What that means for how purchase orders, commitments and job cost actually behave, plus the Procore and CMiC connector limitation worth reading twice.
Read articleThe complete segment and element reference for the X12 846, the report type codes that say whose stock this is, and the quantity qualifier that decides whether a number is available to order or just sitting in the building.
Read articleThe complete segment and element reference for the X12 864, why BMG03 cannot route your messages, and the parsing shortcut that silently truncates the half of the notice that mattered.
Read articleThe complete OTI01 acknowledgment code table, what the TED segment actually tells you, and why a clean 997 does not mean the receiving application accepted your order.
Read articleThe four Oracle purchasing interface tables, the columns PDOI actually requires, why a NOTIFIED row is neither an error nor an import, and how to read PO_INTERFACE_ERRORS.
Read articleThe full AS2 MDN disposition modifier table from RFC 4130, why an HTTP 200 tells you nothing, what really causes a MIC mismatch, and why a processed MDN is not order acceptance.
Read articleThe complete X12 997 error code tables, why an accepted 997 does not mean your order was processed, and how to read AK3, AK4, AK5 and AK9 in the right order.
Read articleThe three tables that store an SAP IDoc, the full inbound and outbound status code list, and the programs that move an IDoc out of status 51, 64 and 30.
Read articleA field level reference for the IIF file format QuickBooks Desktop uses to import purchase orders, including the row structure, the required columns, and the five failures that silently corrupt an import.
Read articleThe four causes behind almost every Integration Manager failure in Dynamics GP, each mapped to its verified Microsoft fix, plus a preflight checklist for purchase order loads.
Read articleChoose your plan