-
Print
-
DarkLight
-
PDF
Voucher Workflow Status Report (APR014)
-
Print
-
DarkLight
-
PDF
Report Description
The Voucher Workflow Status Report can be used to identify Vouchers in the workflow requiring action and managing workflow backlogs.
The Voucher Workflow Status Report will extract the status and workflow details of all the vouchers that are routed through the voucher approval workflow. Voucher workflow details for any selected Business Unit, Voucher Origin, Supplier ID, Voucher ID Range, Accounting Date Range, and Voucher Approval status.
Report Navigation:
1. Main Menu > Reporting Tools > Query > Query Viewer
2. Main Menu > Payables WorkCenter > Reports/Processes > Reports
Query Name: FLP_APR014_VCHR_WRKFLW_STATUS
See the sample layout report 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 | Required |
Voucher Origin | Optional |
Supplier ID | Optional |
Voucher ID From | Optional |
Voucher ID To | Optional |
Accounting Date From | Required |
Accounting Date To | Required |
Voucher Approval Status | 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 |
Supplier ID | PS_VOUCHER.VENDOR_ID |
Supplier Name | PS_ VENDOR.NAME1 |
Accounting Date | PS_VOUCHER.ACCOUNTING_DT |
Gross Amount | PS_VOUCHER.GROSS_AMT |
Schedule Pay Date | PYMNT_VCHR_XREF.SCHEDULED_PAY_DT |
Entry Status | PS_VOUCHER.ENTRY_STATUS |
Voucher Approval Status | PS_VOUCHER.APPR_STATUS |
Audit Denial Reason Code | PS_FLP_VCHR_RSNCD.REASON_CD-REASON_CODE.DESCR |
Current Approval Level | PS_EOAW_STEP.DESCR |
Hold Status | If PS_EOAW_STEPINST.EOAWSTEP_STATUS = ‘H’ then display ‘Y’ else ‘N’ |
Approver Comments | PS_EOAW_COMMENTS.COMMENTS |
Entered Date | PS_VOUCHER.ENTERED_DT |
Entered By | PS_VOUCHER.OPRID |
Last Modified Date | PS_VOUCHER.LAST_UPDATE_DT |
Modified By | PS_VOUCHER.OPRID |
Last Approval Action Date | max (PS_VCHR_AF_XREF.EOAWDTTM_MODIFIED) |
Confidential Indicator | PS_VOUCHER.CUSTOM_C1_A |
Version History
Date | Revision Description |
---|---|
10/26/2023 | Original Version |
11/13/2024 | Updated Sample Report Layout |