Payment Summary (APR027)
-
Print
-
DarkLight
-
PDF
Payment Summary (APR027)
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
A report used to compute the number and dollar amount of payments made by warrant and/or ACH run by day, per month, or other user-defined time-period. This on-demand report summarizes pay cycle activities by payment method. It is intended to support enterprise users with monitoring the pay cycle activities.
Report Location
Data Warehouse
Report Sample Layout
See the sample layout report below.
Report Navigation
Coming Soon!
Report Audience
- AP Reporter
- Treasury CMIA Maintainer
Suggested Report Frequency
- Ad Hoc
- Monthly
- Annually
Business Process Models
This report can be found in the following business processes:
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 |
|---|---|---|---|---|
Business Unit | N | "AP Voucher Business Unit"."Business Unit" | N | Y |
Payment Date (From: To:) | N | "Payables Payment Voucher Details"."Payment Date" | N | Y |
Payment Method | N | "Payment Method"."Payment Method Desc" | N | Y |
Pay Cycle | N | "Payables Payment Voucher Details"."Pay Cycle" | N | Y |
Report Columns
The layout of the report is listed below.
Column Name | Column in Subject Area or TableName.ColumnName |
|---|---|
Pay Cycle | "Payables Payment Voucher Details"."Pay Cycle" |
Payment Date | "Payables Payment Voucher Details"."Payment Date" |
Payment Method | "Payment Method"."Payment Method Desc" |
Business Unit | "AP Voucher Business Unit"."Business Unit" |
Payment Amount | SUM("Fact - Fins - AP Transaction Custom"."Payment Amount" BY "AP Voucher Business Unit"."Business Unit", "Payables Payment Voucher Details"."Payment Date", "Payables Payment Voucher Details"."Pay Cycle" ) |
Count of Payment Reference ID | COUNT("Account Payables Identifiers"."Payment Reference ID" BY "AP Voucher Business Unit"."Business Unit", "Payables Payment Voucher Details"."Payment Date", "Payables Payment Voucher Details"."Pay Cycle" ) |
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 ChartFields 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?
