myGPcloud
myGPcloud Blog
myGPcloud on Twitter
Rose Business Solutions
RoseASP
Linda Rose LinkedIn
Rose Business Solutions on YouTubeIntercompany Processing with Dynamics GP
May 4th, 2011 | 
Author: Intercompany Processing is a standard feature of Dynamics GP. It allows you to create transactions in one company and simultaneously create corresponding entries in one or more other company databases. This functionality ensures that company databases are kept properly balanced, corresponding transactions in all companies are recorded, and maintains accurate related party balances. The setup is really simple, and transactions can be processed in the general ledger and accounts payable modules.
In the setup screen you identify the “Due to” and “Due From” accounts that will be used when intercompany transactions are posted. This helps you identify intercompany balances. Here’s an example of the setup screen:
When you enter an intercompany transaction, you will need to specify that it is an intercompany transaction, and the transaction will need to be posted in a batch. Transactional posting is not allowed. You will specify which company or companies will be used in the transaction. If you look-up account numbers for the distribution, you will be looking at the chart of accounts for the pertinent company.
This edit list shows the original distributions that were entered into the transaction and the “Due to” and “Due From” distributions that are automatically created based on the Intercompany Setup.
Once you post the batch, the appropriate transactions will be created in the specified company datababases, and will be held in a general ledger batch awaiting your review and posting.
Note: If you’re using Integration Manager to create Intercompany Transactions, you will need to omit the segment separators from your account number strings.
Here is a simple demo I made to show this in action: http://www.youtube.com/watch?v=DpQSarYvB8A
Posted in Financial Reporting | 
Tags: Dynamics GP, Financial Reporting, General Ledger, Intercompany
6 Responses to “Intercompany Processing with Dynamics GP”
Leave a Reply
Hi, I need to setup intecompany transactions between the GL and the accounts payable module in Dynamics GP 2010. Your process seems failry simple however the accounts will vary in the one company from one transaction to the other. Please advise on the how we should go about setting that up.
Within GP you can select the other companies in the same screen and set up different account numbers for each relationship. Just select the company in the company ID drop-down list.
I want to terminate an intercompany relationship between companies but it seems all I can do is remove their To/From accounts. I cannot see how I can “turn off” the relationship though. I know this because when I print the Intercompany report before making changes, the relationships and corresponding accounts are printed. After I remove the To/From accounts and print the report, the report prints the same number of pages and relationships, but all of the accounts are removed. I don’t want users to be able to accidentally select a company they used to be able to before this change – is that possible?
To terminate a company relationship, try this:
1.) Backup your databases
2.) Select the company in the Intercompany Setup screen
3.) Then go to: Edit >> Delete Row
Or just try clicking on the Delete button.
We have completed and verified the intercompany setup for several company.
But for unkown reason, we are not able to see some of these companies in the drop down list.
Have you ever troubleshoot something similar to this.
Please advise.
I have not seen that problem. Does the user have company access to the companies that don’t show up?