How to enable the Projection button in the Depreciation Projection window for Fixed Assets in Microsoft Dynamics GP and in Microsoft Business Solutions – Great Plains

INTRODUCTION
This article describes how to enable the Projection button in the Depreciation Projection window for Fixed Assets in Microsoft Dynamics GP and in Microsoft Business Solutions – Great Plains.
More information
To make the Projection button available in the Depreciation Projection window for Fixed Assets, follow these step.

Note The following steps require you to run delete scripts by using the Microsoft SQL Query Analyzer tool. We recommend that you create a backup of your data before you follow these steps.
  1. Make sure that all users exit Microsoft Dynamics GP.
  2. Use one of the following methods to start the Support Administrator Console, Microsoft SQL Query Analyzer, or SQL Server Management Studio depending on the program that you use:
    • Method 1: SQL Server Desktop Engine (MSDE2000)

      Click Start, point to All Programs, point to Microsoft Administrator Console, and then click Support Administrator Console.
    • Method 2: SQL Server 2000

      Click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.
    • Method 3: SQL Server 2005

      Click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.
    • Method 4: SQL Server 2008
      Click Start, point to All Programs, point to Microsoft SQL Server 2008, and then click SQL Server Management Studio.
    • Method 5: SQL Server 2008 R2

      Click Start, point to All Programs, point to Microsoft SQL Server 2008 R2, and then click SQL Server Management Studio.
    • Method 6: SQL Server 2012

      Click Start, point to All Programs, point to Microsoft SQL Server 2012, and then click SQL Server Management Studio.
  3. Run the following commands against the Company database:

    DELETE FA40203
    DELETE FA41900

    Notes
    • FA40203 is the Fixed Assets Depreciation Book Setup table (used for tracking projections and depreciation).
    • FA41900 is the Projection Report Master table.
  4. Start Microsoft Dynamics GP.
  5. Verify that the Projection button is available. To do this, follow one of these steps, depending on the program that you are running:
    • For Microsoft Dynamics GP 10.0 and later versions:

      On the Microsoft Dynamics GP menu, point to Tools, point to Routines, point to Fixed Assets, click Projection, and then verify that the Projection button is available.
    • For Microsoft Dynamics GP 9.0 and Microsoft Business Solutions – Great Plains 8.0:

      On the Tools menu, point to Routines, point to Fixed Assets, click Projection, and then verify that the Projection button is available.
Properties

Article ID: 856544 - Last Review: 03/29/2016 16:52:00 - Revision: 7.0

Microsoft Dynamics GP 2015, Microsoft Dynamics GP 2013, Microsoft Dynamics GP 2010, Microsoft Dynamics GP 10.0, Microsoft Dynamics GP 9.0, Microsoft Business Solutions–Great Plains 8.0

  • kbnosurvey kbtshoot kbexpertisebeginner kbexpertiseinter kbprb kbsurveynew kbmbsmigrate KB856544
Feedback