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.
I have tested making the user a member of the Administrators group on the client and still no joy. Some further comments below.
From: Microsoft Dynamics GP Forum [mailto:email@example.com]
Sent: Wednesday, 27 June 2012 4:31 AM
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
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.
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.
Did you apply SP3 for GP 2010? If so that is a bug we are currently working on resolving.
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.
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.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13