Microsoft Dynamics GP 2013 R2: VBA and the Action Pane

This 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.

Import and Export for Office in GP 2013

This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.

A customer ran across an interesting issue with Excel Based Budgeting after they upgraded to GP 2013.

Quick Tip: Where does that customisation come from?

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I was recently asked about a custom button that was added to a window and how to change the internet URL that the button opened when it was closed. I was not provided with any other information or screenshots.

Quick Tip: Using fields named as reserved words with Visual Basic for Applications

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I had a case today that raised an issue that I have seen before which has a simple solution.

How to modify a field value in a line when generating the EFT file?

This is a reposting of an article Viswanathan Neelakantan originally wrote on my Developing for Dynamics GP blog.

I am a motivated and detail conscious graduate who is a certified Microsoft Dynamics GP consultant. I display considerable strength across a wide range of technical as well as functional skills in particular development, customization together with problem solving. I enjoy working within a team environment together with the challenge of carrying through individual tasks which has been experienced throughout my professional career in Dynamics GP, which spans six years. This is my first article in this blog and I am proud to be able to blog with the Dynamics GP gurus.

Customizations to the Cash Receipts (RM_Cash_Receipts) window failing for GP 2010

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I have had a number of support cases and newsgroup posts recently about Customization to the Cash Receipts (RM_Cash_Receipts) window failing to work for Microsoft Dynamics GP 2010 when they worked for previous versions.

Working with Vertical Lines in Report Writer

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

If you have ever used the SOP Blank Invoice Form or the POP Purchase Order Blank Form in Microsoft Dynamics GP, you will have seen the vertical lines on the report which make up the boxes around the various sections of the report.  This article explains how those vertical lines work and how to easily make changes to them.

Stored Procedure Executing In Wrong Database

This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.

We ran into an odd issue recently that I’d like to share today.

An ISV reported that in their customer was getting an error when the ISV application attempted to execute a stored procedure.

[SQL Server] Could not find stored procedure DYNAMICS.dbo.SomeStoredProcedure

Easy you say – the proc doesn’t exist.  Just create it and you’ll be fine.

Logging SQL with the Support Debugging Tool and 10 Free Add-ons

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

My friend, Mariano Gomez aka The Dynamics GP Blogster has a couple of recent posts I would highlight.

Using 3rd Party Series Reports in the Report Template Maintenance Lookup Window

This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.

A few weeks ago we ran into an interesting case regarding the new Word Report Templates in Dynamics GP 2010.

Errors when importing Customization Maintenance Packages

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Today, I had a support case that was asking about errors when importing a package via Customization Maintenance (Microsoft Dynamics GP >> Tools >> Customize >> Customization Maintenance).  The partner was unable to find an explanation of the errors on the Internet and so I thought I would explain what the errors mean and provide some best practices to avoid these issues in the future.

Increasing the Microsoft Dynamics GP 10.0 Homepage Font Size

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I was recently asked if it was possible to change the fonts on the Microsoft Dynamics GP 10.0 Homepage.  A customer had asked if they could be made a little bit bigger as they were hard to read at the resolution that the machine was running at.

Automating or Customizing the Report Destination Window

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I have seen this issue come up a number of times.  Trying to automate processes which involve reports and wanting to automate the Report Destination window.  Sometimes you can add the Report Destination to Visual Basic for Applications (VBA) and sometimes the system will not add the window to VBA.  This post will explain the reason for this “weird” behavior.

Handling Translation when Customizing with VBA

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

From the Translating Dexterity Applications Series.

The final topic in the series is one that was added later after I was asked about how to handle translated applications when writing customizations.

Customizing Microsoft Dynamics GP? 5 Excuses You Will Want to Bury Once and For All!

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Over the years that I have worked with Great Plains and Microsoft Dynamics GP, I have seen (and written) many customizations at customer sites. Some of those customizations are in the form of products to handle specific vertical markets or generic tools to enhance functionality. Some of those customizations are in the form of customer specific Dexterity or Visual Basic for Applications (VBA) code.

Customizations that you do not need to do

This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.

Having supported the various customization tools over the years, you run into common requests again and again.  Something that often surprises me is that you get requests to ‘customize’ Dynamics GP to make it do something and as it turns out Dynamics GP already does this out of the box.

VBA – Adding Fields to VBA stops working

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

While working with Microsoft Dynamics GP v9.00, I have seen a situation where adding fields to VBA does not work anymore.  You can add windows and reports, but when adding a field they don’t show up on the project.