#GPPT Installing GP Power Tools (Upgrading from SDT, Silent Installs and more)

David Meego - Click for blog homepageNow that GP Power Tools has been out for a little while and I have recently released a hotfix that improves the installer as well as fixes some issues found with the tool, it is time to explain how the installer works and answer some frequently asked questions.

Please note that some of the information in this article only relates to the build 20 hotfix (Last Modified: 19-Aug-2015) or later. If you are unsure what build you have, just go and download the latest installer from the Winthrop website. If you look at the installer’s properties, the File Version will show as XX.0.20.4 or later.

Continue reading

#GPPT GP Power Tools Build 20 hotfix released

David Meego - Click for blog homepageI know that I should not be surprised as I have been in this industry for so long, but after all the work and testing done prior to releasing GP Power Tools Build 20, we have still come across some issues that needed fixing.

You probably won’t come across most of the issues as they relate to problems caused when company databases are not installed or are offline for some reason. Anyhow, GP Power Tools is now smart enough to handle these extra situations.

Continue reading

#GPPT What’s New: Series summary for GP Power Tools build 20

David Meego - Click for blog homepageOver the past few weeks I have been posting a number of “What’s New” articles for GP Power Tools build 20.

If you have missed any of them, this article has all the links to the articles, so you can read them at your leisure.

Continue reading

#GPPT What’s New: Installer and Documentation

David Meego - Click for blog homepageGP Power Tools is the first product that I have released over the years to have a proper installation program. As the complexity of the products increases and there are more files involved than a single Dexterity chunk (.cnk) file, it became necessary to use an installer rather than just a zipped archive file.

GP Power Tools has a number of DLL files as well as a text file with version history, a license document and the user guide PDF.

Continue reading

#GPPT What’s New: Create Custom Service Based Architecture Web Services

David Meego - Click for blog homepageMicrosoft Dynamics GP 2015 added Service Based Architecture (SBA) and .Net Interop functionality to the application. Service Based Architecture allows the Dexterity developer to write global procedures and use meta data to expose these service enabled procedures to the outside world as REST Web Services.

GP Power Tools provides five Service Enabled Procedures which can be used to execute custom business logic created in the Runtime Execute window. These services can be called as Web Services, from Visual Studio Tools using Visual C# or Visual Basic.Net, or from any Dexterity product dictionary using sanScript.

Continue reading

Solving Performance Problems with Microsoft Dynamics GP and Windows 10 – Part 2

David Meego - Click for blog homepageFollowing on from my previous post: Solving Performance Problems with Microsoft Dynamics GP and Windows 10 – Part 1, I was still not happy with the performance of Dexterity and Microsoft Dynamics GP on my newly updated Windows 10 development machine.

This article takes you through the steps to get your Dexterity and/or Dynamics system running fast on Windows 10.

Continue reading

Solving Performance Problems with Microsoft Dynamics GP and Windows 10 – Part 1

David Meego - Click for blog homepageNow that I am running Windows 10 and am starting to get back to work with developing for Microsoft Dynamics GP and Dexterity, I have been noticing some serious performance issues.

This article takes you through the steps I used to identify the issue and what I did to resolve the issues. After making the changes listed in this and the next article I am happy with my Windows 10 development environment.

Continue reading

#GPPT What’s New: Database Validation, copying databases and upgrades

David Meego - Click for blog homepageThe Database Validation feature was previously demonstrated but never released. GP Power Tools now releases Database Validation for general availability.

Database Validation is a tool designed to ensure that the user, company and table settings at the SQL Server level match what the Microsoft Dynamics GP application says they should be.

Continue reading

#GPPT What’s New: Company based color schemes enhancements

David Meego - Click for blog homepageOne of the most popular features of the now discontinued Support Debugging Tool was the Company based Color Schemes. This feature allowed administrators to specify a different color scheme for each Microsoft Dynamics GP company.

GP Power Tools takes this functionality and enhances it to make it more powerful and easier to use.

