Page 2 of 12612345678910...2025303540...Last »

Friday Funny: How many 3’s are in the image?

David Meego - Click for blog homepageI am no longer testing your maths skills, but instead testing your powers of observation.

I found another challenge doing the rounds on the internet and thought we could have some more fun.

The question is: How many 3’s are in the image below?


Do not post the answer in comments, instead here is a poll for you to respond to:

Take Our Poll

Let’s see how good you observant you are.



This article was originally posted on

Filed under: Fun Tagged: Friday Funny, Fun

Excerpt from:
Friday Funny: How many 3’s are in the image?

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

#GPUGAmplify vs #GPUGSummit

David Meego - Click for blog homepageFollowing on from last week’s announcement of the new GPUG Amplify conference, #GPUGAmplify Welcome to the New GPUG Amplify Conference, there have been questions about the focus of the new conference when compared to GPUG Summit.

So Bob McAdam posted a graphic on Facebook which compares the two conferences.

It shows how GPUG Amplify is all about meeting with Microsoft and learning about the future of the Microsoft Dynamics GP product, while GPUG Summit is focussed on meeting with your peers and learning about the current versions you are using.

GPUG Amplify vs GPUG Summit

As you can see there is value in attending both GPUG Amplify and GPUG Summit.



This article was originally posted on

Filed under: Conference, GPUG Tagged: Continuum, GPUG, GPUG Amplify, GPUG Summit 2016

See more here:
#GPUGAmplify vs #GPUGSummit

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

#BPST Batch Posting Service Toolkit says it is not registered from Web Service, but is registered

David Meego - Click for blog homepageAs mentioned in my article #GPPT: GP Power Tools says it is unregistered on login, but is registered, an issue was discovered with Batch Posting Service Toolkit (BPST) where it would fail for live companies with a registration error, but only when called as a web service via Service Based Architecture (SBA).

If you made the same call using the testing window inside Microsoft Dynamics GP, the service calls would work without issues.

The problem came down to the fact that SBA environment might not match Dynamics GP environment. In our case, the Mekorma Product Manager was not initialized and so the registration check failed.

After some testing, I was able identify the changes needed to make the registration system work without needing to specifically initialize the Mekorma Product Manager.


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


This article was originally posted on

Filed under: Batch Posting Service Toolkit, Dynamics, GP, Microsoft, Products Tagged: Batch Posting Service Toolkit, BPST

See more here:
#BPST Batch Posting Service Toolkit says it is not registered from Web Service, but is registered

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

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

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

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

#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

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

Register for the Perth Australia March 2016 GPUG Chapter Meeting

David Meego - Click for blog homepageHere is a call for all Perth based Micosoft Dynamics GP partners and customers to register for the next Perth Australia GPUG Chapter Meeting for Q1 2016.

The meeting will be held at the Microsoft Office in Perth on Wednesday 9th March at 5:00pm for a 5:30pm start.


The agenda for the meeting has been finalised and this time we will be focusing on BI (Business Intelligence) solutions. We will have a look at Microsoft Power BI, QlikView and BI 360 with presentations from Professional Advantage and Solver.

We will also have a member showcase presentation from United Equipment, who run Dynamics GP from the cloud. If you are interested in knowing more about cloud based solutions be sure to attend.

When:   Wednesday 9th March at 5:00pm for a 5:30pm start to 7:30-8:00pm

Microsoft Office Perth
Level 3, ENEX 100
100 St. Georges Terrace
Perth  WA  6000

Please register using the link below, we need to know numbers for catering:

For more details and discussion see the Perth Chapter’s Collaborate forum:

Hope to see you there.


PS: Snacks and refreshments will be provided (let us know if you have any dietary requirements or allergies).

This article was originally posted on

Filed under: GPUG, Public Service Announcement Tagged: GPUG, News

Continued here:
Register for the Perth Australia March 2016 GPUG Chapter Meeting

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