Microsoft Dynamics Forums Homepage

Forum Home Forum Home > Microsoft Dynamics GP (Great Plains) > GP - Installation and Administration
  New Posts New Posts RSS Feed - Deleting companies/logged in users
  FAQ FAQ  Forum Search   Register Register  Login Login


Deleting companies/logged in users

 Post Reply Post Reply
Author
Message
etrack View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: March 28 2007
Location: Australia
Status: Offline
Points: 26
Post Options Post Options   Thanks (0) Thanks(0)   Quote etrack Quote  Post ReplyReply Direct Link To This Post Topic: Deleting companies/logged in users
    Posted: April 11 2007 at 10:46pm
After my last success I thought I try again.Smile
What is the best way to delete a company which appears in the company list of the GP start up screen?
I have deleted the DSN entry, and I tried GP Utilities but there is no facility there to delete a company. ALso I have tried every *.INI file but no luck.
The same companies appear there even thought I have done all of the above.
 
Similarly I have some logged in users stuck on the same screen which I cannot close or remove. Tried removing the user entry in the ACTIVITY file but I am not allowed to delete the lines in that file.
Confused
Back to Top
Sponsored Links


Back to Top
Joseph A Nader View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: September 14 2006
Location: Lebanon
Status: Offline
Points: 360
Post Options Post Options   Thanks (0) Thanks(0)   Quote Joseph A Nader Quote  Post ReplyReply Direct Link To This Post Posted: April 12 2007 at 11:38pm
To delete a company, follow these steps:
1. Start Microsoft Dynamics GP or Microsoft Great Plains, and then log on as a system administrator user.
2. In the Company list, click a company that you do not want to delete, and then click OK.
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:
In Microsoft Dynamics GP, click Tools, point to Utilities, point to System, and then click User Activity.
In Microsoft Great Plains 8.0, click Tools, point to Setup, point to System, and then click User Activity.
In Microsoft Great Plains 7.x and in earlier versions of Microsoft Great Plains, click Setup, click 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, follow these steps:
a. Click Tools, point to Utilities, point to System, and then click Delete Company.
b. Click the lookup button, and then click the company that you want to delete.
In Microsoft Great Plains 8.0, follow these steps:
a. Click Tools, point to Setup, point to System, and then click Company.
b. Click the lookup button, and then click the company that you want to delete.
In Microsoft Great Plains 7.x and in earlier versions of Microsoft Great Plains, follow these steps:
a. Click Setup, click System, and then click Company.
b. Click the lookup button, and then click the company that you want to delete.
5. Click Delete.

Note When you click Delete, the company is deleted from the DYNAMICS database.
6. Delete the company database from the computer that is running SQL Server. To do this, use one of the following methods:
In SQL Server Enterprise Manager, follow these steps:
a. Expand the folder of the computer that is running SQL Server.
b. Expand the Databases folder.
c. Right-click the company database, and then click Delete.
In SQL Server Management Studio, follow these steps:
a. Log on to SQL Server.
b. In Object Explorer, expand the Databases folder.
c. Right-click the company database, and then click Delete.
In the Support Administrator Console utility, follow these steps:
a. Log on to SQL Server.
b. In the query window, type drop database name of the company database.
c. To run the query, click the green arrow button on the toolbar
Joseph Abou Nader, PMP



MCT
,MCTS,MCBMSS,MCSA
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down


Copyright 2013 microsoftdynamicsforums.com. All rights reserved. MicrosoftDynamicsForums.com is an independent non-Microsoft website.
Email: contact AT microsoftdynamicsforums DOT com