Understanding Open Liability and Reconciliation Reporting
PeopleSoft Payables provides reports to view open liabilities and compare them to the open liabilities in PeopleSoft General Ledger. These reports enable you to find unbalanced liabilities easily and correct them as necessary. PeopleSoft Payables also provides a report that enables you to age suppliers' liabilities.
Creating an open liability or reconciliation report involves specifying both report parameters and run control parameters on a single page. Initiating an Application Engine process from the page accesses the PeopleSoft Process Scheduler, from which you can select options to populate the appropriate report tables and generate reports to your specifications.
The following open liability and reconciliation reports are delivered with PeopleSoft Payables:
|
Report Name |
Application Engine Process |
Report Description |
|---|---|---|
|
Payables Open Liability (APY1406) |
AP_APY1406 |
This report lists posted (recorded) open liabilities in the PeopleSoft Payables tables as of a specific date. You can also specify whether to include unrecorded (unposted) liabilities, prepayments, unmatured drafts paid, and available discounts. |
|
Supplier Liability Aging (APY1408) |
AP_APY1408 |
This report lists all posted (recorded) open liabilities in PeopleSoft Payables as of a specific date and grouped by the aging cycle bucket. You can also specify whether to include unrecorded (unposted) liabilities, prepayments, unmatured drafts paid, and available discounts. |
|
Summary AP/GL Open Liability (APY1400) Detail AP/GL Open Liability (APY1405) |
AP_APY1405 |
These reports list accounting activity that has been processed by the Journal Generator Application Engine process (FS_JGEN). |
|
AP/GL Account Reconciliation Report (APY1410) |
AP_APGLRECN |
This report lists account totals by journal ID and account. |
|
AP/GL Journal Reconciliation Report (APY1420) |
AP_APGLRECN |
This report lists account totals by journal line and journal ID. |
Note: Data that appears in open liability and reconciliation reports is accurate as of the time you run the Application Engine process that loads the report tables, based on the requested as-of date and as-of date type parameters that you select. However, if the report tables already have the data that you want, you can run multiple reports by changing the report request parameters and running the reports only.