The main table to set up is always BPCUSTOMER.
To modify the fields coming directly from the business partner ("company name", "currency", etc.), select "BP import" and not "customer import".
The setup must follow the tab presentation order for customer management.
The import of the bank ID number and contacts can refer to address codes that have already been added.
During customer creation, at least one address must already exist to define the invoice customer address. The BP with addresses must exist for the customer creation. Otherwise, addresses must imported into the template.
Two conditions are linked to the customer:
A "command text" and an "invoice text" may be imported into the template, using the global variable GIMP (by defining the areas *71...).
A "preparation text" and an "text delivery" may be imported into the template, using the global variable GIMP (by defining the areas *71...).
Upon import of a customer record, the compulsory fields are:
This template can be used in import and export modes. The data is updated in the following tables :
Table | Table description |
---|---|
BID [BID] | Bank ID statement |
BPADDRESS [BPA] | Addresses |
BPARTNER [BPR] | |
BPCARRIER [BPT] | |
BPCCATEG [BCG] | |
BPCUSTMVT [MVC] | Customer transactions |
BPCUSTOMER [BPC] | |
BPDLVCUST [BPD] | |
CONTACT [CNT] | Contacts |
CONTACTCRM [AIN] | |
CONTTEMPL [COT] | |
FACILITY [FCY] | |
GACCCODE [CAC] | |
PITDEB [PDB] | |
REPSEC [RSE] | Secondary marketing contacts |
SALESREP [REP] | |
TABCOUNTRY [TCY] | |
TABCUR [TCU] | |
TABMODELIV [TMD] |