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

INTRODUCTION

This article describes how to completely remove (uninstall) Analytical Accounting from a computer that has Microsoft Dynamics GP installed. Please note that the steps below will remove Analytical Accounting from 'ALL' companies, so you cannot use these steps if you are using AA in any of your companies (that use the same Dynamics database). 

More Information

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

Note Historical AA tables were added in GP 10.0 so the scripts work for GP 10.0 and later versions.

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 10.0 and higher versions:

  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 on the Microsoft Dynamics GP version listed that you have installedand 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 10.0 and higher versions, download the KB915903_AA_Remove_AACompete_DYNAMICS_10.sql script file, and then save the file to the computer. This script will remove all SQL objects for AA from the Dynamics database. To download the file, visit the following Microsoft Web site:

    https://mbs2.microsoft.com/fileexchange/?fileID=f642f40c-fdc2-4d9d-8d48-26c5583f0c6e
  11. Then download the KB915903_10.sql script file, and then save the file to the computer. This script will remove all SQL objects for AA from the Company database. To download the file, visit the following Microsoft Web site:
  12. Execute the scripts that you downloaded in steps 10 and 11.
    1. Click Start, point to
      Programs, point to Microsoft SQL Server version you have installed, 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 each and 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. Remove the Product ID for AA from the system tables. To do this, run the following statements against the DYNAMICS database in SQL Server Management Studio:
    Delete DB_Upgrade where PRODID='3180' 
    Delete DU000020 where PRODID='3180'
    Note "PRODID of '3180'" represents the Analytical Accounting module.


14. If you are using Management Reporter (MR), you will want to go to Microsoft Dynamics GP, point to Tools, point to Setup, point to Company, and click on Company.  Click on the Options tab.  At the bottom, mark the Management Reporter option for Enable General Ledger Reporting, and unmark the option for Enable Analytical Accounting Reporting.  Click OK and OK again. Be sure to rebuild the Data Mart in Management Reporter.

內容

文章識別碼:915903 - 最後檢閱時間:2017年2月1日 - 修訂: 4

意見反應