Monitoring and Analyzing Consolidations

This chapter provides an overview of the analysis and monitoring tools and discusses how to:

Monitor ledger preparation and consolidation processing status.
Review ledger balances.
Compare ledger balances.
View trial balances.
View pro forma trial balances.
View audit trails.
View data flows.
Analyze the impact of changes to consolidation-dependent rules.
Analyze consolidation runs.
Match intercompany balances.
Generate consolidation reports.

Understanding the Analysis and Monitoring Tools

This section provides an overview of the available monitoring and analysis tools, explains how the system uses reporting trees, and describes consolidation data source values.

PeopleSoft Enterprise Global Consolidations provides many tools that enable you to view different aspects of consolidations, including monitoring the status of each phase of consolidation, ledger enrichment, and ledger preparation, viewing a trial balance of the consolidation ledger—either prior to (pro forma) or after posting consolidation-related journals, and navigating through an interactive audit trail of the consolidation ledger data.

This table lists the available analysis and monitoring tools and describes the type of information that they provide:

Ledger Preparation Manager	View the status of each phase of ledger preparation processing: loading source ledger data, receiving external data sources such as spreadsheet upload, mapping calendars, converting currency, mapping ChartFields (accounts), verification of source data, and creating the consolidation ledger.
Ledger Enrichment Manager	View the status of each phase of ledger enrichment processing: harmonization entries, translations adjustments, and source flows. Harmonization entry is a manual process that you can use the ledger enrichment manager to update the status of these processes as well as view the status.
Consolidation Manager	View the status of each phase of consolidation processing: eliminations, equitization, noncontrolling interest, journal flows, close process, and period locking.
Ledger Inquiry	View ledger balances hierarchically, with amounts grouped by a reporting tree. Optionally, show trends, limit the view to only a filtered subset of the entire ledger, if desired filter by the book code dimension, and generate a chart of the data. If book code functionality is available, you can select this option and the Ledger Inquiry report displays separate amounts by book code when drilling down from inquiries on the consolidation audit.
Variance Inquiry	Compare ledger balances from different scenarios or periods of time. Optionally, show trends, limit the view to only a filtered subset of the entire ledger, if desired filter by the book code dimension, and generate a chart of the data.
Trial Balance	View the consolidation ledger, incorporating only source data and posted journals. Summarize the data by account, with an option to navigate to details of additional dimensions such as book code.
Proforma Trial Balance	View the consolidation ledger, incorporating source data for posted and nonposted journals. Enables you to check the impact of consolidation processing prior to posting any journals. Summarizes the data by account, with an option to navigate to details of additional dimensions such as book code.
Consolidation Audit	Navigate through an audit trail of the consolidation ledger data, viewing the history of activity from the consolidation ledger level back to the source ledger level, or view journal data. Use this tool to determine how the system arrives at a particular balance. If book code functionality is available, you can select this option and the Ledger Inquiry report displays separate amounts by book code when drilling down from inquiries on the consolidation audit.
Flow Inquiry	Use the flow templates and flow inquiry to review translated flow amounts for all the ledger business units within a scenario. View source and journal flow amounts hierarchically according to cash flow rate or closing rate translation types, with amounts grouped by a business unit reporting tree. . If book code functionality is available, you can select this option and the Flow Inquiry report displays separate amounts by book code.
Match Results Inquiry	Preview the outcome of intercompany eliminations by viewing the balances that are matched among business units for an elimination rule set.
Impact Analysis	Determine which consolidation tree nodes need to be rerun if any changes occur after consolidations are initially processed. This information can help you determine which entities within a consolidation may be impacted by changes to any of the supporting rules.
Consolidation Run Analysis	View differences between consolidation runs.

Note. To improve performance of these pages, run tree flattener on any of the dimension trees used in your inquiries.

See Running Tree Flattener.

Reporting Trees

Both the Ledger Inquiry page and the Variance Inquiry page use a reporting tree by which to group ledger balances. Often the consolidation tree is based on business unit, and you specify a reporting tree based on your account rollup structure. This provides you with a view of the ledger balances summarized by account. Optionally, you can limit the view to only a certain set of records, by specifying criteria for which objects to include. As you view the results, you can navigate through the reporting tree, viewing summarized totals for each node. When you reach an end node—a node that has no levels beneath it—you view the details that comprise that amount. You can specify additional dimensions to include with the details. Using the same example of a business unit-based consolidation and an account reporting tree, if you select ledger business unit and department as the additional dimensions, when you click a ledger balance for a particular account, the information is grouped by ledger business unit, then department.

Note. If the reporting tree is a detail tree (also referred to as a summer tree), rather than a node-oriented tree, you must set the use of levels to either strictly enforced or loosely enforced. You cannot have detail values (or ranges) at the same level as nodes.

See Enterprise PeopleTools PeopleBook: Tree Manager

Consolidation Data Source

The GC_SOURCE field stores the consolidation ledger data source—the process from which it originates. The system uses this information when processing consolidations, processing ledger enrichment, and running ledger preparation, and generating the consolidation audit trail. In some of the consolidation pages, the field's numeric value appears instead of its translate table description. This table lists each GC_SOURCE value and its description:

GC_SOURCE	Description
01	Source ledger balance. The data originates from the source staging ledger.
1A	Spreadsheet / Manual Entry The data originates from a spreadsheet upload or manual entry.
02	Currency conversion adjustment. The data originates from a currency conversion adjustment during ledger preparation processing.
2A	Currency conversion adjustment - manual entry The data originates from a manual currency conversion adjustment.
03	Manual journal entry. The data originates from the Manual Journal Entry page.
04	Elimination entry. The data originates during consolidation processing, when eliminating intercompany transactions.
5A	Equitization entry. The data originates from the equitization process. These are the equitization entries that the system records against the parent entity to update the investment in subsidiary and subsidiary offset accounts. Also includes entries to the offset balance accounts for financial-statement-based consolidation ledgers.
5B	Eqtz – Elimination entry. The data originates from the equitization process when eliminating the 5A equitization entries.
5C	NCI for Current Earnings. The data originates from the equitization process when processing noncontrolling interest for current period earnings of subsidiaries.
5D	Eqtz – Subsidiary Offset entry. The data originates from the equitization process when the system creates offset entries for current earnings of subsidiaries to the specified target account.
5E	Eqtz – Elimination of NCI. The data originates from the equitization process. This is an optional step that occurs when the processing option for an equitization rule is set to Source Elimination, and eliminates NCI entries.
5F	Eqtz – Elimination of Source. The data originates from the equitization process when the processing option for an equitization rule is set to Source Elimination. This is an optional step that eliminates the equitization source.
5G	Eqtz – Dividend Reclassification. The data originates from the equitization process. This is an optional step that occurs when the processing option for an equitization rule is set to Dividend Reclassification.
6A	NCI – Elim for Parent Investment. The data originates from the noncontrolling interest process when eliminating the parent investment account. These entries include the elimination of the parent investment, the elimination of the portion of the subsidiary equity corresponding to the parent ownership, and the out-of-balance entry, if defined in the rule.
6B	NCI – Elim for Non-Controlling. The data originates from the noncontrolling interest process, when eliminating the noncontrolling interest account. These entries are for the elimination of the remaining portion of the subsidiary equity (not corresponding to the parent ownership) with an offset to NCI liability. The system also uses this same source code to “unwind” the original 6B entries as other noncontrolling owners are brought into the consolidation at higher levels of the consolidation tree.
07	Allocation entry. The data originates from the allocation process.
08	Currency Translation Adjustment The data originates from the currency translation process.
9A	Closing Entry The data originates from the closing process. These entries represent the balances that are closed into the target accounts by the close process.
9B	RollForward Entry The data originates from the closing process. These entries represent the balances that are rolled forward into the target accounts by the close process.
9C	Elimination Reversal- Closing The data originates from the closing process. These entries represent the reversal amounts booked to period 1 for elimination entity amounts closed during year-end close process. These entries are only created for the trial balance ledger format.
9D	Elimination Reversal - RollForward The data originates from the closing process. These entries represents the reversal amounts booked to period 1 for elimination entity amounts rolled forward during year-end close process. These entries are only created for the trial balance ledger format.

Monitoring Ledger Preparation and Consolidation Processing Status

This section provides an overview of the Consolidation Manager, Ledger Enrichment Manager, and Ledger Preparation Manager pages, lists common elements, and discusses how to:

View ledger preparation status.
Update manual processes status.
View consolidation processing status.
View status details.
View engine message details.
View reconciliation results.
View Source Flow Status.
View Flow Status details.
View summaries of journal activity.
View summaries of pro forma processing runs.
Configure the Consolidation Manager and Ledger Preparation Manager pages.

Understanding the Consolidation Manager, Ledger Enrichment Manager, and Ledger Preparation Manager Pages

The Consolidation Manager and Ledger Preparation Manager pages enable you to view the progress of each stage of consolidation processing and see detailed information about each phase. The pages display information for a particular consolidation model, scenario, fiscal year, and accounting period—the parameters that the consolidation processes uses as input. The pages use status text messages that enable you to quickly assess the progress of consolidations throughout your organization. The pages are interactive; by clicking the links or status text messages, you can view more detail about that information. You can configure the information that appears on these pages to suit your particular needs. For example, you can sort columns by text message status or in the case of Ledger Preparation Manager, you can refresh the grid with either Preparation Manager or Ledger Enrichment preparation phases.

This example illustrates the common functionality of the Ledger Preparation Manager and Consolidation Manager pages:

Using the Ledger Preparation Manager, Ledger Enrichment Manager, and Consolidation Manager pages

In some cases, descriptions for certain fields are also links. Click the link to view the definition page for that object. For example, on the Ledger Preparation Manager page, the Source Ledger field descriptions are links. When you click the description, you access the Detail Ledger definition page for that ledger.

The values for all the links are common here and on the Ledger Enrichment page:

00–None	Indicates that no information is available. Appears when processing has not yet occurred for that phase.
01–Pending	Indicates that the process has not yet started.
02–Process	Indicates that some units under this node are processing.
03–Rerun	Indicates that you need to reprocess this phase, because one or more processes upon which it depends have been run since this phase was last processed, and could impact this phase.
04-Failed	Indicates that processing failed to complete.
05–Error	Indicates that processing was initiated and completed successfully, but with errors. The system did not create a journal.
06–Review	Indicates that processing completed successfully, but there is data that you should review.
07–Done	Indicates that processing completed successfully, without errors.
08–N/A	Indicates that processing is not applicable.

Use these pages to:

View the details for the status of a phase of consolidation processing, ledger enrichment, or ledger preparation processing.
View engine messages for a phase.
View a summary of ledger activity for a phase.
View a summary of pro forma processing runs for a phase.
View a summary of journal entry status processing runs for a phase.

Common Elements Used in This Section

