#GPPT GP Power Tools says it is unregistered on login, but is registered

David Meego - Click for blog homepageSome GP Power Tools (GPPT) sites which also have Mekorma MICR have reported an issue where GP Power Tools reports that it is not registered during login, but when you open the About GP Power Tools window it says it is registered.

This article explains the cause of the issue and the resolution.

The Issue

The dialog displayed after logging into a company says “GP Power Tools is not registered. Do you want to open the About GP Power Tools window?“.


This dialog will be displayed only for the first time a user logs in each day and then will be hidden until the next day.

Even if the dialog has been hidden, you will be able to see the issue occurring if you look in the GPPTools__.log file where it will record an entry similar to the one below:

26/02/2016 18:18:06 : GP Power Tools is Not Registered

When you open About GP Power Tools window, it will show as registered (highlighted below).


The effect of this issue (other than the dialog itself) is that any GP Power Tools features that should start after login, don’t. Features such as changing the window Title bar, Company Color schemes, automatic starting triggers, etc. fail to initialize.

The Cause

The cause of this issue is a timing problem, where GP Power Tools is checking if it is registered before the Mekorma Product Manager has initialized the registration system.

The original approach to fixing the timing issue was to change the Mekorma Product Manager to perform its initialization earlier, AND to ensure it ran before GP Power Tools checked the registration by moving Mekorma Product Manager above GP Power Tools in the Dynamics.set launch file. This worked as long as you had the appropriate build of the Mekorma Product Manager installed.

However, Mekorma MICR sometimes installed a different Mekorma Product Manager (MPM) build which did not include the change made for GPPT. You could get into a loop where the MPM packaged with MICR did not work for GPPT and the MPM packaged with GPPT did not work for MICR. Mekorma Support could provide an updated MICR installer which came with a MPM build that was compatible with both products. But this is no longer required….

The Solution

While researching a related issue where registration was failing for Batch Posting Service Toolkit (BPST) when called as a Web Service via Service Based Architecture (SBA), it was identified that the Mekorma Product Manager was not initialized as SBA does not log into Dynamics GP with the same scripts as the full client. After a bit of testing, I was able to identify a small change which allows the registration check to work.

This change also fixed the registration issue for GP Power Tools without needing an updated version of the Mekorma Product Manager or needing to change the order of the products in the Dynamics.set launch file.

If you are facing this issue, please make sure you download the latest GP Power Tools build from the Mekorma GP Power Tools page. It will have a Last Modified Date: 26-Feb-2016 (as highlighted on the screenshot above) or later.



This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Dynamics, GP, GP Power Tools, Microsoft, Products Tagged: GP Power Tools, GPPT

See more here:
#GPPT GP Power Tools says it is unregistered on login, but is registered

March 1, 2016 · WinthropDC · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 186

What?! Referential Integrity Checked on a Clear Data Table.

I learned something today from Lawrence Reid at ConexusSG that impacted the Clear Data file maintenance utility. They set up some National Accounts and then wanted to clear the Customer Master table. Once you create National Accounts, none of the customers with children will be cleared. After you run the utility you will get an error on your report that states:

You can’t clear data in the parent table RM Customer MSTR until you have cleared data in the child table RM National Accounts Master.

Wow! I’d never seen that before. It does delete all of the customers with no ‘child’ companies, but any customers with children are left intact.

Until next time,

Leslie Vail

See original article:
What?! Referential Integrity Checked on a Clear Data Table.

February 26, 2016 · Leslie Vail · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 73

Friday Funny: Exploits of a Mom

David Meego - Click for blog homepageMy good friend, Belinda Allen MVP, sent a funny comic strip from xkcd to me last week.

I thought it needed to be shared as it is funny to the database administrators and developers among us, but also highlights an important issue.

Here is the comic strip:


For more information and explanation of what the problem is:



This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Development, Dexterity, Fun, SQL Server Tagged: Dexterity, Friday Funny, Fun, SQL

Read more here:
Friday Funny: Exploits of a Mom

February 26, 2016 · WinthropDC · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 100

Virtual Launch Event for The New Dynamics AX!!!

