Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
Hi friends, I need to ask you if is possible to do the following thing... we have 2 companies created on GP10, database SYS1 for a company name MainCorp and database SYS2 for a company name SubCorp, each company is configured in a different way (accounts, sop documents, classes, etc)... but we notice that product of a human mistake the companies are switches, I mean, I need SYS1 with the same company name it already has but with all company configuration of SYS2! and viceversa....
Is it possible to rename the database of a company in GP? because if we rename SYS2 as SYS1 we only have to change company information internally in GP and ...that's all, isn't it?.... all configuration is saved..... we want to prevent the fact of reconfigure both companies....
I don't think its possible and don't know what will go wrong in Dynamics GP if you change DB Name.
I Will do following task
1) Create New Company with New Name (Name you want)
2) Restore Old Company to New Company
3) Test it properly
4) Once you satisfied with Test Delete Old Company from Dynamics GP and than from SQL
Do all above task in Test Environment.
Hope it will help you to resolve your issue.
I agree that creating a new company and restoring the desired data over the new db is the safest way to go. If you are using manufacturing you need to get a script to change the company id's in the restored db.
I do know that the db name of your company db's is stored in the Dynamics tables in the SY01500 table but it may be found other places.
We are now facing this same issue. We use FRx, Management reporter and also Integration Manager. We currently have 5 companys and need to add 3 additional companys and change the name of one of the original databases. The restoring option sounds good--but are there any "gotchas" with the the programs?
Yes you got to set the interid and company ids. KB has the procedure and steps to follow.
Also consider any third party add-ons you may have and if they will need to be updated.
There are also modules such as Fixed Asset Management which store some settings in the system database.
If you are using manufacturing, you need to run a script after restoring company a to company f's database and before opening the app. If you need the script, email me at firstname.lastname@example.org
The safest route will be to create a new GP company. I actually did this in October and it worked really well.
You should follow the steps Sandip outlined and you will be okay.
The companies I had to rename only had about 50 GL journal entries apiece so I just used SSIS to import the data over. We had to recycle some old test companies because we needed two new companies and to make a long story short, we weren't able to create a new company until we upgraded from GP10. So we had some other issues as a result, so I wanted a clean slate to import everything.
Wait a minute... the configuration is the important thing, so who cares what the database names are. Why not just go to MSDGP | Tools | Setup | Company | Company and switch the names there. You can then run a quick script to update the SY01500 to update the company names there too, since the location name is the only thing updated via the interface.
Business Applications communities