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

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 reason for developing this feature has to do with supporting EDI intefacing with Belk. Here is the scenario:
  1. As a trading partner, Belk sends their EDI orders to indicate the store's number.  But you will actually ship to one of their DC locations, not the store. Both the DC Location Number, Address, as well as the store number need to be returned on the EDI 856 (ASN) and 810 (Invoice) documents.
  2. The user set up Elliott's ship-to code to match the store number.  But the ship-to address matches the DC location. The ship-to Xref is the same as the store number.  We need to do this because our EDI interface uses ship-to-Xref to look up the ship-to location. So there is nowhere in our system that we store the DC location code.
  3. The reason for the creation of the Ship-To Xref 2 field is to store the DC location code.
  4. Upon the export of 856 and 810, we can export the Ship-To Xref 2 to the Order Ship-To Xref field, and that will be picked up by our EDI system and used as the DC location code.
To enable this feature  a new option has been added to the Trading Partner Profile. Go to Customer File Maintenance, bring up the specific customer in Customer Change mode and use "Special Function" to change the EDI profile. Go to "Screen 6" and you will see the following two flags:
    85. Ship-To Xref 2 Literal
    86. Export Ship-To Xref 2 in 810/856/855/865
The default value for "86. Export Ship-To Xref 2" is N. The option can only be set once the "85. Ship-To Xref 2 Literal" has been specified. If flag 86 is set to Y and the Ship-To Xref 2 value has been entered for the customer's ship-to, the Ship-To Xref 2 value will be exported instead of the Ship-To Xref value.  

See sample screen below:




85. SHIP-To Xref 2 Literal - The default is spaces. If the “85. Ship-To Xref 2 Literal” value is blank, then when entering the ship-to for a customer, the screen will have no change.



On the other hand, if the “85. Ship-To Xref 2 Literal” value is not blank, then the ship-to file xref 2 literal and field will be displayed:
    15. X-Ref#/DC Loc#
See sample screen below:


In the example above, "DC Loc#" is the “Ship-To Xref 2 Literal.”  When the user is entering data for field 15, they will first enter SHIP-TO-XREF-NO, then enter SHIP-TO-XREF-NO-2 to the right of the SHIP-TO-XREF-NO on the same line.    

Exporting SHIP-TO-XREF-NO-2

The following flag is related to this feature. The Global Setup flag in Sales Order Export field 15 controls whether the ship-to xref is exported as the store identifier.


When it is set to “Y,” then in the export routine, we will use the SHIP-TO-XREF-NO or SHIP-TO-XREF-NO2 field (depending on flag 86 above) and override the exported ORDER-SHIP-TO-XREF-NO. 

Programs Modified: ARCUSEXT.FD, CPSHPFIL.FD, ARCUSEDI, CP1001, CPCHGEDP, CPINHEDP, CPINVHDP, CPHSTEDP, CPORDEXP, CPSHPEDP

CLS/EMK




    • Related Articles

    • 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 - Prevent Duplicate Invoice Numbers with Invoice Cross Reference File

      Release Date - 3/25/19 Version: 8.5 and Up This feature uses a new table, the Invoice Cross Reference table, to determine if an invoice has already been used by another unposted or posted order. The Invoice Cross Reference is updated at the time of ...

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

    • CPSLSDSK Customer Order Processing Sales Desk

      Sales Desk Application Overview Sales Desk is designed for companies who need versatile order entry functions and improved customer service. It is designed to be used by salespersons, order entry personnel and telemarketers. Sales Desk is extremely ...