Product: Acumatica

Article Link: http://help.truecommerce.com/en/articles/11662122-acumatica-configuring-the-item-catalog

The Item Catalog acts as a cross-reference table for all of your Inventory Items for a particular Trading Partner providing a built in system for Transaction Manager to translate and cross-reference the various EDI required item attributes such as your Trading Partner's Buyer Item Number, the UPC Code, Pack Size and many others with that of your Acumatica inventory item.

In order to use the Item Catalog with the Acumatica integration you'll need to first define the Primary Item Field that your specific Trading Partner is going to be using to identify the Inventory Items with.

This Primary Item Field lets Transaction Manager know, which field within the Transactions it needs to look at when translating your Acumatica Inventory Items with and will ultimately drive the Item Catalog.

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 Acumatica or translate against.

Once a Primary Item Field has been properly set you will need to add the items specific to each Trading Partner to the Item Catalog so that Transaction Manager can translate and cross-reference your Acumatica items with specific EDI attributes and codes.

The easiest way to get your Item Catalog configured is by performing an Item Sync that lets you search your Acumatica Inventory directly with in Transaction Manager and select each item.

Navigate: Trading Partners → (Partner) → Translations → Item Catalog

Select: Sync

Select: (Lower) Magnifying Glass in Flyout Window

Check: Each Item desired

Drag (Optional): Existing Primary Item values onto Checked Items

Select: Sync & Save

If you would like to manually add your items into the Item Catalog you can do so by simply ensuring you enter the Inventory ID from Acumatica into the Item Translation column while the 2nd column (Your Primary Item Field) is filled out to match the Trading Partner number utilized based on that field selection.

Navigate: Inventory → Stock Items

Copy: Inventory ID

Navigate: Trading Partners → (Partner) → Translations → Item Catalog

Select: Add New Item

Item Translations: Paste Inventory ID From Acumatica

2nd Column (Primary Item Field): Enter Trading Partner's item code

rev 6/26/2025