EDI 856 Advance Ship Notice (ASN) Inspector, Excel Converter & Label Generator

Untangle nested Shipment → Order → Tare → Pack → Item HL loops into a flat Excel packing list and print matching 4x6" GS1-128 carton labels.

Drop your file below, check the order, then download for Excel (.XLSX) & CSV.

1Load your order file
2Check it and match your SKUs

Drop your EDI order file here

.edi, .x12 or .txt. The file is read on your computer and is not uploaded.

Now showing

target-856-asn-sotpi.edi

No file handy? Open a sample:

No chargeback risks found. This order passes every check.

Checked against the Target supplier guide for EDI 856.

Verified 3 GS1-128 (SSCC-18) Modulo 10 barcodes across 7 HL hierarchy nodes.

Raw EDI Code Inspector

39 lines

1ISAISA*00* *00* *12*5551234567 *08*6111470100 *261109*1415*U*00401*000020856*0*P*>~

2GSGS*SH*5551234567*6111470100*20261109*1415*20856*X*004010VICS~

3STST*856*0001~

4BSNBSN*00*SHP-20261109-01*20261109*1415*0001~

5HLHL*1**S~

6TD1TD1*CTN25*2****G*48.5*LB~

7TD5TD5*B*2*ODFL*M*OLD DOMINION FREIGHT LINE~

8REFREF*BM*BOL-99887766~

9REFREF*CN*PRO-1122334455~

10DTMDTM*011*20261109~

11DTMDTM*017*20261113~

12N1N1*SF*ACME HOME GOODS WAREHOUSE*92*WH-01~

13N3N3*1200 INDUSTRIAL PKWY~

14N4N4*DALLAS*TX*75201*US~

15N1N1*ST*TARGET REGIONAL DC 0555*92*0555~

16N3N3*3000 TARGET WAY~

17N4N4*MIDLOTHIAN*TX*76065*US~

18HLHL*2*1*O~

19PRFPRF*TGT-PO-889900***20261105~

20REFREF*DP*049~

21REFREF*IA*9876543~

22HLHL*3*2*T~

23MANMAN*GM*00106141410000099990~

24HLHL*4*3*P~

25MANMAN*GM*00006141410000010004~

26HLHL*5*4*I~

27LINLIN*1*IN*049-12-3456*UP*012345678905*VN*SKU-TOWEL-BLU-L~

28SN1SN1*1*50*EA~

29PIDPID*F****ORGANIC COTTON BATH TOWEL ROYAL BLUE~

30HLHL*6*3*P~

31MANMAN*GM*00006141410000010011~

32HLHL*7*6*I~

33LINLIN*2*IN*049-12-3499*UP*012345678912*VN*SKU-ROBE-WHT-XL~

34SN1SN1*2*30*EA~

35PIDPID*F****LUXURY WAFFLE ROBE WHITE XL~

36CTTCTT*7*80~

37SESE*35*0001~

38GEGE*1*20856~

39IEAIEA*1*000020856~

BSNBeginning Segment for Ship Notice (856)

Line #4

Identifies the physical shipment in an EDI 856 ASN and declares the hierarchy structure (e.g., 0001 for SOTPI/SOPI).

BSN01Transaction Set Purpose Code

BSN02Shipment Identification (SID)

SHP-20261109-01

BSN03ASN Creation Date (YYYYMMDD)

20261109

BSN04ASN Creation Time (HHMM)

1415

BSN05Hierarchical Structure Code

0001

Packing List & Advance Ship Notice (ASN)

Shipment ID

SHP-20261109-01

Carrier

ODFL · OLD DOMINION F

BOL / Tracking #

BOL-99887766

Total Shipped Units

80 EA (2 Cartons)

Carton Barcode (SSCC-18)	Purchase Order #	Ship-To Warehouse / DC	Your SKU & Item ID	Shipped Qty
00006141410000010004 Pallet: 00106141410000099990	TGT-PO-889900 Dept: 049	TARGET REGIONAL DC 0555 DC #0555 · ZIP 76065	Item: 049-12-3456 · UPC: 012345678905	50 EA
00006141410000010011 Pallet: 00106141410000099990	TGT-PO-889900 Dept: 049	TARGET REGIONAL DC 0555 DC #0555 · ZIP 76065	Item: 049-12-3499 · UPC: 012345678912	30 EA

