Can I customise a 3rd party form with Dexterity?

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

Over the last few weeks I have been asked a number of times about methods of customising a 3rd party form.  This purpose of this post is to clarify what can and cannot be achieved with Dexterity.

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

Hybrid – Adding Record Notes to a window Example

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

I spent this morning discussing a very interesting customisation with my good friend Mariano Gomez.  We had both seen a newsgroup posting asking if it was possible to add access to the Item Master’s record note from the Item Inquiry window using VBA. Mariano had told me that he wanted to see if he could do it and this morning sent me the first version of his code as a package.

Continue reading

Automating Distribution of Customizations Part 1

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

A long time discussion in the Microsoft Dynamics GP world is how to handle the distribution of customizations and updates. There are a number of approaches available and this article discusses the benefits and issues of the different configurations.

Continue reading

VBA – Adding Fields to VBA stops working

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

While working with Microsoft Dynamics GP v9.00, I have seen a situation where adding fields to VBA does not work anymore.  You can add windows and reports, but when adding a field they don’t show up on the project.

Continue reading

Modifier – Extending the length of a Field Example

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

The following VBA example extends the Reference field on the GL Transaction Entry window from string field of 30 characters to a text field of 200 characters.  The first 30 characters of the text field are populated into the original string field so it will contain data when viewed on a non-modified window or report.

Continue reading

Hybrid – Dynamically Populating a Modifier Added List Example

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

When using the Modifier to add a list field (drop down list, button drop down list, listbox, multi-select list box) to a window as a local field, the only option available to populate the list was to add static values.  This is because there is no functionality available in VBA to add items to a Dexterity list field.

Continue reading