The Depreciate button is not available in the Depreciate Assets window when you try to depreciate assets in Microsoft Dynamics GP

Applies to: Dynamics GP 2010Fixed Assets

SYMPTOMS


In Microsoft Dynamics GP or in Microsoft Business Solutions – Great Plains, when you try to depreciate one or more assets, you may experience the following symptoms:

• In the Depreciation Process Information window, the Depreciate button is unavailable.
• You cannot select a book in the Depreciate Asset window.

    RESOLUTION


    To resolve these issues, follow these steps.

    Note If you are not familiar with the following steps, please ask assistance from an IT person.

     

    Step 1: Back up the company database

    Before you follow the steps to resolve these issues, make a complete backup of the company database to prevent data loss.

    Note You may want to use a test company database that has a copy of live company data. When you do this, users will not have to log off from Microsoft Dynamics GP or from Microsoft Business Solutions – Great Plains while you test the steps to resolve these issues. After you have tested the steps, you can process these steps against the live company data after all the users have logged off at the end of the workday. For more information about how to set up a test company database that uses live company data, click the following article number to view the article in the Microsoft Knowledge Base:

    871973 How to set up a test company that has a copy of live company data by using SQL Server 7.0, SQL Server 2000, or SQL Server 2005

    Perform a backup of the company database in Microsoft Dynamics GP 10.0

    1. On the Microsoft Dynamics GP menu, point to Maintenance and then click Backup .
    2. Select the company that you want to back up.
    3. Click OK to make the backup.

    The Back Up Company window will close and a message will appear when the backup is complete.

     

    Perform a backup of the company database in Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions - Great Plains 8.0

     

    Make a backup of the live company database. To do this, use one of the following methods, as appropriate for your situation.


    Method 1: Using SQL Server Enterprise Manager

    If you are using SQL Server Enterprise Manager, follow these steps:
    a. Click Start , and then click Programs .
    b. Point to Microsoft SQL Server , and then click Enterprise Manager .
    c. Expand Microsoft SQL Servers , expand SQL Server Group , and then expand the instance of SQL Server.
    d. Expand Databases , right-click the live company database, click All Tasks , and then click Backup Database .
    e. In the SQL Server Backup window, click Add in the Destination section.
    f. In the Select Backup Destination window, click the ellipsis button next to the File name field.
    g. In the Backup Device Location window, expand the folders, and then select the location for the backup file.
    h. Type a name for the backup file. For example, type Live.bak .
    i. Click OK repeatedly until you return to the SQL Server Backup window.
    j. Click OK to start the backup.
    k. When the backup has completed successfully, click OK .
    Method 2: Using SQL Server Management Studio

    If you are using SQL Server Management Studio, follow these steps:
    a. Click Start , and then click Programs .
    b. Point to Microsoft SQL Server 2005 , and then click SQL Server Management Studio . The Connect to Server window opens.
    c. In the Server name box, type the name of the instance of SQL Server.
    d. In the Authentication list, click SQL Authentication .
    e. In the User name box, type sa .
    f. In the Password box, type the password for the sa user, and then click Connect .
    g. In the Object Explorer section, expand Databases .
    h. Right-click the live company database, point to Tasks , and then click Backup .
    i. In the Destination area, click Remove , and then click Add .
    j. In the Destination on disk area, click the ellipsis button.
    k. Find the location where you want to create the backup file, type a name for the backup file, such as LIVE.bak , and then click OK .
    l. Click OK repeatedly until you return to the Backup Database window.
    m. Click OK to start the backup.

    Step 2: Unlock the Depreciation process

    1. Have all users log off from Microsoft Dynamics GP or Microsoft Business Solutions – Great Plains.
    2.

    Start SQL Server.

    • To start SQL Server 2000, click Start , point to All Programs , point to Microsoft SQL Server and then click Query Analyzer .


    • To start SQL Server Management Studio:

    a. Click Start , point to All Programs , point to Microsoft SQL Server 2005 , and then click SQL Server Management Studio . The Connect to Server window opens.
    b. In the Server name box, type the name of the instance of SQL Server.
    c. In the Authentication list, click SQL Authentication .
    d. In the User name box, type sa .
    e. In the Password box, type the password for the sa user, and then click Connect .


       
    3. Click New Query , and then select the correct company database.
    4. Run the following query to unlock the depreciation process:

    DELETE FA40203

    5. Log back on to Microsoft Dynamics GP or to Microsoft Business Solutions – Great Plains.
    6.

    Open the Depreciation Process Information window. To do this, use the appropriate method:

    • In Microsoft Dynamics GP 10.0, point to Tools on the Microsoft Dynamics GP menu, point to Routines , point to Fixed Assets , and then click Depreciate .
    • In Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions - Great Plains 8.0, point to Routines on the Tools menu, point to Fixed Assets , and then click Depreciate .



       
    7. Verify that the Depreciate button is available.