Page 1 of 1
cash and bank position
Posted: Tue Jul 08, 2008 10:11 am
by keke
Hi All,
Kindly give me details of how to obtain cash and bank position report from oracle cash management. I want details of how to get report that will give me daily bank and cash position in oracle cash management.
thanks
Posted: Wed Jul 09, 2008 4:12 am
by hiszaki
Hi keke
I think you will need a customize report to get your data according to your needs. So try to develop the report by using oracle development tools (report builder) then put this report as a customized report in oracle application.
Thanks
Hisham
Posted: Thu Jul 10, 2008 6:08 am
by wenjie
yes, get the data from oracle payable and oracle receivable, use UNION to join them
Posted: Thu Jul 10, 2008 6:37 am
by hiszaki
Hi wenjie
You can also get the data from cash management tables which contains all data reconciled from AR and AP. in case using bank statement.
Thanks
Hisham
Posted: Thu Jul 17, 2008 6:13 am
by keke
Thanks all for the reply. Mr. wenjie, talked about UNION, pls where in cash management will I do the UNION and what are the setup steps.
Thanks
kehinde
Posted: Thu Jul 17, 2008 3:52 pm
by muzaffarnaim
Keke
For that you have Cash Positioning feature available in CM module in which you can develop worksheet on the basis of your requirement and then run on daily basis. You can generate daily cash position for any currency and bank account.
Muzaffar Naim
Oracle Consultant