#GPPT Replacing VBA with GP Power Tools – Developer Tools

David Meego - Click for blog homepageAs a follow on to the recent post : #GPPT Why every GP site needs GP Power Tools – Developer Tools, this article explains the benefits of replacing your VBA (Visual Studio for Applications) and VSTools (Visual Studio Tools for Microsoft Dynamics GP) customizations with GP Power Tools.

It has been prompted by the issues seen because the redistributable version of VBA that is packaged with Microsoft Dynamics GP has reached end-of-life as explained in the following article from the Microsoft Dynamics GP Support and Services team:

Continue reading

#GPUGSummit Developers at GPUG Summit

David Meego - Click for blog homepageHey Developers… Are you attending the GPUG Summit 2017 conference in Nashville, Tennessee in October? If so, this article is to let you know about Microsoft Dynamics GP related Developer content at the conference.

I asked why there was not much content for developers at GPUG Summit and I was told that there are not many developers in attendance. I disagreed and requested a session for Developers, which Bob McAdam promptly organised … thanks Bob. 🙂

Continue reading

VBA: DUOS data stored in the wrong database after switching companies

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

A while ago I had a case where the customer was storing data in the DUOS (Dynamic User Object Store) table from a VBA (Visual Basic for Applications) customisation. Everything worked fine until the users switched companies. After switching company the VBA customisation would still be connected to the DUOS table in the previous company’s database. If the user exited Microsoft Dynamics GP and logged back in, the DUOS in the correct database was used.

Continue reading

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.

Continue reading

Customising the Company Login window series Part 2 – Visual Basic for Applications

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

GP Power Tools – Administrator Tools Module can provide this functionality without needing customizations. (http://WinthropDC.com/GPPT)

Following on from my previous post: Customising the Company Login window series Part 1 – Introduction, here is the method to create a solution using Visual Basic for Applications (VBA).

Continue reading

Customising the Company Login window series Part 1 – Introduction

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

GP Power Tools – Administrator Tools Module can provide this functionality without needing customizations. (http://WinthropDC.com/GPPT)

Recently a comment from David M (not me) was posted on the Support Debugging Tool Portal page asking:

“We have some fairly long names for our GP companies. Well, when logging onto GP, the second “Company Login” screen cuts off the company names too short for us. The entry field for companies allow for longer strings (65 Characters) but only displays 31 characters on the pull-down list. There is plenty of real estate on this window going unused. Can anyone think of a way to enhance/fix this to display more of the company name?”

Continue reading

All About Listbox, Button Drop Lists, and Drop Down Lists

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

It seems like a trivial subject for our dedicated readers but we had a new customer who is just learning Dexterity and he was having trouble recently trying to select items out of a ListBox.  And just today the issue came up about Drop Down Lists (DDL) and getting the value selected using VBA in a different case.  So this seemed like a good time to put this together.

Continue reading

Quick Tip: Where does that customisation come from?

David Meego - Click for blog homepageThis 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.

Continue reading

Quick Tip: Working with VBA, Extender and Sales Transaction Entry

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I have completed the development project I was working last week and have another Quick Tip that came out of the project. For the previous Quick Tips related to this project have a look at Quick Tip: Passing Variables to SQL Server and Quick Tip: Passing Date and Time Variables to SQL Server.

Continue reading

Quick Tip: Passing Variables to SQL Server

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Wow, the week is almost over and I am yet to post something.

This week I was working on a small development project using Visual Basic for Applications (VBA) to execute some commands at the SQL Server level after some user interface events. The code to be executed needed to have values from the windows passed through to the Transact-SQL.  Now most people just write the code and pass through the value of a string field concatenated before and after with single quotes.

sqlstring = "select * from IV00101 where ITEMNMBR = '" & CStr(ItemNumber) & "'"

Continue reading

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

David Meego - Click for blog homepageThis 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.

Continue reading

Dynamics Report Writer is the Best Report Writer in the World cont.

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

This is a follow up post to my earlier post, which demonstrated how Report Writer when combined with the power of Visual Basic for Applications (VBA) was able to create a customisation that would not have been possible with Report Writer alone.

Continue reading

Using Barcodes from the Dynamics GP Report Writer

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

A few months ago, I worked on a support case where we needed to add a barcode to a Sales Order Processing transaction print out.  We were able to achieve what we needed using Visual Basic for Applications (VBA) to handle some of the scripting for us.  I have been meaning to write a blog post on how to make a customization like this for a really long time and have finally got around to it.

Continue reading

File not found: VBA6.dll error occurs or GP crashes

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

This is a follow up to my previous post on the VBA6.dll not found error (for 64-bit). I have found this can occur on 32-bit computers and Microsoft Dynamics GP 10.0 and GP 2010.

[Edit] Re-installing the VBA 6.4 core components (as used by Dynamics GP) has been shown to resolve this issue for VBA6.DLL, VBE.DLL, VBA7.DLL and VBE7.DLL errors.  Please download the necessary files from this link:

 

Continue reading

Quick Tip: Solving “Do you want to Save?” dialog appearing after VBA customization

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Have you ever used Modifier and Visual Basic for Applications (VBA) to add an additional field to a window?  Have you then had the issue when navigating through records on that window, it keeps coming up and asking “Do you want to Save, Discard or Cancel?” or “Do you want to Save, Delete or Cancel?“.

Continue reading