AP Posted Payment Register

Description

Categories
Enginatics, R12 only
Application
Payables
Source
Payables Posted Payment Register
Short Name
APXPOPMT
DB package
XLA_JELINES_RPT_PKG
Repository
GitHub
Payables Posted Payment Register

This report provides equivalent functionality to the Oracle standard Payables Posted Payment Register report.

For scheduling the report to run periodically, use the relative period from/to offset parameters. These are the relative period offsets to the current period, so when the current period changes, the included periods will also automatically be updated when the report is re-run.

Templates
- Pivot: Summary by Account
Equivalent to standard report in Summarize Report = Yes Mode
- Pivot: Summary by Account, Bank Account, Batch, Payment Currency, Payment Document
Equivalent to standard report in Summarize=No Order By=Bank Account
- Pivot: Summary by Account, Batch, Bank Account, Payment Currency, Payment Document
Equivalent to standard report in Summarize=No Order By=Journal Entry Batch
- Detail
Provides detail listing of the posted payments

Additional data fields are available. Run the report without a template to see full list available fields

Also requires custom package XXEN_XLA package to be installed to initialize the hidden parameters removed from the report to simplify scheduling of the report.

SQL 191 lines

Parameters 13