Deleting a company in Microsoft Dynamics GP

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

On This Page

INTRODUCTION

This article provides the steps to properly delete a company from Microsoft Dynamics GP and prevent the error message stating the company already exists.
When you try to create a new company, you may receive an error message that states that the company already exists.

Resolution

To delete a company that is no longer desired:
  1. Start Microsoft Dynamics GP, and log on with the ‘sa’ login.
  2. At the Company Login window, select a company that you do not want to delete, and then click OK.

    Note The company being deleted cannot have a user logged into it.
  3. Make sure that no users are logged on to the company that you want to delete. To do this, use one of the following methods:
    • Microsoft Dynamics GP 2010 or later

      On the Microsoft Dynamics GP menu, point to Tools, point to Utilities, point to System, and then click User Activity.
    • Microsoft Dynamics GP 10.0

      On the Microsoft Dynamics GP menu, point to Tools, point to Utilities, point to System, and then click User Activity.
    • Microsoft Dynamics GP 9.0

      On the Tools menu, point to Utilities, point to System, and then click User Activity.
  4. Select the company that you want to delete. To do this, use one of the following methods:
    • In Microsoft Dynamics GP 2010 or later, follow these steps:
      1. On the Microsoft Dynamics GP menu, point to Tools, point to Utilities, point to System, and then click Delete Company.
      2. Click the lookup button. Then, click the company that you want to delete.
    • In Microsoft Dynamics GP 10.0, follow these steps:
      1. On the Microsoft Dynamics GP menu, point to Tools, point to Utilities, point to System, and then click Delete Company.
      2. Click the lookup button. Then, click the company that you want to delete.
    • In Microsoft Dynamics GP 9.0, follow these steps:
      1. On the Tools menu, point to Utilities, point to System, and then click Delete Company.
      2. Click the lookup button. Then, click the company that you want to delete.
  5. Click Delete.

    Note When you click Delete, the company is deleted from the DYNAMICS system database.
  6. Delete the company database from the computer that is running Microsoft SQL Server. For Microsoft Dynamics GP 2010, to have us delete the company database from the computer that is running Microsoft SQL Server, go to the "Fix it for me" section.For Microsoft Dynamics GP 2010, Microsoft Dynamics GP 10.0, or Microsoft Dynamics GP 9.0, to delete the company database from the computer that is running Microsoft SQL Server yourself, go to the "Let me fix it myself" section.

    Fix it for me

    For Microsoft Dynamics GP 2010, to run the scripts to delete the company database from the computer that is running Microsoft SQL Server automatically, click the Fix this problem button or link. Click Run in the File Download dialog box, and then follow the steps in the Fix it wizard.
    Fix this problem
    Microsoft Fix it 50438

    Note this wizard may be in English only; however, the automatic fix also works for other language versions of Windows.

    Note if you are not on the computer that has the problem, save the Fix it solution to a flash drive or a CD and then run it on the computer that has the problem.

    Let me fix it myself

    For Microsoft Dynamics GP 2010, Microsoft Dynamics GP 10.0 or Microsoft Dynamics GP 9.0, to run the scripts to delete the company database from the computer that is running Microsoft SQL Server yourself, use one of the following methods, depending on the version you are using:
    • In SQL Server Enterprise Manager, follow these steps:
      1. Expand the folder of the computer that is running SQL Server.
      2. Expand the Databases folder.
      3. Right-click the company database, and then click Delete.
    • In SQL Server Management Studio, follow these steps:
      1. Log on to SQL Server.
      2. In Object Explorer, expand the Databases folder.
      3. Right-click the company database, and then click Delete.
    • In the Support Administrator Console utility, follow these steps:
      1. Log on to SQL Server.
      2. In the query window, type drop database name of the company database.
      3. To run the query, click the green arrow button on the toolbar.
    Note If the company database was deleted in SQL Server Enterprise Manager or 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 following Clearcompanies.sql script in SQL Query Analyzer or in SQL Server Management Studio. 

    ClearCompanies.sql
    https://mbs2.microsoft.com/fileexchange/?fileID=d57c52af-2432-486d-9072-e1a1d60563bf

References

An automated solution that deletes a company in Microsoft Dynamics GP or in Microsoft Business Solutions - Great Plains may be available. All automated solutions are not available for all product versions. For more information, visit one of the following Microsoft Web sites.

Partners
https://mbs.microsoft.com/partnersource/resources/support/automatedsolutions.htm
Customers
https://mbs.microsoft.com/customersource/support/selfsupport/automatedsolutions
For more information about how to install the Support Administrator Console utility, click the following article number to view the article in the Microsoft Knowledge Base:
870052 How to install the Support Administrator Console utility in Microsoft Dynamics GP

Properties

Article ID: 855361 - Last Review: June 5, 2013 - Revision: 10.0
Applies to
  • Microsoft Dynamics GP 2010
  • Microsoft Dynamics GP 10.0
  • Microsoft Dynamics GP 9.0, when used with:
    • System Manager
Keywords: 
kbinfo kbhowto kbmbsmigrate kbmsifixme kbfixme KB855361

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