Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. 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

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

View products that this article applies to.

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.

↑ Back to the top

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.

↑ Back to the top

Keywords: kbnosurvey, kbtshoot, kbexpertisebeginner, kbexpertiseinter, kbprb, kbsurveynew, kbmbspartner, kbmbsmigrate, kb

↑ Back to the top

Article Info
Article ID : 856544
Revision : 1
Created on : 1/7/2017
Published on : 3/29/2016
Exists online : False
Views : 278