Developing for Dynamics GP

by David Musgrave (Perth, WA, Australia) and the Microsoft Dynamics GP Developer Support Team (Fargo, ND, USA)

Browse by Tags

Tagged Content List
  • Blog Post: What is the Dynamic User Object Store (DUOS)

    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 SY_User_Object_Store), from SQL Server (SY90000...
  • Blog Post: Creating SQL Views of DUOS Data

    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. Below is...
  • Blog Post: Using VBA with Report Writer

    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 us to bypass many of the limitations of the...
  • Blog Post: Hybrid - Using Menus for Visual Studio Tools from VBA Example

    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 that would expose the Menus for Visual Studio...
  • Blog Post: Hybrid - Cheque Amount in Words Example

    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...
  • Blog Post: Modifier - Extending the length of a Field Example

    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...
  • Blog Post: Modifier - Sales Prospect DUOS Example

    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) to store the additional fields and captures...
  • Blog Post: Modifier & VBA Samples

    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) Modifier/VBA Samples for Microsoft...
Page 1 of 1 (8 items)