New Company not shown in list

(0) Share

Report

Posted on by Community Member

I recently created a new company within GP v10. Everything runs great and the databases are created within SQL. When I go to login to GP using SA, I would think I would see the new company however I do not. It is not listed anywhere.

If I run Select * from DYNAMICS.dbo.SY01500 I see the list of all my companies except the new one I created. Is there something I am missing?

I've created a company before (a long time ago) and don't remember having all these issues!

Thanks for any help -

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (1)

Suggested answer

drummerboy_10 on at

Like (0)

Report

Hi -

So the database is created in SQL, but you can't find a corresponding record in the SY01500 table? It sounds to me like the company was deleted from within Dynamics GP. When you delete the company from inside the application, it removes it from tables like the SY01500.

I would delete the database inside SQL server and try and create the new database again.

--Sean

Was this reply helpful? Yes No
Suggested answer

Tristan Clores 2,812 on at

Like (0)

Report

Hi kstrley,

When you created the new company in GP Utilities, did you select the correct GP SQL instance?

If you have multiple SQL instances, try checking there for your newly created GP company.

Was this reply helpful? Yes No
Suggested answer

Bill Campbell 12 on at

Like (0)

Report

Just to clarify Sean comment - 'so the database is created in SQL'

When you open SQL Server Studio, open Databases, you DO see the new database - right?

Is there any chance that you created the databases in SQL Management Studio and not in GP Utilities?

If you did, look at the GP Utilities again and see what ODBC it is using - is pointing somewhere else.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Hi,

Bill's answer rang true to me. If it's been a long time since you created a new company, this can easily happen. If you open the new company database in SQL, do you see the usual array of tables normally found in a company? If not, then for sure the company wasn't created in GP Utilities. If you copied an existing database just using SQL, the company will still not show up in GP.

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I've done this a few times with the same results each time. The company is not in the SY01500 table and it is in SQL.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I only have 1 SQL instance to choose from when creating the new company which is the one I used when creating this company.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Bill -

I did not create the database within SQL Management Studio - I used GP Utilities and ran it as Administrator. I verified the ODBC connection to my SQL instance which is the one that the databases show up in.

I'm at a loss as to why this is not working as it should. I've deleted the database about 10 times now and tried to create the company using GP Utilities. Nothing seems to get the company to show up.

Was this reply helpful? Yes No
drummerboy_10 on at

Like (1)

Report

I take it you're not getting any messages when the database is being created through GP utilities correct?

I don't know that I've ever seen a new company created through GP utilities not get created in the SY01500 table even as far back as GP 9.0.

Do you see the new company record in either the Dynamics..db_upgrade or Dynamics..DU000020 table?

Was this reply helpful? Yes No
Suggested answer

Tristan Clores 2,812 on at

Like (0)

Report

Definitely weird then. Can you share a screenshot of the company created in SQL? Make sure to expand the whole tree so we can see the structure.

Was this reply helpful? Yes No
Verified answer

drummerboy_10 on at

Like (2)

Report

I found this suggestion in another thread:

Delete the company, run clear company script, verify DYNSA is the owner of all GP databases and then create the new company again.

Was this reply helpful? Yes No