EDI 880 Grocery DSD Router
$202.40 of $754.46 billed on 7 DSD invoices is not supported by store receiving (4 invoices need credit); $71.70 is on hold with no receipt.
Invoiced 24 - received 18 = 6 short. 6 x $2.10 = $12.60.
Method1880 segments read: G01 invoice date, number and PO; N1*ST store number (N104); G17 quantity, unit, item list cost and UPC; G69 description; G72 allowances and charges; G31 total quantity; G33 total invoice amount (implied two decimals).
2G72 amount is G7208 (implied two decimals), else G7205 rate x G7206 quantity (or the item quantity), else G7209 percent of G7210. C310, A260, B720, D170 and I530 are allowances, D240 and D500 charges (a reference subset of X12 element 1300); other codes count as charges when positive. G7202 01, 03, 04 and 05 settle off the invoice and are left out of the math.
| Store | Invoice | UPC |
|---|---|---|
| 0112 | 401188 | 084521001012 |
| 0112 | 401188 | 084521001050 |
| 0147 | 401190 |
Raw ANSI X12 880 file, plus store receiving log
Back-door reconciliation ledger (Vendor credit request ($202.40), Back-door reconciliation ledger (CSV), 997 functional acknowledgment)
$2,500 / month, 30% to the referring partner
Read in memory for the session, never stored, never used to train a model.
Standard and product names belong to their owners. BaseLoom is not affiliated with or certified by them; validate converted files with your trading partner before production use.