web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Inter group Accounts

(0) ShareShare
ReportReport
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

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    on at

    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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans