Skip to content

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

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


Feedback and Knowledge Base