Cedar Ridge Building Supply buys from 15 suppliers that each send an 832 price catalog. When a catalog goes stale, order and invoice lines stop matching on item, unit of measure or price.
One row per supplier. Each tick is an 832 received, taller when more items changed. Shading shows how old the catalog was on each day compared with that supplier's usual cadence.
Weekly share of order and invoice lines, by reason. Fresh catalogs bring it back down.
Tile is quoted in SF, packed in cartons and shipped on pallets. Try an order line and see where the unit of measure has to be converted, and what happens when the cross-reference or the price is out of date.
Example item: 12×24 porcelain floor tile, matte grey. Supplier item PT1224-MGRY, Cedar Ridge item CR-T1224-GRY.
Supplier's items, pack sizes (PO4) and prices (CTP).
PO1 lines carry quantity, UOM and price.
Supplier confirms or changes each PO line.
IT1 lines are matched to the PO.
Receipt of every X12 transaction.
Supplier 832 price catalogs are imported into the ERP automatically. Empty catalogs are held back.
Item and unit-of-measure cross-references, with conversion factors, are kept per trading partner: SF, CT, PC, PL, LF, BG.
Supplier 855s are compared line by line with the PO, and price, quantity and UOM differences are emailed.
Supplier 810s post into the ERP as AP vouchers matched to POs, and each invoice price is checked against the PO.
Illustrative data. Partner names show trading-partner types Comparatio connects to; figures are examples.