Steps to remove Analytical Accounting from a computer that has Microsoft Dynamics GP installed

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

On This Page

INTRODUCTION

This article describes how to completely remove (uninstall) Analytical Accounting from a computer that has Microsoft Dynamics GP installed. When you completely remove Analytical Accounting, you remove it from all companies. 

More information

To completely remove Analytical Accounting, follow the appropriate steps for the version of Microsoft Dynamics GP that you are using:

Note Iit is important that you run the correct scripts for the Microsoft Dynamics GP version that you are using. Please note that the scripts in the section for Microsoft Dynamics GP 9.0 are different than the scripts in the section for Microsoft Dynamics GP 2013, Microsoft Dynamics GP 2010 and Microsoft Dynamics GP 10.0.

Note Make sure to perform all '13' steps listed below. The last step is often missed.

Note If you wish to continue to use Analytical Accounting in one or more of your companies, then do not use the steps below. These steps will remove AA from all of the companies.



Microsoft Dynamics GP 2013, Microsoft Dynamics GP 2010 or Microsoft Dynamics GP 10.0:

  1.  Make a full backup of the Microsoft Dynamics GP databases. Make sure that this backup does not overwrite an existing backup.
  2. Click Start, click Run, type appwiz.cpl, and then click OK.
  3. In the left pane, click Change or Remove Programs.
  4. Click Microsoft Dynamics GP 2013, Microsoft Dynamics GP 2010 or Microsoft Dynamics GP 10.0 and then click Change.
  5. Click Add/Remove Features.
  6.  In the Select Features window, click Do not install feature in the Analytical Accounting list.
  7. Click Next, and then click Install.
  8. In the Installation Complete window, click Finish.
  9. Close the Add Or Remove Programs window.
  10. For Microsoft Dynamics GP 2013, Microsoft Dynamics GP 2010 or Microsoft Dynamics GP 10.0, download the KB915903_AA_Remove_AACompete_DYNAMICS_10.sql script file, and then save the file to the computer. To download the file, visit the following Microsoft Web site:
    https://mbs.microsoft.com/fileexchange/?fileID=7f3d6d35-426c-4c29-93ad-4e7d671a67d1
  11. Then download the KB915903_10.sql script file, and then save the file to the computer. To download the file, visit the following Microsoft Web site:
    https://mbs2.microsoft.com/fileexchange/?fileID=7fe68151-851f-4fec-9e06-35fc57bf2f2a
  12. Run the script files that you downloaded in steps 10 and 11. To do this, use one of the following methods, as appropriate for your situation.

    Method 1

    If you are using Microsoft SQL Server 2000, follow these steps:
    1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.
    2. Log on by using the sa password.
    3. On the File menu, click Open.
    4. Locate and then click the KB915903_10.spl script file, click the company database in the list, and then press F5 to run the script.

      Note The KB915903_10.sql script must be run against all company databases for Microsoft Dynamics GP.
    5. Locate and then click the KB915903_AA_Remove_AAComplete_DYNAMICS_10.sql script file, and then run the script against the DYNAMICS database. To do this, click DYNAMICS in the database list, and then press F5.

    Method 2

    If you are using Microsoft SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012, follow these steps: 
    1. Click Start, point to Programs, point to Microsoft SQL Server 2005, Microsoft SQL Server 2008, Microsoft SQL Server 2008 R2 or  Microsoft SQL Server 2012, and then click SQL Server Management Studio.
    2. Log on by using the sa password.
    3. On the File menu, click Open, and then click File.
    4. Locate and then click the KB915903_10.sql script file, click the company database in the list, and then press F5 to run the script.

      Note The KB915903_10.sql script must be run against all Microsoft Dynamics GP company databases.
    5. Locate and then click the KB915903_AA_Remove_AAComplete_DYNAMICS_10.sql script file, and then run the script against the DYNAMICS database. To do this, click DYNAMICS in the database list, and then press F5.
  13. Run the following statement against the DYNAMICS database by using SQL Server Management Studio:
    Delete DB_Upgrade where PRODID='3180' 
    Delete DU000020 where PRODID='3180'
    Note "PRODID of '3180'" represents the Analytical Accounting module.

Microsoft Dynamics GP 9.0

  1. Make a full backup of Microsoft Dynamics GP 9.0. Make sure that this backup does not overwrite an existing backup.
  2. Click Start, click Run, type appwiz.cpl, and then click OK.
  3. In the left pane, click Change or Remove Programs.
  4. Click Microsoft Dynamics GP 9.0, and then click Change.
  5. Click Add/Remove Features.
  6. In Microsoft Dynamics GP 9.0, in the Select Features window, click Entire feature will not be available in the Analytical Accounting list.
  7. Click Next, and then click Install.
  8. In the Installation Complete window, click Finish.
  9. Close the Add Or Remove Programs window.
  10. Download the AA_Remove_AAComplete_DYNAMICS.sql script file, and then save the file to the computer. To download the file, visit the following Microsoft Web site:
    https://mbs.microsoft.com/fileexchange/?fileID=718d7f62-905b-4f7a-b833-da2a7829e38e
  11. Download the KB915903.sql script file, and then save the file to the computer. To download the file, visit the following Microsoft Web site:
    https://mbs.microsoft.com/fileexchange/?fileID=e9b65b68-5e9e-4165-8fca-24f4c1186ad1
  12. Run the script files that you downloaded in steps 10 and 11. To do this, use one of the following methods, as appropriate for your situation.

    Method 1

    If you are using Microsoft SQL Server 2000, follow these steps:
    1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.
    2. Log on by using the sa password.
    3. On the File menu, click Open.
    4. Locate and then click the KB915903_10.spl script file, click the company database in the list, and then press F5 to run the script.

      Note This script must be run against all company databases.
    5. Locate and then click the AA_Remove_AAComplete_DYNAMICS.sql script file, and then run the script against the DYNAMICS database. To do this, click DYNAMICS in the database list, and then press F5.

    Method 2

    If you are using Microsoft SQL Server 2005 or SQL Server 2008, follow these steps:
    1. Click Start, point to Programs, point to Microsoft SQL Server 2005 or SQL Server 2008, and then click SQL Server Management Studio.
    2. Log on by using the sa password.
    3. On the File menu, click Open, and then click File.
    4. Locate and then click the KB915903.sql script file, click the company database in the list, and then press F5 to run the script.

      Note This script must be run against all company databases.
    5. Locate and then click the AA_Remove_AAComplete_DYNAMICS.sql script file, and then run the script against the DYNAMICS database. To do this, click DYNAMICS in the database list, and then press F5.
  13. Run the following statement against the DYNAMICS database by using SQL Server Management Studio:
    Delete DB_Upgrade where PRODID='3180' 
    Delete DU000020 where PRODID='3180'
    Note "PRODID of '3180'" represents the Analytical Accounting module.

Properties

Article ID: 915903 - Last Review: October 16, 2013 - Revision: 6.1
Applies to
  • Microsoft Dynamics GP 2013 Service Pack 2
  • Microsoft Dynamics GP 2013
  • Microsoft Dynamics GP 2010
  • Microsoft Dynamics GP 10.0
  • Microsoft Dynamics GP 9.0, when used with:
    • Analytical Accounting
Keywords: 
kbinfo kbmbsmigrate kbhowto KB915903

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