Appendix: PeopleSoft Enterprise Global Consolidations Reports

This appendix provides an overview of PeopleSoft Enterprise Global Consolidations reports and enables you to view a summary table of all reports.

Note. For samples of the Structured Query Reports (SQRs), see the PDF files published on CD-ROM with your documentation.

See Also

Generating Consolidation Reports

Running Match Reports

Enterprise PeopleTools PeopleBook: Using PeopleSoft Applications

Click to jump to top of pageClick to jump to parent topicPeopleSoft Enterprise Global Consolidations Reports: A to Z

This table lists the PeopleSoft Global Consolidations reports, sorted alphanumerically by report ID.

You can also use the PeopleSoft Financials Warehouse as a basis for reporting.

See Understanding the Multidimensional Warehouse.

Report ID and Report Name

Description

Navigation

Run Control Page

GC7000

Journal Detail

Lists journal entry detail information by ledger business unit, including journal ID, date, and debit and credit amounts.

Global Consolidations, Consolidation Analysis, Consolidation Reports, Journal Detail

GC_RUN_GC7000

GC7002

Ledger Activity

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)

Global Consolidations, Consolidation Analysis, Consolidation Reports, Ledger Activity

GC_RUN_GC7002

GC7005

Out of Balance Report

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)

Global Consolidations, Consolidation Analysis, Consolidation Reports, Out of Balance Report

GC_RUN_GC7005

GC7007

Non Controlling Interest

Lists results of the non-controlling interest calculations generated during consolidation. The calculations are based on the combination of business units in the consolidation tree, by entry type and rule set, with subtotals grouped by tree node and ownership set.

Global Consolidations, Consolidation Analysis, Consolidation Reports, Non Controlling Interest

GC_RUN_GC7007

GC7009

Equitization Calculation

Displays details of the equitization accounting entries that are generated during equitization processing. The entries are sorted by entry type and rule set, with subtotals grouped by tree node and ownership set.

Global Consolidations, Consolidation Analysis, Consolidation Reports, Equitization Calculation

GC_RUN_GC7009

GCS2001

Match Report

Lists the journal lines generated by elimination set. (SQR)

Global Consolidations, Consolidation Analysis, Perform Matching, Matching Process and Report

RUN_GC_MATCH

GCS2002

Close Balance Report

Lists the closing and rollforward entries resulting from the close process. (SQR)

Global Consolidations, Consolidation Analysis, Consolidation Reports, Close Process Report

GC_RUN_CLS_RPT

GCV1000

Consolidated Balance Sheet (Trial Balance)

Lists ChartField balances from the Trial Balance consolidation ledger format. (PS/nVision)

Reporting Tools, PS/nVision, Define Report Request

NVS_REPORT_RQST

GCV1005

Consolidated Balance Sheet (Financial Statement)

Lists ChartField balances from the Financial Statement consolidation ledger format. (PS/nVision)

Reporting Tools, PS/nVision, Define Report Request

NVS_REPORT_RQST

GCV1010

Balance Sheet Multi-Column

Lists ChartField balances for each ledger business unit from the Trial Balance consolidation ledger format. (PS/nVision)

Reporting Tools, PS/nVision, Define Report Request

NVS_REPORT_RQST

GCV1015

Balance Sheet Multi-Column

Lists ChartField balances for each ledger business unit from the Financial Statement consolidation ledger format. (PS/nVision)

Reporting Tools, PS/nVision, Define Report Request

NVS_REPORT_RQST

GCV1020

Trial Balance

Lists the year to date amounts for all accounts from the Trial Balance consolidation ledger format. (PS/nVision)

Reporting Tools, PS/nVision, Define Report Request

NVS_REPORT_RQST

GCV1100

Consolidated Income Statement

Generates an income statement from the Trial Balance consolidation ledger format. (PS/nVision)

Reporting Tools, PS/nVision, Define Report Request

NVS_REPORT_RQST

GCV1105

Consolidated Income Statement

Generates an income statement from the Financial Statement consolidation ledger format. (PS/nVision)

Reporting Tools, PS/nVision, Define Report Request

NVS_REPORT_RQST

GCV1110

Income Statement (Nature)

Generates an income statement by nature of expense from the Trial Balance consolidation ledger format. (PS/nVision)

Reporting Tools, PS/nVision, Define Report Request

NVS_REPORT_RQST

GCV1115

Income Statement (Nature)

Generates an income statement by nature of expense from the Financial Statement consolidation ledger format. (PS/nVision)

Reporting Tools, PS/nVision, Define Report Request

NVS_REPORT_RQST

GCV1120

Income Statement (Percentage)

Generates an income statement as a percentage of revenue from the Trial Balance consolidation ledger format. (PS/nVision)

Reporting Tools, PS/nVision, Define Report Request

NVS_REPORT_RQST

GCV1125

Income Statement (Percentage)

Generates an income statement as a percentage of revenue from the Financial Statement consolidation ledger format. (PS/nVision)

Reporting Tools, PS/nVision, Define Report Request

NVS_REPORT_RQST

GCV1130

Budget vs. Actuals

Generates a budget vs actuals report where the actual amount is from the Trial Balance consolidation ledger format. (PS/nVision)

Reporting Tools, PS/nVision, Define Report Request

NVS_REPORT_RQST

GCV1135

Budget vs. Actuals

Generates a budget vs actuals report where the actual amount is from the Financial Statement consolidation ledger format. (PS/nVision)

Reporting Tools, PS/nVision, Define Report Request

NVS_REPORT_RQST

GCV1140

Forecast

Generates a forecast report where the actual amount is from the Trial Balance consolidation ledger format. (PS/nVision)

Reporting Tools, PS/nVision, Define Report Request

NVS_REPORT_RQST

GCV1145

Forecast

Generates a forecast report where the actual amount is from the Financial Statement consolidation ledger format. (PS/nVision)

Reporting Tools, PS/nVision, Define Report Request

NVS_REPORT_RQST

GCV1150

Segment by Product

Generates a segment report by product from the Trial Balance consolidation ledger format. (PS/nVision)

Reporting Tools, PS/nVision, Define Report Request

NVS_REPORT_RQST

GCV1155

Segment by Product

Generates a segment report by product from the Financial Statement consolidation ledger format. (PS/nVision)

Reporting Tools, PS/nVision, Define Report Request

NVS_REPORT_RQST

GCV1160

Segment by Region

Generates a segment report by region from the Trial Balance consolidation ledger format. (PS/nVision)

Reporting Tools, PS/nVision, Define Report Request

NVS_REPORT_RQST

GCV1165

Segment by Region

Generates a segment report by region from the Financial Statement consolidation ledger format. (PS/nVision)

Reporting Tools, PS/nVision, Define Report Request

NVS_REPORT_RQST

GCV1200

Cash Flow Statement

Generates a cash flow report from the Trial Balance consolidation ledger format. (PS/nVision)

Reporting Tools, PS/nVision, Define Report Request

NVS_REPORT_RQST

GCV1210

Change in Equity

Generates a change in equity report from the Trial Balance consolidation ledger format. (PS/nVision)

Reporting Tools, PS/nVision, Define Report Request

NVS_REPORT_RQST

GCV1220

Change in Goodwill

Generates a change in goodwill report from the Trial Balance consolidation ledger format. (PS/nVision)

Reporting Tools, PS/nVision, Define Report Request

NVS_REPORT_RQST