View Advanced Packaging Hierarchy (Optional)

Level #1 (Shipment) [S]

Level #2 (←1) [O]

Level #3 (←2) [T]

Level #4 (←3) [P]

Level #5 (←4) [I]

Level #6 (←3) [P]

Level #7 (←6) [I]

Download for your software

Pick where the order is going, then download. Files are ready for Excel, QuickBooks, Shopify or a thermal printer.

Clean Excel spreadsheet with all order lines, store breakdown, quantities, and prices ready to open in Microsoft Excel or Google Sheets.

Field mapping table: which EDI segment fills which column (for IT & bookkeepers)

EDI 856 SOTPI Hierarchy to Flattened Packing List Mapping

Deterministic segment-to-column mapping rules enforced by our client-side X12 engine

Source X12 Segment / Element	Sample Raw Value	Target ERP / CSV Column	Transformation & Validation Logic
HL (Level S) + BSN + TD5 + REF*BM	SHP-20261109-01 / ODFL	shipmentId / carrierScac / bolNumber	Root Shipment attributes inherited by all child cartons and items.
HL (Level O) + PRF + REF*DP	TGT-PO-889900 / Dept 049	poNumber / departmentNumber	Order-level PO # and Department # attached to all packs under that order.
HL (Level T & P) + MAN*GM	00006141410000010004	palletSscc / cartonSscc	Extracts and Modulo-10 validates 20-digit pallet and carton SSCC-18 barcodes.
HL (Level I) + LIN + SN1 + PID	50 EA of 049-12-3456	buyerSku / upc / shippedQty	Leaf item quantities and product IDs combined with all ancestor attributes.

Critical Chargeback & Import Pitfalls We Prevent

Common EDI mistakes that trigger $250+ retailer fines or accounting balance errors

Sending 856 ASN After the Truck Arrives at the DC

Risk: $500+ Late ASN Chargeback

Retailers require the 856 ASN to be transmitted and accepted before the physical shipment reaches the distribution center gate.

Validate your 856 with our Chargeback Linter before transmission so it is never rejected by a 997/824 error.

Invalid SSCC-18 Check Digit in MAN*GM

Risk: $250 Per Carton

A single typo in the 20-digit MAN*GM segment invalidates the Modulo 10 check digit.

Our linter verifies every MAN*GM segment and can auto-heal bad check digits.

Orphan HL02 Parent Pointers

Risk: 997 / 824 Structural Rejection

If HL*6*3*P points to HL*3, then HL*3 must exist earlier in the transaction.

Inspect the interactive S→O→T→P→I topology badges in the right pane.

How to Flatten an EDI 856 ASN to Excel & Print 4x6 Labels

Zero middleware setup — complete in under 60 seconds

1. Drop Your EDI 856 File into the Inspector

View the S→O→T→P→I hierarchy tree and verify zero Modulo 10 barcode errors.

2. Click "Print 4x6" GS1-128 Carton Labels PDF"

Generate thermal shipping labels that match your 856 MAN*GM segments 100%.

3. Export Flattened Packing List to Excel (.XLSX)

Download the unified spreadsheet showing Pallet SSCC, Carton SSCC, PO #, SKU, and Qty on every row.

Frequently Asked Technical Questions

ANSI X12 specification details, retail companion rules, and ERP import answers

Does the flattener support both SOPI (Standard Pack) and SOTPI (Pick and Pack)?

Yes. Our recursive ancestor-backtracking algorithm handles any HL nesting order (SOTPI, SOPI, SPOI) automatically.

Can I print 4x6 Zebra labels directly from an existing 856 file?

Yes. Load any 856 ASN and click "Print 4x6" GS1-128 Carton Labels PDF" to render labels for every Pack (P) node.