Outstanding Vouchers Report (APR003)
- 29 May 2024
- 1 Minute to read
-
Print
-
DarkLight
-
PDF
Outstanding Vouchers Report (APR003)
- 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 Outstanding Vouchers Report will provide an aging schedule of Vouchers that have not been approved or paid. This report includes vouchers with an incomplete life cycle (e.g. not approved, not unposted, not paid, and not closed) in Florida PALM. This is a PS Query that generates the report in an Excel format.
Report Navigation:
- Main Menu > Reporting Tools> Query > Query Viewer
- Main Menu > Reporting Tools> Query > Query Manager
Query Name: FLP_APR003_Oustanding_VouchersReport
See sample report layout below.
Business Roles
The following business roles have access to this report:
- Agency AP Processor
- Agency AP Approver
- DFS AP Approver
- Agency AP Finance & Accounting (FA) Approver
- AP Reporter
Business Process Models
This report can be found in the following business processes:
- 30.3.1 Process Vouchers
- 30.3.2 Voucher Matching
- 30.3.3 Review and Approve Vouchers
- 30.3.5 Enterprise Process Vouchers
- 30.3.6 Run Prompt Payment Interest Calculation
Selection Criteria
The report data can be filtered by the following selection criteria:
Data Field | Data Field Details |
Business Unit | Optional |
Voucher Origin | Optional |
Accounting Date From | Optional |
Accounting Date To | Optional |
Aging Bucket | Optional |
Voucher Gross Amount From | Optional |
Voucher Gross Amount To | Optional |
Report Layout
The layout of the report is listed below.
Data Field | Florida PALM RECORD.FIELD mapping |
Aging Days | PS_VOUCHER.ENTERED_DT should be used for comparison. |
Aging Buckets (Days) | Example: If Aging Days = 10 then Aging Buckets should be 0-30 Days. |
Business Unit | PS_VOUCHER.BUSINESS_UNIT |
Voucher Origin | PS_VOUCHER.ORIGIN |
Voucher ID | PS_VOUCHER.VOUCHER_ID |
Voucher Style | PS_VOUCHER.VOUCHER_STYLE |
Related Voucher ID | VOUCHER.VOUCHER_ID_RELATED |
Invoice ID | PS_VOUCHER.INVOICE_ID |
Invoice Date | PS_VOUCHER.INVOICE_DT |
Accounting Date | PS_VOUCHER.ACCOUNTING_DT |
Supplier SetID | PS_VOUCHER.VENDOR_SETID |
Supplier ID | PS_VOUCHER.VENDOR_ID |
Supplier Name | PS_VENDOR.NAME1 |
Additional Supplier Name | PS_VENDOR.NAME2 |
Gross Amount | PS_VOUCHER.GROSS_AMT |
Fund | VCHR_ACCTG_LINE.FUND_CODE |
Budget Entity | VCHR_ACCTG_LINE.BUDGET_REF |
Category | VCHR_ACCTG_LINE.PRODUCT |
Voucher Entry Status | PS_VOUCHER.ENTRY_STATUS |
Voucher Post Status | PS_VOUCHER.POST_STATUS |
Budget Checking Status | PS_VOUCHER.BUDGET_HDR_STATUS |
Approval Status | PS_VOUCHER.APPR_STATUS |
Scheduled Due Date | PS_PYMNT_VCHR_XREF.SCHEDULED_PAY_DT |
Payment Selection Status | PS_PYMNT_VCHR_XREF.PYMNT_SELCT_STATUS |
Hold Payment | PS_PYMNT_VCHR_XREF.PYMNT_HOLD |
Payment Method | PS_PYMNT_VCHR_XREF.PYMNT_METHOD |
Voucher Entered Date | PS_VOUCHER.ENTERED_DT |
Last Updated On | PS_VOUCHER.LAST_UPDATE_DT |
Last Updated By | PS_VOUCHER.OPRID_LAST_UPDT |
Version History
Date | Revision Description |
12/01/2023 | Original Version |
Was this article helpful?