Model ID	Click to review or modify the Consolidation Model for the selected business unit.
Consolidation Audit	Click to access the Consolidation Audit Trail page, where you can interactively view the audit trail of the consolidation model.
View Batch Messages	Click to access the Engine Messages component, where you can review messages for a specific process instance.
Consolidation Manager	Click to access the Consolidation Manager page, where you can view the status of each phase of consolidation processing.
Run Ledger Preparation	Click to access the Ledger Preparation run control page, where you can run process ledger preparation.
Update Manual Process	Click to access the Update Manual Process page, where you can update the process status for manual processes previously defined on the Consolidations Processes page—for example, when you want to update the status for harmonization entries.
Change View Parameters	Click to access the search page, where you can specify which data to view in the Ledger Preparation Manager or Consolidation Manager pages.
Global Consolidation Center	Click to access the Global Consolidation Center page.
Preparation Phase	Select from two options to update the grid: Ledger Preparation or Ledger Enrichment phase. Ledger Enrichment shows the status for those processes that enrich the ledger data, as opposed to being a part of the ledger preparation process. The Ledger Enrichment processes are Harmonization Entries, Translations Adjustments, or Source Flows. Click Refresh to update the grid for the selection that you make.
Source Flow Update	Click to access the Source Flow Update page.
Journal Flow Update	Click to access the Journal Flow Update page.
Flow Inquiry	Click to access the Flow Inquiry criteria selection page. After selecting your input, you can view flows by the template selected.
View Trial Balance	Click to access the Trial Balance page, where you can view a trial balance of the consolidation model.
Ledger Preparation	Click to access the Ledger Preparation Manager page, where you can monitor and review the status of the processes used to prepare ledger data for consolidations.
Run Eliminations	Click this link to access the Eliminations run control page, where you can process intercompany eliminations.
Run Equitization	Click this link to access the Equitization run control page, where you can process equitization.

Pages Used to Monitor Ledger Preparation and Consolidation Processing Status

Page Name	Object Name	Navigation	Usage
Ledger Preparation Manager	GC_PREP_MGR	Global Consolidations, Prepare Data for Consolidation, Ledger Preparation Manager	Monitor and review the status of the processes used to prepare ledger data for consolidations.
Ledger Enrichment Manager	GC_LED_ENRICH_MGR	Select the ledger enrichment value for the Preparation Phase field on the Ledger Preparation Manager page, and then click refresh to populate the grid with the ledger enrichment processes, such as source flows.	Monitor and review the status of the ledger enrichment processes. In the case of the harmonization entries process, you can view the status or change the status because this is a manual process. To do so, click the status link under the Harmonization Entries column or the Update Manual Process link. Ledger enrichment defines all the processes that occur after ledger preparation and before consolidation.
Ledger Preparation Manager Search	GC_PREP_SRCH	Click the Change View Parameters link on the Ledger Preparation Manager page.	Specify which data to view in the Ledger Preparation Manager.
Update Manual Status	GC_UPDT_STATUS	Click the Update Manual Status link on the Ledger Preparation Manager page or click the status text message link of any manual processes on the Ledger Preparation Manager page or Consolidation Manager page.	Update status of any manual processes such as harmonization entries.
Consolidation Manager	GC_CONS_MGR	Global Consolidations, Process Consolidations, Consolidation Manager	Monitor and review the status of the processes used in PeopleSoft Global Consolidations.
Consolidation Manager Search	GC_CONSL_SRCH	Click the Change View Parameters link on the Consolidation Manager page.	Specify which data to view on the Consolidation Manager page.
Status Details	GC_PRCS_ENG_MSG	Click a status text message from the Consolidation Manager page or Ledger Preparation/Enrichment Manager page.	View details about a process.
Reconciliation Results	GC_RECON_RESULTS	Click the Review Reconciliation Totals link on the Status Details page.	Review reconciliation totals.
Message Detail	GC_ENG_MSG_DETL	Click Explain in the Message section of the Status Details page.	View engine messages for the process instance.
Journal Summary	GC_JRNL_SUMM	Click the Journal Entry Status text message on the Consolidation Manager page.	View a summary of any journal activity against the consolidation model for that period.
Proforma Summary	GC_PROFORM_STAT	Click the Proforma Run Status text message on the Consolidation Manager page.	View the status of proforma runs for the consolidation model.
Consolidation Processes	GC_PRCS_DEFN	Global Consolidations, Define Consolidations, Common Definitions, Consolidation Processes	Configure the information that appears on the Consolidation Manager and Ledger Preparation Manager pages.
Flow Status Details View	GC_CONS_FLSTAT	Click a flow status text message from the Consolidation Manager page or from the Source Flow Status Details page, click the link value under the Flow Status column.	Click to view the flow status for a ledger business unit, scenario and period.

Viewing Ledger Preparation Status

Access the Ledger Preparation Manager page.

The status of each phase of ledger preparation processing appears for each ledger business unit and source ledger within the selected tree node. You can sort the results by clicking on a column heading. The phases are:

Data Received	Indicates the status of the source ledger loading process.
Source Verification	Indicates the status of the source ledger verification process. The status for the ledger verification and the subsequent ledger preparation processes is updated based on the error handling choice you make on the Ledger Preparation Run Group page. For example, if you select Prevent all BU(s) to continue and errors occur during the ledger verification phase for some of the business units, the ledger verification process continues to update the valid business units with the status text message 06-Review. For the subsequent ledger preparation processes, the ledger preparation process checks if the business units were previously run. If so, the status text messages is set to 03-Rerun, otherwise, the status is set to 00-None. Similarly, the ledger preparation process updates the consolidated business unit status for the subsequent consolidation processes. If you select Allow valid BU(s) to continue and errors occur during the ledger verification phase for some of the business units, the ledger verification process updates the status for the subsequent ledger preparation processes to 00-None, or 03-Rerun for the problem business units. The ledger preparation process continues to prepare the valid business units and set the status per the results from each preparation step. See Establishing Ledger Preparation Groups.
Calendar Mapping	Indicates the status of the calendar mapping rules process.
Account Mapping	Indicates the status of the Data Mapper rules process.
Currency Translation	Indicates the status of the currency mapping rules process.
Ledger Loaded	Indicates the status of the mapped data for the consolidation ledger.

Click the text message for more information, or click a link to access the corresponding page.

Harmonization Entries

Indicates the status of the harmonization entries process. The Preparation Phase must be set to Ledger Enrichment to view this status.

Translation Adjustment

Indicates the status of the translation adjustments process. The Preparation Phase must be set to Ledger Enrichment to view this status.

Source Flows

Indicates the status of the source flow update process. The Preparation Phase must be set to Ledger Enrichment to view this status.

See Common Elements Used in This Section.

Updating Manual Processes Status

Access the Update Manual Status page.

Use this page to update the status of any manual processes, such as harmonization entries.

Process

Displays the manual process that you are updating. Use the Consolidation Processes page to set up any other manual processes that you want to create.

Change Selected Node

Select a tree node, and click Show Details for Node to populate the grid with the detail business unit under that node. Update the statuses for those ledger units.

Note. Ensure that you save your changes before selecting another tree node.

Update Status Using Tree

Select the status for the manual process and click Update Values in Grid to change the status for the ledger units in the grid.

You can change the status for individual ledger units in the grid by selecting the appropriate status from the drop-down list box next to each ledger unit.

Viewing Consolidation Processing Status

Access the Consolidation Manager page.

This page shows the status of any pro forma runs, the status of any journals that require flow processing, and the status of journal entries for the consolidation model for this period.

Within the grid, you can view the status of each phase of consolidation processing for the selected tree node (in bold text) and each consolidation node within the selected tree node. The phases include:

Equitization	Indicates the status of equitization processing.
Elimination	Indicates the status of elimination processing.
Non-Controlling	Indicates the status of noncontrolling interest processing.
Period Locked	Indicates if the ledger is closed to any further journal activity.
Close Process	Indicates the status of the close process.
Journal Flows	Indicates the status of journal flow update processing.

Click the text message for more information, or click a link to access the corresponding page.

See Common Elements Used in This Section.

Viewing Status Details

Access the Status Details page.

The content of this page varies depending on the process phase that you are viewing. The top portion of the page shows the field values for the processing parameters and related fields, such as Run Control ID, Start Date/Time, and so on.

If applicable, this page also shows the generated journal ID, and contacts for the ledger.

The expandable regions that can appear are:

Process Log	Click to expand this region, and review any processing messages for the process instance. Click Explain to view message details.
Control Process Log	Click to expand this region, and review any processing messages for the controlling process (applicable to processes that use parallel processing, or spawning). Click Explain to view message details.
Messages	Click to expand this region, and review engine messages. Click Explain to view message details.
Ledger Chart Field Validation	Click to expand this region, and review ChartField validation error messages.

Click the available links to access the related pages.

Viewing Engine Message Details

Access the Message Detail page.

Review message details.

Viewing Reconciliation Results

Access the Reconciliation Results page.

Review reconciliation results.

Viewing Source Flow Status

Access the Source Flow Status page from the Ledger Enrichment page

From the Source Flows status details page, the ledger unit and flow status is displayed.

00	None - indicates that the source flow update process has not been run.
03	Error - indicates that the process has been run, but the flow amounts do not reconcile to the change amount from the source flow template.
07	Done - indicates that the source flow update process has been run and the flow amounts reconcile to the change amount from the source flow template.

Clicking on the link in the Flow Status column will drill down to Flow Status Details

Viewing Flow Status Details

Access the Flow Status Details page from the Source flow Status Details page.

This flow status details page displays the flow template id as well as the source flow template status. Drill to the template by clicking on the Source Flow Input link. You can also drill to the Flow Inquiry through the Flow Inquiry link.

Note. The flow status page can be accessed from the consolidation manager to display the flow status for the journal flows. As such, the status details page will display the status based on the journal flow update process. The flow status details page will display journal flow template status as well as the Journal Flow Input link.

Viewing Summaries of Journal Activity

Access the Journal Summary page.

This page lists the status of both system-generated journals and manual journals. Any batches for manual journals that were held from posting appear with the Hold check box selected by the system.

Viewing Summaries of proforma Processing Runs

Access the Proforma Summary page.

This page lists the output journals (and their associated reversal journals, if any) generated for the pro forma run, the overall process status, and the status of the equitization, elimination, noncontrolling interest, and close process phases of processing. The page also lists the source input journals for each output journal.

Click a status text message to view the status details for the corresponding phase.

Configuring the Consolidation Manager and Ledger Preparation Manager Pages

Access the Consolidation Processes page.

This page is prepopulated for the SHARE setID. The page lists all the delivered application engine process IDs. You can modify the consolidation processes to incorporate any manual processes that you create. A manual status update method enables you to manually update the statuses. You can revise the fields in the grid to suit your implementation, or create a new definition for a different setID. PeopleSoft recommends that you limit changes to the Display Title and Display Order fields, unless you have configured the system for your implementation or want to add your own processes. The fields are categorized by function within the Name, Display Controls, and Parameters tabs. Either select each tab to view the related fields, or click the Show All Columns button to view all fields on one page. Insert rows as needed and complete these fields:

