Migrating VBA Customizations to VS Tools for Dynam...

With GP 2013 web client around the corner, there is lot of buzz around what’s going to be supported with web client and what’s not. One of the things that not going to be supported in web client is VBA customizations. Therefore, its a good time to start upgrading your VBA customizations. 1. Planning: In vba, code is saved in *.vba files in GP folder. For each dictionary file there is a corresponding vba file. You have...

Authenticate Reprinting of Sales Documents in Micr...

Recently, a question was posted in the community about requiring users to enter a password before reprinting the sales document. I thought I ‘ll document in detail for future references. Steps for accomplishing this are Get the number of times invoice has already been printed In Sales Order Processing, you can use the following query to get number of times document was printed Select TIMESPRT from SOP10100 where...

Making A Custom Field Required using VBA

Steve Gray has written a useful post about Making A Custom Field Required using VBA code. He has written code for the Save Button Click event as well as for the dialog box that appears while closing the window.   Steve Gray’s code is applicable to most of the windows in GP. If you are looking for making PO number required refer to following post by Michael D Johnson II How to make PO field required for specific...

Setting default values in GP Windows

Sometimes, we need to enter a value in textbox or check on a checkbox every time (or most of the times) we use a window. Sometimes, we want to set a default value in a field to avoid users accidentally missing it. In this post, I am going to discuss following options that  you can use to set default values in GP windows. 1.  VBA 2. VS Tools 3. Extenders 4. Support Debugging Tool I am going to use the Paid Transaction...

Add data in AutoComplete list from third party app...

Suppose you need to enter data in a field in GP which already exists in some other application. You want users to add exact same values without any minor difference or spelling mistakes. For this kind of situation you can use the following code to add data in autocomplete list of a particular field in window in GP. I am using the dexterity method AutoComplete_AddStringValue for this which  Dave described in his post Adding...