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 remove Manufacturing in Microsoft Dynamics GP 9.0 if it was installed accidentally

How to remove Manufacturing in Microsoft Dynamics GP 9.0 if it was installed accidentally

INTRODUCTION

This article describes how to remove Manufacturing in Microsoft Dynamics GP 9.0 if it was installed accidentally. When you remove Manufacturing, the following components are removed:
  • Tables
  • Data
  • Stored procedures
Additionally, all references to Manufacturing are removed.

↑ Back to the top

More Information

To remove Manufacturing, follow these steps:
  1. Insert the Microsoft Dynamics GP 9.0 CD 1 into the CD drive.
  2. In the What do you want to do list, click Change Existing Installation.
  3. In the Program Maintenance dialog box, click Add/Remove Features.
  4. In the Select Features dialog box, click the arrow next to Manufacturing, and then click Entire feature will not be available.
  5. Click Next.
  6. In the Install Program dialog box, click Install.
  7. In the Installation Complete dialog box, click Finish.
  8. In the Welcome to Microsoft Dynamics GP Utilities dialog box, type the password, and then click OK.
  9. In the Welcome to Microsoft Dynamics GP Utilities dialog box, click Next.
  10. In the Upgrade Microsoft Dynamics GP dialog box, click Next.
  11. In the Additional Tasks dialog box, click Launch Microsoft Dynamics GP.
  12. In the Welcome to Microsoft Dynamics GP Utilities dialog box, type the password, and then click OK.
  13. In the Company Login dialog box, click OK.

    Note If you are prompted to include new code, click Yes.
  14. Log out of Microsoft Dynamics GP.
  15. Remove the Manufacturing triggers on each company in which Manufacturing was installed. To do this, follow these steps:
    1. Follow the appropriate step:
      • If you are using Microsoft SQL Server 2005, start SQL Server Management Studio. To do this, click Start, point to Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.
      • If you are using Microsoft SQL Server 2000, start SQL Query Analyzer. To do this, click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.
      • If you are using SQL Server Desktop Engine (also known as MSDE 2000), start Support Administrator Console. To do this, click Start, point to Programs, point to Microsoft Administrator Console, and then click Support Administrator Console.
    2. Run the following statement against each company database on which Manufacturing was installed.

      Note Manufacturing is removed from the company databases when this statement finishes running.
      --BM010115
      drop trigger [dbo].[SCSU0030Delete]

      --GL10000
      drop trigger [dbo].[mfg_delete_GL10000_record]

      --IV10001
      drop trigger [dbo].[ICJC_DELETE_LINKS]
      drop trigger [dbo].[ICJC_IV_DELETE_LINKS]

      --IV00101
      drop trigger [dbo].[mfg_update_location_update]
      drop trigger [dbo].[mfg_remove_orphaned_records]
      drop trigger [dbo].[mfg_add_matching_item_records]

      --IV00102
      drop trigger [dbo].[mfg_insert_IV00102_location]
      drop trigger [dbo].[mfg_update_IV00102]
      drop trigger [dbo].[mfg_delete_IV00102]

      --MOP1900
      drop trigger [dbo].[MOP1410Insert]
      drop trigger [dbo].[MOP1410Update]
      drop trigger [dbo].[MOP1410Delete]

      --PK010033
      drop trigger [dbo].[mfg_insert_PK010033_record]
      drop trigger [dbo].[mfg_delete_PK010033_record]
      drop trigger [dbo].[mfg_update_PK010033_record]

      --SOP10200
      drop trigger [dbo].[mfg_delete_SOP10200_record]

      --SOP30200
      drop trigger [dbo].[remove_cost_rollup_records]
      drop trigger [dbo].[remove_comp_price_records]

      --WO010032
      drop trigger [dbo].[mfg_update_MO_status]

      --ICIV0323 
      drop trigger [dbo].[mfg_update_ICIV0323]

      --MOP1020 
      drop trigger [dbo].[MOP1020UpdateForScrap]
      drop trigger [dbo].[MOP1020UpdateLinks]
      drop trigger [dbo].[MOP1020UpdateROWID]

      --MOP1025
      drop trigger [dbo].[MOP1025UpdateROWID]

      --MOP1027
      drop trigger [dbo].[MOP1027UpdateROWID]

      --MOP1040
      drop trigger [dbo].[MOP1040UpdateLinks]
      drop trigger [dbo].[MOP1040UpdateParent_Component_ID]

      --PK010033
      drop trigger [dbo].[mfg_update_and_insert_PK010033_record]

      --SOP10100
      drop trigger [dbo].[mfg_delete_ICJC1002]
       
      --SOP10200
      drop trigger [dbo].[mfg_update_SOP10200_record]

      --WO010032
      drop trigger [dbo].[DeleteSerialNumber]

      --WO010302
      drop trigger [dbo].[WO010302UpdateROWID]

      --WO010515
      drop trigger [dbo].[WO010515UpdateROWID]

↑ Back to the top

Keywords: kbinfo, kbentirenet, kbmbsinstallation, kbexpertiseinter, kbexpertiseadvanced, kbhowto, kbmbsmigrate, kbexpertisebeginner, kbmbspartner, kb

↑ Back to the top

Article Info
Article ID : 936277
Revision : 1
Created on : 3/3/2017
Published on : 7/14/2012
Exists online : False
Views : 101