Dynamics GP Data Level Security

 

I am getting requests about this subject almost from all my customers, therefore we at Dynamics Innovations have decided to develop an add-on for Dynamics GP to fulfill this request a month ago and my development team is currently in the process of developing the final touches on the utility.

The add-on is basically works on creating new Dynamic lookup that replaces traditional Dynamics GP lookups, the same lookup is used for all kind of data inside Dynamics GP and the rows are filter dynamically at runtime based on user privileges which to be setup by creating a specific view for each user/role per each business entity and the system will display only data from the linked view:

image

By achieving this, the system administrator will be able to customize columns names and columns to be displayed by using SQL views or direct SQL queries and rows to be displayed, and the lookup will automatically filter rows using “like/contains” operator based on the user selection and based on the clicked column:

image

The data load were enhanced to load data into .Net data grid that pulls rows from database directly into the user interface, 250,000 records were pulled within less than 7 seconds:

image

In addition to the lookup functionality we have developed a routine that validates user inputs inside GP texts and will make sure that the user selected data is a part of the user query:

image 

The development team is currently working to enhance the navigation buttons as it might violates our security setup.

We been able to automate all the above processes and hanged with a couple of issues, the first is reports and the other is the smart list, and been able to handle smart list security by linking users view with smart list views using smart list builder, so each user will have his smart list configured, not an easy task but doable.

The last part is our challenge for the time being, we cannot figure out a solution for filtering report writer reports using available algorithms, we tried to pass restrictions fields to the reports using VBA but this wasn’t a sustainable solution, we still didn’t give up but we might not be able have this done.


Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Advertisements

What is ERP?

Guys,

For those who attended my session last week at Applied Science University, as promised kindly find below materials I presented during the session:

http://di.jo/presentations/What is ERP.pdf

http://di.jo/presentations/Microsoft Dynamics GP 2010 Modules.pdf


Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Microsoft Open Door 2011

 

Kindly note that Microsoft Jordan Open Door 2011 this year is on the 1st and 2nd of November 2011.

 

Venue: Sheraton Hotel, Amman.

 

Time: 8:30 AM- 5:00 PM.

 

For registration and further information kindly follow the link below:

Open Door 2011

Event Overview

Learn about the latest IT administration and management, software development and see how to solve actual business tasks.

The event is your chance to increase your knowledge, advance your skills and network with your local IT community as well as regional Microsoft and industry experts.


Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Microsoft Open Door Event

Guys,

For those who would like to meet and exchange business cards, I will be available at Microsoft Open Door event in Sheraton Amman – Jordan at Tuesday and Wednesday in the MVPs section to answer any inquiries you might have about Dynamics GP related issues.

Meet you there!

Regards,

Mohammad R. Daoud MVP – MCT
+962 – 79 – 999 65 85
me@mohdaoud.com
http://www.mohdaoud.com

– Posted using BlogPress from my iPhone

Exam Preparation Engine

 

I got an invitation from uCertify team to test their exams engine, I honestly enjoyed going through the engine they built and the way they do help exams attendees to pass the exams, not by the meaning of having actual exam questions which is exist! But instead by providing all the needed information about the exam subject from materials, study notes, question and answers and so on.

Unfortunately they still do not have exams for Dynamics GP nor Dynamics ERP’s, they have exams for CRM only.

I saw the below sections and liked it:

Study Notes Section:

A section with questions and answers for terms about the material you are working on:

image

How Tos Section:

Information about “How To”:

image

Learn and Practice Section:

This section contains practice exam questions and best answers, to help exam attendees pass their exam easily:

image

Enjoy studding guys and do not cheat the exams!

Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Dynamics GP Workflow – Workflow is incorrectly activated

 

Looks like it is the Workflows week! I been in a situation with one of my clients who also had an issue with the workflow, their “Vendors” been suddenly start requesting for approvals once they creates a new vendor and the below message shown on the left panel:

“Unable to Connect to Remote Server”

During the investigation I noticed that the vendor workflow was not activated in the workflow system! Which was very wired situation.

While digging into this I found that the setup they had for the Workflow is incorrect, they had the Microsoft Dynamics Workflow Location is different that the Office Server Location which made this error:

image

Fixing this miss resolved our issue!

Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Another Visit to Jeddah – KSA

 

Guys,

I am travelling to Jeddah after a couple of hours for long 5 days, if you would like to meet and exchange business cards, I will be normally in Break-time Café most of the time and my phone number below will be available all the time.

Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
www.mohdaoud.com