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

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.

Modified Programs: ARCUSEXT.FD, ARCUSEDI, CPSHPEDP, CPINHEDP
EMK



    • Related Articles

    • Change - Shipping Verification Box Edit Serial Numbers

      Release Date - 1/2/18 In Shipping Verification, when the user presses the F5 key to edit box information, items can be added and deleted to/from different boxes. For serialized items this means the deletion and addition of serial numbers in addition ...

    • Feature - Amazon Routing Number (ARN) - ASN Label & VICS BOL Creation

      Release Date - 11/2/2020 Updated: 10/08/2024 Version - 8.5 & Up The nature of this project has to do with the Amazon Routing Number (ARN). The design is generic so it can work with other trading partners if they require the routing number in the EDI ...

    • 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 ...

    • Can You Explain How Elliott Stores Serial Numbers in Its Database?

      Q - Can you explain the various Lot/Serial files (IMLSHST, IMLSTRXS, IMSERREF, etc) - how/when they are populated/updated by the Elliott application and how they relate to other files? A - Here is a highlight of each one of the Elliott database ...

    • Feature - Create ASN Label Records in Order Inquiry

      Release date: 11/22/17 This feature allows ship data CSV files to be created from the Shipment Information window in Order Inquiry for orders and invoices. These files can then be used by BarTender to print ASN labels. This feature is not available ...