My Oracle Support Banner

ECM: AR Payment Missing From Book to Bank Reconciliation > Unbooked Payments Page (Doc ID 2886052.1)

Last updated on MARCH 26, 2024

Applies to:

PeopleSoft Enterprise FIN Cash Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

AR Deposit, which consisted of two Payments, was reconciled to a Bank Transaction. If one of the AR Payments is un-posted and re-posted, the AR Payment is missing from the Book to Bank Reconciliation Details > Unbooked Payments page. This is resulting in a Book to Bank Difference for the amount of the AR Payment that is missing from the Unbooked Payments page.

STEPS
1. Create a new Pending Item Group under BU xxxxx with 2 Items (700 USD and 300 USD), each linked to different customers (Customer ID yyyy & zzzz) and place the Post Action as Batch Standard (Accounts Receivable > Pending Items > Online Items > Online Item Group Entry)
2. Run AR Update process for Business Unit US001 and option of 'Pending Items' selected (Accounts Receivable > Receivables Update > Request Receivables Update)
3. Create a new Regular Deposit under Deposit BU xxxxx, Bank Code/Account xyxyx / yzyz with 2 Payment transactions (700 USD and 300 USD each) and define the Customer ID and Item ID values from Step 1 (Accounts Receivable > Payments > Online Payments > Regular Deposit)
4. Build a Payment Worksheet for the Regular Deposit created, and it's 1st Payment transaction. Ensure that the new Payment Group is balanced and set the Post Action to Batch Standard. (Accounts Receivable > Payments > Apply Payments > Apply Payments Worksheet)
5. Build a Payment Worksheet for the Regular Deposit created, and it's 2nd Payment transaction. Ensure that the new Payment Group is balanced and set the Post Action to Batch Standard.
6. Run AR Update process for Business Unit xxxxx and option of 'Payments' selected
7. Run Journal Generator to pick up the Accounting Entries in Receivables with the Edit and Post boxes checked and generate the GL Journals (Use Business Unit xxxxx and Accounting Entry Definition ARDEFN) (General Ledger > Journals > Subsystem Journals > Generate Jrnl from Subsystem)
8. Add a Bank Statement with all the Dates set to the month prior to the month of the Deposit, Transaction Amount = 1,000 and Trans Code = Automated Clearing House (Banking > Bank Statements > Enter Bank Statements)
9. Reconcile the Bank Transaction to the Deposit which contains both AR Payments on the Semi-Manual Reconciliation page (Banking > Reconcile Statements > Semi-Manual Reconciliation)
10. On the Select Book to Bank Statements page, enter the Bank details and the Dates for the month of the Bank Statement, and Select and Calculate the Bank Statement (Banking > Reconcile Statements > Select Book To Bank Statements)
11. On the Book to Bank Reconciliation page, enter the Bank details and click the Details icon for the Bank statement (Banking > Reconcile Statements > Book To Bank Reconciliation)
12. On the Book to Bank Reconciliation Details page, click the Unbooked Payments icon
13. Both the AR Payments from the Deposit display on the Unbooked Payments page
14. Now, mark one of the Payment Groups for unpost, stating a reason, changing the Accounting Date to a later date, and set the new Unpost Group to a Post Action of Batch Standard (Accounts Receivable > Receivable Update > Unpost Groups > Payment Group)
15. Run AR Update process for Business Unit xxxxx and option of 'Unpost Transactions' selected
16. Build a new Payment Worksheet for the recently unposted Deposit/Payment combination, using the same amount against the Item/Customer combination, and place its Post Action to Batch Standard
17. Run AR Update process for Business Unit xxxxx and option of 'Payments' selected
18. Run Journal Generator to pick up the Accounting Entries in Receivables with the Edit and Post boxes checked and generate the GL Journals (Use Business Unit xxxxx, and Accounting Entry Definition ARDEFN)
19. Recalculate the Bank Statement on the Book to Bank Reconciliation page
20. Click the Details icon for the Bank Statement
21. On the Book to Bank Reconciliation Details page, click the Unbooked Payments icon
22. Notice that only the AR Payment from the Deposit which was not un-posted only displays on the Unbooked Payments page -- AR Payment that was originally posted, un-posted, and re-posted does not display
23. As a result, on the Book to Bank Reconciliation Details page, the Book to Bank Difference field is populated with the amount of the AR Payment that is not being displayed on the Unbooked Payments page

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
Cause
Solution
References


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