Define Account Mapping

Explanation

This activity is used to map the accounts or account ranges of a selected reporting company against the accounts of the master company. The purpose of this activity is to specify which accounts of the reporting company should be considered when a balance transfer is carried out, and which accounts of the master company should be affected by those accounts of the reporting company.

Prerequisites

In order to perform this activity:

• A master company (i.e. a company with the Master Company check box selected in the Company/General tab) should exist.
• A reporting entity connected to a reporting company should exist in the master company.

System Effects

As a result of this activity, individual accounts or ranges of accounts in the reporting company are mapped against selected accounts of the master company.

Window

Account Mapping

Related Window Descriptions

Account Mapping

Procedure

To map the accounts of a selected reporting entity:

1. Open the Account Mapping window and search for the reporting entity for which you want to map accounts.
2. Create a new record in the table.
3. If you want to map an individual account of the reporting entity against the account of the master company, enter a value in the Reporting Company From Account field. If you want to map a range of accounts in the reporting entity against the account of the master company, enter values in both Reporting Company From Account and Reporting Company To Account fields. The List of Values can be used to select the required accounts.
   
   Note 1: If the reporting company and the master company are using the same Chart of Accounts, a single % sign should be entered in the Reporting Company From Account, Reporting Company To Account and Master Company Account fields to indicate that no mapping is required. Exceptions can still be entered.)
   
   Note 2: For the reporting entities defined for the companies which are not in IFS Applications, List of Values will not be available for Reporting Company From Account field and Reporting Company To Account field.
4. Select a value for the Include/Exclude field to specify whether the balances of the entered account/range of accounts should be included or excluded when transferring balances to the master company account.
5. Enter the account of the master company against which the account/account range you specified in step 3 should be mapped. Note that it is not possible to enter a master company account if the selection of accounts is excluded.
6. In the Valid From Period field, enter the period from which the mapping is valid.
7. Repeat steps 2-6 in order to enter all the required mapping rules.
8. Save the information.

Note: Account mapping is not required if a reporting entity with the type Planning is connected to the master company itself.