Simulating company consolidation

This page allows you to define a simulation for the consolidation of a company, business segment or alternate segment. Tell me more.

Select the “Simulate Company Consolidation” link under the “Company Consolidation” business component.

The “Simulate Company Consolidation” page appears.

Enter the following fields:

Simulation Run No.

A unique number identifying the simulation run of the company consolidation (Alphanumeric, 20). Mandatory.

Note: This field can be left blank if “Automatic Generation of Consolidation Run” is set to “Yes” in the company level.

Remarks	Any observations regarding the need for the simulation (Alphanumeric, 255).
	Zoom facility available
Consolidation Option	Use the drop-down list box to select the period for which you want to consolidate the company from “Year” or “Period”. The system displays “Period” by default on launch of the page.

Enter the following fields in the “Financial Calendar Information” group box:

Financial Year	Use the drop-down list box to select the financial year for which you want to simulate the company consolidation. All the financial years that has been defined for the consolidation finance book will be available for selection in the chronological order.
Financial Period	Use the drop-down list box to select the financial period for which you want to simulate the company consolidation. All the financial periods that have been defined for the selected financial year will be available for selection in the chronological order. The system displays “Blank” by default on launch of the page.

The system displays the following:

As On Date

The date on which the selected financial year / financial period ends.

Enter the following fields in the “Simulation Options” group box:

Consolidation Group	Use the drop-down list box to select the group that you want to consolidate from “Company”, “Business Segment” or “Alternate Segment”. The system displays “Company” by default on launch of the page.
Business Segment	Use the drop-down list box to select the code identifying the business segment for which you want to simulate the consolidation. All the business segments that have been defined for the company will be available for selection in the ascending order. The system displays “Blank” by default on launch of the page.
Alternate Segment	Use the drop-down list box to select the code identifying the alternate segment for which you want to simulate the consolidation. All the alternate segments that have been defined for the company will be available for selection in the ascending order. The system displays “Blank” by default on launch of the page.
External Enterprise	Check the box if you want to consider the financial information pertaining to the external enterprise while doing the simulation.

Note: The external enterprise must be in the “Active” status.

Click the “Get” pushbutton to retrieve the finance book details.
Enter the following field in the “Simulation Information” group box:

Reporting Currency

Use the drop-down list box to select the code identifying the currency in which the consolidation report is generated. The base currency and parallel base currency of the login company will be available for selection.

The system displays the following in the multiline:

Finance Book	The code identifying the finance book.
Finance Book Description	The textual description of the finance book.
Company	The name of the company.
Parent Company Name	The name of the parent company.
Base Currency	The code identifying the base currency.
Parallel Base Currency	The code identifying the parallel base currency.
External Enterprise ID	The code identifying the external enterprise.
External Enterprise Name	The name of the external enterprise.

Enter the following field in the multiline:

Reporting Basis	Use the drop-down list box to select the basis of reporting from “Base Currency”, “Parallel Base Currency” or “Conversion”.
	Base Currency – indicates that balances in base currency will be used for simulation of consolidation.
	Parallel Base Currency – indicates that the balances in parallel base currency will be used for simulation of consolidation.
	Conversion – indicates that the balances in the base currency must be converted to the selected reporting currency on the basis of the exchange rates entered for simulation of consolidation.

Note: If “Conversion” is selected then the conversion rates must be entered compulsorily before clicking the “Simulate” pushbutton at the end of the page.

Check the box in the “Select” column of the multiline to mark a finance book / company for inclusion in the simulation run.
Click the “Save” pushbutton to save the simulation run temporarily.

The system saves the details of the simulation run. The system generates a simulation run number for the company consolidation. The actual simulation will be done after the exchange rates have been entered.

Click the “Simulate” pushbutton to simulate a company consolidation.

The system generates a simulation run number for the company consolidation. The system saves the details of the simulation run and updates the status of the simulation as “Scheduled to Start”. The system also updates the login ID of the user and the system date in the “Created By” and the “Created Date” fields.

The system displays the following:

Created By	The login ID of the user who created the simulation run.
Created Date	The date on which the simulation run was created.

To proceed, carry out the following

Select the “Apply Conversion Rates” link at the bottom of the page to modify the exchange rates for the simulation of the consolidation.

Simulating company consolidation – An overview

You can select the period or year for which you want to consolidate the finance books of a company, business segment or alternate segment. You can also define whether you want to simulate the consolidation of the company, the business segments or the alternate business segments. This page also allows you to include the financial information pertaining to an external enterprise. You can select the code identifying the currency in which the reporting of the consolidation has been done. You can also select whether you want to report the consolidation in the base currency or the parallel base currency of the company.

This page also gives you the facility to save the run details temporarily until the final run is created. The system generates a unique run number. The system also updates the status of the simulation run as “Scheduled to Start”. The system also stores the login ID of the user and the system date along with the newly created simulation run number.

What you can do in this page

Set consolidation option

Select consolidation group

Include external enterprise

Set reporting basis

Save simulation run

Generate simulation numbers

Set consolidation option

You can simulate the consolidation of the finance book available for a company, business segment or alternate segment for a defined financial year or financial period. You can select whether you want to simulate for a “Year” or a “period”.

Set the “Consolidation Option” field to “Year” if you want to simulate the consolidation of finance books for a financial year.
Set the “Consolidation Option” field to “Period” if you want to simulate the consolidation of the finance books for a financial period.

Select consolidation group

You can simulate consolidation of all the posting finance books of the company, business segments or alternate business segments. You can also simulate the consolidation accordingly.

Set the “Consolidation Group” field to “Company” if you want to simulate a consolidation for the company.
Set the “Consolidation Group” field to “Business Segment” if you want to simulate a consolidation for a business segment.
Set the “Consolidation Group” field to “Alternate Segment” if you want to simulate a consolidation for an alternate business segment.

Include external enterprise

You can also include the financial information pertaining to an external enterprise while simulating the consolidation. The financial information can be included if it has been updated.

Check the box available beside the “External Enterprise” field to include the financial information pertaining to the external enterprise.

Set reporting basis

The system allows you to report the consolidation values in the base currency or the parallel base currency of the login company. If the currency selected for reporting is different from either the base currency or the parallel base currency of the company the system also provides you an option to convert the base currency or the parallel base currency of the company to the reporting currency.

Set the “Reporting Basis” field to “Base Currency” if the currency selected in the “Reporting Currency” field and the base currency of the selected entity are the same.
Set the “Reporting Basis” field to “Parallel Base Currency” if the currency selected in the “Reporting Currency” field and the parallel base currency of the selected entity are the same.
Set the “Reporting Basis” field to “Conversion” if you want to convert the balances to the base currency if the reporting currency and the base currency of the company are different.

Save simulation run

You can save the simulation run temporarily if “Conversion” has been selected in the “Reporting Basis” field till you enter the exchange rate details.

Click the “Save” pushbutton to save the details of the simulation run temporarily.

Generate simulation numbers

The system generates unique simulation run numbers if “Automatic Generation of Consolidation Run” has been set to “Yes” in the company level. Otherwise you can enter a unique simulation run number.