EAP: Cash Clearing (AP_APCSHCLR) Does Not Create Entries for Reconciled Check (Payment Method = CHK) (Doc ID 2860563.1)

Last updated on SEPTEMBER 05, 2023

Applies to:

Symptoms

Cash Cashing (AP_APCSHCLR) is not creating accounting entries for a Reconciled Check when the following scenario occurs:

1. Two different Vouchers created with two different Payments Methods -- CHK (Check) and ACH, respectively
2. Both the Check and ACH were paid with the same Reference Number
3. Check was reconciled before the ACH

STEPS
1. External Accounts > External Accounts page setup  (Banking > Bank Accounts > External Accounts)
    a. Cash Clearing box is checked
    b. Account chartfields are populated for “Cash – AP” and Cash Clearing “Cntrl – AP”
2. External Accounts > Payment Methods page setup
    a. Payment Method = Automated Clearing House
    b. Last Ref Number = 0000009098
    c. Payment Method = System Check
    d. Last Ref Number = 0000009098, which matches the Last Ref Number in step 2b.
3. Create 1st Voucher with Payment Method = ACH  (Accounts Payable > Vouchers > Add/Update > Regular Entry)
4. Create 2nd Voucher with Payment Method = CHK
5. Create a new Pay Cycle to pay Payment Method Automated Clearing House and System Check  (Accounts Payable > Payments > Pay Cycle Processing > Payment Selection Criteria)
    a. Run Payment Selection & Creation
    b. Run Electronic Payment
    c. Print Checks
6. Payment Inquiry page shows that both Vouchers have been paid with the same Payment Reference ID  (Accounts Payable > Review Accounts Payable Info > Payments > Payment)
7. Run Payment Posting  (Accounts Payable > Batch Processes > Payment > Payment Posting)
8. Accounting Entries page shows Payment entries created for both Vouchers  (Accounts Payable > Review Accounts Payable Info > Vouchers > AP Accounting Entries)
     a. For the Voucher paid by Check, Cash Distribution Clearing entry is created
9. Create a Bank Statement for the same amount and Reference of the Voucher paid by Check  (Banking > Bank Statements > Enter Bank Statements)
10. Run Bank Reconciliation for the Bank Statement from Step 10  (Banking > Reconcile Statements > Process Bank Reconciliation)
11. Semi Manual Reconciliation page shows that the Bank Transaction was reconciled to the Voucher paid by Check  (Banking > Reconcile Statements > Semi-Manual Reconciliation)
12. Create a Bank Statement for the same amount and Reference of the Voucher paid by ACH
13. Run Bank Reconciliation for the Bank Statement from Step 12
14. Semi Manual Reconciliation page shows that the Bank Transaction was reconciled to the Voucher paid by ACH
15. Run Cash Clearing with Pay Date Option = All Reconciled Payments for the Bank Code and Bank Account that paid the above Vouchers  (Accounts Payable > Batch Processes > Payment > Cash Clearing)
16. Accounting Entries page for the Voucher paid by Check only has Payment entries. No Cash Clearing entries were created.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.