This must be one of my most hated error messages. Usually, I see it in Integration Manager, but this time it has shown up in Management Reporter.
Jake Friedl recently posted a list of things to check when you receive this error. Thank you Jake! This is a great list:
- Check for missing ISO codes.
- Start GP and log into any company as 'sa'.
- Go to Microsoft Dynamics GP -> Tools -> Setup -> System -> Currency.
- You will need to select every single currency from the Currency ID lookup.
- Once selected, confirm a code is entered in the ISO Code field.
- Check for missing functional currencies.
- You will need to log into every single company in GP to check the following.
- Go to Microsoft Dynamics GP -> Tools -> Setup -> Financial -> Multicurrency.
- Confirm a currency is selected in the Functional Currency field.
- Check for a blank Budget ID.
- Start SQL Management Studio and log in as a SQL sysadmin.
- Run the following query against each GP company database: select * from gl00200
- If you find a blank value in the BUDGETID column, back up the GP database and clear the value with: delete gl00200 where BUDGETID= ''
- After going through the above, you will need to re-create the data mart integration if you are using the data mart provider:
- Close all instances of MR and back up the MR database.
- Start the Configuration Console and click on the integration under ERP Integrations.
- Click the Disable Integration button and wait a moment for that to take effect.
- Click the Remove link in the top-right.
- Stop the MR services at the top level of the Configuration Console and then delete the DDM database from SQL.
- In the Configuration Console, start the MR services and then click File -> Configure and deploy a new DDM integration.
- Enable the integration and wait for the initial load to complete.
Until next post!