frukeus
asked on
Recreating Same Company Name in Great Plains 10
I've recently used GP Utilities to create 2 new companies but realised that I have loaded shipping methods etc when I should not. I then deleted both the companies using the Tools > Utilities > System > Delete Company.
I then deleted the databases on the backend SQL2005.
After that, I recreate the 2 companies using GP Utilities again, this time making sure I did not load the shipping methods. I worked normally and I can see the 2 databases created in SQL 2005.
However, when I tried to login to the companies, I cannot find them in the dropdown list of the Company Login.
When I tried to check using GP Utilities, it is also missing from there. However, only the SQL 2005, the 2 database is present.
How do I can them to show on the Company Login and work normally?
I then deleted the databases on the backend SQL2005.
After that, I recreate the 2 companies using GP Utilities again, this time making sure I did not load the shipping methods. I worked normally and I can see the 2 databases created in SQL 2005.
However, when I tried to login to the companies, I cannot find them in the dropdown list of the Company Login.
When I tried to check using GP Utilities, it is also missing from there. However, only the SQL 2005, the 2 database is present.
How do I can them to show on the Company Login and work normally?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The BlogSpot link above has been deleted. I have the same problem, so I must have some "remnants of records in some tables." I need to know how to "delete all references".
ASKER
Apparently deleting the company from Tools > Utilities > System > Delete Company left some remnants of records in some tables. Thus the recreation did not work as expected.
http://mohdaoud.blogspot.com/2008/12/how-to-delete-gp-company.html
After deleting all references, I was able to successfully recreate the previous deleted companies using the same ID.