web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

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

(0) ShareShare
ReportReport
Posted on by

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.
  1. Run the following query against the Dynamics database:

    select * from MC40200
  2. Make note of the value in the CURRNIDX column.
  3. Run the following query against the company databases that were listed in the error message:

    select * from MC40000
  4. 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?

 

*This post is locked for comments

I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans