Skip to the app
Search
The operating system for desk work that lives in files
Try a sample
Supply Chain & Retail EDI · Systems talking · Hours back · sample run · 14 ms

EDI 867 Resale Router

$1,405.00 net ship-and-debit claim from 13 resale lines ($1,500.00 of debits less $95.00 of return reversals); 6 lines blocked, with $558.50 of debit the manufacturer would reject for wrong customer or agreement dates.

Evidence · 867 report KCS-POS-2608-BOS
QTY*39*800*EA
Working

Shipped 2026-08-05 to Harlow Medical Devices, inside the SPA-26-0141 window 2026-01-01 to 2026-12-31, with 1,200 of its 5,000-unit cap left. ($1.8000 book cost - $1.3500 authorized cost) x 800 = $360.00 debit.

Method

1Delimiters read from the ISA header: element '*', component '>', segment '~'. Envelope checks: ISA13 = IEA02, GS06 = GE02, GE01, SE01 segment count and ST02 = SE02; a report with an envelope error is not claimed.

2Each PTD loop is one transfer: PTD01 type, PTD02 ship date (or DTM*011 shipped / 003 invoice), PTD04 invoice. The end customer is the N1*BY buying party (then UC, then ST). Each QTY loop inside it is one resale line with its LIN part number (MG manufacturer part first).

6
Blocked lines · $558.50 of debit not claimable
Claim lineTypeAgreement
1DebitSPA-26-0141
2DebitSPA-26-0141
3DebitSPA-26-0141
1 to 3 of 5
Reads

Raw ANSI X12 867 file, plus special pricing agreements

Produces

Resale detail and a ship-and-debit claim file (Ship-and-debit claim file (5 lines, JSON), Ship-and-debit claim file (CSV), Resale detail (CSV))

Price

$3,000 / month, 30% to the referring partner

Your files

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.