Forget Last Logged User Name?!?!

Deep discussion between the GP experts was done through the days, and the simplest option was to remove “SQLLastUser” from DEX.ini and mark the DEX.ini “Read Only” as discussed in this article.

However, there were side effects on this solution and alternatives explained by David Musgrave, checkout his post here.

Regards,

Mohammad R. Daoud – CTO
MVP, MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

View Smart-lists with SQL Tables

Vaidy discovered a good security option in Smart List security! Are you having problems in displaying the data in your customized smart list sourced from SQL Tables? Checkout the below task:

image

Regards,

Mohammad R. Daoud – CTO
MVP, MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Dynamics GP – Account Level Security Setup

Have you ever wanted to activate the account level security but didn’t find the where to assign users to accounts? Well you will find the answer here, there is nothing line “Field Level Security” to link account to users, instead there is an organizational structure positions that linked to your accounts, and your users will be linked to the needed positions, below are the steps required to set this up:

1. Go to “Microsoft Dynamics GP menu >> Tools >> Setup >> Company >> Company” and activate the module by checking “Account Security”:

image

2. Go to “Microsoft Dynamics GP menu >> Tools >> Setup >> System >> Org Structures” and define your company positions:

image

3. Go to “Cards >> Financial >> Account >> Select an account >> Organization button” and link the accounts to the positions:

image

4. Go to “Microsoft Dynamics GP menu >> Tools >> Setup >> System >> User >> Select a user >> Organization button” and link the user to a position:

image

That’s it, Enjoy!

Regards,

Mohammad R. Daoud – CTO
MVP, MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com