Feature - Improved the Additional Shipper Info for Walmart on the VICS Bill Of Lading

Release Date: 07/11/2025

Version: 8.5 & Up

A VICS Bill Of Lading can be printed for Walmart and we provide four specific fields they require on the form: Destination, PO Type, Department, and Must Arrive By Date.  Although the fields are provided, most of the information had to be manually entered.  With the new ESS solution, we can now populate those fields based on the data sent by Walmart on the 850 where Sales Order Import creates Attributes with the information.

To use this feature, you must first switch on the Custom Additional Ship Fields in the EDI Profile.  This is field 11 on screen 4.  We will use WALMRT for the customer number.

The Destination is stored in the COP Ship-To record in the Country field.

The Ship-To Number isn't always an available field, especially if you already have ship-to records established.  Since all truck shipments are within the US, the Country field becomes the logical field to store this value.

The Department Number is stored in the Department Number of the Order Header.  Department Number and Store Number are not original fields in the Order Header and a Global Setup flag must be enabled to activate these fields in COP-Func, Order Header Screen and field 6.

Now the Department Number will appear on the Order Header screen.

You can manually enter the department number or you can map the field in Sales Order Import.

The PO Type and Arrive By Date are stored in Attributes.  These rely on the SPS Attributes that can be generated in System Utilities, System Files Setup, Maintenance, Attribute File, Create, and SPS EDI Attributes.

The PO Type is stored in a Reference with a qualifier of MR.

The Must Arrive By Date is stored in a Dates field with a qualifier of 063.

These two fields can also be mapped in Sales Order Import.

Now when you create a bill of lading for customer WALMRT, the Additional Shipper Info is automatically populated.

These fields are the printed on the bill of lading.

The fields are also available if you need to print them on a shipping label.

Modified Program: CPBOLINS, CPBOLPRT

MAD

• Related Articles

• Feature - Refresh VICS Bill of Lading

  Release Date: 4/30/19 Version: 8.5 and Up Typically, users will process orders through shipping verification first and then create the VICS Bill Of Lading. The VICS Bill Of Lading will then determine the number of cartons based on shipping ...

• Feature - Sales Order Number in VICS BOL Additional Shipping Information Section

  Release Date: 5/15/25 Version: 8.5 and Above This feature allows the user to automatically copy the sales order number to the Bill of Lading Additional Shipping Information field when the Bill of Lading is created. This feature is enabled by setting ...

• Feature - Added Flag To Select The Destination Source On The VICS Bill Of Lading

  Release Date: 08/15/2025 Version: 8.5 & Up The original design used the Country field in the Ship-To record to populate the Destination field on the VICS Bill Of Lading. One customer needs to ship to a Walmart location in Puerto Rico, so the Country ...

• Can I Create a VICS Bill Of Lading For Two Different Customers?

  Release Date: 06/18/2024 Version: 7.x & Up Q - We have a customer with different divisions that are in Elliott as separate customers. Each division placed an order and the two are shipping to the same location at the same time. Can I create one VICS ...

• Feature - Create Shipment Records When Complete Bill Of Lading

  Release Date: 8/8/19 Version: 8.5 and up When orders are processed through Shipping Verification, shipment box information is generated that provides the number of packages (cartons or pallets) that is used when the EDI 856 (Advanced Shipping Notice) ...