I added a new user with power user access in Dynamic GP 10, but this user is getting no data running Financial reports. Other GP users with the same access (Power User) is having no problems running these reports. Help!
*This post is locked for comments
Thanks Mike, but I tried this scenario before and it still didn't work. I'll give it another try and let you know what happen. Maybe I didn't follow the correct delete process. Here is how I deleted the user:
Open SQL Server - Go to Security-->Login-->Right Click on User---->Delete User
Thank you for your help!
I have experienced similar issue (in GP 2016) for even adding a regular user, who could not work properly. I found it odd and simply removing the user and recreating it resolved the case. I have been able to reproduce this scenario over and over.
It seems some glitches during user creation causes the problem.
I call it as common phenomenon of Microsoft, (if Microsoft does not work, restart it, it will work)
added sysadmin role for new user, same results.
Please follow the below steps and try to run the report.
1.Open Sql Server
2.Go to Security-->Login-->Right Click-->New Login
3.Add Windows user(who are all accessing GP via remote desktop to the GP server)
4.Select Server Roles and provide public
5.Select User Mapping and Provide DYNGRP,public role for Company databases
6.Try to run the report
I am able to pull down data using sa user. Other power users in the office are able to pull data running the same reports.
Yes, these reports are within GP and they are the Financial Reports.
Also, this user is accessing GP via remote desktop to the GP server. Other end users, using client based and Remote desktop connection with power user access are able to pull down data in the reports.
Thank you.
Leon,
Could you elaborate on which reports the user is having trouble with? If it is reports within GP I suspect the user is not set to use the correct report dictionary.
Kirk
I deleted and recreated the user as you suggested and it did not work. I still cannot pull data to the financial reports. Do you have any other suggestions?
Thanks in advance for you help.
Share
Report
All responses (
Answers (
592