This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The Dynamics GP Blogster, Mariano Gomez, has written a great article on the Dynamic User Object Store (DUOS).
DUOS
Creating SQL Views of DUOS Data
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
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 a string field 132 characters long.
Using VBA with Report Writer
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
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.
Hybrid – Using Menus for Visual Studio Tools from VBA Example
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
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).
Hybrid – Cheque Amount in Words Example
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
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 calculated fields of return type string are limited to 80 characters. This means that if your amount in words is longer than 80 characters, only the first 80 characters will be returned and the rest will be truncated and lost.
Modifier – Extending the length of a Field Example
This 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.
Modifier – Sales Prospect DUOS Example
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The following VBA example adds two additional fields to the Sales Prospect Maintenance window and Sales Prospect Report.