This article has been archived. It is offered "as is" and will no longer be updated.
This article describes how to modify a Microsoft FRx report for a Microsoft Dynamics GP company if the following conditions are true:
The Microsoft Dynamics GP company is set up to use the calendar year.
You have to run a report for a fiscal year.
When you modify the Microsoft FRx report, you have to change the Fiscal Year value and the Period Code value in the GL columns in the column layout. The changes must reflect the calendar year that is set up in Microsoft Dynamics GP. To modify the report, follow these steps:
Click Start, point to All Programs, point to FRx 6.7, and then click Report Designer.
Click Company, click Select Default, select the Microsoft Dynamics GP company, and then click OK. Type your user name and password, and then click OK.
Click File, point to Open, click Column, and then select the column layout for the report that you want to modify. Click OK.
In the GL column, type the year for which you want to run the report in the Fiscal Year box.
In the same GL column, type the period for which you want to run the report in the Period Code box.
Follow steps 4 and 5 for the rest of the GL columns. Then, save the column layout.
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, FRx Financial Reporter 6.5