Dynamics AX is the Microsoft Cloud enterprise resource planning (ERP) service built on and for Microsoft Azure. Designed to accelerate business, Dynamics AX helps people make smarter decisions quickly with an intelligent user interface, transforms business processes faster with proven methodologies and practices, and enables organizations to do business virtually anywhere, any time, with the choice, flexibility, and powerful data security of the Microsoft Cloud. Dynamics AX is designed and built to leverage the power and trustworthiness of Azure.

Visit site:
Virtual Launch Event for The New Dynamics AX!!!

February 25, 2016 · Sivakumar V · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 87

Answer: What is the answer? 7 + 7 ÷ 7 + 7 x 7 – 7

David Meego - Click for blog homepageLast week I posted a second mathematical challenge, and today I will go through the answer.

If you have not answered the poll on the second challenge, please go and do that now:

So here is the question again:


And here is the answer: 50

Did you get it right? If not, here are the steps.

Remember your order of operations using your favourite mnemonic: BIMDAS, PEDMAS, My Dear Aunt Sally, etc. They all tell you that Multiplication and Division must be done at the same time, but before Addition and Subtraction. Then Addition and Subtraction can be done be at the same time.

i.e. My Dear Aunt Sally (MDAS) is actually the same as Dear My Sally Aunt (DMSA).

After the order of operations is handled, just calculate from left to right. So….

  • 7 + 7 ÷ 7 + 7 x 7 – 7

Do Multiplication and Division first.

  • 7 + 7 ÷ 7 + 7 x 7 – 7
  • 7 + 1 + 49 – 7

Then finish with Addition and Subtraction (from left to right).

  • 7 + 1 + 49 – 7
  • 8 + 49 – 7
  • 57 – 7
  • 50

You could also simplify the equation and cancel out the positive 7 and negative 7.

  • 7 + 1 + 49 – 7
  • 1 + 49
  • 50

Please note that if you type this into a simple calculator and so ignore the order of operations and just calculate each operation individually from left to right, you will get a different but incorrect answer.

  • 7 + 7 ÷ 7 + 7 x 7 – 7
  • 14 ÷ 7 + 7 x 7 – 7
  • 2 + 7 x 7 – 7
  • 9 x 7 – 7
  • 63 – 7
  • 56, but this is still wrong as you must multiply and divide first.

It was good to see that most people got this second challenge correct.

Hopefully, that should end the maths lessons for a while. :)


This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Fun Tagged: Fun

Read this article:
Answer: What is the answer? 7 + 7 ÷ 7 + 7 x 7 – 7

February 24, 2016 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 115

SQL Server Backup Files Cleanup

I learned something interesting today. Something so simple yet crucial. Alright, let me jump straight on to it.

After going live with GP2015R2, as part of SQL maintenance tasks, I created daily backup schedule in SQL Server. Client’s backup retention policy is 3 prior days. So I created a “Maintenance Cleanup Task” to remove all backup files that are older than 3 days.

All good. Only that, it didn’t work. And we realised that only yesterday. Bummer. Thankfully, it was a new server so we had plenty of space. And size of DBs are quite small. So I could see backup files dating yesterday. Which is nice.

I had to figure out what’s going wrong all this time. It’s a fairly simple setup. Nothing complex. Something must be wrong. I opened the maintenance task definition window. Shown below:

Screen Shot 2016-02-23 at 8.55.04 AM.png

Looks perfectly alright to me. Isn’t it? But nope. Something makes this task fail every night.

When I looked at this post, Maintenance Cleanup Task (Maintenance Plan), on Microsoft MSDN site, I could not get much help from. It was good, detailed, but not good enough to help me why my task fails every night.

I then did something that I thought is weird, but turned out to be the solution.

I changed the File extension value from .bak to just bak, as shown below:

Screen Shot 2016-02-23 at 8.55.04 AM.png

Saved the definition and ran the task manually to check if it worked.

Voila… It worked…!!!

Those who are reading this and thinking about why I am blogging something as simple as this (as if I found the god particle), well in all honesty, I had absolutely no idea about this till now. Just thought I would share this, as I always do. So please be nice on me.


Filed under: #MSDYNGP, DBA, SQL, SQL Administration, SQL Server, SSMS, Troubleshooting, Uncategorized

