Performing Consolidation

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.

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:

• Physical Delete: to indicate that the journals from the previous consolidation process are to be physically deleted. This option is not available if document sequencing is being used by the organization.

• Mark as Deleted: to indicate that the journals from the previous consolidation process are to be unposted and given a status of Deleted.

• Retain/Do Not Delete: to indicate that the journals from the previous consolidation process are to be unposted if they have been posted, or deleted if they have not been posted.

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.

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.

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.

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:

• OK: The node is completed and the process was successful.

• Error: An error occurred and needs to be corrected before the process can continue.

• Warning: An error occurred (for example, a journal edit error), but the process continued.

• Blank: The process has not reached this node yet.

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.