EDI VISUALIZATION · BUILDING PRODUCTS & FLOORING

Catalog Health Monitor

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.

Illustrative data
Suppliers with a current catalog
–
 
Lines that failed item or UOM match · this week
–
 
At risk: price differs from PO · 30 days
–
 
Average catalog age
–
 
Showing all 15 suppliers Click a supplier row to filter the charts.

Catalog freshness, last 26 weeks

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.

Status compares days since the last 832 with the supplier's usual cadence: fresh, current, due soon, overdue (past cadence), stale (more than 1.5 times cadence).Mismatch % = order and invoice lines with an item or UOM mismatch or a price that differs from the PO, last 30 days.

Order and invoice lines that didn't match

Weekly share of order and invoice lines, by reason. Fresh catalogs bring it back down.

Sold by the square foot, bought by the carton

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.

PL1 pallet= 40 cartons · 620.00 SF
CT1 carton= 8 pieces · 15.50 SF
PC1 piece300 × 600 mm · 1.9375 SF

Example item: 12×24 porcelain floor tile, matte grey. Supplier item PT1224-MGRY, Cedar Ridge item CR-T1224-GRY.

Try
Catalog state

832Price/Sales Catalog

Supplier's items, pack sizes (PO4) and prices (CTP).

850Purchase Order

PO1 lines carry quantity, UOM and price.

855PO Acknowledgment

Supplier confirms or changes each PO line.

810Invoice

IT1 lines are matched to the PO.

997Functional Acknowledgment

Receipt of every X12 transaction.

What Comparatio does here

Imports supplier 832s

Supplier 832 price catalogs are imported into the ERP automatically. Empty catalogs are held back.

Translates items and UOMs

Item and unit-of-measure cross-references, with conversion factors, are kept per trading partner: SF, CT, PC, PL, LF, BG.

Compares acks to the PO

Supplier 855s are compared line by line with the PO, and price, quantity and UOM differences are emailed.

Matches invoices to POs

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.