Sage 100 - Configuring the Item Catalog
Micah A. Parker avatar
Written by Micah A. Parker
Updated over a week ago

Product: Sage 100


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 100'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 100 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 100 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 100 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

Item 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 100 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 100 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


rev 5/18/2023

Did this answer your question?