Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Management Reporter 20...
Microsoft Dynamics GP (Archived)

Management Reporter 2012 UR6 (or CU6) - General Question

(0) ShareShare
ReportReport
Posted on by James Rodrigues 1,180

Hi All -

Just checking to see if anyone knows the answer to this question:

Does MR2012 RU6 (CU6) require that each imported GP Company has a functional currency and each functional currency has an associated ISO Code regardless of if you are using the GP Legacy connection or a Data Mart?

I only ask this as it appears that functional currency/ISO codes now seem to be required when using RU6 with the GP Legacy connection. In RU5 this was only required if you were using a Data Mart. Any clarification on this would be very helpful.

Cheers,

James.

*This post is locked for comments

  • Suggested answer
    Rick Lunt Profile Picture
    Rick Lunt 20 on at
    RE: Management Reporter 2012 UR6 (or CU6) - General Question

    the issue repeatedly is due to multi-currency setup, or lack thereof.

    Why this is not summarized elsewhere is bewildering. due to the large numbers of requests for this error, is is puzzling why MS does not fix this or publish a KB.

    It behooves everyone to do this BEFORE running the Migration Wizzard. you'll avoid a lot of crashes

    So here is what I've done on 3 occasions to resolve this:

    a) in <Microsoft Dyanamics GP><Tools><Setup><System><Multi-currency access>

    ensure all your companies have access to the currencies you are using.

    b) in <Microsoft Dyanamics GP><Tools><Setup><System><currency>

    ensure all currencies have an ISO code. Anything will suffice, the field cannot be blank. I used the 2 or 3 digits of the currency eg: USD for US dollars, and EUR for Euro, etc.

    c) Run check links on the System - both Multi-currency entries

    d) in <Microsoft Dyanamics GP><Tools><Setup><Financial><Multicurrency>

    Select a functional currency and then exit - you'll be asked to run Check Links on the 'Financial - Multicurrency setup' group. I did all three as a CYA.

    repeat step d)  for each company

  • john doel Profile Picture
    john doel 335 on at
    RE: Management Reporter 2012 UR6 (or CU6) - General Question

    I can confirm that I ran into this exact same issue upgrading from MR2012 RU4 to CU6 with legacy GP connection (not data mart).  I saw the same errors in the service log so applied a functional currency to each GP company and the issue went away.  Presumably, having a functional currency when using the GP legacy connector is now a requirement (or a bug introduced with CU6).

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter 2012 UR6 (or CU6) - General Question

    Hello,

    I had this same issue using the legacy on RU6 and I had to apply a functional currency.  It looks like the requirement has been added to the legacy provider as well.

    Thanks!

    DFC Consultants

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Management Reporter 2012 UR6 (or CU6) - General Question

    Please check out this KB to see if it fixes this issue.

    support.microsoft.com/.../2792806

  • James Rodrigues Profile Picture
    James Rodrigues 1,180 on at
    RE: Management Reporter 2012 UR6 (or CU6) - General Question

    Hi Richard -

    Thank you for the follow up. I thought this was the case. The only puzzling thing is that when I recently installed MR 2012 RU6 with a legacy connection I get an error whenever I try to open a Column Definition, I get the following error which seems to imply that their is a functional currency error:

    “The operation could not be completed due to a problem in the data provider framework.”

    “Value cannot be null. Parameter name: source”

    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

    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

    System.ServiceModel.FaultException`1[Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceFault]: The operation could not be completed due to a problem in the data provider framework. (Fault Detail is equal to Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceFault).

    One note is that this was after a migration from FRx and the GP Company does use Analytical Accounting.

    Have you seen this error before and if it does have to do with Functional Currency not being set up (and ISO codes not being assigned) then why is it occurring with a Legacy connection?

    Cheers,

    - James.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Management Reporter 2012 UR6 (or CU6) - General Question

    In order ro install data Mart for MR 2012 RU6 you must define the functional currency as well as ISO code for that currency. If you are not using the Data Mart you will not need the ISO code.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans