Step 1: Tell Riege Service Team, if you need to import credit limits only or if you need to import open balances as well. Step 2: Prepare the files. Step 3: Go to Finance > Accounting for the import.
Introduction
Credit limit information/Open balances can be imported into Scope to update the data available to debtors (Master Data > Partner…Roles tab…Debtor role). As new outgoing vouchers are created for these debtors, their credit limit and current credit balance is checked. When a debtor exceeds their credit limit, the user will be informed accordingly during the creation of the outgoing voucher.
Description
You can choose to import credit limits only or both open balances and credit limits. Riege service team will set this option for you - please reach out to the team.
Structure of the credit limit file
Files must be CSV file with six columns:
|
1 |
Debit account number |
The debit account number of the business, as stored in the debtor role of the business partner |
|
2 |
Name |
ignored |
|
3 |
Name 2 |
ignored |
|
4 |
Credit Limit |
New credit limit for the accounting group |
|
5 * |
Internal Credit Limit |
New credit limit for the accounting group (can be left blank in standard cases) |
|
6** |
Balance |
The balance available to the accounting group |
- On import, the first line of the file (header) is always ignored.
- Monetary amounts in columns 4, 5 and 6 are given without a currency since the currency will always be the currency used by the debtor when setting accounts.
Monetary amounts should not have a "thousands" separator:
2000,- EUR will be shown in the file as '2000'.
350,50 EUR will be shown in the file as '350,50'. - * Column 5 is related to the accounting software of a specific customer.
- ** If you choose credit limit only option, this column will be ignored.
Performing the import
Credit limit files are imported by opening the Accounting Application (Finance > Accounting) and selecting the Import OB & Credit Limit option.
A file browser will appear and is used to locate the credit limit files on the local computer or network.
- Any number of files may be chosen for import
- The contents of the files may be mixed
If a file contains the line:
14485;000649;;20000;;200
and another line contains:
14485;000649;;20000;;5000
The credit limit for accounting group "14485" will be 20,000 EUR and the balance will be 5.200 EUR.