How to create a Statement of Cash Flows in FRx

Article ID: 851059 - View products that this article applies to.
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.
Expand all | Collapse all

TechKnowledge Content

SUMMARY

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:



This article was TechKnowledge Document ID: 20347

Properties

Article ID: 851059 - Last Review: July 11, 2011 - Revision: 3.0
APPLIES TO
  • 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
  • Microsoft Small Business Financials 9.0
  • Microsoft Business Solutions Small Business Financials North America Edition 8.0
  • Microsoft Business Solutions Small Business Manager 7.5, when used with:
    • Microsoft Business Solutions for Analytics–FRx 6.7 Desktop
    • FRx Financial Reporter 6.5
  • FRx Financial Reporter 6.5
Keywords: 
kbnavisionfrx kbsolomonfrx kbsmallbusinessfinancialsfrx kbgreatplainsfrx kbaxaptafrx kbmbsmigrate KB851059

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com