Dynamics Community Forum Thread Details

Statement of Cash Flow in FRX

Operation Activity Section: What range i have to give in order to calculate & identify Increase/Decrease in A/R, A/P, Inventory. Does it require any special masking or just account range, lets say 001-00-00-00 to 001-01-??-??

what is the most suitable & correct way?

Junaid,

To get a feel for the options you have for CF statements in FRx, take a look at the demo reports. There are two examples of CF statements. One that is FASB compliant (somewhat) and one that is not.

In general you are looking for the net increase/decrease in a given set of accounts, and the opposit of that net change is it's affect on Cash. In most cases, you will just use the normal account masks with a C on that row to reverse the sign on the Net Change amount.

Another observation, it looks like you are using full accounts in your row format (all segments). In most cases it is much better to use only the Natural or Main segment in the Row format. That will give you much more flexibility and functionality from FRx.

If you have any questions or would like any assistance please feel free to contact me directly at Rob.Iversen@MSXGroup.com. Also you can visit our website http://MSXGroup.com for information about our services, support options, training classes and FREE webinars on FRx, Forecaster, Management Reporter and PerformancePoint Server.

Thanks

Rob

Quick Links

Leaderboard