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

    • Enforce UPC in the Picking Ticket Print for EDI Trading Partners

      Release Date: 08/21/2022 Version 8.5 & Higher Some EDI trading partners may require that the UPC be provided on outgoing documents, like an ASN (Advanced Shipping Notice or 856) or or an invoice (810). When the UPC is not provided, the EDI ...

    • Feature - Add SHIP-TO-XREF-NO-2 Field for EDI Processing

      Article Transfer Tracker Article Transfer Tracker 100% C664 Release Date: 4/5/19 Version 8.2 and Up The feature supports a second ship-to cross-reference number that can be used when an order is exported through Sales Order Export. The original ...

    • Enforce UPC in the Purchase Order Print for EDI Trading Partners

      Release Date: 08/22/2022 Version 8.5 & Higher Some EDI trading partners may require that the UPC be provided on outbound EDI purchase orders (850). An 850 may be rejected when a UPC is not provided for a line item. Since the purchase order is ...

    • A Summary to Outline of Elliott EDI Integration Flow

      Release Date: 06/15/2023 Version: 8.x & Up Q - We currently use SPS Fulfillment Portal for our EDI processing. We are getting too great of a volume of EDI orders and we are evaluating whether to automate it with Elliott. Can you give me an outline of ...