Manual Consolidation in Intercompany Solution

Manual Consolidation in Intercompany Solution

Manual Consolidation enables you to perform consolidation activity manually that is you need to export/import the financial data manually from the branch companies and import the same data to the consolidation company.

Caution

In case of multi-level consolidation, you must perform the below described activities for all of the consolidation companie, in a hierarchical manner, that is – bottom up


To perform the consolidation process manually, follow the steps below:

  1. In the SAP Business One Main Menu choose Consolidation →Manual Consolidation. In the Manual Consolidation window make the following settings:


Manual Consolidation Window

Field

Description

Export Tab

Posting Date

The posting date range for journal entries export from the branch companies.

Export Journal Entries

By default, this field is set to All, so export of journal entries is done from all branch companies to the B1i server. To export journal entries from specific branch company, select the relevant branch code and choose the Export button. Repeat this action for all the relevant branch companies. 

Export

Choose this button to export the journal entries from the selected branch company

Status

Choose this button to check the export status

Import Tab

Import Journal Entries

By default, this field is set to All so the journal entry files from all branch companies that are are imported from the B1i server to the consolidation company. To import journal entries of specific branch company, select the relevant branch code, and choose the Import button. Repeat this action for all the relevant branch companies. 

Import

Choose this button to import the journal entries data in to the consolidation company

Status

Choose this button to check the import status

Delete

Choose this button to delete the import journal entry file

Note

An exported journal entry data file is automatically deleted after it is imported to the consolidation company. To manually delete this data, select the required branch code and export filename and choose the Delete button.




Next Step: Automatic Consolidation in Intercompany Solution

    • Related Articles

    • Financial Consolidation in Intercompany Solution

      Consolidation entails combining the financial statements of two or more separate companies into consolidated financial statements. It also enables multi-tier consolidation of journal entries from various levels of the organizational hierarchy to get ...

    • Prerequisites for financial consolidation in Intercompany Solution

      To consolidate the financial figures of all Branch Companies and present them as consolidated financial statements, you need to set up additional companies in SAP Business One, one per level of consolidation. The new "consolidation" company is used ...

    • 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 ...

    • Automatic Consolidation in Intercompany Solution

      Automatic consolidation enables you to automate the consolidation process.  In automatic consolidation, you need to schedule the consolidation process subsequent to which all processes like export/import of financial data are executed automatically ...

    • Consolidation-Automation Setup of Intercompany Solution

      Note This setup is only available in the consolidation company. This window enables you to automate the consolidation process. After automatic setup, the system automatically exports the financial data from the branch companies and imports the same ...