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

    • ARSHPMNT Accounts Receivable Ship Via Code File Maintenance

      Ship Via Code File Maintenance Application Overview When you are setting up your Customer file, you will be asked to enter for each customer a Ship Via Code. This code will designate the usual method that you use for shipping purchased goods to this ...

    • CP0200 Customer Order Processing Print Pick/Pack Tickets and Ship Labels

      Print Pick/Pack Tickets & Ship Labels Application Overview Picking Tickets are documents that list all the items in the order that are eligible to be taken from stock (picked) and shipped from a particular warehouse. These items are listed in order ...

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

    • Can I Edit the Ship Date Field in PO Line Item Screen?

      Q - I noticed that there is a "Ship Date" field in the Purchase Order Line Item screen. It is not editable right now. What settings are necessary to gain access to the Ship Date field? See sample screen below. A - Before answering this question, we ...

    • CP1001 Customer Order Processing Ship-To File Maintenance

      Price Code File Maintenance Application Overview The pricing system is based on price break tables. For example, you could set up a table such that when over 100 of an item are ordered, there is a 5% discount, when over 200 are ordered, there is a ...