I have seen this question come up multitude of times on public newsgroups and forums. In fairly large Dynamics GP installations, Navigation Bar shortcuts tend to be deployed in a standard fashion for groups of users at a time, this is, to ensure all users have the same set of options to perform their functions, or access to company documents, etc. With this in mind, it is very common to setup one user’s shortcuts and wanting to replicate these across other Dynamics GP user accounts. Unfortunately, there isn’t a facility in GP to allow this.
The following T-SQL script allows you to copy the Navigation bar shortcuts from one user to another:
You can enhance this script by adding your own transaction commit and rollback features or use as a mechanism to ensure users do not change their shortcuts based on a template user ID. The options are many.
Until next post!
Mariano Gomez, MVP
Maximum Global Business, LLC