How to display EURO Currency symbol in Dynamics GP?

 

Looks an easy question right? Go to Microsoft Dynamics GP menu >> Tools >> Setup >> System >> Currency >> Currency expansion button and select the € symbol!

Well not that’s easy, if you had languages other that the English or your collation for SQL is not Latin you will get the below:

image

This symbol actually represents the Euro currency symbol, select this symbol and go try to print a report, you will find the symbol there:

image

Enjoy!


Regards,

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

MVP for another year!

 

I like that feeling when receiving the same mail from Microsoft! Informing me about the MVP award renewal.

Glad that I made it, thank you all for your support.


Regards,

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

Microsoft Dynamics Salary Survey 2012

 

Banner Large

Nigel Frank International would like to invite you to complete our annual survey of global Microsoft Dynamics salaries. The survey will only take a couple of minutes to complete and your response and any personal details will be kept strictly confidential.

Complete the survey by the closing date and you will automatically be entered into our prize draw to win one of five amazing prizes:

1st Prize = Apple iPad2 16gb with Wi-Fi + 3G

2nd Prize = Microsoft Xbox 360 250gb + Kinect

3rd Prize = Kindle Keyboard with Free 3G + Wi-Fi

4th Prize = Microsoft LifeCam Studio Webcam

5th Prize = Microsoft Arc Touch Mouse

You will also receive a FREE copy of the Salary Survey report once it has been compiled.

Please click on the following link to complete the Microsoft Dynamics Salary Survey 2012:

http://survey.nigelfrank.com/en/microsoft-dynamics-salary-survey-2012.html

The survey is available in 12 languages for your convenience.


Regards,

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

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

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

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

The Most Influential People in Microsoft Dynamics for 2011

 

I don’t know how the folks of DynamicsWorld evaluates the votes nor how they rank, but I am ranked #38 in the list! Below what they used to rank:

We base our selections on a number of criteria including: Number of nominations received; Number of Microsoft Dynamics employees employed; Number of clients your ISV/VAR has; As an end user how many user licences taken; Social Media Followers (bloggers/twitter/ linkedin) (bonuses for group owners); Number of years experience of Microsoft Dynamics; MVP Recipients; Developers of Add-Ons and new verticals; Speakers and writers about Microsoft Dynamics; Forum contributors and Number of votes received. We attempt to limit what can actually be described as a sphere of influence. The advantage that we have had in quantifying influence in Microsoft Dynamics is that we are dealing with a group of people with similar interests, and so it is possible to be able to quantify one persons influence over the group against another person’s influence.

Many known names were listed, Erik Ernst was listed on rank 13, while Mark Polino was ranked 16, Mariano Gomez ranked 30, Leslie Vail was ranked 68, Steve Endow was ranked 79 and Victoria Yudin was ranked 85.

Below is the complete list:

http://www.dynamicsworld.co.uk/top-100/

On the other hand, it worth to mention that I couldn’t find many other names that really have huge influence on Dynamics.

Regards,

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