Article ID: 851059 - View products that this article applies to.
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.
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.
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.
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: January 10, 2015 - Revision: 4.0