I spent this morning discussing a very interesting customisation with my good friend Mariano Gomez. We had both seen a newsgroup posting asking if it was possible to add access to the Item Master's record note from the Item Inquiry window using VBA. Mariano had told me that he wanted to see if he could do it and this morning sent me the first version of his code as a package.
After a long messenger chat and a few ideas from me, he came up with a streamlined version and posted it on his blog. For the full story and a very detailed step by step instructions please see his post here. During the day today I made some fine tuning changes to his v10.0 code and created packages for versions 8.0 and 9.0 as well as version 10.0.
This VBA example shows it is possible to add access to record notes from a window using Modifier to add the fields and VBA scripts with passthrough Dexterity sanScript to make it work as though it was an original part of the window.
By using the Continuum Integration Library from VBA we were able to access the 'Note Index' value from the IV_Item_MSTR table buffer and also leverage the Note_Button and Check_For_Note Dexterity global procedures to re-use some of the standard Microsoft Dynamics GP code.
NOTE: This customisation uses a method of executing Dexterity sanScript code from VBA which is unsupported by Microsoft.
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
Dave (and Mariano!),
This code is exactly what I've been looking for. It works great! How can I modify it to work on the Service Call Entry/Update window in FieldService to do the same thing for the Tech ID Notes? We are using v10.0. Any input would be much appreciated.
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.