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

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Cleaning up the syMenuMstr table

(0) ShareShare
ReportReport
Posted on by 245

I have duplicate entries in the syMenuMstr (sy07110) table and i have deleted all of the entries for my product id. I have login and these menu items are not being repopulated.  Is there another step in this process? I was working on the assumption that if you deleted all entries related to a product id in this table, the login process will rebuild menus for that product id.

*This post is locked for comments

I have the same question (0)
  • Jonathan Fear Profile Picture
    on at
    Re: Cleaning up the syMenuMstr table

    Hey Jason,

    If I understand you correctly you are missing toolbars when you log into GP. These are actually controlled in table SY07125. You can delete the records from this table and the records will be recreated when the user logs back into GP. You can use the following script to remove the records:

    DELETE FROM DYNAMICS..SY07125 WHERE USERID='UserName'

    DELETE FROM DYNAMICS..SY07121 WHERE USERID='UserName'

    I have seen the toolbar still missing after deleting records from this table. This is caused by the template records not being correct in the SY07125. If running the scripts above don't resolve the issue run the following scripts and let me know the results.

    SELECT * FROM DYNAMICS..SY07121

    SELECT * FROM DYNAMICS..SY07125

    Thanks,

    Jonathan Fear

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans