Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Will changing the company name affect SQL reporting?

Posted on by Microsoft Employee

Hi Guys, i need to change the company name and am wondering if this change will cause errors with the SQL reporting? thank you!

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Will changing the company name affect SQL reporting?

    Just a quick addition. We cannot change the DB name once created. So changing that, however way, is ruled out.

    Changing company name won't affect your SQL reporting unless you have hardcoded your company's name on any of your SQL reports and/or have a condition that checks whether the company name is the name that was present before you update in GP company setup window.

    If all your SQL reports refer to "Company Name" field from "Company Setup" SQL table, then you are safe and good to go.

    Hope this helps.

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Will changing the company name affect SQL reporting?

    The only reason I can see it failing is if one of the queries looks for a specific value in the company name.

    Remember the company name is not the same as the database name.  If you are talking about changing that - then all bets are off.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Will changing the company name affect SQL reporting?

    I was wondering if the queries will be broken because of the name change?  

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Will changing the company name affect SQL reporting?

    What do you mean exactly by SQL reporting ?

    practically speaking, the name of the company is a chabgable field that can be modified from the company setup window without any negative ramifications.

    Your feedback is highly appreciated,

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans