Hi,
I created new GP company in GP 10. Utilities completed without error. The sql db was created but I don't see the company in the DYNAMICS.SY01500 table so can't login to it (not in company drop down on login window). Never had this problem before. Any suggestions?
Thanks,
Vip Kumar
*This post is locked for comments
There is no table that technically holds the Next Company ID. The Sy01500 table holds the company id for each company and when the next company is created this is the table that gets looked at. I would not recommend just going into tables and deleting or updating records.
Delete the company, run clear company script, verify DYNS is the owner of all GP databases and then create the new company again.
Hi Richard,
I looked in the sql table SY01500 and don't see it in the drop down. I am logged in as sa. It is not in the User Access list (had checked that but forgot to mention it). I figured out the problem. I found the next company id in several dynamics tables. I deleted those records. The company was created without a problem.
Thanks
When you say it is not in the sy01500 table, did you look there with SQL Studio or just said that since you can't see it in the drop down?
If the later, are you logged in as SA? If you log in as SA to another company, can you go to Admin->Setup->System->User Access and see the company in that list? If yes, then give access to the users that need to be in the company.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (