Producing Average Daily Balance Reports

Page Name

Definition Name

Usage

ADB Definition Report Page (average daily balance definition report)

RUN_GLS5500

Specify the run parameters for the ADB Definition Report.

ADB Calculation Report Page (average daily balance calculation report)

RUN_GLC5501

Specify the run parameters for the ADB Calculation Report.

To run a report, select it from a menu and enter the necessary parameters. Once you enter the report parameters, you use PeopleSoft Process Scheduler to actually run the report. PeopleSoft Process Scheduler manages the processes, tracks the status, and generates the report behind the scenes while you continue to work on something else.

You can create your own reports or reformat report output. PeopleSoft offers a variety of reporting tools.

Note: Summary ledgers support summarization of ADB target ledgers. However, summarizing daily ledgers is not supported.

Use the ADB Definition Report (average daily balance definition report) page (RUN_GLS5500) to specify the run parameters and run the ADB Definition Report.

Navigation:

General Ledger > Average Daily Balance > ADB Definition Report > ADB Definition Report

The following data is reported:

Field or Control

Description

ADB Amount Record (average daily balance amount record)

Displays the column in the ADB Amount Record table where the system stores daily balances for this ledger.

Work Table Record

Displays the name of the work table ledger.

ADB Amount Field (average daily balance amount field)

Displays the name of the ADB amount field and whether it has an adjustment period.

Balanced ADB (balanced average daily balance)

Indicates with a Y or N whether the system automatically verifies if selected ledger amounts balance. Also adjusts average balance calculations for rounding discrepancies.

Use the ADB Calculation Report (average daily balance calculation report) page (RUN_GLC5501) to specify the run parameters and run the ADB Calculation Report.

Navigation:

General Ledger > Average Daily Balance > ADB Calculation Report > ADB Calculation Report