Using the Currency option in Management Reporter Web Viewer

In the Web Viewer, you can use the Currency option to translate and view your report in another currency. The Currency option allows you to toggle the report between different currencies. The currencies that are displayed are based on the functional and reporting currencies you have set up in Dynamics GP.

In the example that follows, two companies with different functional and reporting currencies are consolidated in MR.

In the Multicurrency Setup window, for the US company, USD and Euro are set up as the functional and reporting currencies.

In the Canadian company, CAD is the functional currency and USD is the reporting currency.

Management Reporter will use the rates that are set up in GP, when changing the currency view in the Web Viewer. In this example, account 000-1101-00 is set to use the Current translation type in both companies.

The Current translation type is set up with the following exchange rate.

For the US company:

For the Canadian company:

Both companies have rates set up for CAD, USD and EUR. This will allow you to display the report in any of the three currencies.

In Management Reporter, you can format your report like you normally would. No extra formatting is needed for currency translation.

Row definition

Column definition- The Currency Display is not needed, since we will be using the currency option in the report definition.

Tree definition, consolidating the two companies

In the report definition, you can select the option Include all reporting currencies.

The currency that displays here will depend on what company you are logged into, or what company is selected in the Company name field. In this case, we are logged into the US company. This has a reporting currency of Euro. If we were to log into the Canadian company, then USD would display.

The US company has $1,000.00 posted to the account and the Canadian company has C$200.00 posted. When the report is generated from the US company, it will display in USD.

The C$200.00 converts to USD at the rate defined of .69.

(C$200 * .69) = 138.00

To view the report in CAD, you can click the Currency icon at the bottom of the Web Viewer window.

When you change the currency to CAD, the USD amount is converted at the rate defined in the US company ($1,000.00 / 1.45) = 689.66

 Since both companies also have the Euro exchange rate, you can view the report in Euros.

($1,000 / .98) = 1,020.41

(C$200 / .98) = 204.08