Import/export template >  Module Common Data >  Import/export template BPS (Suppliers)  

Display all Hide all

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).

  • GIMP(71..78) is used to import a text that will be printed on the orders sent to the supplier. It is possible to import a text of 8*100 characters i.e. 800 characters.
     
  • GIMP(81..88) is used to import a text that will be printed on the returns sent to the supplier.

Prerequisite

Mandatory fields in the template

Upon import of a supplier record, the compulsory fields are:

  • language code
  • statistical groups
  • account code
  • tax rule
  • payment condition
  • at least one address code

Error messages

The only error messages are the generic ones.

Tables used

This template can be used in import and export modes. The data is updated in the following tables :

Table

Table description

ATABDIV [ADI]

Miscellaneous tables

BID [BID]

Bank ID statement

BPADDRESS [BPA]

Addresses

BPARTNER [BPR]

Business partner

BPSCATEG [BSG]

Supplier category

BPSUPPLIER [BPS]

Suppliers

BPSUPPMVT [MVS]

Supplier transactions

CACCE [CCE]

Dimensions

CONTACT [CNT]

Contacts

CONTACTCRM [AIN]

Contact relationships

FACILITY [FCY]

Sites

GACCCODE [CAC]

Accounting codes

PFOOTINV [PFI]

Purchase invoicing elements

PRICSTRUCT [PRS]

Price structure (cust/supp)

TABCOUNTRY [TCY]

Country table

TABCUR [TCU]

Currency table

TABMODELIV [TMD]

Delivery mode table