Prompt Payment Compliance Report (APR002)
-
Print
-
DarkLight
-
PDF
Prompt Payment Compliance Report (APR002)
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
A report that lists interest paid for invoices not timely paid in accordance with prompt pay requirements. This on-demand report identifies AP invoices, subject to prompt payment timeframes, that were not timely paid, and the calculated interest assessed and is intended to support agency users and enterprise users monitor and manage overall compliance with the prompt payment requirements set in law on a monthly or quarterly basis.
Report Location
Data Warehouse
Report Sample Layout
See the sample layout report below.
Report Navigation
Coming Soon!
Report Audience
- AP Reporter
- Confidential AP Reporter
Suggested Report Frequency
- Ad Hoc
- Quarterly
- 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" | Y | Y |
Voucher Entered Date (From: To:) | N | cast("Payables Payment Voucher Details"."Voucher Entered Date" as date) | Y | Y |
Report Columns
The layout of the report is listed below.
Column Name | Column in Subject Area or TableName.ColumnName |
|---|---|
Business Unit | "AP Voucher Business Unit"."Business Unit" |
Business Unit Name | "AP Voucher Business Unit"."AP Business Unit Description (Voucher)" |
Count of Invoices subject to 215.422, F.S. | SUM(CASE WHEN ("Invoice Cleared Date"."Invoice Cleared Fiscal Date" - "Payables Payment Voucher Details"."Invoice Receipt Date") <= 20 THEN 1 ELSE 0 END) |
Total of Invoice Amount | SUM(CASE WHEN ("Invoice Cleared Date"."Invoice Cleared Fiscal Date" - "Payables Payment Voucher Details"."Invoice Receipt Date") <= 20 THEN "Fact - Fins - AP Transaction Custom"."Gross Amount" ELSE 0 END BY "AP Voucher Business Unit"."Business Unit" ) |
Basis Date (Count of Invoices Exceeding 20 Days) | SUM(CASE WHEN ("Invoice Cleared Date"."Invoice Cleared Fiscal Date" - "Payables Payment Voucher Details"."Basis Date") > 20 THEN 1 ELSE 0 END) |
Calculated Percentage in Compliance | 1 - CAST(SUM(CASE WHEN ("Invoice Cleared Date"."Invoice Cleared Fiscal Date" - "Payables Payment Voucher Details"."Basis Date") > 20 THEN 1 ELSE 0 END) AS FLOAT) / CAST(SUM(CASE WHEN ("Invoice Cleared Date"."Invoice Cleared Fiscal Date" - "Payables Payment Voucher Details"."Invoice Receipt Date") <= 20 THEN 1 ELSE 0 END) AS FLOAT)R |
Total Interest Assessed | SUM(CASE WHEN ("Invoice Cleared Date"."Invoice Cleared Fiscal Date" - "Payables Payment Voucher Details"."Invoice Receipt Date") <= 20 THEN SUM(CASE WHEN "Payables Payment Voucher Details"."Invoice ID (Interest Voucher)" LIKE 'INT%' THEN "Fact - Fins - AP Transaction Custom"."Gross Amount" ELSE 0 END BY "AP Voucher Business Unit"."Business Unit") ELSE 0 END) |
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?
