Product: Sage 300
Article Link: http://help.truecommerce.com/en/articles/7984543-sage-300-configuring-the-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 300's Item Code, the Trading Partner's Buyer Item Number, the UPC codes, Pack Size and many other identifications or item properties.
If you're unfamiliar with Transaction Manager's Item Catalog you can learn more about it below
Configuring the Item Catalog
In order to use the Item Catalog with the Sage 300 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.
Primary Item
Your Primary Item is the item your Trading Partner will be sending you as their primary identification for any items you trade with them.
You can learn more about the Primary Item Field below
Setting the Code
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 300 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 300 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
Adding Items to the Catalog
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 300 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 300 is expecting.
This can be done either manually, or by using the Item Sync option within Transaction Manager
Item Sync
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
Manually Adding
You can manually add the items to the Item Catalog by copying the Item Code from your Items list within the I/C Items and Price Lists module of Sage 300.
Adding the Item
Navigate: Inventory Control → I/C Items and Price Lists → Items
Copy: Item Number
Paste: Into Item Translation
Additional Resources
rev 6/6/2023