Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / power user does not se...
Microsoft Dynamics GP (Archived)

power user does not see chart of accounts in lookup

(0) ShareShare
ReportReport
Posted on by Jae Chang 2,305

Hello,

I have an issue where a new user has been created with power user privilege. I am logged into the correct company. I can access everything and even Financials,Cards,Accounts, and click on the lookup but nothing shows. The top left drop down option is checked for "All Accounts".

I've tried scrolling up and down thinking it would show, I've tried deleting the user and re-creating the user, unchecking power user and saving and rechecking power user and saving, I've run the grant.sql script in SQL.

I'm not sure what is happening. Has anyone run into this issue before?

TIA,

Jae

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: power user does not see chart of accounts in lookup

    I do not have many clients using that and would not have thought of it. Glad it is all figured out now. Good work!

  • Verified answer
    Jae Chang Profile Picture
    Jae Chang 2,305 on at
    RE: power user does not see chart of accounts in lookup

    I figured out the issue. The clients have setup an organization structure assignment but is not using it correctly.

    Thanks for the help and quick responses Richard.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: power user does not see chart of accounts in lookup

    Try going to Tools->Setup->System->Alternate Forms and Reports and select the ID assigned to this user. Select Dynamics as the Product and Windows as the Type and then Financial and Account. Toggle back and forth between Dynamics and Smartlist to see if you can either one to work. Also, under Tools->Setup->System->User Security make sure you have the correct Modified Forms and Reports ID selected for this user for all companies.

  • Jae Chang Profile Picture
    Jae Chang 2,305 on at
    RE: power user does not see chart of accounts in lookup

    I just created another separate user "tester" with gave it power user permissions but I'm not able to see anything when I click on Financials, Cards, Accounts, lookup glass. When I switch to the test company, I can see all the accounts.

  • Jae Chang Profile Picture
    Jae Chang 2,305 on at
    RE: power user does not see chart of accounts in lookup

    No spaces, the user id is in the format John Doe = johnd.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: power user does not see chart of accounts in lookup

    Does the GP user ID have spaces or any other reserved characters? If create a new account for this user try something basic and assign the same privileges.

  • Jae Chang Profile Picture
    Jae Chang 2,305 on at
    RE: power user does not see chart of accounts in lookup

    Richard, if you look at my 1st post, I've tried all of your suggested already.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: power user does not see chart of accounts in lookup

    First, try logging out of GP and then back in as this new user. If that does not correct the problem try running the grant.sql script in SSMS and if that does not work unlick PowerUser, save the setting and then click PowerUser again. If all else fails, drop the user completely and start over again.

  • Jae Chang Profile Picture
    Jae Chang 2,305 on at
    RE: power user does not see chart of accounts in lookup

    I forgot to include that his is for GP 2010 and GP is launched from Windows Server 2008 R2. I am able to see the chart of accounts as sa or any other user that has the appropriate permissions. It is just with the newly created user that is having the issue.

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