Browse by Tags
All Tags »
DUOS (RSS)
The Dynamics GP Blogster , Mariano Gomez, has written a great article on the Dynamic User Object Store (DUOS). One of the great things about the DUOS is that it is a table easily available for a developer to use however they want from Dexterity (table
Read More...
Visual Basic for Applications (VBA) can use the Dynamics User Object Store (DUOS) table to store additional data such as user defined fields. The SY_User_Object_Store (SY90000) DUOS table uses a single row for each field stored, It stores the data in
Read More...
Most people are aware that you can use Visual Basic for Applications (VBA) with Microsoft Dynamics GP forms and the Modifier, but not everyone is aware that VBA can be used with the Report Writer as well. In fact using VBA with the Report Writer can allow
Read More...
After the release of Menus for Visual Studio Tools for Microsoft Dynamics GP 10.0 , my good friend Mariano Gomez asked me if it was possible to use the tool to add menus from Visual Basic for Applications (VBA). Mariano was initially working on an approach
Read More...
One of the Report Writer functions added to v7.00 onwards (see Using the built-in Report Writer Functions ) was the RW_ConvertToWordsAndNumbers() function to convert a currency amount into words. After the code was added, it was realised that Report Writer
Read More...
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
Read More...
The following VBA example adds two additional fields to the Sales Prospect Maintenance window and Sales Prospect Report. The Modifier was used to add the additional local fields, and then VBA code added. The code uses the DUOS (Dynamics User Object Store)
Read More...
This page contains a summary list of the Modifier & VBA samples that have been posted. Official Samples from CustomerSource/PartnerSource Modifier/VBA Samples for Great Plains 8.0 (CustomerSource) Modifier/VBA Samples for Great Plains 8.0 (PartnerSource)
Read More...