web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / New GP entity but copy...
Microsoft Dynamics GP (Archived)

New GP entity but copy from other company's GL accounts

(0) ShareShare
ReportReport
Posted on by joseytang 1,800

We would like to setup a new GP entity/company such as called as Malaysia Company.  But we would like to load a chart of account (full COA list) from our consolidation company.  How can we do that?

*This post is locked for comments

I have the same question (0)
  • joseytang Profile Picture
    joseytang 1,800 on at
    RE: New GP entity but copy from other company's GL accounts

    I checked "Account" destination in IM does NOT have Posting Type and Typical Balance in my version (GP2013, R2).  How I can map these 2 fields?  Need help. Thanks!

  • Don Wisch Profile Picture
    Don Wisch 660 on at
    RE: New GP entity but copy from other company's GL accounts

    Hi Josey,

    The "Account" destination used in IM does show fields for Posting Type and Typical Balance.  I assume they show in all versions of IM but I could be wrong. 

    Also the account master is the GL00100.  Hope this helps.

    Thanks,
    Donald Wisch

  • joseytang Profile Picture
    joseytang 1,800 on at
    RE: New GP entity but copy from other company's GL accounts

    Thanks, Leslie.

    I have couple questions for you.

    I reviewed the Integration Manager Tool, we have a template for uploading Chart of Account. However, I found the upload fields contain 3 fields only such as Account Number, Category and Description.  But in the front-end Account Maintenance window, it has Typical Balance and Posting Type.  However, these 2 fields do not exist in the IMTool.  My question is how I can add these 2 fields into the IM templates?

    The other question I have is to use Table Import Utility.  I believe the target table needs to point to Account Master Table (GL00100).  Am I correct?  Do you have a screen shot to show me how I can map all the fields in Table Import template?

    Thanks,

    Josey

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: New GP entity but copy from other company's GL accounts

    Oh,

    That's much easier. Using the VLookup function, as has been suggested, come up with your missing accounts. You could also use a SQL statement to find the missing accounts. SQL would be easier IMHO. If you have integration manager, it's a piece of cake, just import them using that tool. You can change that first character with your SQL statement. But, let's say you have the missing accounts in Excel and do not own Integration Manager. You could go the macro route, or you could get bold and use the Table Import Utility and slam the records into the GL master table. You'd need to save your Excel spreadsheet as a comma or tab delimited text file. Be sure to run checklinks if you use the utility, because you need to populate the GL00105 table.

    The macro (or Integration Manager) is much safer, I must be in a rebellious mood tonight to suggest such a radical move. :)

    Kind regards,

    Leslie

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: New GP entity but copy from other company's GL accounts

    Josey  -

    I personally would change manually compare to using the VLOOKUP feature in Excel, which can substantially automate the comparison of data.

    Once, you have your missing data set for Malaysia and Romania, which may be two different lists, then I would use a Macro to upload the missing accounts to the Malaysia and Romania entities.  I put a link to my blog post on macros in my earlier response, please refer to the post to get you started with macros.  If you have any specific questions, don't hesitate to reach out to me.

  • joseytang Profile Picture
    joseytang 1,800 on at
    RE: New GP entity but copy from other company's GL accounts

    I think we need to rephrase my question.

    We have existing Consolidation company, US, Malaysia and Romania.  However, we want to find out how many GL accounts are missing in Malaysia and Romania. So we downloaded the GL Account list from Consolidation company. Manually compare with the other company's COA.  Once we find out the gap, we want o push the new GL accounts to Malaysia and Romania.  

    How can we do that?

    Thanks,

    Josey

  • joseytang Profile Picture
    joseytang 1,800 on at
    RE: New GP entity but copy from other company's GL accounts

    Thanks for your help, Leslie.

  • joseytang Profile Picture
    joseytang 1,800 on at
    RE: New GP entity but copy from other company's GL accounts

    Thanks for your help, Harry

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: New GP entity but copy from other company's GL accounts

    Hi Josey,

    I might be missing what you want to do, so let me state what question I think I'm answering.

    You have company A that has a COA with the first segment designating 'company'.

    You want that same COA in company B, but you want to change the first segment to align with that company.

    Here's what I propose:

    1. Create your company (company B) in Dynamics Utilities

    2. Log in to company A, launch the PSTL tool and then select Copy Company in the Misc. Tools section and hit ‘Next’.

    3. Check all of the boxes for what you want to copy, identify the target company and complete the transfer

    4. Log in to company B.

    5. Go to the Financial Mass Modify screen (Cards | Financial | Mass Modify) and change the first segment to whatever you need. Use the ‘Move’ option.

    6. After running the process, your new company should have an identical chart of accounts to company A, except the first segment will reflect the appropriate company number.

    7. I would then run checklinks on the Account Master and then check my Account Format Setup to make sure the correct segment is marked as my Main Account.

    I don’t have GP installed on this machine, but I think that will work.

    Kind regards,

    Leslie

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: New GP entity but copy from other company's GL accounts

    Josey,

    I have a blog post on creating a macro.

    redbeardblogging.blogspot.com/.../how-to-create-and-run-simple-macro-in.html

    The only steps to add would be:

    Add the segment columns to your account list in SmartList prior to exporting your COA to import it using the macro.

    Once you have the COA in Excel, change 'Segment 1' from 10 to 11 using Excel prior to performing the mail merge function in Word.

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans