R11: CE: Enhancement Request - Allow the AutoReconcile Functionality to Search and Match on Batch Names (Doc ID 329854.1)

Last updated on JULY 27, 2017

Applies to:

Oracle Receivables - Version 11.5.8 to 11.5.10.2 [Release 11.5.8 to 11.5.10]
Oracle Cash Management - Version 11.5.8 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
Information in this document applies to any platform.

Goal

Cheques received on a daily basis are recorded on a Bank Giro Credit (BGC/Paying in Book).
 
On average around 17 slips per day. (85 per week, 4400 per year). Each slip in the BGC has a unique 6 digit number. This unique number is entered into the field 'Batch Number' on the form ARXRWMAI. (Navigation in AR - Receipts > Batches)

The bank Statements we receive from our bank reference the BGC number. These statements are loaded via sql Loader into CE. The BGC Number populates the field 'Number' on the form CEXCABMR with the Type 'Receipt'.
(Navigation in CE - Bank Reconciliation > Bank Statements > Bank Statement Lines)

Auto reconciliation is run but does not match on Batch Numbers. The current workaround is to manually reconcile the receipt by changing the search on the field Numbers to Batch Names on the form 'Find Transactions'. The required enhancement is to allow the AutoReconcile functionality to search and match on Batch Names.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms