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:
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