Display Order	Enter the display order, which controls the order in which the field appears. Fields appear in ascending order, based on the value that you enter in this field, with the lowest displaying first.
Process ID	Enter the ID of the process to monitor.
Description	Enter a description of the process.
Function	Select a function, describing what the process does. Options are: Account Mapping, Calendar Mapping, Close Process, Consolidation Approval, Consolidation Ledger Created, Consolidation Locked, Currency Translation, Elimination, Equitization, Journal Flows, Journal Entries, Manual, Non-Controlling Interest, Source Flows, Source Ledger Load, Source Ledger Verification, and Translation Adjustment.
Consolidation Phase	Select the phase of consolidation processing in which this process occurs. Options are: Consolidation, Consolidation/Last Period, Ledger Enrichment, or Ledger Preparation.
Display On	Displays the page on which the process status appears: either the Consolidation Manager page or the Ledger Preparation Manager page.
Display Title	Enter the title to use for this process on the Consolidation Manager or Ledger Preparation Manager pages.
Status Update Method	Select the update status method. Options are: Application Engine Batch, Locking Processing, Manual Processing, or None. Your selection controls the prompt list for the process name, and also the information that appears on the Status Details page for that process. For example, for application engine batch processes, the Status Detail page includes links to the Process Monitor.
Process Order	Enter a value indicating the sequential order in which each process must be run, the lowest number occurring first. Use the process order to indicate processing dependencies. For example, calendar mapping must occur prior to loading the consolidation ledger. The system determines which processes should be rerun based on these dependencies.
Process Name	Enter a process name, which is the page or PeopleSoft Application Engine program used for this process. This field is inactive when the value in the Status Update Method field is None or Manual Processing. The system uses this information to determine which process status ID it should update.
Reconciliation Job ID	Enter the job ID for reconciliation rules that you may have established for this process. When you assign a reconciliation job ID, the Review Reconciliation Totals link becomes active on the status details page. See Reconciliation for Consolidation Processes.

Reviewing Ledger Balances

This section provides overviews of the Ledger Inquiry component and amount options for viewing ledger balances and discusses how to:

Specify which data to view.
View ledger inquiry results.
View ledger inquiry detail results.

Understanding the Ledger Inquiry Component

The pages within the Ledger Inquiry component enable you to view ledger balances hierarchically, with amounts grouped by a reporting tree. Optionally, you can show trends, limit the view to only a filtered subset of the entire ledger, and generate a chart of the data.

Understanding Amount Options for Viewing Ledger Balances

When viewing ledger balances, several options control how to display the amounts. The available options depend on the consolidation ledger format and whether the account type is balance-forward. Balance-forward accounts (balance sheet accounts) are displayed as period-end balances. For nonbalance-forward accounts (income statement accounts), you can choose to view amounts as either period activity or year-to-date (YTD) amounts.

This table summarizes the available amount options:

Amount Option	Description	Availability
End of Period / Period Activity	View end of period balances for balance sheet accounts, and period activity for income statement accounts.	Available for trial balance and financial statement ledger formats.
End of Period / Year to Date	View end of period balances for balance sheet accounts, and YTD activity for income statement accounts.	Available for trial balance and financial statement ledger formats.
Period Activity	View period activity for all accounts.	Available only for trial balance ledger format.

These definitions apply to the different amount options:

End of Period	Amounts reflect the account balances as of the end of the reporting period. Prior period balances are irrelevant.
Period Activity	Amounts reflect the activity on an account over the duration of an accounting period.
Year to Date	Amounts reflect the accumulated activity on an account from the beginning of the fiscal year through the specified period.

Pages Used to Review Ledger Balances

Page Name	Object Name	Navigation	Usage
Ledger Inquiry - Selection	GC_LED_INQ_SEL	Global Consolidations, Consolidation Analysis, Consolidation Inquiries, Ledger Inquiry	Enter parameters by which to view consolidation ledger data.
Ledger Inquiry - Results	GC_LEDGER_INQUIRY	Click Go on the Ledger Inquiry - Selection page.	View the results of a ledger inquiry.
Ledger Inquiry Results - Details	GC_LEDINQ_DETAIL	Click a node at the lowest level of the tree.	View the details for the node's balances.
Get Preference	GC_LEDINQ_PREF_SEL	Click Get Preference on the Ledger Inquiry - Selection page.	Select a preference to use for the ledger inquiry page. The field values defined for that preference load into the Ledger Inquiry - Selection page.
Save Preference	GC_LEDINQ_PREF_SAV	Click Save Preference on the Ledger Inquiry - Selection page.	Save the current settings to a named preference.
Detail Dimensions	GC_LEDINQ_DET_SEL	Click Select Detail Dimensions on the Ledger Inquiry - Selection page.	Select which dimensions to display when viewing details.

Specifying Which Data to View

Access the Ledger Inquiry - Selection page.

Specify the common consolidation business unit on which to inquire an associated scenario, fiscal year, and accounting period.

By default, results display ledger data for a single accounting period. Select the Perform Trend option to view ledger data from the beginning period of the specified fiscal year through the specified accounting period, summarized by period.

Amount Type

Select how to summarize amounts for ledger balances. Options are:

End of Period / Period Activity: Select to view end of period balances for balance sheet accounts, and period activity for income statement accounts.

End of Period / Year to Date: Select to view end of period balances for balance sheet accounts, and YTD activity for income statement accounts.

Period Activity: Select to view period activity for all accounts. This option is available only for trial balance format ledgers.

Book Code Group

Select the book code group by which you want to further filter the inquiry report data. This is an optional field and is only available if you turn on book code functionality on the General Options page and you create book code values with the Book Codes and Book Code Group pages. Book code is an additional dimension on which you can report. If book code functionality is available, you can select this option and the Ledger Inquiry report displays separate amounts by book code when drilling down from inquiries on the consolidation audit.

See Understanding the Ledger Inquiry Component.

The Drill Type field determines which tree level information appears in the grid. Select from these options:

Get All Lowest Level Nodes	Displays the information for the children (direct or indirect) at the lowest level of the tree for the selected node.
Get Next Level Nodes	Displays the information for the direct children of the selected node within the grid. When you select this option, you must navigate through the tree nodes to eventually view the lowest level details.

The reporting tree determines how to group the amounts. Select an account rollup tree based on the accounts in your consolidation ledger to view the totals broken down by account, or another tree depending on your requirements.

See Reporting Trees.

Specifying Which Data to Include

As an option, you can limit the data that you include in the ledger balances by completing the Filter Dimension fields. Define the filter by specifying a value or a tree node. First, specify the dimension by which to limit the data. Then, either specify a detail value from within that dimension, or a tree name and tree node. Your ledger inquiry only includes data that matches your filter dimension criteria. as the dimension, then enter the business unit in detail value.

If you select data using a tree node, you can navigate to different nodes in the filter tree on the inquiry page. If you select data with a detail value, you have to return to the selection page to specify a different value.

Saving and Loading Preferences

You can save a set of defined field values to a named preference, which you can use to generate the ledger balances. Click the Save Preference button after defining the field values, and enter a preference ID and description. To load a previously saved preference, click the Get Preference button, and select the preference. If a preference is currently active, its name appears in the Preference field.

Viewing Results

Click Go to view the Ledger Inquiry - Results page.

Viewing Ledger Inquiry Results

Access the Ledger Inquiry - Results page.

The ledger balances appear in the grid.

Select a tree node to view the data associated with that node. When you reach an end node, you view details for the reporting tree objects within that node, grouped by dimension values. The system uses the dimensions on the user preferences page by default, or the dimensions selected on the Detail Dimensions page.

If you select a book code parameter, you can access the Book Code Group setup page by clicking the designated book code group name.

Viewing Charts

To view a chart of the results, select a chart in the Chart Type field.

Auditing Amounts

When viewing details, click the Audit link to view the Consolidation Audit Trail page for this data.

Select Detail Dimensions

Click the Select Detail Dimensions link to select the dimensions that you want to display when you view the ledger inquiry detail results.

Return to Selection Page

Click the Return to Selection Page to return to the Ledger Inquiry - Selection page.

See Also

Reporting Trees

Viewing Ledger Inquiry Detail Results

Access the Ledger Inquiry - Detail Results page.

The detail ledger balances appear in the grid.

Click the Audit link to view the Consolidation Audit Trail page.

Note. You can add or remove columns in the grid on the Detail Dimensions page.

Including Additional Dimensions

Comparing Ledger Balances

This section provides an overview of the Variance Inquiry component and discusses how to:

Specify which data to compare.
View comparison results.

Understanding the Variance Inquiry Component

The Variance Inquiry pages show period over period net changes on balance sheet account types. Use these pages to compare two different scenarios or time frames and review the ledger balance differences between them.

Pages Used to Compare Ledger Balances

Page Name	Object Name	Navigation	Usage
Variance Inquiry - Selection	GC_LEDINQ_VAR_SEL	Global Consolidations, Consolidation Analysis, Consolidation Inquiries, Variance Inquiry	Specify which ledger data to compare.
Variance Inquiry - Results	GC_LEDINQ_VAR	Click Go on the Variance Inquiry Selection page.	Review differences between ledger data, either from different scenarios or different periods.
Variance Inquiry Results - Details	GC_LEDINQ_VAR_DET	Select a node at the lowest level of the tree.	View the details for the node's balances.
Get Preference	GC_LEDINQ_PREF_SEL	Click Get Preference on the Variance Inquiry page.	Select a preference to use for the ledger inquiry page. The field values defined for that preference load into the Ledger Inquiry page.
Save Preference	GC_LEDINQ_PREF_SAV	Click Save Preference on the Ledger Inquiry - Selection page.	Save the current settings to a named preference.
Detail Dimensions	GC_LEDINQ_DET_SEL	Click Select Detail Dimensions on the Ledger Inquiry page.	Select which dimensions to display when viewing details.

Specifying Which Data to Compare

Access the Variance Inquiry - Selection page.

This page functions like the Ledger Inquiry page, except that you are comparing two different scenarios or time frames to view the differences between ledger balances. You must specify the inquiry scenario and its fiscal year and period, and the compare scenario and its fiscal year and period. You can either compare the same scenario for different time frames, or different scenarios. When comparing two different time frames, the Inquiry Scenario fields should be the most current fiscal year and period. (The Compare Scenario fields should contain a fiscal year and period prior to those of the inquiry scenario.) Select the book code group by which you want to further filter the inquiry report data. This is an optional field and is only available if you turn on book code functionality on the General Options page and you create book code values with the Book Codes and Book Code Group pages. Book code is an additional dimension on which you can report. If book code functionality is available, you can select this option and the Variance Inquiry report displays separate amounts by book code when drilling down from inquiries on the consolidation audit.

Complete the fields, and click Go to view the results.

Note. When using the Variance Inquiry page to compare two scenarios, both scenarios must use the same ledger format (financial statement or trial balance).

