AP ACH Returns and Reissued Warrants (APR102)
- 17 Jun 2024
- 1 Minute to read
-
Print
-
DarkLight
-
PDF
AP ACH Returns and Reissued Warrants (APR102)
- Updated on 17 Jun 2024
- 1 Minute to read
-
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:
- AP Reporter
Business Process Models
This report can be found in the following business processes:
- 30.5.2 Manage ACH/EFT Notifications
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 | |
Supplier Location | |
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 | |
Error Code | PS_PMT_ACK_ERR.ERROR_CODE |
Payment File ID | PS_PMT_DETAIL_TBL.PMT_FILE_ID |
Acknowledgment File ID | |
Bank Send Date | PS_PMT_ACK_HEADER.BANK_SEND_DTTM |
Version History
Date | Revision Description |
|---|---|
06/17/2024 | Original Version |
Was this article helpful?
