Convert an X12 856 ASN to Excel
The advance ship notice is a nested document, and that is exactly what makes it hard to read. Drop it here and the shipment, order, pack and item levels come out as rows you can follow.
Drop an invoice here
What do you want to do with your invoice?
Nothing is downloaded yet.
View on screen
Export to:
Seller and buyer
Line items
| # | Description | Qty | Unit | Unit price | VAT % | Net amount |
|---|
Tax breakdown and totals
| Category | Rate | Taxable base | VAT amount |
|---|
Payment and references
Remittance items
| # | Qualifier | Reference | Amount | Paid |
|---|
EDI segments
| Segment | Element | Value |
|---|
An 856 is a tree, not a list
An 856 is a tree built out of HL segments: shipment, then order, then tare, then pack, then item, each level inheriting the one above it. Flatten it carelessly and the quantities stop meaning anything. The export keeps the level of every row, so a pack quantity is never read as an item quantity.