Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
lcarness 10/22/2019 7:30:25 PM

Management Reporter - Wont Multiply by Exchange Rate

I am implementing GP 2018 and the latest version of MR.  I have configured two different sets of Exchange Rate tables, one that derives Reporting Currency (USD) from GBP by multiplying and one by dividing by the exchanges rate. 

No matter which I setup using the Rate Types MR insists on calculating the wrong USD, always making it less than the original GBP instead of more. For example if the rate is set as a multiply type 1.25 GBP to each 1.00 USD and you have a value of 100 GBP it shows 80 USD, when it should be 125 USD.

If I change the Exchange tables the result is the same. 

What step am I missing? I have loaded the Dec 2015 Balance Sheet in GBP and that is the first month being entered ever in the entity, and the year is not closed. I just want to know that I can translate this to the USD balance I was expected.

Do I need to close the year, and then enter historical data? But the balances were all GBP, its not that they were USD transactions converted to GBP. I just want MR to show me a translated amount. 





Version: GP 2015
Section: Management Reporter

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables