For CPG suppliers on EDI
Your item file
is wrong.
How one stale field becomes a shortage deduction
pixelsandclicks.com
swipe →
The invoice
The 810 is the last document in the chain
You ship, transmit an 856 ASN, then bill with an 810. The retailer compares all three before paying.
X12 standard
02 / 10
What gets compared? →
The three-way match
Three records, one payment decision
850 + 856
What was ordered and what you said shipped.
Both inherit quantities from your item file.
Receiving scan vs. 810
What the DC counted vs. what you billed.
Any gap here becomes a shortage on the remittance.
03 / 10
Where does it go wrong? →
The mismatch
10 cases × 12 = 120 EA
The item file says 12 per case. The actual pack changed to 6. Your ERP calculates 120 eaches, but 60 shipped.
04 / 10
What happens at the dock? →
The worked example
Nobody updated the item master
The buyer changed the pack from 12 to 6. Sales confirmed it. The PO terms reflected it. The ERP didn't.
Every document after that carried the wrong quantity, and the warehouse picked the right one.
The 810 billed 120. The DC scanned 60. Shortage: 60 EA.
05 / 10
On the remittance
Same mismatch, different codes
Walmart
Code 22
Billed qty exceeds received
Walmart
Code 25
No receipt matched at all
Amazon 1P
ASN Acc.
ASN qty differs from scan
Target
SIFR
Fill rate below threshold
06 / 10
Where do you catch it? →
Before the 810 goes
Three gates that prevent it
Pre-856 check
ASN qty vs. confirmed pick, not order qty.
Pre-810 match
Invoice qty vs. ASN qty vs. PO price.
Item-file audit
Pack size and UOM current before next PO.
07 / 10
Why nobody catches it →
The pattern
It fires every month until the field is fixed
The same stale field produces the same deduction on every order to the same retailer.
Dispute cost
Often exceeds the deduction, so teams write it off.
Root cause
Invisible from the remittance. One field, upstream.
08 / 10
The real problem →
The takeaway
Data problem, not a warehouse problem
Most shortage deductions trace to a stale item-file field that traveled through every document unchallenged.
Finding which field, in which record, feeding which document is what a data-bridge assessment closes.
pixelsandclicks.com
09 / 10
Pixels and Clicks
Forensic margin diagnostics for CPG and logistics suppliers
Free calculator sizes what the gap between your ERP and your EDI feed costs
The full causal chain from item file to remittance, mapped on our site
A data-bridge assessment finds the specific field producing your recurring deductions
pixelsandclicks.com