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.
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.
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).
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.
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).
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.
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 6th… Don’t forget to use the Winthrop 10% discount code below.
We 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.
