Producing Interim and Year End Closing Reports

This section lists the standard closing reports. Running a report entails selecting it from a menu and entering any necessary parameters. Once you enter the report parameters, use PeopleSoft Process Scheduler to run the report.

Page Name

Definition Name

Usage

Closing Rule Report

RUN_GLS1002

Specify run parameters for the Closing Rules report (GLS1002 SQR). The report lists detailed information about the closing set rules.

General Ledger > Close Ledgers > Closing Rule Report

Closing Trial Balance

RUN_GLS1003

Specify run parameters for the Closing Trial Balance report.

The GLS1003 SQR report lists summary information of all entries on the ledger by account type.

The report shows the ledger entry account type with its beginning balance and period total, along with any adjustments made to the beginning balance. It also lists the closing entry and period total amounts for the year.

From the Close Ledgers menu option, select Closing Trial Balance.

Journal Closing Status Report Page

RUN_GLS1004

Specify the run parameters for the Journal Closing Status report.

Use the Journal Closing Status Report page (RUN_GLS1004) to specify the run parameters for the Journal Closing Status report.

Navigation:

General Ledger > Close Ledgers > Journal Closing Status Report

This example illustrates the fields and controls on the Journal Closing Status Report. You can find definitions for the fields and controls later on this page.

Journal Closing Status Report

Note: This page is discussed in detail because it involves more parameters than the system usually requires for generating reports.

Field or Control

Description

Display Full Numeric Field

Select to display the full numeric value if it is larger than the report column size. The number wraps to a second line.

Select From Closing Log Table

Select to have the scope of the report defined by the process instance stored in the closing log table. The Process Instance field becomes available.

Process Instance

Enter the process instance number of the Close process run.

Report Closing Status

Select one of the following to:

All Closing Status Types: Include all journals, regardless of their closing status.

All Except Not Processed: Include only journals that the close process has processed.

Closed Journals: Include only journals that the close process has closed.

Not Processed: Include only journals that the close process did not process.

Unclosed Journals: Include only journals that the close process processed but did not close.

ChartField Selection

Enter a sequence number and ChartField field long name. Use the Select option to include only selected values, and enter a value.

Note: To modify standard reports, create your own reports, or reformat report output, you can use a variety of reporting tools that the PeopleSoft system provides.