Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Error message when you install the 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"


View products that this article applies to.

Symptoms

The Dynamics GP Data Mart provider installation may fail with the following error shown in the Deployment log:

You must set up a functional currency for the following companies before the integration can continue

↑ Back to the top


Cause

The Dynamics GP Data Mart provider requires a Functional Currency be set for each GP company and an ISO code defined for each of these currencies.

↑ Back to the top


Resolution

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.




An ISO code for each currency must be defined. This is a system-wide setting, and only has to be completed once. You can find these settings at: 

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.



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.

If the values do not match, you will need to contact Dynamics GP support for assistance with updating the index so that it is the same in both tables. 

↑ Back to the top


Keywords: kbmbsmigrate, kbmbspartner, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2831801
Revision : 1
Created on : 1/7/2017
Published on : 5/22/2013
Exists online : False
Views : 375