Symptom
In certain business Scenarios, Catalog Numbers are used for Items and Business Partners.
In the Data Transfer Workbench,
1. What template should be used to import these Catalog Numbers to the module ‘BP Catalog Numbers’ in SAP Business One?
2. Is it possible to update or remove existing Catalog Numbers via DTW?
Cause
Consulting
Solution
1. What template should be used to import these Catalog Numbers to the module ‘BP Catalog Numbers’ in SAP Business One?
The DTW template ‘AlternateCatNum’ is used to import BP Catalogue Numbers.
This template contains the business partner code, Item Code and catalog number. The catalog number is inserted in the column ‘Substitute’ in this template.
2. Is it possible to update or remove existing Catalog Numbers via DTW?
No.
It is only possible to update or remove existing Business Partner Catalog Numbers via DI API or Business One Client.
See attached SDK project to demonstrate how to update and remove existing Business Partner Catalogue Numbers via the DI API:”BPCatalogueNumber_DIAPI_VB6.zip”
Note:
For certain Business Processes it is possible to create several different Business Partner Catalog Numbers (Substitute) for the same Business Partner (CardCode) and Item (ItemCode).