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.
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 the Save, Read and Delete events to keep the data synchronised. Additional business logic has been added to prevent deleting of a hot prospect.
This example code can be re-used in other windows as the basis for storing user defined fields.
Example code for v8.0, v9.0 & v10.0 is attached at the bottom of the article.
Please see the “Installation Instructions.txt” file in each version’s archive for more information.
David
This article was originally posted on the Developing for Dynamics GP Blog and has been reposted on https://www.winthropdc.com/blog.
PingBack from http://blogs.msdn.com/developingfordynamicsgp/pages/modifier-vba-samples.aspx
Most people are aware that you can use Visual Basic for Applications (VBA) with Microsoft Dynamics GP
Over the last few weeks I have been asked a number of times about methods of customising a 3rd party
This looks great
If you use this can you report on the values using Sql RS or crystal?
Is there a table the information is stored in?
Hi Wayne
Each item of information will be stored as a single record in the SY_User_Object_Store (SY90000) DUOS table.
You can create a view of the data and add it to the original table so it looks like part of the original data.
This is a great topic for another post. Keep watching the blog and I will get something published soon.
Thanks
David
Visual Basic for Applications (VBA) can use the Dynamics User Object Store (DUOS) table to store additional
Visual Basic for Applications (VBA) can use the Dynamics User Object Store (DUOS) table to store additional