Where are Dynamics GP’s Business Rules Defined and Enforced?

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

In a recent forum post, the question of where the business logic for Dynamics GP resides was raised.  This is an excellent question which, sadly, does not have a simple answer.

Continue reading

Understanding how Microsoft Dynamics GP works with Microsoft SQL Server continued

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

As a followup to last week’s post about Understanding how Microsoft Dynamics GP works with Microsoft SQL Server, I am adding a few more topics about why Microsoft Dynamics GP works the way it does with Microsoft SQL Server. So here goes ….

Continue reading

Understanding how Microsoft Dynamics GP works with Microsoft SQL Server

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Many people who have not been working with Microsoft Dynamics GP since the early non-SQL versions of Great Plains Dynamics sometimes wonder about the way that the application works with Microsoft SQL Server.

Continue reading

How to Play a Sound File with Dexterity

Dave Duesk - Click for blog homepageThis is a reposting of an article Dave Duesk originally wrote on my Developing for Dynamics GP blog.

This is really an extension of the blog article that David Musgrave wrote VBA – Welcome to Dynamics Example, but instead of using VBA to play the sound file, we are using Dexterity. The same method is called in the winmm.dll, but this is just the Dexterity way to do it. I didn’t include trigger information on this because you could really put this anywhere.

Continue reading

Dexterity and Double Byte Languages

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

From the Translating Dexterity Applications Series.

During the course of this series we have discussed how you can change terminology, or even the entire language of a Dexterity application.  We have discussed flipping the windows for languages that read from right to left.  We have also discussed using languages which have different character sets.

Continue reading

What do the zDP_ Auto Generated Stored Procedures do?

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

If you look at a SQL Server installation of Microsoft Dynamics GP, in the Stored Procedures folder underneath the Dynamics system database or a company database you will find a large number of stored procedures starting with the initials”zDP”. This article explains what the zDP stored procedures do and why they exist.

Continue reading

Why does Microsoft Dynamics GP encrypt passwords?

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Why doesn’t the password I use for Microsoft Dynamics GP work for me to access the data in SQL from <insert application name here>?

Why does my password sometimes fail to work from one workstation when it works from another?

Why does the password policy feature only allow one failed attempt before locking me out?

Why is the User ID case sensitive on Microsoft Dynamics GP v10.00?

What is the Password field in the SY_Users_MSTR (SY01400) table used for?

Can I use my Windows or Active Directory Login to access Microsoft Dynamics GP?

I hope to answer all these questions and more by explaining the password encryption that is used by Microsoft Dynamics GP for all users except ‘sa’.

Continue reading

VBA – Welcome to Dynamics Example

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

For those of you who have been involved with the Great Plains product for a while, you will remember the “Welcome to Dynamics” wave that played when the application was launched. Well, if you want that functionality again, you can use VBA to add it back.

Continue reading