For CPG suppliers on Business Central
Shipped full.
Billed short.
Where Business Central EDI breaks
pixelsandclicks.com
swipe →
The mechanism
Business Central speaks no X12
Every retailer ASN passes through a connector that reads your BC records first.
Microsoft Learn
02 / 10
So who changed the number? →
The tension
Four systems, one quantity
Inside BC
Your order shows shipped complete.
Item, unit, and location all read correct.
At the dock
The receiving scan reads short.
Three hops had a chance to change it on the way.
03 / 10
The most common way it drifts →
The drift
1 case = 12 eaches
Declare the wrong unit and you report 12x what shipped, and that clean multiple is the tell.
04 / 10
Which hop tells you first? →
Who owns which hop
Only one hop warns you
Business Central
No
Item, unit, ship-to
Connector
Its log
Mapping, kit explosion
EDI provider
The 997
Syntax, never content
Retailer
No
You learn by deduction
05 / 10
A clean 997 proves nothing →
The timing trap
A registered pick is not a shipment
In an advanced warehouse setup, Business Central splits picking and shipping across two documents.
Wire your connector to the first one and your ASN reports quantities packing never confirmed.
Trigger off the posted shipment, not the pick.
06 / 10
Before the ASN goes
Four checks BC won't run for you
Item references
Audited per customer, no stale GTINs.
Unit of measure
Rounding precision set on every alternate.
Connector trigger
Fires off the posted shipment.
Ship-to record
Location code and GLN both filled.
07 / 10
Skip them and this is what arrives →
On your remittance
It arrives with no BC fingerprint
The deduction never names the system that caused it.
Reads like code 22
A billed quantity the DC never scanned in.
Reads like code 25
No receipt recorded against the invoice at all.
08 / 10
This is not a BC-only problem →
Beyond Business Central
Same chain, different ERP
NetSuite suppliers hit five different gaps for exactly the same structural reason.
Most shortage deductions are data problems, not warehouse problems.
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 Business Central checklist, all five gaps and the fix for each, on our site
We map every hop between BC and the retailer before it becomes a deduction
pixelsandclicks.com