
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)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.