How to uninstall Project Accounting in Microsoft Dynamics GP when you use SQL Server


INTRODUCTION


This article describes how to uninstall Project Accounting in Microsoft Dynamics GP when you use Microsoft SQL Server.

More Information


Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.

To uninstall Project Accounting in Microsoft Dynamics GP when you use SQL Server, follow these steps:
  1. Follow the appropriate method to remove security from Project Accounting windows and from Project Accounting reports. Method 1: Use security in Microsoft Dynamics GP 10.0
    1. On the Microsoft Dynamics GP menu, point to Tools, point to Setup, point to System, and then click Alternate Modified/Forms and Reports.
    2. In the ID field, enter the Alternate Modified/Forms and Reports identifier (ID) that is used for the Project Accounting users.
    3. In the Product list, click Project Accounting.
    4. In the Type list, click Windows.
    5. In the Alternate Modified/Forms and Reports List pane, expand the following folders, and then expand each series in these folders:
      • Financial
      • Inventory
      • Payroll
      • Purchasing
      • Sales
    6. Under each series node, click Microsoft Dynamics GP.
    7. In the Type list, click Reports.
    8. Repeat steps e and f.
    9. Click Save.
    Method 2: Use the Advanced Security tool in Microsoft Dynamics GP 9.0
    1. On the Tools menu, point to Setup, point to System, and then click Advanced Security.

      Note If you are prompted, type the system password.
    2. Expand the by Dictionary node, and then click to clear the Project Accounting check box.
    3. Click View, and then click by Alternate, Modified, and Custom.
    4. Click to clear the Project Accounting check box, and then click OK.
    Method 3: Use standard security in Microsoft Dynamics GP 9.0
    1. On the Tools menu, point to Setup, point to System, and then click Security.

      Note If you are prompted, type the system password.
    2. In the Security Setup window, follow these steps:
      1. In the User ID field, type a user identifier.
      2. In the Company field, type the company name.
      3. In the Product list, click Project Accounting.
      4. In the Type list, click Windows.
      5. In the Series list, click Project.
    3. Click Unmark All.
    4. In the Type list, click Reports, and then click Unmark All.
    5. In the Type list, click Alternate Dynamics GP Windows.
    6. In the Series list, click each series individually, and then click Unmark All.
    7. In the Type list, click Alternate Dynamics GP Reports.
    8. In the Series list, click each series individually, and then click Unmark All.
    9. Repeat steps b through h for each Project Accounting user.
    10. Click OK.
  2. Follow the appropriate step:
    • In Microsoft Dynamics GP 10.0: On the Microsoft Dynamics GP menu, point to Maintenance, and then click SQL.
    • In Microsoft Dynamics GP 9.0: On the File menu, point to Maintenance, and then click SQL.
  3. In the Database list, click the company database.
  4. In the Product list, click Project Accounting.
  5. In the pane that contains the Project Accounting list, select all the tables except the following tables:
    • PA Report Posting Definition Master
    • Palette Master
    • PDK Record Notes Master
    • Report Option Names
    • Window Notes Master
    • Work Menu Master
    • PA Report Purchase Order History
    • PA Report Purchase Order Line
    • PA Report Purchase Order Line History
    • PA Report Purchase Order Work
    • PA Report Purchasing Batch History
    • PA Report Purchasing Distribution History
    • PA Report Purchasing Distribution Work
    • PA Report Purchasing Receipt History
    • PA Report Purchasing Receipt Line
    • PA Report Purchasing Receipt Line History
    • PA Report Purchasing Receipt Work
  6. Click to select the Drop Table and Drop Auto Procedure check boxes.
  7. Click Process.
  8. Repeat steps 2 through 7 for each company. However, when you repeat these steps, change steps 3 and 5 as follows:
    • In step 3, click Dynamics in the Database list.
    • In step 5, select all tables except the following:
      • User Notes Master
      • User Notes Master
      Note User Notes Master is listed two times. Do not select either instance of User Notes Master.
  9. Insert the Microsoft Dynamics GP 10.0 installation CD or the Microsoft Dynamics GP 9.0 installation CD into the CD drive.
  10. In the What do you want to do list, click Change Existing Installation.
  11. On the Program Maintenance page, click Add/Remove Features.
  12. On the Select Features page, expand Project Accounting, and then click Entire feature will not be available.
  13. Click Next.
  14. On the Install Program page, click Install.
  15. On the Installation Complete page, click Finish.
  16. In the Welcome to Microsoft Dynamics GP Utilities window, type the password in the Password field, and then click OK.
  17. On the Welcome to Microsoft Dynamics GP Utilities page, click Next.
  18. On the Upgrade Microsoft Dynamics GP page, click Next.
  19. On the Additional Tasks page, click Launch Microsoft Dynamics GP.
  20. In the Welcome to Microsoft Dynamics GP Utilities window, type the password in the Password field, and then click OK.
  21. In the Company Login window, click OK.


    Note If you are prompted about whether you want to include new code, click Yes.

References


For more information, click the following article number to view the article in the Microsoft Knowledge Base:

851624 How to uninstall Project Accounting in Microsoft Business Solutions - Great Plains 8.0 when you use SQL Server