#GPPT Replacing VBA with GP Power Tools – Developer Tools

As 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:

• Microsoft Dynamics GP and VBA: Future Considerations

#GPPT Renumbering SOP Transaction Lines

Earlier this week, a forum post by my friend Abra Gilman on the GPUG Open Forum brought up the problem where a user was getting an error when attempting to insert a new line into a SOP Transaction.

• SOP Line Items – Running out of Line Item Sequence (cannot add line items)

This problem can be reproduced by attempting to insert lines in the same location more than 14 times, on the 15th attempt an error will be generated.

Announcing Dexterity Training at User Group Summit 2019 in Orlando, FL, USA

The 2019 conference season starts soon (just a week to Johannesburg, South Africa), and it is time to take advantage of the Dexterity Bootcamp training that is being run in the week prior to User Group Summit 2019 in Orlando, Florida, USA.

Dexterity is the development environment that Microsoft Dynamics GP is built on and the best tool to use for any customisation to the user interface of the product. Knowledge of Dexterity is vital for anyone customising Dynamics GP even when using other languages such as C#, VB.Net and even VBA (Visual Basic for Application).

Announcing Dexterity Training after User Group World Tour 2019 in Johannesburg, South Africa

I will be heading to Johannesburg, South Africa soon for the User Group World Tour 2019 conference organised by Dynamic Communities.

After the conference I have been asked by a customer to run Dexterity Training for some of their staff and so this has been planned to run in the week following the conference. Additional, but limited room, is available at this training and so I am opening this up to any partner or customer who can attend.

Dexterity is the development environment that Microsoft Dynamics GP is built on and the best tool to use for any customisation to the user interface of the product. Knowledge of Dexterity is vital for anyone customising Dynamics GP even when using other languages such as C#, VB.Net and even VBA (Visual Basic for Application).

This training is being offered at a special reduced price and I cannot guarantee that there will be another opportunity to receive this training in the region or at this price.

#Dexterity Creating Large SQL Store Procedures

Today I was asked about how you can use Dexterity to create SQL Stored Procedures when the stored procedure itself exceeds 32,768 characters.

This 32K limit is because the largest datatype supported by Dexterity is the Text field which is limited to 32,768 characters. This is the maximum size of a signed 16 bit integer (-32767 to 32768).

#GPPT SOP Batch Maintenance Self Service Scripts

Recently Steve Endow MVP asked on Twitter if there was a simple solution for moving SOP Transactions from one batch to another batch.

This is something that is easily solved as a Self Service script using the GP Power Tools – Developer Tools module. In fact, I had already created a solution for the same request for a customer in Australia using GP Power Tools. I spoke to the customer, Anand, and he said he was happy for me to post the code on the blog.

#GPUGSummit GPUG Summit 2018 in Phoenix, AZ, USA early bird pricing ends soon

The GPUG Summit 2018 Conference is fast approaching. It is being held on October 15-18, 2018 at the Phoenix Convention Center, Phoenix, Arizona, USA.

Winthrop Development Consultants will be at the conference as I am training 3 GPUG Academy classes and co-presenting at least 5 sessions. We will also have booth 1540 at the Expo.

Register now before the early-bird pricing runs out on September 6^th… Don’t forget to use the Winthrop 10% discount code below.