AP ACH Returns and Reissued Warrants (APR102)
-
Print
-
DarkLight
-
PDF
AP ACH Returns and Reissued Warrants (APR102)
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
The AP ACH Returns and Reissued Warrants Report is run on demand to extract the details of the ACH Payments originating in the Accounts Payable (AP) module that were not successfully processed and returned by the bank. The Report can be run for the selected Supplier SetID, Supplier Classification, Business Unit, and Bank Send Date range.
Report Navigation:
- Main Menu > Accounts Payable WorkCenter > Queries > Reports > AP ACH Returns and Reissued Warrants
- Main Menu > Reporting Tools > Query > Query Viewer
Query Name: TBD
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 |
|---|---|
Supplier SetID | Optional |
Supplier Classification | Optional |
Business Unit | Optional |
Bank Send Date From | Required |
Bank Send Date To | Required |
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 |
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 |
Supplier Location Status | PS_VENDOR_LOC.EFF_STATUS |
Supplier Classification | PS_VENDOR.VENDOR_CLASS |
Payment Reference ID | PS_PAYMENT_TBL.PYMNT_ID_REF |
Payment Amount | PS_PAYMENT_TBL.PYMNT_AMT |
Schedule Pay Date | PS_PYMNT_VCHR_XREF.SCHEDULED_PAY_DT |
Cancel Action | PS_PAYMENT_TBL.CANCEL_ACTION |
Confidential Indicator | PS_VOUCHER.CUSTOM_C1_A |
Error Message | PS_PMT_ACK_ERR.ERROR_MESSAGE |
Error Code | PS_PMT_ACK_ERR.ERROR_CODE |
Payment File ID | PS_PMT_DETAIL_TBL.PMT_FILE_ID |
Acknowledgment File ID | PS_PMT_ACK_ERR. PMT_ACK_FILE_ID |
Bank Send Date | PS_PMT_ACK_HEADER.BANK_SEND_DTTM |
Payment Handling Code | PS_PAYMENT_TBL.PYMNT_HANDLING_CD - PS_PYMNT_HNDL_TBL.DESCR |
Version History
Date | Revision Description |
|---|---|
06/17/2024 | Original Version |
| 08/23/2024 | Updated to reflect 08/19/2024 updates to design as per DDID #0765 to add Payment Handling Code with the Description in a new field. |
Was this article helpful?
