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: