Suppliers that ship Direct Store Delivery Consolidation (DSDC) must follow Walmart’s ASN validation process. With Walmart’s new Supplier Quality Excellence Program (SQEP), now more than ever, suppliers must ensure compliance with the latest standards for their Advance Ship Notices.
To comply with Walmart’s system, the supplier must follow the instructions for Walmart ASN Validation. First, enter the supplier’s Advance Shipping Notice (ASN) data for each purchase order (PO) shipped to Regional Distribution Centers (an ASN is also known as an EDI 856).
Then, the supplier should actively monitor for an acknowledgment of the ASN transmission (Accepted or Rejected). The supplier should then follow up on any EDI error messages (EDI 824s) or ASNs that do not successfully download into the Walmart system. The supplier should also be familiar with the suite of EDI 800 transaction codes.
To ensure that there is enough time allotted for the ASN data to run through all levels of validation in the Walmart system, the supplier should send Walmart an ASN through the EDI system simultaneous to the departure of the outbound DSDC shipment from their facility.
All suppliers may find this glossary of EDI terms helpful as a reference. Please remember that ASN data must also populate into the RDC’s system correctly, and any errors can lead to delays.
Working within the EDI framework is beneficial at all stages of the Walmart supply chain, ensuring cohesion and accountability for the warehouse and its shipment, the provider, vendor, supplier, and retailer.
Please remember that all EDI documents sent from a supplier must pass through several Walmart systems before populating into the Distribution Center tables in functional receiving status. The validation process takes approximately 2.5 hours from sending the ASN through the EDI system until the data loads in the DC system.
That timeframe is also assuming that there were no errors in the ASN. When any supplier sends an ASN to Walmart, it receives a document called an EDI 997 (Functional Acknowledgment). The EDI 997 serves as a response, or electronic receipt, between EDI transactions that alert suppliers to one of two things: either Walmart’s system has acknowledged or rejected the ASN.
If Walmart acknowledges an ASN, that means that the document appears correctly formatted and accurate and that the system can ingest the data. If the document has issues that prevent its acceptance by the Walmart system, the supplier will need to correct and then retransmit the ASN as soon as possible to ensure prompt shipping action and compliance.
Once a supplier receives an EDI 997 acknowledgment for its ASN transmission, it should be on the lookout for any potential error messages in the form of an EDI 824 (Application Advice). EDI 824 transactions always indicate a problem with the ASN. These problems or errors include an invalid Global Location Number (GLN), a missing, improper, or otherwise invalid UPC, or some other segment of the ASN that may be missing or inaccurate.
To validate the original ASN, suppliers must first correct the errors listed in the EDI 824 as quickly as possible (if not immediately) and then retransmit the updated ASN. After transmission of the updated document, the entire process starts over, meaning that a supplier in this situation should look for a follow-up EDI 997 and be aware there could still be subsequent EDI 824 transactions issued.
If a supplier fails to correct the EDI 824 errors before the freight arrives at the DC, the ASN will not be available in the system. In that case, the cargo will go into the problems/remedy category. If that happens, the freight will not move on to the stores until the supplier remedies problems, potentially negatively impacting store inventory and sales.
If a supplier does receive an EDI 997 acknowledgment, and there are no EDI 824s listed, it should be reasonably confident that the ASN loaded without issue. The supplier should still be looking for an EDI 864 (Text Message), a transaction sent when there is a problem with a digital invoice (EDI 810).
Suppliers with a valid Retail Link ID can continue to monitor their ASNs using the Order Management System (OMS). The OMS requires additional access authorization. It is a tool containing various methods to support order generation and maintenance.
Additionally, suppliers should monitor the Advanced Ship Notification Dashboard (ASND). Suppliers can access the ASND by going to Retail Link, selecting Apps, and clicking on Advanced Shipment Notification Dashboard.
This tool provides data on the metrics that measure compliance, is capable of drilling down to verify the accuracy of ASNs, and offers features that help with root cause analysis or data retention. There is also the ability to:
Remember, a supplier must first gain access from their Replenishment Manager (RM). Typically, an RM will email the Walmart BPS team asking to grant the supplier access.
To avoid errors in data validation, suppliers should ensure that they maintain the structural integrity of their ASNs. They need to avoid adding invalid items, invalid UPCs, or product overages to their ASNs. Also, suppliers must remember that ASNs must contain specific carton content. Therefore, suppliers will need to transmit item quantities with specificity regarding the individual item quantities required and in warehouse-pack multiples as appropriate.
The supplier should also review the below list of error message codes and their explanations. A supplier can avoid most errors by being mindful of the syntax, structure, and required values within that list. If an error occurs and a supplier receives an EDI 824, the supplier should quickly refer to this list to determine the problem and its remedy.
Refer to the following list of EDI 824 Error Messages for an explanation of each error code. Suppliers should use the EDI help desk at 479-273-8888 or open a ticket in Supplier Self Service (found under Apps in Retail Link) to find a solution to any ASN errors that this reference has not described.
The PO number submitted in the first element of the PRF segment is not a type 73 PO.
There are a few reasons this error could occur:
There are two reasons this error could occur:
There are two reasons this error could occur:
The Walmart item file does not recognize the UPC/EAN.
The ASN contains the incorrect destination GLN in the N1 segment for the DC listed on the PO.
The GTIN (UPC/EAN) found in LIN*UP segment does not match Walmart Item Number found in LIN*IN segment.
An Item Identification (LIN) Product/Service ID pair (LIN_02 through LIN_31) contains a UP qualifier and an ID containing one of the following errors:
The LIN segment does not include a GTIN. This segment has the following elements:
Additionally, this error can occur if the LIN position is incorrect. Currently, the ordering of the GTIN sent in the LIN matters:
This error occurs when either:
Either the MAN*GM segment (the SSCC-128 pallet label) is missing in the data, or another issue in the data structure exists.
There are plenty of things that can go wrong in the ASN process, but this guide should help mitigate those errors or help to correct them. With proper monitoring and adherence to data structures, suppliers can avoid common EDI errors and ensure compliance.
SupplyPike builds software to help retail suppliers fight deductions, meet compliance standards, and dig down to root cause issues in their supply chain.Visit their Website ➝