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
Hi John,
ReplyDeleteMind uploading the cash flow example file somewhere else? I can't get into Microsoft Dynamics and would love to get my hands on the FW example as my FRx software did not come with it.
Thanks,
Max
Max,
ReplyDeleteCan you send me a way to contact you directly? I will not publish your reply, but I do not have the capacity here to publish a link to the sample.
Thanks, John
John,
ReplyDeleteThank you so much for your instructions. I surely would not have been able to pick this up as fast were it not for your assistance. The instructions were right on. My report came out correctly the first time. Thank you!
Antonio
Hi John,
ReplyDeleteI was able to download the zip file you have above but inside was a .tdb file. What is a .tdb file. My system did not recognize it.
Lloyd
John,
ReplyDeleteI consolidate several companies (one of which is a foreign entity) in Great Plains. I need to build a cash flow statement that can translate the local currencies into the functional/reporting currency. Is there a site that you can suggest or a method to producing this type of report?
John