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, choose Administration → Intercompany Tools → Account Classification Mapping Tool.

Account Classification Mapping Tool Window

Field	Description
From Account, To Account	Specify the required range of G/L accounts. Press TAB in each field to display a list of G/L accounts and select the required account codes.
Excel File Path	Select the path of the account classification 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 account classification mapping template file.
Cancel	Choose this button to close Account Classification Mapping tool window.

Use the following steps to import data using the account classification mapping tool:

a. Define the From Account and To Account fields.

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

c.  Open the template and define the Account Classification and Account Classification Id fields for each Account Code. Choose the Save button to save the template.

            Note

1.    In the Account Classification column of the Microsoft Excel template, define “B” to set the account classification for the balance sheet and define “P” to set the account classification for the profit and loss against each account code.

2.    For the Account Classification Id field, see the Default Accounts By Balance Sheet and Default Accounts By Profit & Loss windows.

              Caution 

​Do not alter the template or delete or modify records in any column other than the Account Classification and Account Classification ID column.

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

e. Choose the Validate button to check the correctness and completeness of the data in the selected template. If any errors are detected, they are displayed in the error column of the template. Rectify all error and validate the template again.

f. Choose the Upload button to import the data.

 

Next Step: Consolidation Account Mapping Tool of Intercompany Solution