I recently joined Microsoft as a Partner Consultant for the Global Partner Services team. I have been associated for more than 8 years in the design, development and implementation of Microsoft Dynamics GP in India, Middle East and US. This is my first post in this blog and it feels great to be posting alongside community experts like David Musgrave, Patrick Roth and others.
Microsoft Dynamics GP offers the Account Level Security option to restrict the access of GL accounts to specific users. There is no specific report (or) Smartlist which is available for viewing the details of the accounts which each user has access to.
The script below gives us the details of the various users in the system and the accounts they have access to. If a user does not have access to any accounts, the user will not be listed in the results.
The script is also available as an attachment at the bottom of this post.
We could also create a view based on this script and then create custom Smartlists using Smartlist Builder.
Hope this helps the community...
Until next post!
// Copyright © Microsoft Corporation. All Rights Reserved.
// This code released under the terms of the
// Microsoft Public License (MS-PL, http://opensource.org/licenses/ms-pl.html.)