Dynamics GP - Incorrect Functional Currency Index - Incorrect Currency Indexes

Whenever you combine companies that have had separate installs and separate dynamics databases, chances are, the currency indexes across the companies are different. Even if the currency name is the same, GP uses the indexes for everything.
You will realize this problem if you are trying to install Management Reporter and you get the error

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

Check indexes in the following tables to ensure the currency indexes in the company match the currency indexes in the dynamics db.

• MC40000 in company
• MC40200 in Dynamics

Update the MC40000 index to match the MC40200 as long as the currency id's are the same