Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Inter group Accounts

Posted on by 1,290

Dear All,

We are a group of six legal entities; each legal entity has its own currency, so our inter group transactions are done with six different currencies. When consolidating the report of the group, the due to and due from accounts do not balance to zero because of different exchange rates that are used when entering the group transactions.

I appreciate if you share with me how the GP can help to balance these accounts to zero, or if there is another method that is used.

Thank you

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Inter group Accounts

    Hello Waleed,

    You have two options to resolve this, shown below:

    1. Using Management Reporter (Working Papers): setup your corporate reporting exchange rate using management reporter and perform the consolidation at the level of the report, keeping in mind that following IAS #27 you should eliminate all intercompany balances, transactions, income, and expenses in full as a part of the consolidation procedure therefore your issue should no longer exist as both transactions on both companies were eliminated.

    2. Using correcting Journals (Actual GL): before doing the consolidation, create 1 transaction for each company and for each currency to close the actual difference to the multicurrency relealized gain/losses, you can do changes in the exchange rate to fix small variances.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,232 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,064 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans