Dynamics Community Forum Thread Details

MR consolidations and currency errors

hi folks

I am trying to bring together CAD, USD, Chinese, and Hong Kong is MR RU7 legacy provider.

Some reports are working great. Some are giving me errors that are meaningful that I can do something about. Some are giving me look at the log errors.

My latest is this.

Microsoft.Dynamics.Performance.DataProvider.Core.RequestException: The source system request did not complete successfully. ---> 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)

--- End of inner exception stack trace ---

at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemProvider.SubmitRequest(SourceSystemRequest request)

at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemProvider.HandleSubmit(SourceSystemRequest request)

at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemConnection.Submit(SourceSystemRequest request)

at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkService.SubmitRequestDirect(SourceSystemConnection connection, GLRequest request)

at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ProviderLink.SubmitRequest(GLRequest request, ProviderConnection context)

at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ProviderLink.GetGLCurrencyCollection(ProviderConnection context)

at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ReportUnitProcessor.SetAccountStructure()

at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ReportUnitProcessor..ctor(ProviderConnection providerConnection, UnitProcessorKey unitProcessorKey, ReportProcessor reportProcessor)

at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ReportProcessor.SetUnitProcessor(ReportUnitResult reportUnitResult, UnitProcessorKey unitProcessorKey)

at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ReportProcessor.AssignToGLProcessor(ReportUnitResult reportUnitResult, Guid unitID, Guid linkControlID)

at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ReportProcessor.AssignOneUnitToProcessor(ReportUnitResult reportUnitResult)

at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ReportProcessor.AssignUnitsToProcessors()

at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ReportProcessor.SetupReportForRun()

at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ReportGenerator.ProcessReport(Definition definition, Action`1 resultHandler)

at Microsoft.Dynamics.Performance.Reporting.Engine.Server.EngineController.GenerateReport(Action`1 resultHandler)

at Microsoft.Dynamics.Performance.Reporting.Engine.Server.EngineController.Run(NativeReport repositoryReport, Definition definition)

at Microsoft.Dynamics.Performance.Reporting.Scheduler.ReportRunner.RunReport(String reportDefinitionXml, Guid repositoryId, Guid generatedByPrincipalId)

What does all that mean? I'm reading it is something with multicurrency and exchange rates. But which company? Which currency? I'm running 20 companies, and five currencies. Where to go from here?

thanks in advance for assistance.

There unfortunately isn't a way to know which company the currency issue is coming from. Below are the steps to track down the issue:

***Please note that you must run the company-specific queries against every company that is returned for the following query***:

select INTERID, CMPANYID, CMPNYNAM from DYNAMICS..SY01500

--Valid currency IDs in the DYNAMICS database:

select CURNCYID, CURRNIDX, CRNCYDSC, ISOCURRC from MC40200

--Functional currency in company database:

select FUNLCURR, FUNCRIDX from MC40000

--Functional currency ID does not match the currencies in the DYNAMICS database. Run against the GP company database:

select * from MC40000 where FUNCRIDX not in (select CURRNIDX from DYNAMICS..MC40200)

If you are able to identify that the currency ID in the GP company database does not match the currency ID in the DYNAMICS database, you will want to log a case with the GP team to correct it.

Quick Links

Leaderboard