Creating SQL Views of DUOS Data

David Meego - Click for blog homepageThis 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.

Continue reading

Hybrid – Using Menus for Visual Studio Tools from VBA Example

David Meego - Click for blog homepageThis 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).

Continue reading

Hybrid – Cheque Amount in Words Example

David Meego - Click for blog homepageThis 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.

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