Page 1 of 1
Cash Flow in Oracle
Posted: Wed Jul 22, 2009 12:31 am
by rihan m
Dear Friends,
Is there a way to prepare cash flow statement in Oracle ???
We r in 11i and have CM installed
Regards,
Rihan
Posted: Wed Jul 22, 2009 5:30 am
by oteixeira
Hello.
You can achieve that by using the Cash Forecasting features (CE).
Octavio
Posted: Wed Jul 22, 2009 7:02 am
by Rizwan.Mumtaz
Hi Rihan
Yes we can perare Cash Flow Statement in Oracle in GL using FSG.
Tell me more about ur COA Structure.
Regards
Rizwan Mumtaz
Posted: Thu Jul 23, 2009 1:36 am
by rihan m
Hi Octavio/Rizwan Mumtaz,
I was actually thinking of doing it through Cash Management. Firstly how can we do it through Cash Forecasting.
Octavio : Do u have any guide ?
Well.., Rizwan ..,
Its a Multi Org Setup and have seven segments in the COA.
Regards,
Rihan
Posted: Thu Jul 23, 2009 1:40 am
by Rizwan.Mumtaz
HI Rihan
Ok wait for Otovio's Reply and;
tell me do you want to prepare consolidated CFS or for a single org.
Keep in touch.
Regards
Rizwan
Posted: Thu Jul 23, 2009 6:57 am
by oteixeira
Hello Rihan.
Please see Chapter 5 of the Oracle Cash Management User's Guide:
http://download.oracle.com/docs/cd/B255 ... 15ceug.zip
Octavio
Posted: Fri Jul 24, 2009 2:51 am
by rihan m
Hi Octavio,
Thanks and I think I can achieve my objective there. But the Oracle Guide is very complicated and not straight forward. Let me go through it anyway.
Rizwan : we are planning to do for a single OU & set of books but for multiple bank accounts.
Thanks
Rihan
Posted: Thu Jul 30, 2009 9:15 am
by Rizwan.Mumtaz
HI rehan
Please tell me Cash Flow Statement u prepared through Cash forecast from CM, are according to IAS-7 of International Accounting Standards.
Thanks
Posted: Fri Jul 31, 2009 12:38 am
by rihan m
Hi Rizwan,
I have not prepared a cash flow statement from CM or GL yet. In fact, I am running through the Oracle CM guide and would love to have a easy instruction or guide.
Thanks,
Rihan
Posted: Mon Aug 03, 2009 5:09 am
by Rizwan.Mumtaz
HI rehan
ok well, do tell me if u want to prepare Cash flow Statement form GL (FSG) and if u have any idea through CM then plz guide me.
Best Regards
Posted: Wed Sep 02, 2009 12:36 am
by rihan m
Hi Rizwan,
I couldn't find a way to do Cash Flows in CASH MGT. So, can u please guide me on the FSG (Cash Flow in GL)
Thanks,
Rihan
Posted: Wed Sep 02, 2009 12:54 am
by tgs100
With my limited experience, I could not fit the cash flow requirements of the clients into neither with CM reports nor with FSG reports.
The cash flow report was always customized, though conceptual inputs were taken from the standard reports.
In my opinion, cash forecasting in CM is far better compared to FSG in GL (for this report).
FSG basic concepts are same, for P&L or B/S or Cashflow. Once you learn the basics, you can do any type of FSG report. There are FSG whitepapers available in the metalink apart from a seperate chapter on FSG in GL user guide.
Cheers,
Saravanan TG
Posted: Fri Sep 11, 2009 5:17 am
by rihan m
Hi All,
I am in the process of developing a cash flow statement via FSG. However , I have come across many issues like getting the opening balance , changes in WIP etc.. If anyone of you all have developed a CFS using FSG (Indirect Method) kindly advice me and if possible send across a Screen Shot or Guide
Thanks,
Rihan