Import/export template > Module A/P-A/R accounting > Import/export template BIC (Customer BP invoices) 

Use this template to import Customer BP invoices. By default, the template imports invoices without the transaction and ledger rate fields and uses the transaction and ledger rates from the Currency rate function (COURDEV).

To import the transaction and ledger rates as part of the template, you need to add the following fields to the template:

Divider rate (RATDIV) for the transaction rate

Multiplier rate (RATMLT) for the ledger rate

You can add as many divider and multiplier rate fields as there are ledger lines in the company's account core model (ACM). When adding multiples of each field, use the following convention:

Example: For a company with three ledger lines:

Line 1RATDIV or RATDIV(0)RATMLT or RATMLT (0)
Line 2RATDIV(1) RATMLT (1)
Line 3 RATDIV (2) RATMLT(2)

Important

If the company's ACM is set to Divider, the transaction or divider rate can be entered (RATDIV) and the ledger or multiplier rate (RATMLT) is forced to a value of 1.

If the company's ACM is set to Multiplier, the ledger or multiplier rate (RATMLT) can be entered and the transaction or divider rate (RATDIV) is forced to a value of 1.

If the company's ACM is set to Both, the transcation (RATDIV) and ledger (RATMLT) rates can be entered.

Below are some examples to explain the behavior that occurs according to the template structure used and the account core model settings of the company from which the invoices originate.

RATDIV & RATMLT not includedNo rates in the bank fileNo. of fields vs. Ledger lines in the company ACM not relevantNo ACM rate typeNo ACM rate entry
No behavior change


RATDIV & RATMLT both includedRATDIV & RATMLT both valuated in the fileNo. of RATDIV & RATMLT fields equals the No. of ledger linesDaily, monthly, etc.Both
Behavior: When importing a BP invoice with an invoicing currency different from the legal ledger currency (LEDTYP=1), the multiplier and divider rates are initialized (RATDIV and RATMLT fields) from the file for the ledgers with a different currency.
Note:If there are ledger lines that have the same ACM settings (currency, rate type, and rate entry) and if their rates are different in the file, the rate(s) from the first ledger found in the file (with same criteria) is also applied to these ledgers and the rates from the file are not considered.
If there are ledger lines that do not have the same criteria (currency, rate type, and rate entry), the multiplier and divider rates are initialized from the file.


RATDIV & RATMLT both includedRATDIV & RATMLT both valuated in the fileNo. of RATDIV & RATMLT fields equals the No. of ledger linesDaily, monthly, etc.Multiplier
Behavior: When importing a BP invoice with an invoicing currency different from the legal ledger currency (LEDTYP=1), the multiplier rate (RATMLT fields) is initialized from the file for the ledgers with a different currency.
Note:If there are ledger lines that have the same ACM settings (currency, rate type, and rate entry) and if their rates are different in the file, the rate(s) from the first ledger found in the file (with same criteria) is also applied to these ledgers and the rates from the file are not considered.
If there are ledger lines that do not have the same criteria (currency, rate type, and rate entry), the multiplier rate is initialized from the file.


RATDIV & RATMLT both includedRATDIV & RATMLT both valuated in the fileNo. of RATDIV & RATMLT fields does not equal the No. of ledger lines
Ex. Only one RATDIV and one RATMLT field
Daily and monthly, etc.Both
Behavior: When importing a BP invoice with an invoicing currency different from the legal ledger currency (LEDTYP=1), the divider rate RATDIV(0) and multiplier rate RATMLT(0) are initialized from the file.
Then for the other ledgers:
If there are ledger lines that have the same ACM settings (currency, rate type, and rate entry), the same divider rate RATDIV(0) and multiplier rate RATMLT(0) apply to these ledgers.
If there are ledgers managed with the same currency as the ledger, but with a different rate type (monthly, whereas the ledger 1 is daily), the related rates default from the currency rate function (COURDEV) and do not apply the rate from the file.

Prerequisites

Mandatory fields in the template

You must add the Divider rate (RATDIV) and Multiplier rate (RATMLT) fields to include the transaction and ledger rate fields, respectively, with the import.

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

ACCES [ACC]

Access by user

ATABDIV [ADI]

Miscellaneous tables

BID [BID]

Bank ID statement

BPADDRESS [BPA]

Addresses

BPARTNER [BPR]

Business partner

BPCINVLIG [SIL]

Customer invoice lines

BPCINVLIGA [SIA]

Customer analytical line

BPCUSTMVT [MVC]

Customer transactions

BPCUSTOMER [BPC]

Customers

BPSUPPLIER [BPS]

Suppliers

CAAUZ [CAZ]

Restriction table

CACCE [CCE]

Dimensions

CADSP [DSP]

Analytical allocations

COMPANY [CPY]

Company

FACILITY [FCY]

Sites

FISCALYEAR [FIY]

Fiscal years

GACCCODE [CAC]

Accounting codes

GACCDUDATE [DUD]

Open items

GACCOUNT [GAC]

Accounts

GAUTACE [GAU]

Automatic journals

GAUTACED [GAD]

Automatic journals (lines)

GAUTACEF [GAG]

Automatic journal formulas

GDIAACC [GDA]

Account scheme header

GJOUCOA [JCO]

Journals - Chart of accounts

GJOURNAL [JOU]

Journal codes

GTYPACCENT [GTE]

Document types

PERIOD [PER]

Periods

SINVOICE [SIH]

Sales invoices

TABCOUNTRY [TCY]

Country table

TABCUR [TCU]

Currency table

TABSIVTYP [TSV]

Customer invoice type table

TABUNIT [TUN]

Table of units of measure

TABVACBPR [TVB]

BP tax rule table

TABVAT [TVT]

Tax code table