#GPPT Parsing Returned SQL Data into Rows and Columns

David Meego - Click for blog homepageWhen writing customizations using GP Power Tools as your development tool, there may be times where you need to return a SQL query as a data set to your Trigger Setup script or Runtime Execute Setup script.

It is possible to display a data set to the end user in a SQL Results window using the MBS_SQL_Results helper function. If you have “Goto” actions defined, the MBS_SQL_Results_Goto helper function will display the data and enable the SQL Goto functionality.

But what if we don’t want the data displayed to the user and just need to use the data in your code.

Continue reading

#GPPT Unknown Identifier Error when working against Modified windows

David Meego - Click for blog homepageDexterity is the native language of Microsoft Dynamics GP. It is an amazing development environment that is still the best and most powerful tool to integrate with the Dynamics GP User Interface. While Dexterity was originally developed in the late 1980’s, it has been continuously developed and extended with more and more features and functionality which allow it to handle everything needed for modern business applications AND still be completely backwards compatible to its original release.

However, Dexterity does have some limitations: It is a little bit more complex if you need to integrate with other third party dictionaries and it cannot work with modified windows. GP Power Tools extends Dexterity’s scripting capabilities to make it possible to easily work with multiple dictionaries and with modified windows.

Continue reading

#GPPT Beginner’s Guide to Adding Custom Fields – Video Demonstration

David Meego - Click for blog homepageWelcome to the eighth and final article in the series of articles that explains in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic.

The series should be read in order starting with the introduction article:

In this article we will put everything in the previous articles together in a video demonstration of the steps.

Continue reading

#GPPT Beginner’s Guide to Adding Custom Fields – Publishing the project

David Meego - Click for blog homepageWelcome to the seventh article in the series of articles that explain in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic.

The series should be read in order starting with the introduction article:

In this article we will adjust security and GP Power Tools settings to publish the customization to all users.

Continue reading

#GPPT Beginner’s Guide to Adding Custom Fields – Modifying the report

David Meego - Click for blog homepageWelcome to the sixth article in the series of articles that explain in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic.

The series should be read in order starting with the introduction article:

In this article we will use Report Writer to modify the Detailed Item List report to add a calculated field which in turn calls the custom RW Function created in the previous article.

Continue reading

#GPPT Beginner’s Guide to Adding Custom Fields – Creating the RW function

David Meego - Click for blog homepageWelcome to the fifth article in the series of articles that explain in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic.

The series should be read in order starting with the introduction article:

In this article we will use GP Power Tools to create a custom Report Writer (RW) function which will allow our custom URL field to be easily added to reports in the Report Writer.

Continue reading

#GPPT Beginner’s Guide to Adding Custom Fields – Using the data

David Meego - Click for blog homepageWelcome to the fourth article in the series of articles that explain in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic.

The series should be read in order starting with the introduction article:

In this article we will use GP Power Tools to add the business logic to make the URL field work. We will make the hidden button open the URL in a browser window and add http:// at the beginning of the URL field if it is not added by the user.

Continue reading

#GPPT Beginner’s Guide to Adding Custom Fields – Saving the data

David Meego - Click for blog homepageWelcome to the third article in the series of articles that explains in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic.

The series should be read in order starting with the introduction article:

In this article we will use GP Power Tools to add the business logic to save the data from the newly added custom field on the Item Maintenance window.

Continue reading

#GPPT Beginner’s Guide to Adding Custom Fields – Modifying the window

David Meego - Click for blog homepageWelcome to the second article in the series of articles that explains in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic.

The series should be read in order starting with the introduction article:

In this article we will use Modifier to add the custom field to the Item Maintenance window.

Continue reading

#GPPT Beginner’s Guide to Adding Custom Fields – Introduction

David Meego - Click for blog homepageWelcome to a series of articles that explains in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic. The example project will only need six scripts and no external development tools will be required.

The aim of this series is to work through each of the parts of the process and explain with step by step instructions how it works and why various settings are used. The final article also includes a step by step video.

It would be possible to just show the final result, but I want this series to serve as a guide for creating similar customizations in your own system. That said I will provide the final customization files at the end of the series.

Continue reading

#UserGroupSummit Winthrop Development Consultants at User Summit Orlando 2019

David Meego - Click for blog homepageIn one week from today, I will be getting on the first of three flights and heading back to the USA (after the recent GP Technical Conference in Fargo) for the User Group Summit North America 2019 Conference being held on October 15-18, 2019 at the Gaylord Palms Resort, Kissimmee, Orlando, Florida, USA.

My wife, Jennifer, will be coming with me to help with running our booth at the Expo Hall. Please come see us at Booth 222. Read on for more information on the two training classes and three sessions I am presenting.

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

#GPPT Renumbering SOP Transaction Lines

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

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.

Continue reading

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

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

Continue reading

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

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

Continue reading

#Dexterity Creating Large SQL Store Procedures

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

Continue reading

#GPPT SOP Batch Maintenance Self Service Scripts

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

Continue reading

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

David Meego - Click for blog homepageThe 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 6th… Don’t forget to use the Winthrop 10% discount code below.

Continue reading

Announcing Dexterity Training at GPUG Summit 2018 in Phoenix, AZ, USA

David Meego - Click for blog homepageWe are getting to the 2018 conference season again, and it is time to take advantage of the pre GPUG Summit Dexterity training that is being run in the week prior to GPUG Summit 2018 in Phoenix, Arizona, 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.

Continue reading

New Site for Microsoft Dynamics GP Product Suggestions

David Meego - Click for blog homepageIt took a little while after the old Microsoft Connect site for Microsoft Dynamics GP product suggestions was shut down, but the new site has been up and running for a little while and is getting lots of great suggestions added.

I recommend signing in and reviewing the existing suggestions and even adding some of your own ideas (if they are not there already). The Microsoft Dynamics GP development team use these suggestions when deciding on future enhancements to the product.

Continue reading