SQL Server Backup Files Cleanup

February 23, 2016 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 100

#GPPT: Responding to the GP Power Tools Survey Part 1

David Meego - Click for blog homepageIf you have installed GP Power Tools (GPPT), firstly thank-you for your support, secondly you probably would have been presented with the GP Power Tools Feedback Survey dialog.

This dialog will first appear for an administrator user after two days for a new installation and immediately on an upgrade install. You can gdecide whether to go to the web based survey at that time or to dismiss the dialog for a period of time.

The survey launched from this dialog is a major source of information on the usage of the product and a chance for users to provide feedback. The dialog is shown below:


Please take the opportunity to respond to the survey when the dialog opens. You can also manually open the survey dialog under the GP Power Tools >> Setup menu.

However, this blog post is not about users responding to the survey, it is a chance for me to respond to some of the survey comments entered by the community.

The Survey Dialog is intrusive

The dialog will only open automatically for System Administrator users. It will never open automatically for normal users. When the dialog opens automatically, the user must make a selection of an action. If you select to respond on the survey, the web site will open and the dialog will not show again until you update to a new build. You can also select not to respond and ask the dialog to remind you on next login, tomorrow, in 7 days, in 30 days or never again until a new build is installed.

So, how intrusive or not intrusive the dialog can be is completely under your control.

Product has no documentation

One of the comments said that GP Power Tools has no documentation.

Well, this is incorrect. When you install GP Power Tools, it also installs the User Guide manual in pdf format. The User Guide has details about installation and explanations of every window in the product, more than 250 pages worth.

It can be opened from any GP Power Tools window by pressing F1 or selecting Help from the menu and then choosing to open the Manual on the dialog.


There is also more information on the Portal, both old and new blogs as well as conference sessions and video recordings.

Users not getting full use of product

Some users feel that they are not getting full use of GP Power Tools as there are features they are not using. This is understandable as the tool has a variety of features targeted as different audiences. For example: some development and scripting features might not be as useful to system administrators.

We are working on releasing a video series to give example usage and steps for each of the features. These short videos should help you know what each feature is for and when it can be used.

Identifying tables for window fields

One comment was that in another product, it was possible to click on a window field and it would identify the table and column related to that field. They wanted the same functionality from GP Power Tools.

Sadly, it is not possible to provide that exact functionality. While fields on a report are linked to a specific table and column, Dexterity does not link fields on windows to a table.

So, the Resource Information window can identify the current field automatically (when the Show currently selected Window and Field information option is enabled), but it cannot directly identify the table.

However, if you click on the Associated Tables button, it will filter all the tables linked to the form to only show those including the current field. This will usually bring the possible table locations down to a single table.  The same window also identifies which table is the linked or main table for the window. If the field exists in the linked table, then that is your most likely location.

Cost used to be included with GP

GP Power Tools (or its predecessor, the Support Debugging Tool) were never included with GP.

The Support Debugging Tool was a pet project of my while I was a Microsoft employee to create a tool to help the Dynamics GP support team resolve issues, especially when we did not know how to replicate the issue yet. While it was provided free of charge and was very popular in the customer and partner community, it was never officially supported by Microsoft and was not widely used by the support team.

It was free as Microsoft did not want the hassle of charging for it and it made no difference to me as I was getting a salary.

After leaving Microsoft, rather than let the tool be discontinued, I negotiated to take control of it and continue developing and supporting it as an ISV product.

GPPT is not cloud based

GP Power Tools can be as “cloud based” as Microsoft Dynamics GP. GP Power Tools can be used with the web client, but does lose some features because they either don’t work in the web client (due to limitations in the web client implementation) or they don’t make sense in the web client. There is a section at the end of Chapter 2 of the User Guide manual which lists what features are not available on the web client.


I have called this article “Part 1” as I will post more articles like this to respond to feedback from the community.

Please keep providing feedback and product feature suggestions.


This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Dynamics, GP, GP Power Tools, Microsoft, Products Tagged: GP Power Tools, GPPT

Originally posted here:
#GPPT: Responding to the GP Power Tools Survey Part 1

February 22, 2016 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 119