Wednesday, 2 March 2016

Reconciliation Of Many Bank Statement To One Transaction In Oracle Cash Management In Oracle Apps R12


Business Scenario 
 
Reconciliation Of Many Bank Statement To One Transaction In Oracle Cash Management R12
or
How to reconcile two bank statement lines of different dates (in two different Bank Statement) with one Payments or Receipt in Oracle Cash Management R12.

Solution:-

(1). At this time Cash Management (CE) does not support reconciling multiple statement lines to the
same transaction, but it is being considered, along with other enhancements, for future development.

(2). As a workaround: Here is what you can do to reconcile the payment or Receipt with the two statement lines: 

1) Make sure both statement lines are un-reconciled. If any of the statement line is reconciled, then un-reconciled it first. 

2) Make sure both statement lines have the same bank transaction number. 

3) One of the statement line must have statement line type of Misc Payment or Misc Receipt 

4) Using the Misc Payment or Misc Receipt statement line, go query the payment / Receipt transaction and other statement line. 
- On the Find Transaction window, check both the Payment / Receipt and Statement line check box. The Numbers field should also be populated with the bank transaction number. 
- Click on Find. 
- You should see both the statement lines and the payment or Receipt transaction. 
- Select the other statement line and the payment or Receipt transaction then click on the Reconcile button. 
5). It should help you to reconcile both lines with one payment.


For more reference you can review the docs 419653.1, 1963403.1

No comments:

Post a Comment