web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

The 'sa' user has lost half the menu options

(1) ShareShare
ReportReport
Posted on by 75,848 Moderator

Well here is a new one. We have a client whose 'sa' user has lost half of the menu options. For example, there is no Tools->Utilities. Usually I would drop the user and recreate it but that cannot be done for 'sa'. How do I restore all the menu options for 'sa'?

I have the same question (0)
  • Suggested answer
    Derek Albaugh Profile Picture
    on at

    In the SY07121 and SY07125 tables, there are records for the USERID = ''. These are the defaults that are given to the sa and non-sa users. If these defaults are missing or incorrect, it could cause menu items to be missing in the Dynamics GP application when users login.

    When I look at my GP 18.3 system, in the SY07121, the USERID of '', sa and all other users, have 11 or so records each.

    In the SY07125 table, the '' userid has 42 records, as do the sa and all other users.

    **NOTE: This is with all U.S. modules installed, so your tables may have different amounts of records.

    What we'll usually do, after backups are made, is delete the records in these two tables for the blank user and any 'bad' users, as by doing this, the system rebuilds them the next time someone logs into the GP application.

    I would start with these two tables to begin........

    Thanks

  • Richard Wheeler Profile Picture
    75,848 Moderator on at

    As usual you are correct. These tables had almost no records in them for 'sa'. I went to User Security and set 'sa' to AP clerk and clicked Save. I then pulled up 'sa' again and assigned PowerUser and clicked Save and all returned to normal.

  • Suggested answer
    Derek Albaugh Profile Picture
    on at

    Should I admit to luck, or knowledgeable guess? lol

    Happy to hear that resolved it for you.

    Have a great day.

  • Richard Wheeler Profile Picture
    75,848 Moderator on at

    I was pretending to be one of our users. Just keep pushing buttons and selecting menu options and hope for the best.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 611 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans