How to modify a Microsoft FRx report if a Microsoft Dynamics GP company is set up to use the calendar year, but you have to run a report for a fiscal year

Article ID: 926637 - View products that this article applies to.
Expand all | Collapse all

INTRODUCTION

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.

MORE INFORMATION

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:
  1. Click Start, point to All Programs, point to FRx 6.7, and then click Report Designer.
  2. 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.
  3. Click File, point to Open, click Column, and then select the column layout for the report that you want to modify. Click OK.
  4. In the GL column, type the year for which you want to run the report in the Fiscal Year box.
  5. In the same GL column, type the period for which you want to run the report in the Period Code box.
  6. Follow steps 4 and 5 for the rest of the GL columns. Then, save the column layout.

Properties

Article ID: 926637 - Last Review: July 29, 2011 - Revision: 2.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, when used with:
    • Microsoft Business Solutions for Analytics–FRx 6.7 Desktop
    • FRx Financial Reporter 6.5
  • FRx Financial Reporter 6.5
Keywords: 
kbexpertiseinter kbexpertisebeginner kbgreatplainsfrx kbmbsmigrate kbhowto KB926637

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