How to import tax information under BP Master Data (FI-CO)

Symptom

Import data into the fields Ecc.NO, CE Registration, CE Range, CE division, CE commissionerate in the table "CRD7".

The Fields Ecc.NO, CE Registration, CE Range, CE division, CE commissionerate are accessible in the Business One application under
-> Business Partner Master Data
-> Addresses tab -> Ship To address
-> Excise information button

The Fields  CST Assesse type, TIN no, LST, Service Tax, Pan Circle, Pan Ward, TAN No , Pan Assessing Officer, Trader, Nature of Business, P.A.N. no, Pan no are accessible in the Business One application under
-> Business Partner Master Data
-> Accouting Tab -> Tax tab
-> Tax Information Button


Valid for Version SAP Business One B Cluster

Solution
 

The fields of the table CRD7 are exposed to the DI API and Data Transfer Workbench (DTW) through the BPFiscalTaxId entry in the BusinessPartner object.

To be able to import data via DTW into these fields we suggest to follow the steps described below:

1. Create a data import file BPFiscalTaxId. See the sample file attached to this Note for your reference.

2. Select the business object oBusinessPartners in the first step of the DTW import.

3. Select the appropriate data import file for the BusinessPartner header object

4. Select the data file created in Step 1 for the BPFiscalTaxID lines object

REMARK:

1. Please review the attached sample file in order to recognise the different fields for the table.
In the DTW import ensure that the mapping to the different fields is correct.

2. The Fields Ecc.NO, CE Registration, CE Range, CE division, CE commissionerate are accessible in the Business One application under
have yet not been exposed via the DI API.