Mapping both chart of accounts
Mapping both chart of accounts
Mapping allows transfer of transaction values in General Ledger from our chart of accounts to chart of accounts for external reporting. This mapping is set before data collection. If new account numbers are added to chart of accouts in the working database, then the mapping must be altered to include mapping for new accounts.
Mapping is done on panel Replace/Exclude Accounts:
As seen from picture, account number in working database si 1200. We have to transfer all transactions to account 4730. Type Replace is selected and replacemet is checked as active.
The following data must be entered for each mapping:
| Column |
Description |
| Account (affilliate) |
account from working database is entered. Special characters can be used (? and _) |
| Account (ours) |
account for external reporting from chart of accounts in the new database is selected |
| Name |
displayed name of account |
| Type |
We can exclude or replace transaction from working database |
| Being Established |
if checked then replacement/exclusion is done |
| Exchg. rate type |
You can define exchange rate for each account separately. you can define exchange rate for all account in created document as well (suggested) |
| No linked subjekt's posts |
This is the reverse option for exclude demengers on reports
Exclude demengers- option on reports: Program exclude posts betwen seperate figures according to the VAT number entered at subject. Meaning: if posts between mother/daughter1/daughter2 or eny other seperate figure exist in DB and that subject is entered in main DB with the same VAT number, posts will be excluded at gathering data.
|
| % of value |
Option to set percentange for transfer amounts for accounts |
Import of mapping from external Microsoft Excel File
If mapping is prepared in Microsoft Excel file, it can be imported into program by clicking button Import Chart of Accounts:
The structure of the Excel file is:
| Column |
Description |
|
Subject
|
Affiliated company name |
|
Account in linked database
|
Accounts in source database |
| Account in master database |
Accounts in target databae |
| Type of action |
Z - replace, I - Exclude account |
| Enabled |
Setting is enabled (T) or disabled (F) |