Microsoft Dynamics GP 2013 R2: VBA and the Action Pane

Lucas Miller - Click for blog homepageThis is a reposting of an article Lucas Miller originally wrote on my Developing for Dynamics GP blog.

Hello!

I just want to first take a second to introduce myself since this is my first post on the Developing for Dynamics GP blog.  My name is Lucas Miller and I’ve been supporting Microsoft Dynamics GP since 2005.  Like much of the team I’m based out of Fargo, ND, USA.  I’ve been married for almost 2 years and my wife and I are expecting our first in just under 3 weeks as of this writing.  My main focus has been on the system side, but the last couple years I’ve been focusing on import tools (e.g. Integration Manager and eConnect) and I was deeply involved in the Dynamics GP 2013 Web Client development and readiness efforts.

We’ve recently seen a couple questions on both the community forums and in support cases regarding the ability to add resources that are contained in the new Action Pane that was introduced in GP 2013 R2, to VBA.

When you go to Microsoft Dynamics GP > Tools > Customize > Add Fields to Visual Basic… you will see that your mouse cursor changes to symbolize you are now adding fields to VBA rather than simply selecting them.  The problem arises when you hover over a button on the Action Pane, for example the Save button.  You’ll notice that the cursor changes back to an arrow.  You’re not allowed to add the field to Visual Basic, which can certainly hinder customizations that many of our customers and partners want to create.

The solution that we’ve found for this issue is to go to the Microsoft Dynamics GP > User Preferences window and change the Window Command Display option to Menu Bar.

 

You then need to log out and back into Dynamics GP to finalize this change.  You are then able to add your buttons to VBA just like you could in previous versions.  Just to refresh your memory, here’s what the Action Pane looks like:

And here’s the Menu Bar:

This change should only be required to get the fields into VBA initially.  After the development task has been completed the customizations should work the same for users who are using Menu Bar, Action Pane Strip or Action Pane.

Hope this helps for those of you who are looking into Visual Basic to meet your customization needs in Dynamics GP 2013 R2!

Enjoy!

Lucas

This article was originally posted on the Developing for Dynamics GP Blog and has been reposted on http://www.winthropdc.com/blog.

4 thoughts on “Microsoft Dynamics GP 2013 R2: VBA and the Action Pane

  1. Thank you!  I'm recreating all my customizations on my test server in preparation for an upgrade to GP2013R2, and I just had an "oh crap" moment when I realized this.  Thanks for sharing your simple solution!

    Like

  2. Hi Eric
    If you export your packages from the previous version and import them into GP 2013 R2, they will still have the same toolbar buttons exposed top VBA.
    You only need to disable the ribbons if you want to add new toolbar buttons.
    David

    Like

Please post feedback or comments

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.