Creating Reconciliation Reports

Page Name

Definition Name

Usage

Payables Open Liability Reconciliation Page

RUN_APY1405

Specify run control and reporting parameters to generate Payable Open Liability Reconciliation (APY1400 and APY1405) reports. Create a detail report, a summary report, or both during processing.

AP/GL Account Reconciliation Page (accounts payable and general ledger account reconciliation)

APGL_RECN_REQ2

Specify run control and reporting parameters to generate AP/GL Account Reconciliation (APY1420) reports.

AP/GL Journal Reconciliation Page (accounts payable and general ledger journal reconciliation)

APGL_RECN_REQ1

Specify run control and reporting parameters to generate AP/GL Journal Reconciliation (APY1410) reports.

Use the Payables Open Liability Reconciliation page (RUN_APY1405) to specify run control and reporting parameters to generate Payable Open Liability Reconciliation (APY1400 and APY1405) reports.

Create a detail report, a summary report, or both during processing.

Navigation:

Accounts Payable > Reports > Voucher Reconciliation > Open Liability Reconciliation > Payables Open Liability Reconciliation

Field or Control

Description

Request ID

Enter an ID that comprises any combination of characters.

As Of Date

Enter a date for the period that you are processing. This field is compared to the journal date.

Business Unit Option

Select All to create a report for all business units for the time period you specified.

Select Value to specify any number of general ledger business unit rows on which to report.

Process Scheduler Options

When you click the Run button, the Process Scheduler Request page lists the processes that generate an open liability reconciliation report. The following options enable you to load data and generate a report or merely generate a report:

Process List Option

Description

APGL Open Liab Recon Data/Rept

Loads data into the report tables based upon run request parameters and generates both summary and detail versions of the Payables Open Liability Reconciliation report.

Summary AP/GL Open Liability

Generates a summary version of the Payables Open Liability Reconciliation report using data that is already loaded into report tables. Use this option only when data is already loaded.

Detail AP/GL Open Liability

Generates a detailed version of the Payables Open Liability Reconciliation report using data that is already loaded into report tables. Use this option only when data is already loaded.

Use the AP/GL Account Reconciliation (accounts payable and general ledger account reconciliation) page (APGL_RECN_REQ2) to specify run control and reporting parameters to generate AP/GL Account Reconciliation (APY1420) reports.

Navigation:

Accounts Payable > Reports > Voucher Reconciliation > AP/GL Account Recon Request > AP/GL Account Reconciliation

Field or Control

Description

Business Unit

Select a business unit for the time period that you specify.

Ledger and Account

Select the general ledger and account for the journal entries that you want to include in the report.

Accounting Period

Enter the accounting period for which you want to create a report.

Fiscal Year

Enter the four-digit fiscal year for the accounting period for which you want to create a report.

Process Scheduler Options

When you click the Run button, the Process Scheduler Request page lists the processes that generate a reconciliation report. The following options enable you to load data and generate a report or merely generate a report:

Process List Option

Description

AP GL Accnt Recon Data & Rept

Loads data into the report tables based upon run request parameters and generates the AP/GL Account Reconciliation report.

AP/GL Account Reconciliation

Generates the AP/GL Account Reconciliation report using data that is already loaded into report tables. Use this option only when data is already loaded.

Use the AP/GL Journal Reconciliation (accounts payable and general ledger journal reconciliation) page (APGL_RECN_REQ1) to specify run control and reporting parameters to generate AP/GL Journal Reconciliation (APY1410) reports.

Navigation:

Accounts Payable > Reports > Voucher Reconciliation > AP/GL Journal Recon Request > AP/GL Journal Reconciliation

Field or Control

Description

Report Option

Specify how you want to organize the report data. Options are:

Accounting Period: Include detail in the report by accounting period. If you select this option, the Accounting Period and the Fiscal Year fields become active.

Journal Date: Include detail in the report by journal date. If you select this option, the Journal Date field becomes active.

Journal ID: Include detail in the report by journal ID. If you select this option, the GL Journal ID field becomes active.

Journal ID

Enter the general ledger journal ID for which you want to create a report. This field is active only if you select the Journal ID report option.

Journal Date

Enter the journal date for which you want to create a report. This field is active only if you select the Journal Date report option.

Accounting Period

Enter the accounting period for which you want to create a report. This field is active only if you select the Accounting Period report option.

Fiscal Year

Enter the four-digit fiscal year for the accounting period for which you want to create a report. This field is active only if you select the Accounting Period report option.

Process Scheduler Options

When you click the Run button, the Process Scheduler Request page lists the processes that generate a reconciliation report. The following options enable you to load data and generate a report or merely generate a report:

Process List Option

Description

AP GL Journal Recon Data & Rpt

Loads data into the report tables based upon run request parameters and generates the AP/GL Journal Reconciliation report.

AP/GL Journal Reconciliation

Generates the AP/GL Journal Reconciliation report using data that is already loaded into report tables. Use this option only when data is already loaded.