See Specifying Which Data to View.

Viewing Comparison Results

Access the Variance Inquiry - Results page.

The results grid contains these fields:

Tree Node and Description	Displays the tree node for the row.
Inquiry Amount	Displays the balances in the ledger or period for the inquiry scenario.
Compare Amount	Displays the balance in the compared ledger or period.
Variance Amount	Displays the difference between the ledger or period balances. The calculation that the system uses to compute this amount is: (Variance Amount) = (Inquiry Amount) – (Compare Amount).
Variance Percentage	Displays the percentage difference between the ledger or period balances. The calculation that the system uses to compute this percentage is: (Variance Percent) = (Variance Amount) ÷ (Compare Amount).

See Viewing Ledger Inquiry Results.

Viewing Trial Balances

This section provides an overview of the Trial Balance component and discusses how to:

Select trial balance criteria.
View a trial balance.
Set options for how to display account balances.
Specify the accounts to include in the trial balance.
Include additional dimensions.
View ledger balance details for an account.

Understanding the Trial Balance Component

The Trial Balance component enables you to view ledger balances and determine whether you need to make further adjustments. Use the pages in the Trial Balance component to:

See both a summarized and detailed view of the data.
Select which accounts to include.
View ledger amounts summarized by another dimension.
View activity for the specified period only, or view cumulative activity from the beginning of the fiscal year through the specified period, or view a mix of cumulative and period activity, based on account type.
Specify whether to combine debit and credit balances in a single column, or view them in separate columns.
View ledger balances by account.
View ledger balances by book code.

Pages Used to View Trial Balances

Page Name	Object Name	Navigation	Usage
Trial Balance Inquiry	GC_TB_INQ_SEL	Global Consolidations, Consolidation Analysis, Consolidation Inquiries, Trial Balance	Select criteria for the Trial Balance Inquiry pages.
Trial Balance	GC_TRIAL_BAL	Global Consolidations, Consolidation Analysis, Trial Balance Click the Trial Balance link from various pages.	View a trial balance for the consolidation ledger.
Balance Options	GC_TRIAL_OPT_SEL	Click the Options link on the Trial Balance page.	Specify whether to view separate columns for debit and credit amounts, and whether amounts include activity for only the specific period or are cumulative to date.
Account Selection	GC_TRIAL_ACCT_SEL	Click the Account link from the Trial Balance page.	Specify which accounts to include in the trial balance.
Select Dimension	GC_SEL_DIMENSION	Click the Dimension link on the Trial Balance page.	Select which information appears when you view balance amount details.
Ledger Balance for Selected Account	GC_TRIAL_BAL2	Click the Ledger Balance by Account link on the Trial Balance page or the Proforma Trial Balance page.	View the ledger balance for a specific account grouped by selected dimensions.

Selecting Trial Balance Criteria

Access the Trail Balance Inquiry page.

This page functions like the Ledger Inquiry page, except that you are working with trial balance ledger balances. You must specify the inquiry scenario and its fiscal year and period. Complete the fields, and click Go to view the results.

Viewing a Trial Balance

Access the Trial Balance page.

Informational Fields

These fields display information about the trial balance data that you are viewing:

Business Unit	The common consolidation business unit.
Amount Type	How amounts are summarized for ledger balances.Values are: End of Period / Period Activity: Amounts displayed as end of period balances for balance sheet accounts, and period activity for income statement accounts. End of Period / Year to Date: Amounts displayed as end of period balances for balance sheet accounts, and YTD activity for income statement accounts. Period Activity: Amounts displayed as period activity for all accounts. This option applies to only trial balance format ledgers.
Fiscal Year	The fiscal year being viewed.
Period	The accounting period being viewed.
Scenario	The scenario being viewed.
Currency Code	The base currency of the consolidation model.
Primary Book Code Balance	Shows the primary book code balance.
Secondary Book Code Balance	Lists the secondary book code balance.
Book Code Group	Lists the Book Code Group
Total Balance or Balance DR, Balance CR	The total proforma balance for the accounts.

Account Balances

The trial balance lists the accounts and descriptions and the ledger balance amount for the selected tree node. If you've set the options to display separate debit (DR) and credit (CR) amounts, the ledger balance column headings are Ledger Balance DR and Ledger Balance CR.

If you specify a book code group, the trial balance grid lists the primary book code balances and secondary book code balances. The column headings are defined by the primary description and secondary description fields on the book code group definition.

Expand or collapse tree nodes, as needed, and click a node to view the balances for that node.

Links to Other Pages

Options	Click to access the Trial Balance Options page, where you can specify how to display the amounts within the Trial Balance grid.
Accounts	Click to access the Account Selection page, where you can specify which accounts to include.
Dimensions	Click to access the Dimension Selection page, where you can indicate what dimensions to view when you navigate to details.
Ledger Balance	Click a ledger balance amount within the grid to access the Ledger Balance for Selected Account page, where you can view the ledger balance details by dimension.
Book Code Group	If you specify a book code group, you can click the name of the book code group definition to view that book code group definition on the setup page.

Setting Options for How to Display Account Balances

Access the Balance Options page.

Amount Type

Select how to summarize amounts for ledger balances. Options are:

End of Period / Period Activity: Select to view end of period balances for balance sheet accounts, and period activity for income statement accounts.

End of Period / Year to Date: Select to view end of period balances for balance sheet accounts, and YTD activity for income statement accounts.

Period Activity: Select to view period activity for all accounts. This option is available only for trial balance format ledgers.

Specifying the Accounts to Include in the Trial Balance

Access the Account Selection page.

You can view a trial balance for all accounts, or for a subset of accounts.

All Accounts

Select to include all accounts. Specify the tree name of the consolidation ledger account tree.

To view a subset of accounts, select an account selection type to define which accounts to include, and enter the account criteria, which depends on the account selection type. Use one of these options:

Select by Tree Nodes	Select to specify the accounts that use a tree, and then specify the tree name. In the Account Criteria grid, add rows as needed and specify the tree node to use. You can also navigate through the tree viewer to select the node that contains the group of accounts; the system inserts the node into the Account Criteria grid when you click it.
Select by Account Ranges	Select to specify one or more ranges of accounts to include. In the Account Criteria grid, add rows as needed, and complete the Range From and Range Through fields to define the account range for each row.
Select by Account Types	Select to specify one or more types of accounts to include. In the Account Criteria grid, add rows as needed and select an account type.
Select by Account Values	Select to specify a list of one or more accounts to include. In the Account Criteria grid, add rows as needed and select the account.

Including Additional Dimensions

Access the Select Dimension page.

Select

Select this check box to view the dimension values.

Show Description

Select to view the dimension descriptions.

This option is especially useful for dimensions that contain numeric values, such as the source process dimension.

Viewing Ledger Balance Details for an Account

Access the Ledger Balance for Selected Account page.

The total balance listed is for this specific consolidation ledger account. The details show the balance broken down by the dimensions specified on the Selected Dimension page. Click a specific ledger balance amount to view the Consolidation Audit page for that balance and navigate to the source stage data.

See Also

Viewing Audit Trails

Viewing Pro Forma Trial Balances

This section provides an overview of the Proforma Trial Balance component and discusses how to:

View a pro forma trial balance.
Set options for how to display account balances.
Select additional dimensions.
Specify journals to include.
Specify accounts to include.
View journal balances by account.
View ledger balances by account.

Understanding the Proforma Trial Balance Component

The Proforma Trial Balance component enables you to see what the impact of additional journals would be on a consolidation prior to posting them. For example, assume that you run a consolidation, then view a trial balance and determine that you need to make some adjustments using manual journal entries. You make the journal entries, but don't post them. Then, you process consolidations again, selecting the proforma option on the run control page so that the system processes only the nonposted journals. To view the results, you can use the Proforma Trial Balance pages. The page lists the current ledger balance, as well as the journal balance. You can specify which journals to include by using the Journal Selection page, and view the details for a journal balance by account.

These pages enable you to:

View both a summarized and detailed view of the data.
Select which journals to include.
Select which accounts to include.
Specify whether to combine debit and credit balances in a single column or view them in separate columns.
View activity for the specified period only, or view cumulative activity from the beginning of the fiscal year through the specified period, or view a mix of cumulative and period activity, based on account type.
View journal balances by account.
View ledger balances by account.

Pages Used to View Proforma Trial Balances

Page Name	Object Name	Navigation	Usage
Proforma Trial Balance Inquiry	GC_TB_INQ_SEL	Global Consolidations, Consolidation Analysis, Consolidation Inquiries, Proforma Trial Balance	Select criteria for the Proforma Trial Balance Inquiry report.
Proforma Trial Balance	GC_PROFORMA_BAL	Global Consolidations, Consolidation Analysis, Proforma Trial Balance Click the Proforma Trial Balance link from various pages.	View a trial balance, including nonposted journals.
Balance Options	GC_TRIAL_OPT_SEL	Click the Options link on the Proforma Trial Balance page.	Specify whether to view separate columns for debit and credit amounts, and whether amounts include activity for only the specific period or are cumulative to date.
Select Dimension	GC_SEL_DIMENSION	Click the Dimension link on the Proforma Trial Balance page.	Select which information appears when you view balance amount details.
Journal Selection	GC_TRIAL_JRNL_SEL	Click the Journal link on the Proforma Trial Balance page.	Select which journals to include in the proforma trial balance.
Account Selection	GC_TRIAL_ACCT_SEL	Click the Account link on the Proforma Trial Balance page.	Specify which accounts to include in the proforma trial balance.
Journal Balance by Account	GC_TRIAL_BAL3	Click the Journal Balance by Account link, or click a journal balance on the Proforma Trial Balance page.	View the journals that comprise the balance of a specific account.
Ledger Balance for Selected Account	GC_TRIAL_BAL2	Click the Ledger Balance by Account link on the Trial Balance page or the Proforma Trial Balance page.	View the ledger balance for a specific account grouped by selected dimensions.

Viewing a Proforma Trial Balance

Access the Proforma Trial Balance page.

Informational Fields

These fields display information about the proforma trial balance data that you are viewing.

Business Unit	The common consolidation business unit.
Fiscal Year	The fiscal year being viewed.
Period	The accounting period being viewed.
Scenario	The scenario being viewed.
Currency Code	The base currency of the common consolidation business unit.
Total Balance or Balance DR, Balance CR	The total proforma balance for the accounts.

Account Balances Fields

The proforma trial balance lists the accounts, their descriptions, the ledger balance amount, the journal balance amount, and the proforma ledger balance amount for the selected tree node. If you've set the balance options to display separate debit (DR) and credit (CR) amounts, the proforma ledger balance column headings are Proforma Balance DR and Proforma Balance CR.

Expand or collapse tree nodes, as needed; click a specific node to view the balances for that node.

Click a journal balance amount to view the Journal Balance by Account page.

Click a ledger balance amount to view the Ledger Balance for Selected Account page.

Links to Other Pages

