ERPstuff - Oracle EBS Community

Hi,

Long back AP, AR and GL are implimented (11.5.10.2), now client wants Cash Mgt.

In receipts cheque number is given in DFF and receipt number is their identification naming convention. Remittances are not there .

Some security deposits to suppliers are entered as prepayments , paid and the refund of the same is booked as invoice with bank account in invoice distribution. And invoice is applied to prepayment.


How to reconcile in this case through automatic reconciliation? Is there any work around?


Thanks in advance.

I believe that the process should be changed.

1. You should capture the cheque number in receipt number field and identification naming convention in the DFF (You should also analyze the implications of this change).

2. In the case of prepayment, the invoice should be created debiting "AP-AR-Cleaing Account" and then create a misc receipt in AR (crediting "AP-AR-Clearing Account" using adjustment activity).

Cheers,
Saravanan TG

Thanks for reply,
The naming convention can not be changed. How to reco with GL?
What is the purpose of

Bank Statement Mapping

Bank Trx Codes

Do they help in any way?


Regards

Bank statement mapping - Used for uploading of bank statement.
Transaction codes - To identify whether it is a debit or credit (Payment or Receipt)

In your case,
1. The prepayment refund transaction will not appear for the reconciliation in CM.
2. The receipt transaction check number and the bank statement check number will not match. Your receipt transaction will show "identification naming convention" as check number.

You may try the following.

After uploading the bank statement in CM, you should change the check number with the corresponding "identification naming convention" programatically and then auto reconcile the receipts (Not an ideal solution-a similar customization was done in one of my implementation)

Cheers,
Saravanan TG