Account Classification Setup Tool of Intercompany Solution

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


Account Classification Setup Tool Window

Field

Description

Account Classification

Select the required account classification, either Balance Sheet or Profit & Loss.

Excel File Path

Specify the path of the account classification template file.

Prepare Template

Choose this button to prepare a Microsoft Excel based template.

Validate

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

Upload

Choose this button to import an account classification template file.

Cancel

Choose this button to close the Account Classification Setup Tool window.


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

  1. Select an account classification option from the Account Classification dropdown list.
  2. Choose the Prepare Template button to generate the Microsoft Excel-based template.
  3. Open the template and define the Account Code field for each Account Type. Choose the Save button to save the template.
                  Note
The account code must be set up as an all currencies account in the chart of accounts to support multi-currency transactions.
 Caution
 Do not alter the template or delete or modify records in any column other than the Account Code 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 errors and validate the template again.
      f. Choose the Upload button to import the data.
    • Related Articles

    • 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 ...
    • 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, ...
    • Define Account Classification Setup of Intercompany Solution

      When allocating incomes and expenses, the system posts to specific accounts in the receiver companies depending on the account classification and account type setup in the chart of accounts of the sender company. When posting an allocation, the ...
    • 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 ...
    • User-Defined Default Accounts Setup of Intercompany Solution

      This window enables you to define your own categories for the Default Accounts by Profit & Loss and Default Accounts by Balance Sheet setups. Note This window is only available to the head office company. This setup is used by the G/L Allocation ...