Product: Dynamics NAV
Article Link: http://help.truecommerce.com/en/articles/8792329-dynamics-nav-adding-an-item-cross-reference
The Item Cross-Reference is a native Dynamics NAV table that the TrueCommerce Extension leverages in order to translate your Customer or Vendor specific item codes utilized within your EDI transactions (from Transaction Manager) in order to link your Trading Partner's item codes to your Dynamic NAV items.
Accessing the Item Cross-Reference
The Cross-Reference table is a native Dynamics NAV table that can be accessed from your Items List within the quick actions tab at the top of the screen.
Navigate: Home → Items
Select: (Item) → Home → Cross References
Configuring the Cross-Reference
You'll need to configure the Cross-Reference Type based on the the type of Item Code you're attempting to translate. For example if you're configuring a TUN No or an EAN No you'll configure it differently than if you were setting up a Customer Item No reference
Customer/Vendor Item No.
Item Codes that are filled in under the Customer/Vendor Item No. field are considered unique numbers assigned to the specific Customer or Vendor - as such you'll need to configure your Cross-Reference up specific to that Customer Code
Every EDI based Customer or Vendor that utilizes the Customer/Vendor Item No. field must have their own entry within the Cross-Reference table in order for orders to properly process
if a single Item Code is shared across multiple customers/vendors it's recommended to move that code into the TUN or EAN field instead and utilize the Bar Code type translation setup
Cross-Reference Type
The Cross-Reference Type determines whether this item translation is for a specific Customer or a specific Vendor - if set to the incorrect type the translation will not pickup
EDI Type | Cross-Reference Type |
Sales Agreement Customers | Customer |
Purchasing Agreement Vendors | Vendor |
Cross-Reference Type No
The Cross-Reference Type No. is utilized only for the Customer/Vendor selections - and it is the specific Dynamics NAV Customer/Vendor No that allows this item to be assigned to that Customer or Vendor card for their orders only.
Cross-Reference No
The Cross-Reference No is your actual Item Code that your Customer or Vendor utilizes - often found in the Customer/Vendor Item No. field of your Inbound/Outbound Messages at the line level.
Unit of Measure
If your Trading Partner utilizes different Unit of Measures for the same product - you must setup an entry and set the Unit of Measure within the Cross-Reference for each unit sent by the trading partner otherwise a match will not be found.
If only a single Unit of Measure is used - no entry is required.
rev 1/8/24