ERPstuff - Oracle EBS Community

After Defining the bank And A/cs My client want to see the Opening Balance of As of date .

How can we Update the opening balance on Newly created Bank



Regards

Hi tirumal

Try to use the Cash management & define a bank statement for this bank as a opening balance then upload the last statement for this bank.

Thanks

For the new bank accounts, from where the money came from? Either you should have deposited the cheque/cash or transfered from another bank account. Accordingly you should create the transactions (Bank Account Transfer/Misc Receipt/Manual GL JV)

Cheers,
Saravanan TG

Hi Saravanan

Shall I upload all check trough AR & AP as a opening balance then make the reconciliation process or can I upload the opening balance in the cash statement only?

Thanks
Hisham

<b>can I upload the opening balance in the cash statement only</b>

Hisham: I really do not understand this method. Can you pls explain bit detail.

I have so far used bank account transfer/AR Receipt/Manual JV in GL to create the bank account balance.

Cheers,
Saravanan

Hi Saravanan

what I ask for that If I made a new bank statement can I upload the opening balance in the statement only using data loader without link these lines with AR or AP ?

Thanks
Hisham

I don't think so.

You should link the statement with AP/AR or Cash Flow (Bank Account Transfer) or with GL JV.

Cheers,
Saravanan TG