Problem Adding Fields To VBA in Microsoft Dynamics GP 2013 R2

Microsoft Dynamics GPI had a colleague (actually the First Minion, Erebus) using Modifier with VBA to create a customisation of the Account Maintenance window (Financial area page » Cards » Account) in Dynamics GP 2013 R2 (for a client who does not and will not be using the web client). This customisation required a small number of fields and the save button to be added to VBA.

When he was adding the fields everything was fine, but as soon as he tried to add the save button the cursor changed to a standard one and did not allow the save button to be added. Microsoft Dynamics GP 2013 R2 saw the introduction of the action pane (or ribbon bar as I keep on calling it):

Account Maintenance action pane

This is the first time I’ve tried adding VBA to a button since GP 2013 R2 was released so I was slightly concerned to see this.

I was aware, however, that the action pane can be switched off so via the User Preferences (Microsoft Dynamics GP menu » User Preferences). There is a field half way down where you can toggle back to the Menu Bar:

User Preferences

We set this to menu bar, logged out of Microsoft Dynamics GP and back in and with the menu bar in Account Maintenance we were able to successfully add the Save button to VBA:

Account Maintenance menu bar

Half the battle was won at this point; VBA added and worked fine on the menu bar, but we needed to check that the VBA still worked on the action pane before we could declare victory. We reset the option in User Preferences, logged out of GP, back in and tested the customisation.

It worked which was good news. All we need to do is remember to make any VBA customisations with the menu bar active instead of the action pane.

What should we write about next?

If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.

Your Name

Your Email

Suggested Topic

Suggestion Details

Looking for support or consultancy with Microsoft Dynamics GP?

I no longer work with Microsoft Dynamics GP, but the last company I worked for was ISC Software in the UK; if you’re looking for support or consultancy services with Microsoft Dynamics GP you can contact them here.

2 thoughts on “Problem Adding Fields To VBA in Microsoft Dynamics GP 2013 R2

Leave a Reply

Your email address will not be published. Required fields are marked *