Announcements
Hi,
I'm in the process of cleaning up our chart of accounts and changing some of the category. Since there are about 120 entities and 2 multi databases I have to change, is there an easier way to make this change. The Mass Modify doesn't really apply in this case.
Version 2020 18.3.1233
Thank you so much!
If you have access to an import module (like Integration Manager), you should be able to update the account categories that way.If you are comfortable with SQL, you can update that way. Small print: -If you do financial reporting via Category, you'll need to consider the impact on financial reports.-You may find you need to be updating the Category Number (not the more visible Category Description).-Try everything out in a test company first!
Hi Hersheys
SQL is the easiest way out.
Please read the below thread
https://community.dynamics.com/gp/f/microsoft-dynamics-gp-forum/77368/importing-cloning-account-categories
Richard Wheeler's script is still relevant and spot on.
Best of luck
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 382 Super User 2026 Season 1
Martin Dráb 265 Most Valuable Professional
Subra 262