Options	Click to access the Balance Options page, where you can specify how to display the amounts within the Proforma Trial Balance grid.
Dimensions	Click to access the Dimension Selection page, where you can indicate what dimensions to view when you navigate to details.
Accounts	Click to access the Account Selection page, where you can indicate which accounts to include.
Journals	Click to access the Manual Journal Selection page, where you can select a manual journal.
Create Journals	Click to access the Journal Entries page, where you can enter a manual journal. See Entering or Reviewing Manual Journals.
Post Journals	Click to access the Ledger Post page. See Processing and Posting Journals.
Ledger Balance	Click a ledger balance amount within the grid to access the Ledger Balance for Selected Account page, where you can view the ledger balance details by dimension.
Journal Balance by Account	Click a journal balance amount within the grid to access the Journal Balance by Account page, where you can view the details that comprise a particular journal.
Proforma Ledger Balance	Click a proforma ledger balance amount within the grid to access the Proforma Ledger Balance by Account page, where you can view the details that comprise a proforma ledger balance.
Book Code Group	If you specify a book code group, you can click the name of the book code group definition to view that book code group definition on the setup page.

Setting Options for How to Display Account Balances

Access the Balance Options page.

See Also

Processing and Posting Journals

Selecting Additional Dimensions

Access the Select Dimension page.

See Including Additional Dimensions.

Specifying Journals to Include

Access the Journal Selection page.

Edited, unposted journals are listed on this page by PF batch ID and batch status. To include a journal in the proforma trial balance inquiry, select the Select check box.

Specifying Accounts to Include

Access the Account Selection page.

See Specifying the Accounts to Include in the Trial Balance.

Viewing Journal Balances by Account

Access the Journal Balance by Account page.

This page displays the journals that comprise the proforma balance of a specific account.

Journal ID

Click to access the Consolidation Audit Trail page and further analyze the journal source.

See Viewing Audit Trails.

Viewing Ledger Balances by Account

Access the Ledger Balance for Selected Account page.

See Viewing Ledger Balance Details for an Account.

Viewing Audit Trails

This section provides an overview of the consolidation audit trail and discusses how to:

Specify the main audit criteria.
Select the data to audit.
View and navigate through the audit trail.
Specify which dimensions or journals to include.

Understanding the Consolidation Audit Trail

The consolidation audit trail enables you to review account balances within the consolidation ledger or journal entries, and track those amounts back to their source. Using the audit trail, you can:

Navigate through the consolidation results back to the source data level.
Identify all the rules used to transform the source data to the results.
View the intermediate results at various stages of consolidations.

You can audit either a consolidation ledger or journal details. For the consolidation ledger, the levels through which you navigate begin with the consolidation ledger and end with the amount's source—down to the source ledger level, if applicable. For the journal details, the levels begin with the journal entry and end with the journal's source, which could be the output log or a manual journal entry. The actual levels that you view for an amount depend on where the amount originated from, and what processing phases it went through.

Navigation

To navigate through the levels, click the amount that you want to audit. The previous level from which that amount originated appears. Continue to click the amount to view all the phases through which the data flowed. The system displays the navigation path that you've traveled through as you click through the levels. The path is interactive; click any path segment to return to that level. As you navigate, the information that appears at the bottom of the page changes, showing details of the current level. For example, if you have navigated to the source ledger, the bottom section displays source ledger data details. The page title also changes accordingly.

In this example, there are labels that show the navigation path and level detail regions. Also, notice how the page title corresponds to the detail level:

Consolidation audit example

Levels

This table defines the levels that appear in the navigation path. The actual levels that appear depend on the data that you audit:

Level	Description
Consolidation Ledger	The consolidation ledger results, after consolidation processes have completed and the ledger has been updated. (Contains source data and data from posted journals only.)
Consolidation Log	Stores the intermediate results during consolidation processing before the final results are moved to the consolidation ledger (by way of journals).
Equitization Input	The consolidation log, after processing equitization.
Source Ledger Consolidation	The consolidation ledger used as the data source for the consolidation processing. This ledger stores the results of ledger preparation processing.
Mapping Ledger	The ledger that stores the data after the mapping rules are applied during ledger preparation processing.
Source Ledger	The source staging ledger, which stores your subsidiary data prior to ledger preparation processing.

Pages Used to View Audit Trails

Page Name	Object Name	Navigation	Usage
Consolidation Audit - Criteria	GC_CONS_AUDIT1	Global Consolidations, Consolidation Analysis, Consolidation Inquiries, Consolidation Audit, Consolidation Audit Trail	Specify which consolidation data to audit.
Consolidation Audit Trail - Results	GC_CONS_AUD_RESULT	Click Go on the Consolidation Audit Trail - Criteria page.	View the ledger balances or journals for the consolidation data that matched your criteria. This data is the starting point for the audit trail.
Consolidation Audit - Details (page title changes depending on the level)	GC_CONS_AUDIT3	Click an amount from the Consolidation Audit Trail page.	View the details that comprise an amount. Navigate through the levels for additional details.
Consolidation Audit - Select Dimensions	GC_CONS_AUDIT_INFO	Click the Dimension Criteria link on several of the pages within this component, or the Select Journal link on the Consolidation Audit Trail - Criteria page. A display-only version of this page also appears when you click the Dimension Details link.	Enter criteria to limit the dimension values or journal information included in the audit trail, or view the established dimension settings.

Specifying the Main Audit Criteria

Access the Consolidation Audit Trail - Criteria page.

Business Unit, Scenario, Fiscal Year, and Period

Specify the data to audit. The business unit should be a common consolidation business unit.

Amount Type

Select how to summarize amounts for ledger balances. Options are:

End of Period / Period Activity: Select to view end of period balances for balance sheet accounts, and period activity for income statement accounts.

End of Period / Year to Date: Select to view end of period balances for balance sheet accounts, and YTD activity for income statement accounts.

Period Activity: Select to view period activity for all accounts. This option is available only for trial balance format ledgers.

Source Process

(Optional) Limits the audit scope to data that originates from a specific GC_SOURCE value.

See Consolidation Data Source.

Max Rows to Scroll

Enter the number of rows to view per page.

Book Code Group

Select the book code group by which you want to further filter the inquiry report data. This is an optional field and is only available if you turn on book code functionality on the General Options page and you create your code values with the Book Codes and Book Code Group pages. Book code is an additional dimension on which you can report. If book code functionality is available, you can select this option and the report displays separate amounts by book code when drilling down for inquiries on the consolidation audit.

Select

Select Ledger Details to audit data from the consolidation ledger (GC_CLED_XXX_F00) or Journal Details to audit data from the journal table (GC_JRNL_XXX_F00).

Dimension Criteria

Click to access the Consolidation Audit - Select Dimensions page, where you can specify which dimension values to include in the audit.

Select Journal

Click to access the Consolidation Audit - Select Journal page, where you can limit which journal to include when auditing journal details.

Go

Click to access the Consolidation Audit Trail - Results page, where you can view the audit results.

Selecting the Data to Audit

Access the Consolidation Audit Trail - Results page.

Click an amount to view its audit trail. The Consolidation Audit Trail - Details page appears.

Viewing and Navigating Through the Audit Trail

Access the Consolidation Audit Trail - Details page.

Click an amount to view the previous level from which that amount originated.

This page includes these regions:

Main Criteria	Displays the criteria used for the audit.
ChartFields	Click to expand this region, and review the ChartField values from the previous level that comprise the amount.
Go To	This interactive section shows the navigation path of your audit, with the current viewing level listed last. Click a previous level to return to a view of the data at that point.
Ledger Details	Displays an interactive grid containing details of the data. The grid title changes depending on the level. The grid contains tabs that pertain to the current navigation level. Select a tab to view the information for it. If the information includes rules, you can click the rule description to view its definition. Click an amount to view the previous level of the data.

Specifying Which Dimensions or Journals to Include

Access the Consolidation Audit - Select Dimensions page.

To limit the audit to a specific dimension value or journal batch, complete the criteria on this page.

Operation

Select how to filter the dimension values. Options are:

Begins With: Include dimension values that begin with the entered value.

Contains: Include dimension values that contain the entered value.

Equal To: Include dimension values that are equal to the entered value.

Is Blank: Include blank dimension values.

Value

Enter the value to use as the basis by which to filter the results, if appropriate for the selected operation. For example, you don't need to specify a value when Is Blank is the selected criterion.

Show Description

Include the description for the dimension value when displaying the audit results.

Viewing Data Flows

This section provides an overview of the flow inquiry component and discusses how to:

Specify which data to view.
View flow inquiry results.
View the flow inquiry details.
View the flow inquiry difference details.
View the flow inquiry audit.

Understanding the Flow Inquiry Component

After translating and updating your flow templates, you can review the flow templates (both manual input and system activity) in the consolidation currency for the source and journal flows. The flow template inquiry enables you to look at the template from a single ledger business unit or by multiple ledger business units using a filter tree.

There are two views to see the translated flows: closing rate or cash flow rate. If you are using book code functionality, the book code group option appears on the flow inquiry parameters and flow inquiry page.

Flow amounts and differences on the Flow Inquiry page have active links. You can click a flow amount to get detailed information about the flows and the accounts on the Flow Inquiry for Selected Amount page. The Flow Inquiry for Selected Amount page details the selected amount, the account, flow code, and breakdown by ledger business unit. The flow amounts have separate columns for source flow amounts and journal flow amounts, illustrating where the flow amounts originated.

Select any amount in the Source Flow Amount column or Journal Flow Amount column to view the Flow Audit page. Because the flow inquiry amounts are in the consolidated currency and the source input templates are in the foreign currency, you can review the base flow and the source flow amounts in their respective currencies on the Flow Audit page. Click Source Flow Amount to access the source input template. Similarly, click the Currency Rule link to access the Currency Rule setup page. If there are multiple currencies on the input template, there are multiple rows of data detailing the base amounts, source amounts, and source currency. Click Journal Flow Amount to access the journal flow input template, which is always in the consolidation currency.

Pages Used to View Data Flows

Page Name	Object Name	Navigation	Usage
Flow Inquiry - Selection	GC_FLINQ_SEL	Global Consolidations, Consolidation Analysis, Consolidation Inquiries, Flow Inquiry	Enter parameters by which to viewflow data.
Flow Inquiry	GC_FLOW_INQUIRY	Click Go on the Flow Inquiry - Selection page.	View the results of a flow inquiry.
Flow Inquiry for Selected Amount	GC_FLINQ_AMT	Click an amount in the flow inquiry flow template grid.	View detailed information about a flow amount and its associated account.
Flow Inquiry-Details	GC_FLINQ_AMT_DIFF	Click an amount in the Difference to be Reconciled column of the flow inquiry flow template grid.	View detailed information about a source or journal flow amount difference and its associated account.
Flow Audit	GC_FLINQ_AUD	Click an amount on the Flow Inquiry for Selected Amount page	View the base flow amount and the source flow amount for their respective currencies for a selected amount.
Get Preference	GC_FLINQ_PREF_SEL	Click Get Preference on the Flow Inquiry - Selection page.	Select a preference to use for the Flow Inquiry page. The field values defined for that preference load into the Flow Inquiry - Selection page.
Save Preference	GC_FLINQ_PREF_SAV	Click Save Preference on the Flow Inquiry - Selection page.	Save the current settings to a named preference.

