web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / New GP company creatio...
Microsoft Dynamics GP (Archived)

New GP company creation-sql db created, gp company not created

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    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.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    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

  • AXGPGal Profile Picture
    AXGPGal 19 on at

    Hi, I have the same issue. Which tables did you find the next Company ID in?

  • Jonathan Fear Profile Picture
    Jonathan Fear Microsoft Employee on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans