Using FRx to create a Cash Flow Statement

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.

MORE INFORMATION

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.

Catalog:

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.

REFERENCES

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

https://mbs.microsoft.com/downloads/customer/TK20347_cash_flow.zip