Product: SAP Business One
Article Link: http://help.truecommerce.com/en/articles/9524396-sap-business-one-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 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 SAP Business One to 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 SAP Business One 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 an Item
You can easily Sync your SAP Business One Item Codes to the Item Catalog utilizing the Sync functionality of the catalog.
Navigate: Trading Partners → (Partner) → Translations → Item Catalog
Select: Sync
Enter: Search Criteria
Select: Magnifying Glass to Search
Drag/Enter: Partner's Primary Item Code to SAP Business One Item Codes
Learn how to use the Item Sync in depth below
Manually Adding an Item
If you would rather manually fill out your Item Catalog you can do so by Adding to your Item Catalog and inputting your SAP Business One Item No. into the Item Translation column of your Item Catalog.
Gathering the Item Code
Navigate: Inventory → Item Master Data
Search: For Item
Copy: Item No.
You can see a list of all Item Codes easily by utilizing an asterisk (*) in the Item Code search window of the Item Master Data
Adding to the Item Catalog
Navigate: Trading Partners → (Partner) → Translations → Item Catalog
Select: Add New Item
Enter: SAP Business One Item No. into Item Translation Column
Additional Resources
rev 6/26/24