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.
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
PLEASE READ BEFORE POSTING
Please only post comments relating to the topic of this page.
If you wish to ask a technical question, please use the links in the links section (scroll down, on right hand side) to ask on the Newsgroups or Forums. If you ask on the Newsgroups or Forums, others in the community can respond and the answers are available for everyone in the future.