I have been asked a number of times about some of the Modifier with Visual Basic for Applications (VBA) customizations featured on my blog and those over at Developing for Dynamics GP. It's no secret that I co-author a number of development posts with my friend David Musgrave in the spirit of educating and delivering some of the best articles to the end-user and development communities alike.
In light of this, this week I will deliver a 3-day Online Modifier with Visual Basic for Applications workshop, featured right here on this blog, that will step through a real-life customization from end to end.
What you will need
For the workshop, you will need a registered copy of Microsoft Dynamics GP v10, the Fabrikam sample company, and familiarity with the overall Dynamics GP navigation.
This workshop assumes you have some familiarity with Modifier and have prior programming experience in Visual Basic or any other development environment. If you are an end-user just looking to understand some of the advance Modifier principles, tag along and why not, try it for yourself.
I love the newsgroups because they address real-life situations faced by real-life individuals. In this post, the developer wants to add a VBA customization to the Equipment Maintenance window in the Field Service module, which requires opening the Customer Lookup window, a part of the Smartlist dictionary. The goal is to return the Customer Number from the lookup window to a custom field added to the Equipment Maintenance window. This custom field is used to track a regulatory entity setup as a customer. The customization will need to store the regulatory entity associated to the equipment.
- Workshop Day 1- Adding custom fields and lookups to a window (Monday, March 2). This session will explore adding the Regulatory Agency field and a lookup button and a zoom button to the Equipment Maintenance window in Field Service. The lookup window will call the Customer Lookup and the zoom button will drill down to the customer maintenance window.
- Workshop Day 2 - Setting up the VBA project (Wednesday, March 4). This session will address how to add all the necessary elements of this project to Visual Basic for Applications.
- Workshop Day 3 - Adding the VBA code to the project (Friday, March 6). This workshop session will show how to "wire" all the elements to deliver the final working solution.
NOTE: All links will become available at 8:00 AM EST (GMT -5:00) on the date the article is schedule to post.
Until next post!
Mariano Gomez, MVP
Maximum Global Business, LLC