AP Holds by Hold Type Report (APR091)
- 10 Jun 2024
- 1 Minute to read
-
Print
-
DarkLight
-
PDF
AP Holds by Hold Type Report (APR091)
- Updated on 10 Jun 2024
- 1 Minute to read
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
This query lists vouchers and payments marked for payment hold including the hold reason. All vouchers that are created may be kept on HOLD if the decision has been made to hold the payment temporarily. To hold the Payment on the voucher the “Hold Payment” checkbox on the voucher can be checked. Once the “Hold Payment” checkbox is checked, the Hold Reason is required to be selected.
Report Navigation: Main Menu > Payables WorkCenter > Reports/Processes > Reports will update from report catalog once information is available
Query Name: Main Menu> Reporting Tool > Query > Query Viewer will update from report catalog once information is available
Click below to view the sample report layout.
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 |
Entered Date From | Optional |
Entered 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 |
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_ PYMNT_VCHR_XREF.REMIT_SETID |
Supplier ID | PS_ PYMNT_VCHR_XREF.REMIT_VENDOR |
Supplier Name | PS_ VENDOR.NAME1 |
Supplier Location | PS_ PYMNT_VCHR_XREF. VNDR_LOC |
| Single Payment Supplier Name | PS_VCHR_VNDR_INFO.NAME1 |
| Line Number | PS_DISTRIB. VOUCHER_LINE_NUM |
| Distribution Line Number | PS_DISTRIB. DISTRIB_LINE_NUM |
| Organization | PS_DISTRIB.DEPTID |
| Distribution Amount | PS_DISTRIB. MERCHANDISE_AMT |
Gross Amount | PS_VOUCHER.GROSS_AMT |
Schedule Due Date | PS_PYMNT_VCHR_XREF.SCHEDULED_PAY_DT |
Payment Method | PS_PYMNT_VCHR_XREF.PYMNT_METHOD |
Payment Hold Reason | PS_PYMNT_VCHR_XREF.PYMNT_HOLD_REASON |
Supplier Payment Hold Status | PS_VENDOR_PAY.VNDR_PYMNT_HLD_FLG |
Confidential Indicator | PS_VOUCHER.CUSTOM_C1_A |
Entered Date | PS_VOUCHER.ENTERED_DT |
Entered By | PS_VOUCHER.OPRID |
Last Modified Date | PS_VOUCHER.LAST_UPDATE_DT |
Modified By | PS_VOUCHER.OPRID |
Version History
Date | Revision Description | |||||
|---|---|---|---|---|---|---|
02/01/2024 | Original Version | |||||
| 06/10/2024 | Data Fields added to Report Layout:
|
Was this article helpful?
