Consolidation-Automation Setup of Intercompany Solution

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 in to the consolidation company without any user input.

​

To display the Consolidation-Automation window, choose Administration → Setup → Intercompany → Consolidation-Automation.

Automatic Consolidation Window

Field

Description

Start Date

Set the start date for exporting financial data recorded from that date on that must be used for consolidation reporting

For example, if the user enters the Start Date as 01/01/2010, then the Automatic Consolidation process includes in the export journal entries from the date 01/01/2010 till current date. Current date is the date on which automatic process is executed.

Frequency

Choose whether to export the journal entries on a Daily, Weekly, or Monthly basis. The default frequency is set to Daily.

Branch Code

Displays the branch code. All Branch codes are listed in this window. This field is read-only

Execution Time(Hour), Execution Time (Minute)

Set the execution time (hour, minute) 

Start/Stop

Choose this button to start the consolidation automation process. Once the process is started button label is changed to Stop. Choose the Stop button to stop the consolidation automation process. If there is any export or import process ongoing, the system will not allow to stop the scheduled automatic consolidation process.

Export Check Status/ Import Check Status

Choose this button to check the Export/Import status.

Update / Ok

Choose this button to save changes to the data.

Cancel

Choose this button to ignore any changes and close the window.


    • Related Articles

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

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

      When consolidating between multiple currencies, you must define the Consolidation Translation Method (exchange rate translation method) for each G/L account in the chart of accounts.  Note This setup must be performed in all branch companies This ...