How to create a Statement of Cash Flows in FRx

This article has been archived. It is offered "as is" and will no longer be updated.
Microsoft Business Solutions-Axapta 3.0 is now part of Microsoft Dynamics AX 3.0. All references to Microsoft Business Solutions-Axapta and Microsoft Axapta pertain to Microsoft Dynamics AX.
TechKnowledge Content

This article describes how to create a Statement of Cash Flows in FRx so the beginning period and end of period cash amount calculates correctly.


Column layout:

1. Create Column A as the description column.
2. Column B is the GL CUR column.
3. Column C is a GL YTD/BB column.
4. Column D is a GL YTD column.
5. Column E is a CALC column. The formula for the CALC column should be D-C.
6. Make columns C and D non printing.

Row format:

1. Cash at Beginning of period is in row 1300. Make it a non printing row.
2. Pull in the cash accounts (1100 to 1110),/BB.
3. In row 1330, create a CAL row, B=@1300, C=0, D=@1300.
4. Either column C or Column D must equal zero or nothing will print in the CALC Column E.
5. Cash at End of period is in Row 1510. Make it non-printing.
6. Pull in the cash accounts (1100 to 1110),/Y.
7. In row 1540, create a CAL row, B=@1510, C=0, D=@1510.


1. In the Catalog of Reports, under Report Options | Advanced tab, make sure that the option to Calculate Rows first under Calculation Priority is marked.


For a sample report, download and unzip the correct Cash Flow statement for the FW company at the following link:

This article was TechKnowledge Document ID: 20347

Article ID: 851059 - Last Review: 01/10/2015 15:53:59 - Revision: 4.0

  • Microsoft Business Solutions for Analytics–FRx 6.7 Desktop
  • Microsoft Dynamics GP 9.0
  • Microsoft Business Solutions–Great Plains 8.0
  • Microsoft Business Solutions–Great Plains 7.5
  • Microsoft Dynamics SL 6.5
  • Microsoft Business Solutions–Solomon 6.0
  • Microsoft Dynamics AX 4.0
  • Microsoft Dynamics AX 3.0
  • Microsoft Dynamics NAV 4.0
  • Microsoft Business Solutions–Navision 3.70
  • FRx Financial Reporter 6.5
  • kbnosurvey kbarchive kbnavisionfrx kbsolomonfrx kbsmallbusinessfinancialsfrx kbgreatplainsfrx kbaxaptafrx kbmbsmigrate KB851059