EDI - How to Add a Ship To Cross Reference

Whenever an EDI customer has a Master - Sub relationship, you must have the sub-accounts cross referenced in the EDI set-up so that when you receive an order for a particular sub-account, the system knows which customer account number to use.

As an example, HD Supply has a Master - Sub account with WHITECAP being the master account number and then each individual store 001, 002, 064, etc. having a separate sub-account number.  The orders are placed on the sub-account but all of the billing goes to the master account.

Example:   Master Account Number: WHITECAP   Sub-Account Number: 01898804

To set-up a new Ship-To (or Sub-Account location), go to:

Ship To Locations on the Cross References menu

Or - you can click on the button under EDI transactions for Ship-To Locations in the Default AEC Navigation Menu.

When setting up a new Ship-To Location, the Trading Partner ID is filled in for the Trading Partner (in this case, WHITECAP) and the Partner Address ID will be the Location ID or Store number found in the AR Customer Set-Up Screen. The store number has to be typed exactly as you see it in the field beside Sub account store number with no additional numbers, letters, or characters. In addition, the store code in the customer's name must match this exactly as well.

Once you have the Trading Partner and Partner Address ID filled in, you can type in or search for the A/R account number and click save.  The location should be added.

• Related Articles

• EDI - Customer Stock Code Interchange (Cross Reference)

  When a customer submits an 850 Purchase Order, often they will reference their own internal stock code on the order rather than AEC's stock code. We can go ahead and enter the order after we cross reference the customer's stock code with the correct ...

• EDI - HD Supply Line Item Change Codes (850 Purchase Order)

  Whenever you make a change to an EDI line item, you also must put a code on the line to specify what change was made.  Below are the possible change codes:

• Sales Order Entry - Enter a Stock Code (Tip)

  Did you know that you can enter a Sales Order line item in SYSPRO if you don't know the Stock Code? Here is where you enter the Sales Order Line Item: If you click on the small box beside the magnifying glass on the Stock Code line, you will get a ...

• EDI - HD Supply FOB Codes for 850 Purchase Order

  HD Supply (WHITECAP) may put the following FOB codes on their purchase orders (850). These codes can be translated as follows: Buyer noted below is HD Supply (WHITECAP) CC - Collect (Buyer selects Collect - Buyer pays freight) DF - Defined by Buyer ...