Specifying Which Data to View

Access the Flow Inquiry - Selection page

Specify the common consolidation business unit on which to inquire an associated scenario, fiscal year, accounting periods, flow template, translation type, and book code group if you set up the system to use book codes.

Template

Select the template type. Your choices are dependent on the flow templates you create

Translation Type

Select the translation type. You have two options to select from to view the currency translated flows: Cash Flow Rate or Closing Rate.

If you select closing rate as the translation type, the 99980 FXAJ1 column appears on this page as the translation flow code. It represents the flow translation adjustment to adjust the opening balance, translated at prior rates to the closing balance at the closing translation rate. This amount derives from the GC_SOURCE, '08', for currency translations adjustments.

If you select cash flow rate as the translation type, both the 99980 FXAJ1 and 99985 FXAJ2 columns appear on this page as the translation flow code. It represents the flow translation adjustment to adjust the flow amounts translated at the average rate to the closing rate. The flow codes of FXAJ1 and FXAJ2 are combined with the cash accounts to determine the net effect of the FX (foreign exchange) translation line on the cash flow statement.

See Understanding Data Flows.

Book Code Group

Filter Tree

Select the business unit tree used to roll up and navigate through the flow data. The flow inquiry allows you to look at the template from a single ledger business unit or by multiple ledger business units by using the filter tree.

See Reporting Trees.

Specifying Which Data to Include

If you select data using a tree node, you can navigate to different nodes in the filter tree on the inquiry page.

Saving and Loading Preferences

You can save a set of defined values to a named preference, which you can use to generate the flow amounts. Click the Save Preference button after defining the field values, and enter a preference ID and description. To load a previously saved preference, click the Get Preference button, and select the preference. If a preference is currently active, its name appears in the Preference field.

Viewing Results

Click Go to view the Flow Inquiry - Results page.

Viewing Flow Inquiry Results

Access the Flow Inquiry page.

The flow amounts appear in the grid.

Select a tree node to view the data associated with that node. When you reach an end node, you view details for the filter tree objects within that node.

Drilling on Flow Amounts

When viewing the Flow Inquiry page, click an amount to view more details on the Flow Inquiry for Selected Amount page. The flow amounts and difference amounts that are highlighted as links enable you to can click the linked amount in the grid and get more detailed information about the flow amounts for the related accounts.

Note. System flows such as the Open, Close, and Change columns do not have active links for viewing details.

Select Source Flow Input

Click the Source Flow Input link to view the source flow input page where you can enter and validate flow information for source flow data.

Note. This link is not available for system defined flow templates.

Select Journal Flow Input

Click the Journal Flow Input link to view the journal flow input page where you can enter and validate flow information for journals.

Note. This link is not available for system defined flow templates.

Source Flow Update

Click the Source Flow Update link to view the source flow update page where you can submit a request to update the source flow activity amounts.

Journal Flow Update

Click the Journal Flow Update link to view the journal flow update page where you can submit a request to update the journal flow activity amounts.

Return to Selection Page

Click the Return to Selection Page to return to the Flow Inquiry- Selection page.

Viewing the Flow Inquiry Details

Access the Flow Inquiry for Selected Amount page.

The Flow Inquiry for Selected Amount page provides details about the flow amounts, the account, and flow code by ledger business unit. The flow amounts are segregated by source flow amount and journal flow amount. This distinguishes where the flow amount originated. Selecting any amount in the Source Flow Amount column or Journal Flow Amount column directs you to the flow audit page.

Auditing Amounts

When viewing details, click the amount link to view the Flow Audit Trail page for this data.

Viewing the Flow Inquiry Difference Details

Access the Flow Inquiry-Difference Details page.

By drilling on the Difference to be Reconciled amount, you access the Flow Inquiry - Difference Details page. Because flow amounts originate from two different sources, the difference amounts are divided into the Source Difference and the Journal Difference columns.

If there is a difference in the grid, you can drill on the flow input link to correct the amount difference on either the Source Flow Input page or the Journal Flow Input page depending on the type of flow amount you are attempting to correct.

Note. Once you correct the flow amount in the respective flow input page, use the Validate button on the flow input page to validate the flow template. Once the flow amounts are correct, rerun the update engine to eliminate the difference to be reconciled amount.

Viewing the Flow Inquiry Audit

Access the Flow Audit page.

Because the flow inquiry amounts are in the consolidated currency and the source input templates are in the foreign currency, the Flow Audit page enables you to view the base flow amount and the source flow amount in their respective currencies. You can access the Currency Rule setup page by clicking on the currency rule link. You can also drill to the flow input pages when drilling on a flow amount that originated from source flows or journal flows.

You can use the navigation path to navigate back to the Flow Inquiry and Flow Inquiry for Selected Amount pages.

Note. If there are multiple currencies on the input template, then there are multiple rows of data detailing the multiple base amounts with the multiple source amounts and source currency. When drilling on a system flow, the source and journal flow input link will not display as the flow is system generated.

Analyzing the Impact of Changes to Consolidation-Dependent Rules

This section provides an overview of impact analysis and discusses how to:

Specify the impact analysis scope.
Indicate the object to analyze.

Understanding Impact Analysis

The pages within the Impact Analysis component enable you to identify which nodes of a consolidation tree would be affected if, after processing consolidations, you make changes or adjustments to:

Allocation rules.
Ledger preparation rules.
Journal entries.
Elimination, equitization, or noncontrolling interest rules.

Use this information to analyze at what level you may need to reprocess a consolidation if any of the supporting rules or journals change. For example, in some cases you may find that you only need to reprocess a particular node of the consolidation tree. The analysis is date-sensitive; you specify the date on which the rule or journal change occurs, as different rules may be active depending on their effective date.

After setting the scope of the analysis, you indicate which type of rule and the specific rule or journal to analyze. The system displays the results when you click Show. The results show the past run control IDs that are impacted based on the change; click the run control description to view the specific run control.

Note. Because the run control ID may have changed since the last time a process was run, be sure to carefully check the parameters.

Pages Used to Analyze the Impact of Changes to Consolidation-Dependent Rules

Page Name	Object Name	Navigation	Usage
Impact Analysis Search	GC_IMPACT_SRCH	Global Consolidations, Consolidation Analysis, Consolidation Analysis, Impact Analysis	Set the scope of the impact analysis.
Impact Analysis	GC_CHANGE_IMPACT	Click OK on the Impact Analysis Search page.	Enter the impact analysis criteria and interactively view the results.

Specifying the Impact Analysis Scope

Access the Impact Analysis Search page.

Impact Analysis Scope

Select the level of analysis. Options are:

Allocation Rule Change: Select to view the impact of changes to an allocation rule.

Consolidation Setup Change: Select to view the impact of changes to an elimination, equitization, or noncontrolling interest rule, rule set, or rule group.

Journal Change: Select to view the impact of changes to a journal.

Mapping Rule Change: Select to view the impact of changes to a calendar mapping rule, currency conversion group, or data mapper rule (ChartField mapping).

Effective Date

Enter the date on which the rule change takes effect.

No date is required here for journal changes; you indicate the date when you specify the journal on the Impact Analysis page.

Indicating the Object to Analyze

Access the Impact Analysis page.

After you click OK on the search page, the system displays the Impact Analysis page, where you indicate the specific object to analyze. The fields that you complete on this page differ, depending on your scope; the page discussion is grouped by scope.

Scope: Allocation Rule Change

SetID	Select the setID that contains the allocation rule.
Allocation Rule ID	Select the allocation rule to analyze.

Click the allocation rule description to view the rule definition page.

Scope: Consolidation Setup Change

Setup Option	Select which consolidation rule type to analyze. Options are: Elimination Setup Change, Equitization Setup Change, or NonControlling Interest Change.
Select Options	Select the rule type to analyze. Options are: Group Change (for a rule group), Rule Change (for a rule), or Set Change (for a rule set).
Group, Rule, and Set	Enter the specific item to analyze.

Scope: Journal Change

Business Unit, Scenario ID, Journal ID, and Date

Complete these fields to indicate the journal to analyze.

Click a description to view the journal detail.

Scope: Mapping Rule Change

Rule Selection	Select the type of rule to analyze. Options are: Calendar Map Change, Currency Rule Change, or Ledger Map Change (ledger mapping is set up by using data mapper).
SetID	Enter the map rule's setID.
Calendar Map ID, Currency Rule ID, and Ledger Map ID	Enter the specific item to analyze. The ledger map ID is equivalent to the data map ID.

Click a description to view the rule detail.

Viewing Results

Click Show to view the results. The results list all the impacted consolidation runs and include these fields: Run Control ID, Business Unit, Scenario, Consolidation Model, Year, Period, Consol Node (consolidation node), and process Batch ID.

Click the run control ID description to view that run control page.

Analyzing Consolidation Runs

This section provides an overview of consolidation run analysis and discusses how to:

Specify criteria for a consolidation run analysis.
Include additional dimensions.
View the analysis results.
Compare the details by ChartField.

Understanding Consolidation Run Analysis

The consolidation run analysis component enables you to view the differences between two consolidation processing runs based on the same criteria (consolidation business unit, scenario, fiscal year, and accounting period), so that you can determine if and why there are differences, and decide whether you need to reprocess. This could be the case, for example, if you process by using the top node of the consolidation tree, and then process a lower level node, or if changes were made to the source subsidiary data or consolidation rules since the prior run.

Note. To use this feature, you must run consolidation processes with the Get Prior Run Differences option selected.

Running the Equitization Application Engine

Pages Used to Analyze Consolidation Runs

Page Name	Object Name	Navigation	Usage
Consolidation Run Analysis - Criteria	GC_DIFF_INQ_PAGE	Global Consolidations, Consolidation Analysis, Consolidation Inquiries, Run Difference Analysis	Specify the criteria to compare processing runs.
Consolidation Run Analysis - Results	GC_DIFF_INQ_PAGE	Click Go on the Consolidation Run Analysis - Criteria page.	View the differences between processing runs.
Additional Dimensions	GC_DIFF_SEL_DIM	Click Additional Dimensions on the Consolidation Run Analysis page.	Select which dimension data to view.
Run Analysis By Chartfields	GC_DIFF_INQ_DTL	Click an amount on the Consolidation Run Analysis - Results page.	View differences between processing runs for the selected amount.

Specifying Criteria for a Consolidation Run Analysis

Access the Consolidation Run Analysis - Criteria page.

Tree Node

Specify which node to use for the run analysis. The node level used the last time the process ran appears by default, but you can specify a different node to limit the results to objects within that node and subordinate to it.

Process

Select which consolidation process to compare. Options are: Elimination, Equitization, or Non-Controlling Interest.

