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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Managment Reporter translating GPB 203,574, becomes USD 12,175.25

(0) ShareShare
ReportReport
Posted on by 337

Just ran into an issue, running a consolidated statement and this is how it translated one account.  The account is a closing account for year end 2012 and an entry went into the 991* account and closed to this account.  991* is set to record at average and of course the closing account is a BS account.  BPS at 12/31 was CUR 1.5471 and AVG was 1.6125.  The 12,175.25 is a result of what was moved from the 991* acct to the closing account.  So, how do we fix this mess, have tried running all the maintenance I can think of.  I need the account to reflect the correct amount for the 203,574 BPS to USD $314,949.33.  Kind of understating the amount for USD right now...

Sure doesn't give my accounting staff a whole lot of confidence in this system at all...BTW, have Managment reporter 2.0 running as well as MR2012, R2 (legacy)  and getting the same results.  

Are they every going to get this thing right?

Sue

*This post is locked for comments

I have the same question (0)
  • Verified answer
    sueconrod Profile Picture
    337 on at

    Had to work with Great Plains support, since this was the RE account there is a way to go in and put in the currency translation that you want for the end of each year.  BTW, although it looked like it would work for just the one transaction when testing, in the produciton company, had to go the year and then add a translation rate for each year and mark off all the accounts and then hit calculate.  BTW,  this is something you do in a test comany and look at the rates that you have traditionally had,  and been reporting.  

    Tools>>Routines>>Financial>>Currency Translation.  

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans