New User Access

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (11)

Answers (0)

Sort by

Kumar_Sat 1,290 on at

Like (0)

Report
Copy link

Link copied!

Have you granted access to the company for this user? If yes and still not working, then I would recommend delete the user and recreate it.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

KirkLivermont 5,985 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Jeyakumar 592 on at

Like (0)

Report
Copy link

Link copied!

Try to run the report using sa user.Because Power User does not have all rights in GP as SA does.Please try and let me know.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Jeyakumar 592 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Jeyakumar 592 on at

Like (0)

Report
Copy link

Link copied!

Still if you are facing same issue,For testing Purpose Open Sql Server-->Select Newly Added Windows user-->Provide sysadmin role in under Server Roles.Try to run the report and let me know.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

added sysadmin role for new user, same results.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No