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 1 | RATDIV or RATDIV(0) | RATMLT or RATMLT (0) |
Line 2 | RATDIV(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 included | No rates in the bank file | No. of fields vs. Ledger lines in the company ACM not relevant | No ACM rate type | No ACM rate entry |
No behavior change | ||||
RATDIV & RATMLT both included | RATDIV & RATMLT both valuated in the file | No. of RATDIV & RATMLT fields equals the No. of ledger lines | Daily, 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 included | RATDIV & RATMLT both valuated in the file | No. of RATDIV & RATMLT fields equals the No. of ledger lines | Daily, 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 included | RATDIV & RATMLT both valuated in the file | No. 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. |
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] | |
BID [BID] | Bank ID statement |
BPADDRESS [BPA] | Addresses |
BPARTNER [BPR] | |
BPCINVLIG [SIL] | Customer invoice lines |
BPCINVLIGA [SIA] | Customer analytical line |
BPCUSTMVT [MVC] | Customer transactions |
BPCUSTOMER [BPC] | |
BPSUPPLIER [BPS] | |
CAAUZ [CAZ] | |
CACCE [CCE] | |
CADSP [DSP] | |
COMPANY [CPY] | |
FACILITY [FCY] | |
FISCALYEAR [FIY] | |
GACCCODE [CAC] | |
GACCDUDATE [DUD] | Open items |
GACCOUNT [GAC] | |
GAUTACE [GAU] | |
GAUTACED [GAD] | |
GAUTACEF [GAG] | Automatic journal formulas |
GDIAACC [GDA] | |
GJOUCOA [JCO] | Journals - Chart of accounts |
GJOURNAL [JOU] | |
GTYPACCENT [GTE] | |
PERIOD [PER] | Periods |
SINVOICE [SIH] | Sales invoices |
TABCOUNTRY [TCY] | |
TABCUR [TCU] | |
TABSIVTYP [TSV] | |
TABUNIT [TUN] | |
TABVACBPR [TVB] | |
TABVAT [TVT] |