Payment Lifecycle Report (APR118)
-
Print
-
DarkLight
-
PDF
Payment Lifecycle Report (APR118)
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
A report that supports monitoring of payment life cycle by identifying key dates and providing elapsed days between voucher approval, voucher post date, payment issuance, payment post date, and payment settlement date.
This enterprise report will identify key dates associated with the payment lifecycle, such as the Voucher Entered Date, Voucher Posted Date, Payment Date, and Payment Reconciliation Date, to use in statistical reporting purposes.
Report Location
Data Warehouse
Report Sample Layout
See the sample layout report below.
Report Navigation
Coming Soon!
Report Audience
- AP Reporter
- AP Confidential Reporter
Suggested Report Frequency
- Ad Hoc
- Monthly
Business Process Models
This report can be found in the following business processes:
- 30.3 Enter and Process Vouchers
- 30.3.1 Process Vouchers
- 30.4 Process Payments
- 30.4.1 Process Pay Cycle
- 90.2 Create and Maintain Grants
- 90.2.4 Monitor CMIA
Report Prompts
The report data can be filtered by the following report prompts:
Parameter Name | Default Value | Column in Subject Area | Required (Y/N) | User Input |
|---|---|---|---|---|
Date Type | Y | N/A | Y | Y |
Date | N | "Payables Payment Voucher Details"."Voucher Entered Date" Payables Payment Voucher Details.Voucher Post Date Financials – AP Transactions.Payables Payment Voucher Details.Payment Date Financials – AP Transactions.Payables Payment Voucher Details.Payment Reconciliation Date | Y | Y |
Business Unit | N | Financials – AP Transactions.AP Voucher Business Unit.Business Unit | N | Y |
Payment Reference ID | N | Financials – AP Transactions.Account Payables Identifiers.Payment Reference ID | N | Y |
Report Columns
The layout of the report is listed below.
Column Name | Column in Subject Area or TableName.ColumnName |
|---|---|
Business Unit | Financials – AP Transactions.AP Voucher Business Unit.Business Unit |
Payment Reference ID | Financials – AP Transactions.Account Payables Identifiers.Payment Reference ID |
Payment Amount | Financials – AP Transactions.Fact - Fins – AP Transaction Custom.Payment Amount |
Voucher ID | Financials – AP Transactions.Account Payables Identifiers.Voucher ID |
Voucher Amount | Financials – AP Transactions.Fact - Fins – AP Transaction Custom.Gross Amount |
Remit Supplier Name | Financials – AP Transactions.Payables Payment Voucher Details.Name 1 |
Payment Method | "Payment Method"."Payment Method Desc" |
Voucher Entered Date | "Payables Payment Voucher Details"."Voucher Entered Date" |
Voucher Post Date | Payables Payment Voucher Details.Voucher Post Date |
Accounting Date | "Document Details"."Accounting Date" |
Budget Date | "Payables Payment Voucher Details"."Budget Date" |
Payment Date | Financials – AP Transactions.Payables Payment Voucher Details.Payment Date |
Payment Reconciliation Date | Financials – AP Transactions.Payables Payment Voucher Details.Payment Reconciliation Date |
# of Days Elapsed between Voucher Entered Date and Voucher Post Date | TIMESTAMPDIFF(SQL_TSI_DAY,"Payables Payment Voucher Details"."Voucher Entered Date", "Payables Payment Voucher Details"."Voucher Post Date" ) |
# of Days Elapsed between Voucher Post Date and Payment Date | TIMESTAMPDIFF(SQL_TSI_DAY,"Payables Payment Voucher Details"."Voucher Post Date" , "Payables Payment Voucher Details"."Payment Date") |
# of Days Elapsed between Payment Date and Payment Reconciliation Date | TIMESTAMPDIFF(SQL_TSI_DAY, "Payables Payment Voucher Details"."Payment Date" , "Payables Payment Voucher Details"."Payment Reconciliation Date") |
# of Days Elapsed between Voucher Entered Date and Payment Reconciliation Date | TIMESTAMPDIFF(SQL_TSI_DAY,"Payables Payment Voucher Details"."Voucher Entered Date", "Payables Payment Voucher Details"."Payment Reconciliation Date" ) |
Data
More information about the data fields, including business definition and key values, is included as part of the Interface Catalog and applicable interface file layouts.
More information about the data values is included here: Configured Data Values.
More information about the ChartField and related values is included in the Chart of Accounts Design.
Version History
Date | Revision Description |
|---|---|
01/31/2025 | Original Version |
Was this article helpful?
