How to Add a Report to VBA in Dynamics GP

There were times when you need to modify a current report in Dynamics GP and add some VBA code to it. When you look at the Tools > Customize menu, you often wonder if you are able to add a current report to Visual Basic. Here you might think that, yeah, this is so not possible. But guess what? This print screen is actually very misleading. Even though you are not able to add the report from here, you can do it somewhere else.

How to Add a Dynamics GP Report to VBA

All you need to do is go to Report Writer and open up your selected modified report. Here my example is using the SOP Long Invoice Form.

How to Add a Dynamics GP Report to VBA

Now go to Tools. From here, you can add your report to Visual Basic by clicking the Add Report to Visual Basic option or pressing Ctrl+ F11.

How to Add a Dynamics GP Report to VBA

Once you do this, you should be able to see your report on the VBA Pane. In this case, you can see my SOP Long Invoice Form on the VBA Pane.

If you would like to add the fields that you would like to modify or manipulate, either Click Shift+ F11 or click on Add Fields to Visual Basic.

Please note that if you do add fields, you will have to go in to each field and add them one by one.

Once you have added the fields. You can see the fields in the drop down in the following example:

How to Add a Dynamics GP Report to VBA

And there it is, now you are ready to code away.

Have any questions about Dynamics GP? Contact our Dynamics GP team at any time.

By |2019-02-27T11:28:19+00:00February 27th, 2019|Dynamics GP, Technology, Tips & Tricks|0 Comments

About the Author:

Shirly Winy
Shirly Winy has been with Sikich for almost two decades. Her current role is Senior Technical Consultant. She specializes in application development, data migration and data integration. In her daily tasks, Shirly plans, coordinates, and executes software upgrades. She also serves as vital resource for Help Desk staff, overseeing daily support operations and aiding on complex trouble tickets.
This material has been prepared for general informational purposes only and is not intended to be relied upon as accounting, tax, or other professional advice. Please refer to your advisors for specific advice.

Privacy Information

We use cookies to personalize the website for you and to analyze the use of our website. Click 'Privacy Options' to configure how we can interact with you and your device or computer.

Privacy policy | Close
private equity services construction accountants Agriculture Services Construction Services Non-Profit Services Government Services