#MySummitNA Don’t miss my Dynamics GP Development Tools Session

David Meego - Click for blog homepageCommunity Summit Conference 2021, hosted by Dynamic Communities (DC), is happening right now in Houston, Texas, USA until from 12th to 15th October 2021.

I am presenting a session on Microsoft Dynamics GP development tools as the first session of the day on Friday. As I am still unable to leave Australia due to the pandemic border closures, the session has been pre-recorded and will be run as a video presentation.

However, I will be online in a Microsoft Teams Meeting for the duration of the session and would love for anyone attending the conference (and those just interested in GP Development) to join me and others in the community for a chat and Q & A session.

Continue reading

#GPPT Moving on from the Visual Basic for Applications (VBA) Mindset

David Meego - Click for blog homepageAs a follow on from yesterday’s article on how different languages can be used to drive the Microsoft Dynamics GP user interface, this article discusses the need to move away from the old Visual Basic for Applications (VBA) way of thinking. If you missed yesterday’s article, here is the link.

Now that VBA is “End of Life” and many sites are starting to use GP Power Tools – Developer Tools module to replace the VBA business logic with GP Power Tools triggers and scripts. However some developers are still trying to write code as though they were still limited by VBA rather than leveraging the more powerful capabilities of GP Power Tools and Dexterity.

Continue reading

#MSDynGP Development: Driving the User Interface of Microsoft Dynamics GP using Code

David Meego - Click for blog homepageOver the last couple of months I have been seeing a huge uptake on the sale and use of GP Power Tools – Development Tools module as more and more Microsoft Dynamics GP customer sites move their customizations away for the now “End of Life” Visual Basic for Applications (VBA).

This article explains some of the differences and techniques for the common method driving the user interface using code written in VBA, Dexterity and Visual Studio Tools (C# or Visual Basic .Net).

Continue reading

#MySummitNA Dynamics GP Development Tools Session

David Meego - Click for blog homepageDynamic Communities (DC), the team behind GPUG, will be hosting their Community Summit Conference on 12th to 15th October 2021. The agenda with sessions has now been posted online and I will be presenting a session on Microsoft Dynamics GP development tools.

Continue reading

#DynamicsCon Dynamics GP Development Tools Session

David Meego - Click for blog homepageThe Dynamics User Group (DUG) will be hosting its DynamicsCon Conference on 20th to 23rd September 2021. The agenda with sessions has been posted online after the session voting and selection has been completed and I will be presenting a session on Microsoft Dynamics GP development tools.

Continue reading

#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