Continue reading

#GPPT What’s New: Microsoft Dynamics GP usability enhancements

David Meego - Click for blog homepageGP Power Tools is now released and available via my distribution and support partner, Mekorma.

Continuing on with the What’s New series, today’s article will have a quick look at some of the usability enhancements to the Microsoft Dynamics GP application.

Continue reading

#GPPT GP Power Tools Build 20 released

David Meego - Click for blog homepageI am so proud and excited to finally release the much anticipated replacement for the discontinued Support Debugging Tool.

Welcome to GP Power Tools for Microsoft Dynamics GP for versions GP 2010 (v11.0), GP 2013 (v12.0 including R2) and GP 2015 (v14.00 including R2).

This first release of GP Power Tools will be build 20 and includes many new features, enhancements to existing features as well as rebranding as a Winthrop Development Consultants product.

Continue reading

#GPPT What’s New: Publish scripts to users with the new Executer windows

David Meego - Click for blog homepageOne request that I have heard a number of times is for a method to expose scripts written using Runtime Execute or SQL Execute to normal users.

Because these windows are Advanced Mode features designed for administrators to use, they require SQL Server sysadmin or dbo privileges as well as application level security and the System password (if used) to access.

Continue reading

#GPPT What’s New: Run C# and VB.Net scripts with .Net Execute

David Meego - Click for blog homepageThe Support Debugging Tool already has the ability to create and execute Dexterity sanScript and Transact-SQL scripts, without needing the Dexterity development environment or SQL Server Management Studio installed.

Now GP Power Tools adds the ability to create and execute Visual C# scripts and Visual Basic.Net scripts, without needing Visual Studio installed.

Continue reading

#GPPT What’s New: Administrator Password vs System Password

David Meego - Click for blog homepageThe Administrator level (Advanced Mode) features of GP Power Tools require application level security, SQL Server sysadmin or dbo status and the System Password (if one is configured) to access them.

So what happens if you want a user to be able access a feature and can provide the security required at the application level and SQL Server level, but you don’t really want to provide them with the Microsoft Dynamics GP System password?

Continue reading

#GPPT What’s New: Security Activity Tracking and Security Log

David Meego - Click for blog homepageAs GP Power Tools approaches release, it is time to continue the What’s New series and explain another of the new features added to the product.

You can now enable Security Activity Tracking to collect statistical data on the usage of the various resources and security objects within the system.

Continue reading

Developing using Dexterity for Microsoft Dynamics GP 2015

David Meego - Click for blog homepageToday, I was contacted by a fellow Dexterity developer who was having trouble getting Dexterity for Microsoft Dynamics GP 2015 to run Dynamics.dic in Test Mode.

In this article, I will take you through the errors you could get and how to resolve them. Some of these you might know from previous versions, others are new to GP 2015.

Continue reading

#GPPT What’s New: GP Power Tools is faster and easier to navigate

David Meego - Click for blog homepageAs mentioned in recent posts, GP Power Tools is almost ready for release. The user guide manual documentation is now completed… all 256 pages of it. If you want to get the code now, you can already install the public beta and upgrade to the final release later.

This is the first article in a series of What’s New posts for GP Power Tools. The aim of this series is to highlight some of the new features of the tool and flesh out more details than the 21 reasons to upgrade article.

Continue reading

#GPPT Updates for the GP Power Tools Public Beta

David Meego - Click for blog homepageToday, I am releasing an update to the GP Power Tools Public Beta.

If you have installed a previous version, please download and install this updated code as it contains a number of cosmetic and performance changes that have been identified by beta testers and during the documentation process.

Continue reading

#GPPT Installing the GP Power Tools Public Beta

David Meego - Click for blog homepageNow that the GP Power Tools Public Beta is out there, I know that people will not read the user guide documentation (GPPTools.pdf).

So I thought it would be worth while mentioning some guidelines to make the install as smooth as possible.

Continue reading