Consolidation Configuration

Consolidation Configuration


  1. In the top menu bar of the Administration Console, choose the Preferences option.
  2. In the left frame, choose the Consolidation Configuration option.
  3. To consolidate journal vouchers during the consolidation run, select the checkbox next to the Replicate Journal Voucher field.
  4. To replicate period end closing journal entries during the consolidation run, select the checkbox next to the Replicate Period End Closing Journal Entries field.
  5. If you select this checkbox, then “Period End Closing Journal Entries” will be imported in to the Consolidation company(s) from the branch companies during the Consolidation process execution.
  6. After the consolidation process is executed, if user runs the Profit & Loss report in Consolidation company then report displays blank data, this is due to the reason as “Period End Closing Journal Entries” are posted in Consolidation company that nullifies the Profit & Loss Account balances in the Consolidation company(s).
  7. Set the journal entry batch size to be imported during the consolidation run in Consolidation Batch Size field, the value is set to 500 by default. 
  8. When you are importing Journal Entries for large date range, you may specify the batch count accordingly. For example, if the Journal Entries count is more than 50000, you may specify the batch size of 5000.
  9. 'Consolidation Company Name' Consolidation Mode displays the financial consolidation process set in the consolidation company i.e. manual or Automatic.
  10. Choose the Save button.

Caution

If you encounter some problems during consolidation processing, you may choose the Reset button to clear the consolidation queues. Note that choosing the reset button deletes all export and import consolidation data and terminates the consolidation processing. However, resetting the consolidation does not impact the data in the consolidation companies.

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

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

    • 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 Accounts Setup of Intercompany Solution

      Note This setup is only available in the consolidation company. To display the Consolidation Accounts Setup window, choose Administration → Setup → Intercompany → Consolidation Accounts Setup Consolidation Accounts Setup Window Field Description ...

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