Delete a company in Microsoft Dynamics GP
This article provides the steps to properly delete a company from Microsoft Dynamics GP and prevent the error message stating the company already exists.
Applies to: Microsoft Dynamics GP
Original KB number: 855361
Introduction
When you try to create a new company, you may receive an error message that states that the company already exists. To delete a company that is no longer desired, use one of the following methods:
Method 1: in Microsoft Dynamics GP
Start Microsoft Dynamics GP, and sign in with "sa".
At the Company Login window, select a company that you don't want to delete, and then select OK.
Note
The company being deleted cannot have a user logged into it.
Make sure that no users are logged on to the company that you want to delete. To do this, on the Microsoft Dynamics GP menu, point to Tools, point to Utilities, point to System, and then select User Activity.
Select the company that you want to delete. To do this, follow these steps:
- On the Microsoft Dynamics GP menu, point to Tools, point to Utilities, point to System, and then select Delete Company.
- Select the lookup button. Then, select the company that you want to delete.
Select Delete.
Note
When you select Delete, the company is deleted from the DYNAMICS system database.
Method 2: in SQL Server Management Studio
In SQL Server Management Studio, follow these steps:
- Sign in SQL Server.
- In Object Explorer, expand the Databases folder.
- Right-click the company database, and then select Delete.
Note
If the company database was deleted in SQL Server Management Studio before it was deleted from Microsoft Dynamics GP, you must remove the orphaned records. To remove the orphaned records, run the Clearcompanies.sql script in SQL Query Analyzer or in SQL Server Management Studio.