I am getting an error when attempting to generate a report or modify column definitions:
"Microsoft.Dynamics.Performance.DataProvider.Core.ValidationException: One functional currency code must be defined."
...Then the designer crashes. Online searches have many suggested solutions for other Dynamics products but not AX.
Any Suggestions? (full error below)
Vitals:
Dynamics AX 2009 5.0.1500.6491
Management Reporter 2012 RU9
Full Errors:
: (I have confirmed the functional currency code is setup in all the companies in Dynamics AX).
*****
Microsoft.Dynamics.Performance.DataProvider.Core.ValidationException: One functional currency code must be defined. Correct the data to define a functional currency code for the provider.
at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GLCurrencyCollection.ValidateItems()
at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GLSystemProvider.HandleRequest(GLCurrencyRequest request)
at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemRequest.Handle[TRequest](SourceSystemProvider provider, TRequest request)
at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemProvider.SubmitRequest(SourceSystemRequest request)
Component: Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkService
User:
***************************
Microsoft.Dynamics.Performance.Reporting.Common.ReportingProviderFrameworkException: The operation could not be completed due to a problem in the data provider framework.
at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkService.SubmitRequestErrorHandler[T](Func`1 requestSubmission)
at Microsoft.Dynamics.Performance.Reporting.Security.Service.SecureServiceBase.SecureExecuteInternal[TResult](Func`1 hasPermission, Func`1 executor)
at Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceBase.BaseExecute[TResult](Func`1 executor)
Component: Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkService
User:
******
