Product: Sage X3

Article Link: http://help.truecommerce.com/en/articles/8007899-sage-x3-configuring-item-catalog

The Item Catalog acts as a cross-reference table for all your items for a particular Trading Partner providing a built in location for the Transaction Manager system and its users to have a way to reference between things such as your Sage X3's Item Code, the Trading Partner's Buyer Item Number, the UPC codes, Pack Size and many other identifications or item properties.

In order to use the Item Catalog with the Sage X3 integration you'll need to configure it first with a couple of settings within Transaction Manager such as setting the Primary Item key, adding your items and their cross-references to the table.

Your Primary Item is the item your Trading Partner will be sending you as their primary identification for any items you trade with them.

Navigation: Trading Partners → (Partner) → Preferences → Transactions

Select: Translations

You will need to set the drop-down for each document type you use to the appropriate item code that your Trading Partner is sending you as it relates in Transaction Manager. This will inform the system on which code to send to Sage X3 or translate against.

Note: The Primary Item Field needs to be a consistent, always present value sent by your Trading Partner as this is the field that'll be used to identify your Sage X3 number.

If this value is missing when a Purchase Order (850) is received the system will be unable to identify your Item Code resulting in a failed export

Once your Primary Item Field is set - you will have the option to fill out that value within your Item Catalog to match it against your Sage X3 Item Code. This step allows the system to know that every time your Trading Partner sends an primary code it can translate it into the Item Code that Sage X3 is expecting.

This can be done either manually, or by using the Item Sync option within Transaction Manager

It's recommended that you use the Item Sync option from within Transaction Manager's Item Catalog as this is the fastest, and more reliable way to ensure your Item Codes are brought overly properly

You can manually add your Items to the Item Catalog

You can pull your Sage X3 item codes from the Products tab under Common data

Navigate: Common Data → Products → Products

Copy: Product #

With your Sage X3 Item Code - you'll need to enter that into the Item Translation field corresponding to the proper Primary Item code being sent by your Trading Partner

rev 6/13/2023