The import of a supplier can involve up to 5 different tables (defined below), but the main table to be set up is always the BPSUPPLIER table.
In order to modify the fields coming directly from the business partner, it is necessary to import the business partner and not import the supplier (modification of the company name, the currency etc)
It is preferable to import these records in the order of entry in the tabs that make up the BP management in order to comply with the same chronology of processes. The import of the bank ID number and contacts can refer to address codes that must have been loaded beforehand.
Import of plain texts: When necessary, it is possible to import an order text and a return text. This can be set up in the import template by using the global variable GIMP (in the template *71... fields are included).
Upon import of a supplier 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 |
---|---|
ATABDIV [ADI] |
|
BID [BID] |
Bank ID statement |
BPADDRESS [BPA] |
Addresses |
BPARTNER [BPR] |
|
BPSCATEG [BSG] |
|
BPSUPPLIER [BPS] |
|
BPSUPPMVT [MVS] |
Supplier transactions |
CACCE [CCE] |
|
CONTACT [CNT] |
Contacts |
CONTACTCRM [AIN] |
|
FACILITY [FCY] |
|
GACCCODE [CAC] |
|
PFOOTINV [PFI] |
|
PRICSTRUCT [PRS] |
|
TABCOUNTRY [TCY] |
|
TABCUR [TCU] |
|
TABMODELIV [TMD] |