Payment Cancellation Report (APR050)
- 29 May 2024
- 1 Minute to read
-
Print
-
DarkLight
-
PDF
Payment Cancellation Report (APR050)
- Updated on 29 May 2024
- 1 Minute to read
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
The APR050–Payment Cancellation Report lists all canceled payments within a date range and the number of days outstanding, at the point of cancellation. The details of the canceled payments are grouped by Business Unit. The report displays the total payment count and total voucher line amount for each Business Unit (as applicable based on user privileges) and a grand total of payment count and voucher amount at the end of the report.
Report Navigation:
1. Main Menu > Florida PALM > Reports > AP > Payment Cancellation Report
2.Main Menu > Reporting Tools > Query > Query Viewer
Query Name: TBD
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 processes:
Selection Criteria
The report data can be filtered by the following selection criteria:
Data Field | Data Field Details |
|---|---|
Business Unit | Optional |
Supplier ID | Optional |
Voucher Origin | Optional |
Payment Reference From | Optional |
Payment Reference To | Optional |
Payment Method | Optional |
Payment Date From | Optional |
Payment Date To | Optional |
Report Layout
The layout of the report is listed below.
Data Field | Florida PALM RECORD.FIELD mapping |
|---|---|
Business Unit | PS_VOUCHER.BUSINESS_UNIT |
Voucher Origin | PS_VOUCHER.ORIGIN |
Voucher ID | PS_VOUCHER.VOUCHER_ID |
Voucher Style | PS_VOUCHER.VOUCHER_STYLE |
Invoice ID | PS_VOUCHER.INVOICE_ID |
Invoice Date | PS_VOUCHER.INVOICE_DT |
Accounting Date | PS_VOUCHER.ACCOUNTING_DT |
Voucher Line Number | PS_VOUCHER_LINE. VOUCHER_LINE_NUM |
Distribution Line Number | PS_DISTRIB_LINE.DISTRIB_LINE_NUM |
Voucher Line Amount | PS_VOUCHER_LINE. MERCHANDISE_AMT |
Budget Year | PS_VCHR_ACCTG_LINE.BUDGET_DT |
Account (Issued From) | PS_VCHR_ACCTG_LINE.ACCOUNT |
Fund (Issued From) | PS_VCHR_ACCTG_LINE.FUND_CODE |
Budget Entity (Issued From) | PS_VCHR_ACCTG_LINE.BUDGET_REF |
Category (Issued From) | PS_VCHR_ACCTG_LINE.PRODUCT |
Account (Returned To) | PS_VCHR_ACCTG_LINE.ACCOUNT |
Fund (Returned To) | PS_VCHR_ACCTG_LINE.FUND_CODE |
Budget Entity (Returned To) | PS_VCHR_ACCTG_LINE.BUDGET_REF |
Category (Returned To) | PS_VCHR_ACCTG_LINE.PRODUCT |
Payment Reference | PS_PAYMENT_TBL.PYMNT_ID_REF |
Remit Supplier ID | PS_PAYMENT_TBL.REMIT_VENDOR |
Remit Supplier Name | PS_PAYMENT_TBL.NAME1 |
Payment Method | PS_PAYMENT_TBL.PYMNT_METHOD |
Payment Status | PS_PAYMENT_TBL.PYMNT_STATUS |
Cancel Action | PS_PAYMENT_TBL.CANCEL_ACTION |
Cancel Reason | PS_PAYMENT_TBL.PYMNT_REASON_CD |
Cancel Date | PS_PAYMENT_TBL.CANCEL_DT |
Payment Date | PS_PAYMENT_TBL.PYMNT_DT |
Outstanding Days | PS_PAYMENT_TBL.CANCEL_DT - PS_PAYMENT_TBL.PYMNT_DT |
Payment Amount | PS_PAYMENT_TBL.PYMNT_AMT |
Request ID | PS_FLP_PYMNT_CAN.REQUEST_ID |
Requester | PS_FLP_PYMNT_CAN.SUBMIT_BY |
Request Approver | EOAW_STEP_VW.OPRID |
Total Payment Count | PS_PAYMENT_TBL.PYMNT_ID_REF |
Total Voucher Amount | PS_PAYMENT_TBL.PYMNT_AMT |
Grand Total Payment Count | Sum (Total Payment Count) |
Grand Total Voucher Amount | Sum (Total Voucher Amount) |
Version History
Date | Revision Description |
|---|---|
11/1/2023 | Original Version |
Was this article helpful?
