Using the Dynamics GP Copy Company Tool

Earlier this month, one of our clients sold his company, and the new owner needed us to move all of the accounts from the old company into his new company. The original company had been operational for over fifteen years, and naturally, had steadily accumulated a lot of accounts—over 35,000, actually. But the vast majority of them hadn’t been used in years. The ownership transition seemed like a great opportunity to do some account cleanup and make things a bit easier to navigate for the Account Manager.

We decided the best approach would be to write four different scripts: one for all the accounts; one for accounts that had never been used; another for accounts that hadn’t been used since 2008; and finally, one for accounts that had been used after 2008. Fortunately, Victoria Yudin’s wonderful blog made these scripts simple. We tweaked the base scripts we found here by adding a “group by” at the end of the script that included the date range we were looking for:

It turned out there were over 27,00 accounts still on the books that really didn’t need to be there. So once we were confident these queries produced the results we needed, we used the very handy Copy Company tool to setup the new company in GP. The Copy Company feature—free, and available with Microsoft GP 2010—turned a generally laborious process into a quick and easy transition with only minimal manual information importing.

Then, with the new company built, we wrote a query to delete all those excess accounts we found earlier. The result: a slimmer, more relevant, and more manageable list of accounts.

To read more, check out the “Recent News” section of our main website.

About sdnprs

Graduated from the University of Wisconsin earning a Bachelor of Arts degree in Accounting. I have been with SDN since 1989 . My previous work experience includes five years as a controller and prior experience in a large corporation as a financial analyst. As a computer consultant, I am involved in all aspects of serving the clients computer and information analysis needs. My experience in consulting extends over twenty years with a wide variety of commercial and non-profit organizations. I work with clients in wholesale distribution, construction, manufacturing, health care, and various financial and service organizations. I work directly with management to ensure their reporting requirements are met. As an implementer of Microsoft Great Plains and CRM software, I have received certification on SQL Great Plains implementation and installation, Frx Forecaster , Scribe Software, Salespad, Key2Act Job Cost and Service Management and Certified for Sage Intacct the AICPA recommended product. As a Certified Public Accountant, I am a member of the American Institute of Certified Public Accountants and of the Jacksonville Chapter of the Florida Institute of Certified Public Accountants.
This entry was posted in Copy Company Tool, Dynamics GP, Microsoft, Uncategorized and tagged , , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s