Exact MAX Support

Dynamics GP Data Mart Currency Errors and Data Mart

The official Knowledgebase article from MicroSoft is here: mbs2.microsoft.com/…/KBDisplay.aspx

To install the Data Mart in Management Reporter you need to assign both a functional currency and an ISO code to each of your companies in Dynamics GP.

Here are the steps:

1. A Functional Currency must be defined. This is done for each company:
   1. Microsoft Dynamics GP > Tools > Setup > Financial > Multicurrency
2. An ISO code for each currency must be defined.
   1. Microsoft Dynamics GP > Tools > Setup > System > Currency

When you have completed the above and the setup in the Configuration Console has been done then Management Reporter will build the Data Mart and the errors will go away.