Consolidation Account Mapping Tool of Intercompany Solution

Consolidation Account Mapping Tool of Intercompany Solution

Enables the user to map an active G/L account of the consolidation company to the active G/L accounts defined in the branch company’s chart of accounts. This tool updates the Consolidation Account Mapping window.

To display the Consolidation Account Mapping Tool window, choose Administration  Intercompany Tools  Consolidation Account Mapping Tool.


Consolidation Account Mapping Tool Window

Field

Description

Excel File Path

Specify the path of the consolidation account mapping template file.

Prepare Template

Choose this button to prepare Microsoft Excel based template.

Validate

Choose this button to check the correctness and completeness of the data in the selected template.

Upload

Choose this button to import consolidation account mapping template file.

Cancel

Choose this button to close Consolidation Account Mapping tool window.


Follow the steps below to import data using Consolidation Account Mapping Tool.

a)     Choose the Prepare Template button to generate the Microsoft Excel-based template.

b)    Open the Microsoft Excel template. The template has two sheets: one contains the branch company COA and the other sheets contains the consolidation company COA.

c)     In branch company COA sheet, define the Consolidation Account Code against each Account Code and complete the mapping. Choose the Save button to save the template.

Caution

Do not alter the template or delete or modify records in any column other than the Consolidation Account Code column.

d)    Choose the Browse button to navigate to the template path.

e)     Choose the Validate button to have the system check the correctness and completeness of the data in the selected template. If an error is detected, it is displayed in the error column of the template. Rectify all errors and validate the template again.

    f)      Choose the Upload button to import the data.

    • Related Articles

    • Consolidation Setup in Intercompany Solution

      To setup the consolidation process, perform the following tasks: Define the consolidation companies in the Intercompany Landscape application and set their Company Type as Consolidation. In the Administration Console, on the Company Registration ...
    • Account Classification Mapping Tool of Intercompany Solution

      Enables the user to map an account classification to active G/L accounts. This tool updates the G/L accounts in the Chart Of Accounts window in SAP Business One. To display the Account Classification Mapping Tool window, ...
    • Account Classification Setup Tool of Intercompany Solution

      Enables you to map a G/L account to the account classifications defined in the system. This tool updates the Intercompany Account Classification by Balance Sheet and Account Classification by Profit & Loss Setup windows. To display the Account ...
    • Branch Account Setup Tool of Intercompany Solution

      Enables you to map Due From and Due To accounts in the branch accounts setup. To display the Branch Account Setup Tool window, choose Administration → Intercompany Tools → Branch Account Setup Tool. Branch Account Setup Tool Window Field Description ...
    • Define Average Rates Setup of Intercompany Solution

       Note This setup must be performed in the consolidation company. This window enables you to define the average currency exchange rates. This setup is only used in the consolidation company. When consolidating account balances are based on average ...