ECM: Bank Statement Status Is Not Updated Correctly When Using Semi-Manual Reconciliation And Multiple Statements Are Involved
(Doc ID 2827001.1)
Last updated on APRIL 04, 2025
Applies to:
PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
When a bank statement contains ACH payment and is reconciled, and then an ACH return is received, un-reconcile it using the semi-manual recon page and then when these bank statements are reconciled along with others, then the bank statement status is not updated correctly.
STEPS
---------
1. Create an ACH voucher (Accounts Payable - Vouchers - Add / Update - Regular Entry) to be processed through Financial Gateway
2. Pay the voucher (Accounts Payable - Payments - Pay Cycle Processing - Pay Cycle Manager)
3. Dispatch the payment (Financial Gateway - Process Payments - Payment Dispatch)
4. Create a bank statement (Banking - Bank Statements - Enter a Bank Statement)
5. Reconcile the bank statement with the voucher (Banking - Reconcile Statements - Process Bank Reconciliation)
6. Create a bank statement with ACH return (Banking - Bank Statements - Enter a Bank Statement)
7. Using semi-manual reconciliation, un-reconcile the voucher. (Banking - Reconcile Statements - Semi-Manual Reconciliation)
8. Verify the bank statement in step 4 to be ready status (Banking - Bank Statements - Enter a Bank Statement)
9. Create another ACH voucher (Accounts Payable - Vouchers - Add / Update - Regular Entry)
10. Pay the voucher in step 9 (Accounts Payable - Payments - Pay Cycle Processing - Pay Cycle Manager)
11. Dispatch the payment (Financial Gateway - Process Payments - Payment Dispatch)
12. Create a bank statement for voucher in step 9 (Banking - Bank Statements - Enter a Bank Statement)
13. Using semi-manual recon page, reconcile bank statement in step 4, 6, 12, and voucher in step 9 (Banking - Reconcile Statements - Semi-Manual Reconciliation)
14. Observe that the bank statements in step 4, 6 are not updated to complete (Banking - Bank Statements - Enter a Bank Statement)
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |