I am converting our reporting system from FRx to Management Reporter. I have setup everything for translating one company from UK pounds(GPB) to USD in the consolidated reports. Everything translates correctly until November 2010. At that date the system stops translating and the reports show the untranslated GBP amounts. The next logical step is to check the currency translation table, but everything looks consistent. Has anyone seen this before or am I just special?
I am hoping that you got the currency all setup in Great Plains now. Are you on Roll up 2 and have you checked off your report to use future periods. I ran into that when I wanted something for a full year.
Haven't run into this yet.
There really isn't much to set up in MR as all you are doing is selecting USD from the Currency Source field in the column. Confirm that you are only using the Currency Source field and not the Currency Filter field. Other than that, the "Include amounts in future periods" option that Susan mentioned in the Report Definition under Settings -> Other -> Additional Options could play a factor. I recommend having it marked. Other than that, I would recommend reviewing the KB below to ensure all of your GP setup is correct, as that is the only thing left. If you need additional help beyond that, I would recommend logging a thread for GP Multicurrency as the cause is likely a setup issue in GP.
We are currently on version 2.1.1029.30.
I believe MR is set up correctly as I can run historical reports and get the right amounts up to Nov 2010. I can run a Sep 2010 report and all accounts translate correctly. I have verified the average rates translation table and everything is entered consistently from Jan 2007 throught September 2012. I doesn't make any sense.
Thank you all for your suggestions.
On the Exchange Rate Table Setup I changed the Search for Unexpired Rates to unlimited. After that MR picked up the earliest rate in the table and applied it to Nov and Dec (the first ten months were still correct), which also doesn't make sense since the Trans Rate Default is set to "Next Date".
It is correct that you need to have the Search for Unexpired Rates option set to Unlimited as per the KB I linked to. In addition to that, it is recommended to have the "Transaction Rate Default" set to Previous Date if you want to have MR translate in the same manner that FRx did. Below is how each function works.
Transaction Rate Default NotesSelect a Transaction Rate Default option to determine the exchange rate that will be used when multicurrency transactions are entered. Every time that you enter a transaction, a currency must be selected. If there is not an exchange rate for the transaction date, the option selected here will be used to select the exchange rate. Exact Date Select if you want the default exchange rate only to be an exchange rate with the same date as the transaction date. If there is no exchange rate for the transaction date, there will be no default exchange rate.Previous Date Select if you want the default exchange rate to be the rate for the closest previous date, if no rate exists for the transaction date. If an exchange rate exists for the transaction date, that rate will be used as the default exchange rate. You will also have to enter the number of previous days that you want to search for an unexpired exchange rate.If you have selected to use a previous date as the transaction rate default and there are no unexpired rates for a previous date within the number of days that you have specified as a search limit, the closest future date will appear as the default exchange rate.Next Date Select if you want the default exchange rate to be the rate for the closest date after the transaction date, if no rate exists for the transaction date. If an exchange rate exists for the transaction date, that rate will be used as the default exchange rate. You will also have to enter the number of previous days that you want to search for an unexpired exchange rate.If you have selected to use the next date as the transaction rate default and there is not one, then the closest unexpired rate prior to the transaction date will appear as the default exchange rate. Only the number of days that you have specified to search will be used to determine an unexpired previous rate.Note The Previous Date setting is recommended as that is how FRx Currency Translator functions.
Also per the same KB, below is how MR will pull rates based on the translation type.
Current – Current is a single exchange rate based on the last date in the report which could be either the report date in the report definition or a future date from the column. The same rate is used for all periods in the report. This translation type is typically used with balance sheet accounts and a YTD column.Average – Average is a single exchange rate for each period. Management Reporter does not actually calculate an average rate as it is expected that people will enter the average for the period into the exchange table. Each period is calculated at the average rate for that period and any YTD results are summed from the period totals. This translation type is typically used with income statement accounts.Historical – Historical is an exchange rate based on the transaction date. The transaction date is used to find the rate for that time period and that is the rate used for the translation. This translation type is typically used with non-monetary assets, such as inventory, fixed assets, long term liabilities, or equity / retained earnings.
Please post screenshots of the following if you have further questions:
Microsoft Dynamics GP menu >> Tools >> Setup >> System >> Exchange Table
Microsoft Dynamics GP menu >> Tools >> Setup >> System >> Exchange Table >> Rates (button)
I don't know what made me think of this, but I checked the fiscal periods and all periods were closed in 2010. I opened up a period (even though the year is closed) and the translations worked properly.
MR only cares if all periods are closed in a non-historical year. I'm betting that what you did was a coincidence to what really corrected the issue. Either way though, glad to hear you got it resolved.
Just a quick question .. How did u come across this setting (Transaction Rate Default Notes) ? Was it mentioned with any of the manuals ?
I linked to the KB where this information is contained above.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13