EDI 856 - Advanced Ship Notice
The EDI 856 Advanced Ship Notification (ASN) is exported from AcctVantage to SPS Commerce in response to a valid sales order import to provide your trading partner with shipment details related to their EDI 850 Purchase Order.
This document provides a standard data ‘map’ to define which AcctVantage fields align with specific elements of the EDI 856.
EDI 856 Requirements
An EDI 856 may only be generated from an AcctVantage ERP Sales Order that originated from a valid EDI 850 Purchase Order import.
The 856 Advanced Ship Notification requires a Shipment record associated with the AcctVantage Sales Order. See the screen image below. As of this writing (July 2022), the ASN includes Shipment detail but does not include specific parcel detail.
Data Map
We are providing a list of the primary user-facing fields; there are many additional elements to the 856 needed for processing that are not called out here.
This standard may be modified as a custom project to support specific trading partner requirements.
In the table below, [ ] indicates an AcctVantage table name followed by the specific AcctVantage field name. For example, [Sales_Document]Client_Name refers to the Client Name field on the Sales Document table. Some values are static or calculated at time of export; these values are listed in place of a field name.
| AcctVantage Field (fixed value) | EDI 856 Element | Sample Data & Notes |
|---|---|---|
| Date the ASN was generated | ShipNoticeDate | |
| Time the ASN was generated | ShipNoticeTime | |
| [Shipments]ID | ID | |
| 00 | TestPurposeCode | |
| [Client]Import_ID | TradingPartnerID | Found on Additional Info 2 tab of Sales Master |
| [Shipments]ShipmentDate | ShipDate | 7/13/22 |
| [Shipments]EstimatedDeliveryDate | CurrentScheduledDeliveryDate | 7/24/22 |
| [Shipments]TrackingNumber | CarrierProNumber | 2043309094 |
| [Client]UUID or [ShipToAddress]ID | AddressLocationNumber | |
| ST (Ship To) | AddressTypeCode | |
| [Shipments]ShipTo_Name | AddressName | FreeWheelin |
| [Shipments]ShipTo_Add1 | Address1 | 1200 E Franklin |
| [Shipments]ShipTo_Add2 | Address2 | |
| [Shipments]ShipTo_City | City | Telluride |
| [Shipments]ShipTo_State | State | CO |
| [Shipments]ShipTo_Zip | PostalCode | 81435 |
| [Sales_Document]ShipTo_Country | Country | USA |
| SF (Ship From) | AddressTypeCode | Warehouse as indicated on Sales Order |
| 1 | LocationCodeQualifier | |
| [Warehouse]UUID | LocationNumber | |
| Company Name from System Setup | AddressName | |
| [Warehouse]AddressLine1 | Address1 | |
| [Warehouse]AddressLine2 | Address2 | |
| [Warehouse]City | City | |
| [Warehouse]State | State | |
| [Warehouse]Zip | PostalCode | |
| [Warehouse]Country (or US, if blank) | Country | |
| T | CarrierTransMethodCode | |
| FDEG, UPSD, Others | CarrierAlphaCode | |
| CTN | PackingMedium | |
| 1 | LadingQuantity | |
| [Shipments]Weight_Ounces | Weight | Shipments screen weight (20lb) in ounces |
| OZ | WeightUM | |
| P | PackingLevelType | |
| [Shipments]TrackingNumber | CarrierPackageID | 204309094 |
| [InvoiceDetail]Sequence | LineSequenceNumber | [InvoiceDetail] fields repeat for each line on the Sales Order |
| [InvoiceDetail]Alias or Part Number | BuyerPartNumber | |
| [InvoiceDetail]Part Number | VendorPartNumber | |
| [InvoiceDetail]QtyShip | ShipQty | |
| [InvoiceDetail]UM | ShipQtyUOM | |
| [Sales_Document]Their_PO | PurchaseOrderNumber | From the Sales Order screen |