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.