Creating Reconciliation Reports
Page Name |
Definition Name |
Usage |
---|---|---|
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:
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:
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:
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. |