Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Cannot drill to Dynamics GP2010 from Management Reporter 2012 with user who does not have Admin. rights.

Posted on by 250

Users who have Administrative rights can succesfully drill to GP from the Account Level window but users who are normal users cannot. The "Drill to Dynamics" just goes blank and nothing happens. With an Admin user it opens the Account Detail window in GP.

What files, if any, does a local user need Write access? All users have Read Access to the GP2010R2 folder.

 

*This post is locked for comments

  • April Olson Profile Picture
    April Olson on at
    Re: Cannot drill to Dynamics GP2010 from Management Reporter 2012 with user who does not have Admin. rights.

    Hello Terry,

    Because we are not aware of the issue, it may be a good idea to open a case with support so they can troubleshoot it.

    When a user drills back, a file is copied from the Management Reporter server to the local client's Management Reporter folder. This invokes the drill back. You could try and rename the file locally, perform the drill back, and see if the new file is getting copied. If it is, then the work on the Management Reporter side should be complete and then the URL is being called to GP at that point. For GP, I do know it is cacheing the company name. So the folder to which the .dll gets copied and the cache/registry setting are the only two areas I know of that a user needs to have access to.

    The .dll that is copied should have the term navigation in it. It would probably be best to step through this with support so they can help troubleshoot.

    Thanks,

    April

  • Terry Bolden Profile Picture
    Terry Bolden 250 on at
    Re: Cannot drill to Dynamics GP2010 from Management Reporter 2012 with user who does not have Admin. rights.

    No. SP3 is not applied. Only SP2.

    The Drill Down works with an Administrator but not with a normal user. Surely there must be a log that tells you what is happening when the Icon just goes blank.

  • Re: Cannot drill to Dynamics GP2010 from Management Reporter 2012 with user who does not have Admin. rights.

    Did you apply SP3 for GP 2010? If so that is a bug we are currently working on resolving.

  • Verified answer
    Terry Bolden Profile Picture
    Terry Bolden 250 on at
    Re: Cannot drill to Dynamics GP2010 from Management Reporter 2012 with user who does not have Admin. rights.

    Hi April

    I have tested making the user a member of the Administrators group on the client and still no joy. Some further comments below.

    Terry

    From: Microsoft Dynamics GP Forum [mailto:dlcommed@microsoft.com]

    Sent: Wednesday, 27 June 2012 4:31 AM

    To: terrybolden@hotmail.com

    Subject: Re: Cannot drill to Dynamics GP2010 from Management Reporter 2012 with user who does not have Admin. rights.

    Re: Cannot drill to Dynamics GP2010 from Management Reporter 2012 with user who does not have Admin. rights.

    Replied to by April Olson

    Hello Terry,

    I am assuming you mean Administrative rights on the local workstation and not within Management Reporter or Dynamics GP?

    When the user tries to drill to Dynamics GP, is the icon disabled from the beginning, or after the user tries and clicks on it?

    When you click once on the amount the Icon is enabled but when you click the Icon it goes Blank. No Error Message, nothing in the Event Log. The Icon Remains Greyed even if you select another item in the tree.

    There is one issue that if the user tries to drill back to a company in GP that is different from when they first opened GP and signed in, it will not work. This issue will be resolved with a future GP service pack.

    No Logged in to the same company and can select and view Financial/Enquiry/Detail

    As long as the user can open GP, sign in, and open the Detail Inquiry screen, they should be able to drill to Dynamics GP as we are using a URL from the GP team.

    If you check the above and still have the issue, please also check to see if there is an error in the Event Viewer.

    Nothing in the Event Viewer but did manage to  force an entry by logging in to Windows as Domain Administrator and GP as a Local user. The entry was

    System.ServiceModel.FaultException`1[Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceFault]: The connection to the Microsoft Dynamics GP database failed. Contact your system administrator. (Fault Detail is equal to Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceFault).

    This error was when the Windows User Nanotechsys\TBolden was not a member of the local Admin Group. After making TBolden a member of the Admin group the Icon just goes blank when you click on it.

  • April Olson Profile Picture
    April Olson on at
    Re: Cannot drill to Dynamics GP2010 from Management Reporter 2012 with user who does not have Admin. rights.

    Hello Terry,

    I am assuming you mean Administrative rights on the local workstation and not within Management Reporter or Dynamics GP?

    When the user tries to drill to Dynamics GP, is the icon disabled from the beginning, or after the user tries and clicks on it? There is one issue that if the user tries to drill back to a company in GP that is different from when they first opened GP and signed in, it will not work. This issue will be resolved with a future GP service pack.

    As long as the user can open GP, sign in, and open the Detail Inquiry screen, they should be able to drill to Dynamics GP as we are using a URL from the GP team.

    If you check the above and still have the issue, please also check to see if there is an error in the Event Viewer.

    Thanks,

    April

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