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) / Old Company, New Chart...
Microsoft Dynamics GP (Archived)

Old Company, New Chart of Accounts

(0) ShareShare
ReportReport
Posted on by Community Member

My boss wants me to see if we can set up a new company (Company B), which will have a new chart of accounts, and import company A's 2015 1st quarter data to company B though the chart of accounts are different (maybe through the alias some how?). I guess I'm asking can you take data from an old chart of accounts and import it to a new company which has a new chart of accounts? (I'm at home and am not sure what version of GP we are using, but I know it's not 2013 or 2015)

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Redbeard Profile Picture
    Redbeard 12,931 on at

    I can think of a few ways to accomplish this off hand. Then I am going to ask you a question.

    First, in the company A, use one of the User Defined Fields (UDF) in Account Maintenance to enter the equivalent company B account for each account.  This will allow you to easily import the detail data using a SmartList export or SQL dump as your source.  You will need both the Company A account column and the UDF containing the Company B account, but it should go smoothly. If you are feeling very ambitious, you can do the same thing in Company B Account Maintenance.

    Second, you can use PSTL on Company B to convert the Chart of Accounts after you do the creation and import using the data from Company A. To be clear, do the change after creation and import, not during the process.  PSTL is Free, easy to use and has numerous other useful features.

    Third, if you use Integration Manager, you can create a translation table for the accounts which contains the data for Company A and Company B COA.  This approach will allow you to make the changes during processing.

    Finally, a question - will you ever need to consolidate financials for both of the companies? If so, you should give this some real thought, and make sure you don't cause yourself problems going forward.

    For instance, if you're simply changing the sub account string in company B to a value different than company A, then that's no biggy.  If you are going to use different main / natural account numbers for the same financial data in Companies A and B, it could negatively impact your options for consolidation going forward.

  • Community Member Profile Picture
    Community Member on at

    No, I see no reason for consolidation in the future. That company will not be used again. The new setup was planned to take effect Jan 1, 2015 but it didn't happen. So now, we're considering the export.

    So, if I understand you correctly, going with the first option, I would update the UDF's in company A with the new accounts codes from company B. Update the UDF's in company B with the old account codes from company A. Create a smartlist in Company A with the financial transactions for the quarter which includes the UDF fields. Then go into company B and import the file?

    If there are say, 100 accounts, but only 20 have been used thus far, is it alright to only plug account info in the UDF for those accounts or should I do it for all 100?

  • Verified answer
    Redbeard Profile Picture
    Redbeard 12,931 on at

    Your understanding is correct, and you need only do this for the accounts that have equivalents in both companies, and therefore require translation.  I would restrict the accounts in the SmartList export from Company A to just the accounts with data in the User Defined fields. You should be able to restrict GL Detail in this manner as well.

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