Product: NetSuite
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 NetSuite's Item Code (internal id), the Trading Partner's Buyer Item Number, the UPC codes, Pack Size and many other identifications or item properties.
Learn More about the Item Catalog with the below article
Primary Item
In order to use the Item Catalog with the NetSuite 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 as well as their cross-references to the table.
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 NetSuite 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 NetSuite 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
Syncing Your Items
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 NetSuite internal ID. 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 NetSuite 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 an Item
If you would like to manually add an item versus Sync to your NetSuite Item List you can do so fairly easily simply by entering the Internal ID of your Item into the Item Translation column of your Item Catalog that matches to the corresponding Primary Item Field.
NetSuite Internal ID
NetSuite uses an internal ID to mark your transactions, items, customers, and any other record stored within its system - you can find your Internal ID for your NetSuite Items within the Items List
Navigate: Lists → Accounting → Items
Copy: Internal ID
Item View - URL ID
If you're within the Item screen itself viewing a singular item, you can find the Internal ID located within your browser's URL.
Adding to the Item Catalog
You can add a new item manually simply by inserting the Internal ID from NetSuite into the Translation Column and matching it against your Trading Partner's Primary Item.
Additional Resources
rev 6/16/2023