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

    • 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 ...
    • 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 ...
    • Work Order Plus Advanced Feature Manual 1

      Work Order Plus Advanced Feature Manual Chapter 1: Utilities Print Costed Bill of Material Application Overview Run Instructions Purge Complete Production Orders Application Overview Run Instructions Standard Product Routing Export Application ...
    • Work Order Plus Advanced Feature Manual 9

      Chapter 3: Advanced Features Exception Handling Mistakes occur on a daily basis preventing us from collecting accurate information, accidentally and intentionally. For example, an operator may forget to log off at the end of the day or forget to log ...
    • 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 ...