How to Write a Cash Flow Statement in FRx

ERP CRM Software Blog

Like ( 0 )

Report

FRx Reporter is the go-to Financial Statement report writing tool for Microsoft Dynamics GP, AX and SL. FRx is supported for customers that are currently on Dynamics GP 10.0, and they can stay on FRx when they upgrade to Dynamics GP 2010. All customers and anyone who purchase Dynamics GP 2010 will receive licenses for Management Reporter when they upgrade to Dynamics GP 2010. The features I describe here are relevant for both FRx and Management Reporter (MR).

When clients ask me how to write a cash flow statement or tell me it can’t be done with FRx or MR, I just smile. There are three samples of FRx Cash flow statements in the Filmworks sample company that comes with FRx. All you have to do is export from the Filmworks sample reports and import into the live company reports. You do have to change the mapping to your accounts in the row format, but that is easily done. The tricky part is getting the beginning of month or year cash balance into FRx. There is a trick in the row format that allows you to pull in the beginning balance or year-to-date balances to make sure your cash ties out to the balance sheet. These are called account modifiers under the row modifiers option.

Sometimes you need to bring in other cash flow sources or uses that are not easily pulled from the general ledger. If you have MR, let me know and I can copy and paste the row format for you and send to you. You can use a feature called linking to Excel worksheets that will pull in data such as common stock issues, fixed assets purchases or retirements, etc.

We just covered these exact topics in my FRx Advanced Training class this week. Crestwood also offers FRx Basics classes at the Microsoft Office in Downers Grove, IL on September 9 and October 13. Let us know if you would like to attend e-mail dmagera@crestwood.com.

By Mary Lenehan, Client Education Manager, at your Chicago IL Area Gold Certified Partner, Crestwood Associates.