This is one of my favourite examples mainly because it achieves something that most people thought was not possible with VBA. To be honest, it still is not possible with VBA alone.  This hybrid code uses the unsupported method of calling Dexterity sanScript from VBA to use the Dexterity commands to select and change colours.

This example was demonstrated at the Microsoft Dynamics GP Technical Airlift 2008 to show how you can have a Microsoft Dynamics GP for Barbie release, see screenshot below: 

The Modifier is used to modify the form and create the additional buttons and fields needed.  Then VBA is used to add the scripting.  I created two VBA functions that do most of the work, SetColour and GetColour.  The SetColour function uses…

When logging into the Fabrikam sample company with Microsoft Dynamics GP, the current user date will be set to April 12, 2017 and you will be presented with a dialog with the following message:

You have chosen to use the sample company, which provides data that you can use to practice procedures or learn more about the product. When you use this sample company, the date is automatically set to April 12, 2017.

The ability to control the behavior of the user date for the Fabrikam sample company was added to…

Here’s the scenario. You have set up a Pilot environment, loaded all of your setups and master files, tweaked the settings, tweaked the master file setups, have your security perfect, entered some test transactions and are ready to go live. Well, you do not want to leave the test transactions in there, but you want everything else.

Where’s the Tool?

In my world, this scenario is a common event. I saw a question on the forum asking if there was some sort of tool that would strip out all of the…

David post an article about covering this section in the Support Debugging Tool, checkout…

In a new post by Leslie Vail, she looks at how to Delete all but Master Files in Dynamics GP. This could be a…