New Instance and Old Instance

Specify which two runs to compare. The most recent process instances appear by default in these fields.

Additional Dimensions

Click to access the Additional Dimensions page, where you can specify which other dimensions appear when you view details.

Go

Click to run the inquiry and view the results. The system displays the Consolidation Run Analysis - Results page.

Including Additional Dimensions

Access the Additional Dimensions page.

The dimensions that are included because of the run parameters that you specified are display-only and already selected.

Select Dimension	Select to include this dimension field in the run analysis results.
Value	Enter a value to include only rows that match this dimension value.
Show Description	Select to display the description field for the dimension values.

Viewing the Analysis Results

Access the Consolidation Run Analysis - Results page.

The results of the run analysis appear in the Summarized details by Selected Dimensions grid. The amount shown for each row is the difference between runs for the selected dimensions, which is derived by subtracting the ChartField balances in the old instance from the new instance. Only those ChartFields with balances that differ, or that exist in one run but not the other, appear in the grid.

Click a difference amount to access the Run Analysis by ChartFields page, where you can view the details that comprise the amount.

Comparing the Details by ChartField

Access the Run Analysis By Chartfields page.

This page shows the ChartField details for the two compared runs. This information appears in the grid:

Difference Type	Describes why there is a difference between processing runs. Delete indicates that the amount was deleted in the new run, Add indicates that the amount was added in the new run, and Changed indicates that the amount changed.
New Instance and Old Instance	Displays the process instances of the compared runs.
New Amount	Displays the amount for the new instance.
Original Amount	Displays the original amount.
Currency	Displays the base currency of the amount.

Select the Additional ChartFields tab to view columns for all ChartFields.

Matching Intercompany Balances

This section provides an overview of matching and discusses how to:

Run match reports.
Define matching tag reason codes.
Review match results.
View details of match results.
Create matching tag entries.

Understanding Matching

The match report and inquiry enable you to validate that your intercompany balances match prior to processing consolidations; you can view the consolidation ledger data that will be matched, or paired, based on a consolidation model's elimination rules. Matching encompasses both intercompany and intracompany transactions (such as interdepartment transactions within a single business unit). Use the Matching process to check data for discrepancies, such as when business unit A shows an interunit payable of $100 to business unit B, but business unit B shows only a $90 interunit receivable from business unit A. In cases where the matching report shows entries that do not balance, you can analyze the data to determine the cause. After you verify that all of the subsidiaries have loaded their data, you can correct any material differences with adjusting manual journal entries and tag any immaterial differences. Tagging the record does not balance the ledger; it enables you to provide an explanation for the out-of-balance amounts on the match report and track the reasons for analysis. The next time that you run the match report, you can include the tag record, which reduces the variance.

Amount Options

The Amount Option field controls whether the amounts displayed on the match report and inquiry are cumulative year-to-date amounts or amounts for the specified period only. The way this field applies differs depending on the consolidation ledger format.

If the consolidation ledger is based on the trial balance format, the amount option applies to all account types. Matching tag entries represent period activity for all account types.

If the consolidation ledger is based on the financial statement format, the amount option applies only to nonbalance forward account types (income statement accounts). Balance sheet accounts are always matched on a period-end balance basis and income statement accounts are matched either on a period activity basis or a year-to-date basis, depending on which amount option you select. Matching tag entries retain the same character as the ledger amounts that they correct: tags for balance sheet accounts represent end of period balances, tags for income statement accounts represent period activity. Also, proforma journal input data is considered current period only, regardless of the amount option.

Note. When the amount option is set to year-to-date, match tags for nonbalance forward account types are entered for period activity only. When the match process is run for year-to-date balances, all the tags entered for the year (up to the period being processed) are included.

This table summarizes the matching logic for financial statement format ledgers based on the selected account type and amount option:

Input Source for Matching	Account Type	Amount Option	Match Process Method
Ledger Data	Balance Forward	Current Period	Processes only current period data, which contains period end balances.
	Nonbalance Forward	Current Period	Processes only current period data, which contains period activity.
	Balance Forward	Year-to-Date	Processes only current period data, which contains period end balances.
	Nonbalance Forward	Year-to-Date	Processes all prior period and current period data.
proforma Journals	Balance Forward	Current Period	Processes only current period journals.
	Nonbalance Forward	Current Period	Processes only current period journals.
	Balance Forward	Year-to-Date	Processes only current period journals.
	Nonbalance Forward	Year-to-Date	Processes only current period journals.
Match Tags	Balance Forward	Current Period	Processes only current period tags, which explain period end balance discrepancies.
	Nonbalance Forward	Current Period	Processes only current period tags, which explain period activity discrepancies.
	Balance Forward	Year-to-Date	Processes only current period tags, which explain period end balance discrepancies.
	Nonbalance Forward	Year-to-Date	Processes all prior period and current period tags.

Pages Used to Match Intercompany Balances

Page Name	Object Name	Navigation	Usage
Match Report	RUN_GC_MATCH	Global Consolidations, Consolidation Analysis, Perform Matching, Matching Process and Report	Enter parameters for the matching process.
Match Report Select Journals	GC_RUN_GCS2001_JRN	Click the Select Journals link on the Match Report page.	Select the journals to include in the match report process.
Match Report Select Rules	GC_RUN_GCS2001_RUL	Click the Select Elimination Rules link on the Match Report page.	Specify which elimination rules to use in the matching report.
Matching Tag Reason Code	GC_MATCH_CD_PG	Global Consolidations, Consolidation Analysis, Perform Matching, Matching Tag Reason Code	Define reason codes that provide explanations for why a variance occurs on the matching report for intercompany transactions. You use reason codes when you create a matching tag entry to reverse a variance on the matching report.
Match Results Inquiry	GC_MTCH_INQ_PAGE	Global Consolidations, Consolidation Analysis, Perform Matching, Match Results Inquiry	View matching report results online.
Match Results Inquiry - Journals Selection	GC_MTCH_INQ_JRN	On the Match Results Inquiry page, click the List Journals link.	View a list of journals included in a proforma report.
Match Results Detail	GC_MTCH_INQ_DTL	On the Match Results Inquiry page, click a match results amount.	Review the detail lines that comprise an amount on the match results inquiry.
Matching Tag Entry	GC_MATCH_TAG_PG	Global Consolidations, Consolidation Analysis, Perform Matching, Matching Tag Entry Click the Add Tag Entry link on the Matching Results Detail page.	Create a manual entry to offset a variance in the match report. When you run the match report again, the variance is reduced (possibly eliminated) by the matching tag amount if you select the check box to include the tag records in the report.

Running Match Reports

Access the Match Report page.

Specifying Process Information

The system saves match results by consolidation business unit, scenario, fiscal year and period, and consolidation dimension (such as ledger business unit or department). Separate results are stored for current period and year-to-date data.

Business Unit, Scenario, Fiscal Year, and Period	Specify the common consolidation business unit, scenario ID, fiscal year, and accounting period to process.
Get Consolidation Model	Click to retrieve the information from the defined model. The system determines the consolidation dimension and currency code, and the page expands to enable you to enter processing and report criteria.
Amount Option	Select whether to include Current Period Activity or Year To Date balances.
<Dimension Value> Option	Select which dimension values to include. The label for this field varies depending on your consolidation dimension. In the sample shown, the label is Ledger Unit Option, as the consolidation dimension is ledger business unit. Options are: All: Include all dimension values. Tree Node: Use a tree to specify the dimension values to include. Complete the Tree Node field to indicate which values to include. Value: Include a single dimension value. Specify the value in the adjacent Dimension field.

Specifying Processing Criteria

Jobstream ID	GC_MATCH appears by default.
Proforma	Select to use data from journals that have not yet been posted as the source. Click Select Journals to access the Match Report Select Journals page and specify which journals to include in the proforma report.

Now you can click Run, and the match process automatically matches the report unit to all potential match units, stores all match results, and processes all elimination sets.

Complete the report criteria to further refine the selection criteria for the printable report (a Structured Query Report).

Specifying Report Criteria

Match To Ledger Unit Option	Select All to include all matched dimension objects. Select Value to include a specific object, specifying which one in the Match To field. (This field label differs depending on the consolidation dimension.)
Report Out of Balance Only	Select to include only matches that don't net to zero in the report. Optionally, enter a value in the Tolerance field to limit the report to out-of-balance matches that are equal to or greater than the specified tolerance amount. The amount is in the consolidation base currency.
Include All Elimination Rules	Controls the scope of the elimination rules to include in the report. Select to include all of the elimination rules associated with this consolidation model. Clear this option and click Select Elimination Rules to access the Select Elimination Rules secondary page and select the specific rules to include.
Include Tags in Report	Select to include any match tag entries in the report. If you are running the matching report to process tag entries prior to running any consolidation processes, you must run tree flattener before you run the match report. See Running Tree Flattener.

Generating the Results

Run	Click to submit the job.
Match Results Inquiry	Click to access the online inquiry page for the matching report.

Note. You must run the Match Report process before you can use the inquiry page to view match results.

Defining Matching Tag Reason Codes

Access the Matching Tag Reason Code page.

Description and Short Description

Enter long and short descriptions for the reason code. When you view a match report, you can tag an entry by using a reason code to explain why there is a nonzero balance.

Reviewing Match Results

Access the Match Results Inquiry page.

Business Unit, Scenario ID, Fiscal Year, and Period

Specify the common consolidation business unit, scenario ID, fiscal year, and accounting period.

A match report using these same field values must exist to view results. Depending on how you access this page, these fields may be prepopulated and the results are viewable. If not, complete the fields, and click Go; the page expands, displaying the Inquiry Criteria and the Match Results regions. You can modify the inquiry criteria and click Go again to view different results.

Specifying Inquiry Criteria

Amount Option	Specify whether to include Current Period Activity or Year To Date balances.
<Dimension Value> Option	Select which dimension values to include. The label for this field varies depending on your consolidation dimension. In the sample shown, the label is Ledger Unit Option, as the consolidation dimension is ledger business unit. Options are: All: Includes all dimension values. Tree Node: Uses a tree to determine the dimension values to include. Complete the Tree Node field to indicate which values to include. Value: Includes a single dimension value. Specify which value to include in the adjacent dimension field.
Match To Option	Select All to include all matched dimension objects. Select Value to include a specific object, specifying which one in the Match To field. (This field label differs depending on the consolidation dimension.)
Out of Balance	Select to include only matches that don't net to zero. Optionally, enter a value in the Tolerance field to limit the report to out-of-balance matches that are equal to or greater than the specified tolerance amount. The amount is in the consolidation base currency.

Reviewing Match Results

The Match Results region includes an overall report total (Total Remaining), and a Summary grid that contains rows of summarized results for each elimination rule, match group, unit, and affiliate combination (if your elimination rules match on affiliate).

