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 / Serial No." The default export serial number for ASN is "N" for backward compatibility. See sample screen below:

This is done by adding the "R" record type to the ASN exported hierarchy structure as follows:
S - Shipment Record
O - Order Record
B - Box (Container) Record
L - Line Item Record
R - Serial Number Record (Newly Added Support with This Feature)
In order for the Export program to know which serial number belongs to which box and line item, we must have the serial number data in both the CPBOXSER and CPORDLS tables. That means we are assuming that you are using the "Shipment Verification" function to verify the shipment so the serial numbers are collected in the CPBOXSER table.  It is also assumed that the billing selection is completed before you send the ASN (Advanced Shipment Notice) so the serial number record is stored in CPORDLS.  If you do not meet this requirement, you will receive an error when trying to run COP -> Utility -> Sales Order Export -> Shipped Data Export.


Feedback and Knowledge Base