Speeding up login by clearing the Menu Master table

The Menu Master table in Dynamics GP holds details of all the menu options to which users have access. Over time this table can accrue rogue entries that can slow down the login process, or even cause errors to be displayed.

Clearing Menu Master is a fairly simple process and is often scheduled in during an upgrade, or run on an ad hoc basis if it has become corrupt and is producing error messages when a user starts GP or switches companies. This recipe will show how to clear down Menu Master, which causes it to be rebuilt for each user as they next log in.

How to do it…

To clear Menu Master, follow these steps:

1. Make a backup of Dynamics GP.
2. Select the Microsoft Dynamics GP menu, and from there, pick Maintenance | Clear Data:
   
3. Click Display on the menu and then select Physical:
   
4. Select Menu Master and click Insert to add this item.
5. Click OK to run clear data.
6. A report will be produced showing any errors that occurred.

With Menu Master cleared...