Tags Included	When selected, indicates that matching tags were entered for objects within that row, their totals have been included in the processing for the match report, and the calculated total amount reflects the matching tag entry amounts.
List Journals	Click to view the list of journals included in a proforma report.
Total Amt	Click the amount total to access the Match Results Detail page and view the detail lines that contributed to an amount.

Viewing Details of Match Results

Access the Match Results Detail page.

This page lists the report dimension unit entries in one grid and the match dimension unit entries in a separate grid. The rows may not necessarily match up on a one-to-one basis, but if there is a variance, you can compare the amounts to determine why. When the report dimension and match dimension are the same, the data represents intracompany transactions.

Elimination Rule Description	Click to access the Elimination Rule page and review the rule.
Add Tag Entry	Click to access the Matching Tag Entry page, where you can enter or review tags to explain the reason for a variance and reduce it by the amount that you enter.
Reason Code	Click to access the Matching Tag Entry page and review the tag entry.
Return to Selection Page	Click to access the Match Results Inquiry page, retaining the current criteria and results.

Creating Matching Tag Entries

Access the Matching Tag Entry page.

Insert rows as needed to enter matching tag lines. The first column after the line number varies, based on the consolidation dimension. In the example, the consolidation dimension is business unit, and the tag entry is for a specific ledger business unit.

Account, Total Amount, Affiliate, and Reason	For each tag entry, you must specify an account, a total amount, and a reason code. Affiliate is optional, but recommended when the elimination rules are defined to match on affiliate values. The amounts that you enter are included in the match process the next time that it is run. These lines are not posted to any journals; they impact the matching report only.
Comments	Select to enter detailed notes about the entry.
Create Matching Tag Reason Code	Click to access the Matching Tag Reason Code page, where you can add or update a reason code.

Remember, before the matching tag entries actually impact the totals for your matching report, you must run the matching report process again with the Include Tags in Report check box selected.

Generating Consolidation Reports

This section provides an overview of delivered PS/nVision reports, lists common elements, and discusses how to run consolidation reports.

Understanding Delivered PS/nVision Reports

The sample PSn/Vision reports are:

GCV1000	Lists ChartField balances from the Trial Balance consolidation ledger format.
GCV1005	Lists ChartField balances from the Financial Statement consolidation ledger format.
GCV1010	Lists ChartField balances for each ledger business unit from the Trial Balance consolidation ledger format.
GCV1015	Lists ChartField balances for each ledger business unit from the Financial Statement consolidation ledger format.
GCV1020	Lists the year to date amounts for all accounts from the Trial Balance consolidation ledger format.
GCV1100	Generates an income statement from the Trial Balance consolidation ledger format.
GCV1105	Generates an income statement from the Financial Statement consolidation ledger format.
GCV1110	Generates an income statement by nature of expense from the Trial Balance consolidation ledger format.
GCV1115	Generates an income statement by nature of expense from the Financial Statement consolidation ledger format.
GCV1120	Generates an income statement as a percentage of revenue from the Trial Balance consolidation ledger format.
GCV1125	Generates an income statement as a percentage of revenue from the Financial Statement consolidation ledger format.
GCV1130	Generates a budget vs actuals report where the actual amount is from the Trial Balance consolidation ledger format.
GCV1135	Generates a budget vs actuals report where the actual amount is from the Financial Statement consolidation ledger format.
GCV1140	Generates a forecast report where the actual amount is from the Trial Balance consolidation ledger format.
GCV1145	Generates a forecast report where the actual amount is from the Financial Statement consolidation ledger format.
GCV1150	Generates a segment report by product from the Trial Balance consolidation ledger format.
GCV1155	Generates a segment report by product from the Financial Statement consolidation ledger format.
GCV1160	Generates a segment report by region from the Trial Balance consolidation ledger format.
GCV1165	Generates a segment report by region from the Financial Statement consolidation ledger format.
GCV1200	Generates a cash flow report from the Trial Balance consolidation ledger format.
GCV1210	Generates a change in equity report from the Trial Balance consolidation ledger format.
GCV1220	Generates a change in goodwill report from the Trial Balance consolidation ledger format.

Note. These are sample reports; you need to modify them to work with your data. PS/nVision reports created for use with PeopleSoft Enterprise Global Consolidations must be query-based.

See Also

Enterprise PeopleTools PeopleBook: PS/nVision

Common Elements Used in This Section

Display Full Numeric Field	Displays all digits.
ChartField Selection	Controls which ChartFields to include in the report. For each ChartField that you include, indicate its sequence (they appear in ascending order, with the lowest number first) and dimension. Select the Select check box to include it. Select the Show Description check box to list the ChartField value's description in the report.
Show Discrepancies Only	Select to show only those rows where the sum of the details doesn't equal the difference between the beginning and ending values. Applies to the Ledger Detail report only.
Show Journal Detail	Select to include journal line details. Applies to the Ledger Detail report only.
Show Statistics Amount	Includes statistical amounts in the report. Applies to the Journal Detail report only.
PF Batch ID	Indicate the processed batch ID to include. Applies to the Journal Detail report only.
Batch Source	Select the source of data to include in the report; applies to the Journal Detail report only. Values are: All: Include data from all sources. Engine: Include data generated from consolidation processes only. Manual: Include manually entered data only.
Batch Status	Select the status of data to include in the report; applies to the Journal Detail report only. Values are: All: Include all data regardless of the batch status. Error: Include only data with an error status. Posted: Include only posted data. Valid: Include only valid, but not posted, data.

Pages Used to Generate Consolidation Reports

Page Name	Object Name	Navigation	Usage
Journal Detail	GC_RUN_GC7000	Global Consolidations, Consolidation Analysis, Consolidation Reports, Journal Detail	Run the Journal Detail report (GC7000) Lists journal entry detail information by ledger business unit, including journal ID, date, debit and credit amounts. (SQR)
Ledger Activity	GC_RUN_GC7002	Global Consolidations, Consolidation Analysis, Consolidation Reports, Ledger Activity	Run the Ledger Activity report (GC7002) Lists the beginning and ending ledger balances by ChartField combination and account. Optionally lists the detailed journal line activity posted against the ledger for the accounting periods that are specified. (SQR)
Out of Balance Report	GC_RUN_GC7005	Global Consolidations, Consolidation Analysis, Consolidation Reports, Out of Balance Report	Run the Out of Balance report (GC7005). Lists the elimination sets and ledger amounts processed for a consolidation request. The elimination sets are totaled and any out of balance amount is displayed. Summarizes the out of balance amounts at the node and tree levels. (SQR)
Non-Controlling Interest	GC_RUN_GC7007	Global Consolidations, Consolidation Analysis, Consolidation Reports, Non Controlling Interest	Run the Non-Controlling Interest report (GC7007). Lists results of the noncontrolling interest calculations generated during consolidation based on the combination of business units present in the consolidation tree, by entry type and rule set, with subtotals grouped by tree node and ownership set. (SQR)
Equitization Calculation	GC_RUN_GC7009	Global Consolidations, Consolidation Analysis, Consolidation Reports, Equitization Calculation	Run the Equitization Calculation report (GC7009). Lists details of the equitization accounting entries generated during equitization processing by entry type and rule set, with subtotals grouped by tree node and ownership set. (SQR)
Match Report	RUN_GC_MATCH	Global Consolidations, Consolidation Analysis, Perform Matching, Matching Process and Report	Run the Match report (GCS2001). Lists the journal lines generated by elimination set. (SQR)
Close Balance Report	GC_RUN_CLS_RPT	Global Consolidations, Consolidation Analysis, Consolidation Reports, Close Process Report	Run the Close Balance report (GCS2002). Lists the closing and rollforward entries resulting from the close process. (SQR)
Match Results Inquiry	GC_MTCH_INQ_PAGE	Global Consolidations, Consolidation Analysis, Perform Matching, Match Results Inquiry	Run the Match Results Inquiry report.
Matching Tag Reason Code	GC_MATCH_CD_PG	Global Consolidations, Consolidation Analysis, Perform Matching, Matching Tag Reason Code	Run the Matching Tag Reason Code report.
Matching Tag Entry	GC_MATCH_TAG_PG	Global Consolidations, Consolidation Analysis, Perform Matching, Matching Tag Entry	Run the Matching Tag Entry report.
nVision Report Request	NVS_REPORT_RQST	Reporting Tools, PS/nVision, Define Report Request	Create or modify PS/nVision reports.

See Also

Running Match Reports

Running Consolidation Reports

To run a consolidation report:

Access the specific report page.

See Pages Used to Generate Consolidation Reports.
Enter the report parameters.

See Common Elements Used in This Section.
Click Run.

Harmonization Entries	Indicates the status of the harmonization entries process. The Preparation Phase must be set to Ledger Enrichment to view this status.
Translation Adjustment	Indicates the status of the translation adjustments process. The Preparation Phase must be set to Ledger Enrichment to view this status.
Source Flows	Indicates the status of the source flow update process. The Preparation Phase must be set to Ledger Enrichment to view this status.

Business Unit, Scenario, Fiscal Year, and Period	Specify the data to audit. The business unit should be a common consolidation business unit.
Amount Type	Select how to summarize amounts for ledger balances. Options are: End of Period / Period Activity: Select to view end of period balances for balance sheet accounts, and period activity for income statement accounts. End of Period / Year to Date: Select to view end of period balances for balance sheet accounts, and YTD activity for income statement accounts. Period Activity: Select to view period activity for all accounts. This option is available only for trial balance format ledgers.
Source Process	(Optional) Limits the audit scope to data that originates from a specific GC_SOURCE value. See Consolidation Data Source.
Max Rows to Scroll	Enter the number of rows to view per page.
Book Code Group	Select the book code group by which you want to further filter the inquiry report data. This is an optional field and is only available if you turn on book code functionality on the General Options page and you create your code values with the Book Codes and Book Code Group pages. Book code is an additional dimension on which you can report. If book code functionality is available, you can select this option and the report displays separate amounts by book code when drilling down for inquiries on the consolidation audit.
Select	Select Ledger Details to audit data from the consolidation ledger (GC_CLED_XXX_F00) or Journal Details to audit data from the journal table (GC_JRNL_XXX_F00).
Dimension Criteria	Click to access the Consolidation Audit - Select Dimensions page, where you can specify which dimension values to include in the audit.
Select Journal	Click to access the Consolidation Audit - Select Journal page, where you can limit which journal to include when auditing journal details.
Go	Click to access the Consolidation Audit Trail - Results page, where you can view the audit results.

Tree Node	Specify which node to use for the run analysis. The node level used the last time the process ran appears by default, but you can specify a different node to limit the results to objects within that node and subordinate to it.
Process	Select which consolidation process to compare. Options are: Elimination, Equitization, or Non-Controlling Interest.
New Instance and Old Instance	Specify which two runs to compare. The most recent process instances appear by default in these fields.
Additional Dimensions	Click to access the Additional Dimensions page, where you can specify which other dimensions appear when you view details.
Go	Click to run the inquiry and view the results. The system displays the Consolidation Run Analysis - Results page.