Flooring Supplier EDI: Keep Roll, Box, and Pallet Quantities Consistent From PO to Invoice

What this looks like in commercial flooring and interior installation

A flooring installer orders a project in boxes while its takeoff uses area. The supplier ships pallets containing different box counts and invoices using an area unit. One pallet contains a partial quantity for a later phase. The exchange needs both the packaging context and the commercial line references. Without them, a receiving import can overstate stock or accounts payable can flag a valid invoice as a price error simply because the unit basis changed.

Records, ownership, and update rules

Work through the process

1. 01
   Document the unit vocabulary

   List the units used in takeoff, purchasing, stocking and supplier invoicing for the selected products. Do not assume that a supplier's abbreviated code means the same thing as your ERP label. Confirm the actual code and conversion with the trading partner before importing quantities.
2. 02
   Map at purchase-line level

   Carry the buyer PO number, line reference and supplier product identifier through acknowledgments, shipments and invoices. Keep project or phase allocation in the internal mapping. A document-level match is insufficient when several products or finishes share one order.
3. 03
   Preserve packaging relationships

   Where the shipment message includes packaging hierarchy, retain enough detail for receiving to interpret what is on each pallet or roll. Do not multiply by a standard pallet size when the shipment contains mixed or partial packages. Verify the actual quantity in the agreed unit.
4. 04
   Compare commercial changes deliberately

   Route quantity, price and product changes from supplier responses to the buyer. Normalize the comparison using approved conversions before calling a difference an overcharge or shortage. A mathematically equivalent unit change should remain explainable, while a real substitution needs its own approval.
5. 05
   Reconcile receipt and invoice evidence

   Use actual receiving records to confirm quantity and condition, then match the supplier invoice under finance's policy. Keep damaged or held goods visible separately. Preserve transaction identifiers and processing results so a retransmission cannot create a second receipt or duplicate invoice handoff.
6. 06
   Keep price units separate from stocking units

   An item may be counted in boxes for warehouse work and priced by area on the supplier invoice. Retain both meanings in the mapping rather than changing the ERP's stocking unit to make one invoice import easier. Accounts payable should see the original price basis and the approved conversion used for comparison. Receiving should continue to count the physical packaging actually handled at the dock or site.

Handle the exceptions explicitly

Pallet contains mixed box counts

Read the supplied packaging detail and actual receipt; do not apply a blanket pallet conversion.

Invoice switches the unit basis

Normalize with the approved product conversion and show the comparison to accounts payable.

Partial roll length is missing

Hold the affected quantity for clarification instead of assuming a full roll.

What to verify before expanding

• Every quantity carries an explicit unit.
• Package counts reconcile to the actual shipment detail.
• Invoice comparisons use a documented conversion.
• Duplicate EDI messages do not duplicate mapped business records.

Technical references

• Stacksync NetSuite connector and object support
• X12 transaction sets