Shipped Data Export Integrity Check

Shipped Data Export Integrity Check

Release Date: 04/14/2021
Version: 8.5 & Up

COP, Utilities, Sales Order Export, Export, and Shipped Order Data Export are used to create an Advanced Ship Notice (ASN) to send to EDI trading partners.  In cases where the box data is required, we discovered an inconsistency in the data that would not only send the wrong data, but could create an ASN in the wrong format.  The process to create the ship data is through Shipment Verification, which allows you to specify what items are packed in what box.  Once the ship data is created, the order should not be changed without removing or editing the ship data.  There are many safeguards in place to prevent this from happening, but these can be turned off or overridden.

The most common mistake is when the Quantity To Ship is reduced or a line item is deleted through Order Entry.  An item may have an initial quantity shipped of 4 with 4 confirmed through Shipment Verification.  Reducing the Quantity To Ship in the CP Order Line Item file (CPORDLIN) to 3 through Order Entry now makes it inconsistent with the Quantity Confirmed in the CP Box Ship file (CPBOXSHP).  If there is only one each per box, then there is a problem of figuring out which box should be excluded.  A bigger problem is the ship data will still contain 4 box records.  Even though the quantity shipped of 3 will be transmitted correctly, it will export the 4th box without a line item -- an empty box.



A quantity integrity check was added to the Shipped Data Export to compare the Quantity Confirmed with the Quantity To Ship.  This can be activated through a flag added to the sixth field on screen 1 of the Customer EDI Profile, ASN Required.  There are four flags associated with this field, ASN Required, ASN Required Before The 810 Invoice, Verification Data Required, and the new flag Quantity Integrity Check.




Activating this flag will cause Shipped Data Export to compare the total quantity to ship of each item with the quantity confirmed.  An inconsistency between the quantities will produce an error and prevent the data from being exported.




Modified Programs: CPSHPEDP
MAD



    • Related Articles

    • Add Ship Via Code Selection to Shipped Data Export (ASN)

      Release Date: 04/17/2021 Version: 8.5 & up In COP -> Utility -> Sales Order Export -> Shipped Data Export, a new parameter "Ship Via Code" is added. Users can use the F4 key to select by "Ship Via Group" instead. See sample screen below: The ship via ...

    • Feature - Export Serial Number with ASN (Advanced Shipping Notice / 856)

      Release Date: 2/20/2020 Version: 8.5 & Up Added support for serial numbers to Sales Order Export-> Shipped Order Data Export and Shipped History Data Export based on EDI trading partner profile flag in the first screen, "12. Export Ship Box Data / ...

    • Feature - Add Tracking Number to Shipped Data Export

      Release Date: 07/09/2021 Version: 8.5 & Up In COP -> Utilities -> Sales Order Export -> Shipped Data Export, the tracking number is added to the report. To keep the reports within the same space, the Misc. Charges & Sales Tax columns are taken out ...

    • Feature - Export Orders with WO Line Item Only in Shipped Data Export

      Release Date: 03/17/2021 Version: 8.5 & Up In COP -> Utility -> Sales Order Export -> Export -> Shipped Order Data Export, a new flag is added: 14. Export Orders with WO Line Item Only? The possible values are: Y=WO Line Item Only (All line items in ...

    • Added Preview Option to Shipped Order Data Export

      Elliott Version: 8.5 & Up Released: 07/09/2021 A Preview option was added to Shipped Order Data Export as field 16 on the parameter screen (COP -> Utilities -> Sales Order Export -> Shipped Order Data Export.) The default value for "16. Preview ...