Dynamics Community Forum Thread Details

Error message when you install the Dynamics GP Data Mart provider for Management Reporter 2012

Hi,

I'm getting the below error when I try to install Dynamics GP Data Mart provider for Management Reporter 2012.

"You must set up a functional currency for the following companies before the integration can continue: REEL."

What I have done so far;

A functional currency will need to be set for all Dynamics GP companies. To set the functional currency in Dynamics GP, follow these steps.

1.    Start Dynamics GP and log in as an administrator user.

2.    Click Microsoft Dynamics GP on the menu bar.

3.    Point to Tools, point to Setup, point to Financial, and then click Multicurrency.

4.    Select a currency in the Functional Currency field.

----Did not work

1.    Click Microsoft Dynamics GP on the menu bar.

2.    Point to Tools, point to Setup, point to System, and then click Currency.

3.    Select a currency from the Currency ID lookup.

4.    Verify that the currency has an ISO Code.

5.    Repeat steps 3 and 4 for each currency.

---> All currencies had the ISO codes

The currency index in the MC40000 and MC40200 do not match.

Run the following query against the Dynamics database:
```
select * from MC40200
```
Make note of the value in the CURRNIDX column.
Run the following query against the company databases that were listed in the error message:
```
select * from MC40000
```
Make note of the value in the FUNCRIDX column.

-----> Noted that there is a mismatch between the two tables. Dynamics and REEL (company db) . How do I fix this?

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)