ERPstuff - Oracle EBS Community

We would like to go for automatic bank reconciliation .If any one having some details , please do share with me.

Regards


Vimal

Even we had a requirement like this and I have posted it in Oracle Forum and received reply from a person . I think he/she also member in this also. We are working on this. You need to customise your Journal form using triggers. I can share you the info. once we are through with this customization.

Rajiv

Book your invoice in Foreign Curr. but give the exchange rate. When you pay book as Debit Memo and pay in Func. Curr. But this will have few shortcomings.
1.You can't clear the line item.
2. You can't run payment batch

Vimal

My earlier reply, I am sorry , I didn't understand properly.

Alternative payee is not at possible in Oracle. SAP is having very robust method for 'Alternative Payee'. Oracle is having a functionality called"Factoring". You need to go for customization only.

Select the category as "reverse' Once you select the category (enter Journal window)under 'reverse' column next month with get populated.(this depends as per setup done at Auto reverse menu) Once entries over, run Program Automatic reversal .

Yes . It is possible. But you need to convert your currency and book. System will create exchange variation also. But clearing will be a problem. You can clear by create a dummy bank and clear. At the time of clearing system will pass exchange variation a/c.