Prompt Payment Report (APR024)
- 29 May 2024
- 2 Minutes to read
-
Print
-
DarkLight
-
PDF
Prompt Payment Report (APR024)
- Updated on 29 May 2024
- 2 Minutes to read
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
The Prompt Payment Report is a report that lists vouchers that are approaching Prompt Payment processing deadlines i.e., vouchers that are not paid, and the Basis Date is greater than 10 Days. The Prompt Payment Report lists the vouchers approaching prompt payment processing deadlines and also interest vouchers.
Report Navigation: Main Menu > Florida PALM > Reports > AP > Prompt Payment Report
Query Name: FLP_APR_Prompt_Payment_Report
See the sample report layout below.
Business Roles
The following business roles have access to this report:
Business Process Models
This report can be found in the following business sub-processes:
Selection Criteria
The report data can be filtered by the following selection criteria:
Data Field | Data Field Details |
Business Unit | Field prompt. User can select specific BU’s. % or actual value as per BU security - Optional |
Voucher Creation Date From | Field prompt. User can select specific dates - Optional |
Voucher Creation Date To | Field prompt. User can select specific dates - Optional |
Report Layout
The layout of the report is listed below.
Report Detail Section 1 – Prompt Pay Approaching Payments Deadlines
Florida PALM RECORD.FIELD mapping | |
Voucher ID | VOUCHER.VOUCHER_ID |
Invoice ID | VOUCHER.INVOICE_ID |
Origin | VOUCHER.ORIGIN |
Voucher Gross Amount | VOUCHER.GROSS_AMT |
Voucher Line | DISTRIB_LINE.VOUCHER_LINE_NUM |
Distribution Line | DISTRIB_LINE.DISTRIB_LINE_NUM |
Distribution Line Amount | DISTRIB_LINE.MERCHANDISE_AMT |
Account | DISTRIB_LINE.ACCOUNT |
Medical Account (Y/N) | Derived Value based on Account attribute for Medical Account |
Goods and Services Account (Y/N) | Derived Value based on Account attribute for Goods and Services Account |
Voucher Status | VOUCHER.ENTRY_STATUS |
Voucher Creation Date | VOUCHER.ENTERED_DT |
Estimated Basis Date | Derive estimated Basis Date from latest of below three dates from ‘Basis Date Calculation’ Page.
|
Date the goods or services were approved | VOUCHER.INSPECT_DT |
Date the goods or services were received | VOUCHER. USER_VCHR_DATE |
Date the invoice was received | VOUCHER.INVOICE_RCPT_DT |
Scheduled Due Date | PYMNT_VCHR_XREF. SCHEDULED_PAY_DT |
Number of Days Past Estimated Basis Date | Derive number of days past basis date from Current Date - Estimated Basis Date (latest date of below 3 dates) for vouchers that are not Paid.
|
Scheduled Days Past Prompt Payment | Derive scheduled days past prompt payment from Scheduled Due Date and Estimated Basis Date (latest date of below 3 dates) for vouchers that are not Paid. Step 1: Calculate Total Days Late Total Days Late = Scheduled Due Date - Estimated Basis Date Step 2: Calculate Scheduled Days Past Prompt Payment Scheduled Days Past Prompt Payment = Total Days Late - 35 Days or 40 days Step 3: Display data in ‘Red’ color Only when Scheduled Days Past Prompt Payment > 0 else display as blank. |
Report Detail Section 2 – Interest Vouchers Approaching Payments Deadlines
Data Field | Florida PALM RECORD.FIELD mapping |
AP BU | VOUCHER.BUSINESS_UNIT |
Voucher ID | VOUCHER.VOUCHER_ID |
Invoice ID | VOUCHER.INVOICE_ID |
Origin | VOUCHER.ORIGIN |
Voucher Gross Amount | VOUCHER.GROSS_AMT |
Voucher Line | DISTRIB_LINE.VOUCHER_LINE_NUM |
Distribution Line | DISTRIB_LINE.DISTRIB_LINE_NUM |
Distribution Line Amount | DISTRIB_LINE.MERCHANDISE_AMT |
Account | DISTRIB_LINE.ACCOUNT |
Voucher Status | VOUCHER.ENTRY_STATUS |
Voucher Creation Date | VOUCHER.ENTERED_DT |
Date the goods or services were approved | VOUCHER.INSPECT_DT |
Date the goods or services were received | VOUCHER. USER_VCHR_DATE |
Date the invoice was received | VOUCHER.INVOICE_RCPT_DT |
Scheduled Due Date | PYMNT_VCHR_XREF. SCHEDULED_PAY_DT |
Number of Days Past Voucher Creation Date | Derive number of days past voucher creation date from below dates. Current Date - Voucher Creation Date |
Version History
Date | Revision Description |
12/01/2023 | Original Version |
Was this article helpful?
