Cash Flow in Oracle

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
rihan m
Posts: 24
Joined: Thu Nov 06, 2008 4:04 am
Location: Sri Lanka

Cash Flow in Oracle

Post 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
oteixeira
Posts: 451
Joined: Wed Aug 27, 2008 12:34 pm
Location: Portugal

Post by oteixeira »

Hello.

You can achieve that by using the Cash Forecasting features (CE).

Octavio
Rizwan.Mumtaz
Posts: 80
Joined: Sat Feb 21, 2009 11:40 am
Location: Pakistan

Post 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
rihan m
Posts: 24
Joined: Thu Nov 06, 2008 4:04 am
Location: Sri Lanka

Post 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
Rizwan.Mumtaz
Posts: 80
Joined: Sat Feb 21, 2009 11:40 am
Location: Pakistan

Post 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
oteixeira
Posts: 451
Joined: Wed Aug 27, 2008 12:34 pm
Location: Portugal

Post 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
rihan m
Posts: 24
Joined: Thu Nov 06, 2008 4:04 am
Location: Sri Lanka

Post 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
Rizwan.Mumtaz
Posts: 80
Joined: Sat Feb 21, 2009 11:40 am
Location: Pakistan

Post 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
rihan m
Posts: 24
Joined: Thu Nov 06, 2008 4:04 am
Location: Sri Lanka

Post 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
Rizwan.Mumtaz
Posts: 80
Joined: Sat Feb 21, 2009 11:40 am
Location: Pakistan

Post 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
rihan m
Posts: 24
Joined: Thu Nov 06, 2008 4:04 am
Location: Sri Lanka

Post 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
tgs100
Posts: 624
Joined: Tue Jun 13, 2006 3:42 am
Location: USA
Contact:

Post 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
rihan m
Posts: 24
Joined: Thu Nov 06, 2008 4:04 am
Location: Sri Lanka

Post 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
Post Reply

Who is online

Users browsing this forum: No registered users and 19 guests