Performing Consolidation
Page Name |
Definition Name |
Usage |
---|---|---|
CONSOL_REQUEST |
Identify consolidation parameters that the system will process and how often the GLPOCONS COBOL process will run. |
|
CONSOL_PROCESS_INQ |
View how and when consolidation processes are run. This page also shows you the parameters used for undoing previous consolidation processes. |
|
CONSOL_PROCESS_MON |
View the consolidation process status at the tree node level. You can also query the calculation log based on user-specified criteria. |
Use the Consolidation Request page (CONSOL_REQUEST) to identify consolidation parameters that the system will process and how often the GLPOCONS COBOL process will run.
Navigation:
This example illustrates the fields and controls on the Consolidation Request page. You can find definitions for the fields and controls later on this page.
![Consolidation Request page](img/i2a517932n-7f3a.png)
Request Parameters
Field or Control |
Description |
---|---|
SetID |
Select the SetID of the consolidation set for which you want to run the consolidation process. |
Currency |
Currency used in the consolidation. |
Consol Set (consolidation set) |
Select the consolidation set to use for the consolidation process. |
As of Date |
Serves as a point of reference for determining the year and period to consolidate for each ledger in the consolidation. If business units use different calendars, the system evaluates the year and period for each. This date is also used to access the effective-dated setup. |
Consolidation Options
Field or Control |
Description |
---|---|
Create Journal Entries |
General Ledger creates journals that can be edited and posted. |
Create Calculation Log |
Creates a calculation log that contains the amounts generated by each elimination and minority interest set at each tree node. After the system creates the log, you can inquire on the calculation log with the Consolidation Process Monitor page, or run the Consolidation Out of Balance (GLS2003) and the Minority Interest Eliminations and Adjustments (GLS2004) SQRs. The Consolidation Out of Balance report examines the elimination sets for the consolidation as of the date specified, indicates which elimination sets are in balance and which are not, and shows you the details of any out-of-balance condition. The Minority Interest Eliminations and Adjustments report details the majority and minority parent eliminations and adjustments based on the hierarchical relationship of business units present in the tree. |
Include Adjustment Period(s) |
Includes balances from the adjustment periods specified in the consolidation set when calculating the elimination. |
Edit Journal(s) |
Provides the ability to identify an edit error and process the consolidation again. The system clears journals from the original process before regenerating. Not available if Document Sequencing is enabled at the system or business unit level. |
Post Journal(s) |
Posts journals during consolidation processing. Not available if Document Sequencing is enabled at the system or business unit level. |
Undo Previous Process |
Select the Undo Previous Process check box when you need to rerun a consolidation for a period that has already been processed. Selection of this check box clears the entries that were created by the previous consolidation for the requested processing periods. If the elimination journals are not yet posted to General Ledger, the process deletes them. If they have been posted, the process removes the amounts from the ledger before it deletes the journals. The same applies to elimination reversal entries. The system identifies the previous process by looking at the key fields in a consolidation process log that stores information about previous processes. You can view the process log on the Consolidation Process Log page. The extent of the Undo process is based upon whether the Include All Lower Level Nodes check box is also selected. Selecting the Undo Previous Process option alone reverses only the outcome from a single process with matching Consolidation Set, As Of Date, currency, tree name, tree level, and tree node as designated on the current run control. |
Include All Lower Level Nodes |
Click this option after selecting the Undo Previous Process check box if you want to remove the results of previous consolidation processing of lower-level nodes before processing the tree again at the same or higher levels or nodes. |
Journal Delete Option |
Select an option that indicates how the system handles journals from a previous consolidation process when performing an Undo. Options include:
This is an open field when the Undo Previous Process check box is selected. This option is useful to organizations that operate in countries where document sequencing is required or for organizations that use data warehousing or a metadata storage process. If the previous journals are deleted, the sequencing of documents and metadata no longer agree with the data. |
Note: If the process ends prematurely during an Undo process, unlock the journals for the process instance before rerunning the Undo process.
Scope of Consolidation
Field or Control |
Description |
---|---|
Tree |
Specify the applicable tree for the consolidation. |
Scope |
Chose Process the Whole Tree to processes all entities defined in the consolidation tree. If you choose Process a Level or Process a Tree Node, the Level and Node fields become available. |
Level |
Processes all business units at and below a particular tree level. Identify the level in the edit box. |
Node |
Processes consolidated business units at and below a particular tree node. Identify the node in the edit box. |
Tree Effective Date Option
Field or Control |
Description |
---|---|
Use As of Date |
Uses the date defined for the consolidation. |
Use Override Date |
Select and use any date that you define in the Tree Override Date field. For example, you may want to consolidate based on a tree that is not yet active to test (using current figures) its effect on future consolidations. |
Use the Consolidation Process Log page (CONSOL_PROCESS_INQ) to view how and when consolidation processes are run.
This page also displays the parameters used for undoing previous consolidation processes.
Navigation:
This example illustrates the fields and controls on the Consolidation Process Log page. You can find definitions for the fields and controls later on this page.
![Consolidation Process Log page](img/i2a517932n-7e1e.png)
This information is useful if you want to undo a previous consolidation process, but have forgotten what parameters were used for that process.
The fields on this page are the same as those found on the Consolidation Request page.
Use the Consolidation Dashboard page (CONSOL_PROCESS_MON) to view the consolidation process status at the tree node level.
You can also query the calculation log based on user-specified criteria.
Navigation:
This example illustrates the fields and controls on the Consolidation Dashboard page. You can find definitions for the fields and controls later on this page.
![Consolidation Dashboard page](img/i2a517932n-7f29.png)
The Consolidation Dashboard provides an easy way to view and analyze the results of a given consolidation set by date.
Field or Control |
Description |
---|---|
Tree |
The Tree Control area displays the consolidation process status of a given Consolidation Set and Tree, between a certain From Date and To Date. |
Calculation Log Criteria
Field or Control |
Description |
---|---|
Elim. Set (elimination set) |
Specify an elimination set to inquire on consolidation results related to that elimination set. |
Minor Set (minority interest set) |
Specify a minority interest set to inquire on consolidation results related to that minority interest set. |
Unit |
Specifies a business unit to inquire on consolidation results related to that business unit. If there is an error involving a business unit, you can click the Exception button to the right of the Unit edit box to display information in the Message dialog box. |
Node |
The consolidation tree is color-coded with the status of each node. Click the node on the tree and click the Exception button to the right of the Node edit box. The system displays a message about the node status in the Message dialog box. |
Message |
Displays messages regarding the consolidation processing status of a business unit or a node. If there is an error status and the error has been corrected, you can rerun the same process. The consolidation process resumes from the point where the error occurred. Status codes include:
|
Consolidation Calculation Log
Field or Control |
Description |
---|---|
Consol Entity (consolidation entity) |
The business unit or the values of your consolidation entity (for example, operating unit). |
Identifier |
Stores either the elimination set or the minority interest set. |
Entry Type |
Identifies one of the following entry types: elimination, majority parent adjustment, majority parent elimination, or minority parent adjustment. |