Page 1 of 12512345678910...2025303540...Last »

#GPPT Why wait till you upgrade to install GP Power Tools?

David Meego - Click for blog homepageYesterday, I received an email from a customer that I met in Reno at the GPUG Summit 2016 conference. He asked a technical question on GP Power Tools and mentioned that he had purchased the tool to be used once he had completed the upgrade to Microsoft Dynamics GP 2015.

The question I had to ask was …

  • Why wait till you upgrade to install GP Power Tools?

The reason I ask the question is fairly simple.

By running the GP Power Tools’ Database Validation feature against your system BEFORE you upgrade, you can avoid many upgrade issues before they even occur.

Database Validation can be used to validate that the system’s user and company settings match the SQL Server Logins, Databases and Database Users as well as comparing the data structures of all tables against their definitions in the Dynamics GP Product dictionaries.

Note: For more details on what checks Database Validation makes, see the first article in the links below.

You can also use Database Validation to fix SQL Logins (passwords) and Database Users when moving the system to a new server, which often happens during upgrades.

Even if not moving to a new server, it is common practice to do a test upgrade on a test server. Running Database Validation on your test environment can remove references to users and companies that are not included in the test system.

Database Validation has many features that will help you before and during the upgrade process, so why not get some help now… before you upgrade?

If you already have registered GP Power Tools, your license will be valid for all versions GP Power Tools (for Microsoft Dynamics GP 2010, GP 2013, GP 2013 R2, GP 2015 & GP 2015 R2).

For more information see:

You have no reason to wait.


PS: Database Validation is new to GP Power Tools and is not included in the Support Debugging Tool.

This article was originally posted on

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

Continue Reading:
#GPPT Why wait till you upgrade to install GP Power Tools?

November 25, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 18

Inaugural Class of Credentialed Professionals Announced

David Meego - Click for blog homepageAfter Microsoft removed the requirement for Microsoft Dynamics GP and Microsoft Dynamics NAV partners to be certified and shutdown the examinations for those two products, the community decided that some sort of certifications were still needed.

To this end, the Association of Dynamics Professionals (DynamicsPro) was formed.

From the Association’s web site:

The Association of Dynamics Professionals (DynamicsPro) is an independent, not-for-profit membership organization which exists to serve the Microsoft Dynamics community by establishing competency standards and assessments, and to positively impact the Dynamics community through member-led advocacy initiatives.

At the recent reIMAGINE 2015 and GPUG Summit 2015 conferences, attendees were given the opportunity to take the examinations for Dynamics GP and Dynamics NAV (at Summit).

Joe Carroll has recently published an article with a list of the Inaugural Class of Credentialed Professionals, including yours truly. :-)

For details see Joe Caroll’s blog post below:

So, get involved and get credentialed.


PS: The certifications are open to partners and customers alike.

This article was originally posted on

Filed under: Dynamics, Microsoft, News Tagged: DynamicsPro, News

Continued here:
Inaugural Class of Credentialed Professionals Announced

November 23, 2015 · WinthropDC · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 24

SQL Script To Copy Tax Setup To All Companies Using … – azurecurve

Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant ( This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int). …. MVP Profile azurecurve on the Dynamics Community Email azurecurve View azurecurve View Detailed RSS Feed View Ian Grieve’s View azurecurve’s Feed on Twitter View Ian Grieve’s profile on LinkedIn View …

View original post here:
SQL Script To Copy Tax Setup To All Companies Using … – azurecurve

November 18, 2015 · Ian Grieve · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 9

RoboCup Junior Australia 2015 National Championships

Wombat Fitness - Click for blog homepageWhile David was away in the USA and Mexico, I got to accompany Rohan to the RoboCup Junior Australia 2015 National Championships on 26th and 27th September 2015. You may know from past blogs that robotics has been a bit of a hobby for David and our sons. This year, being in the National Competition meant travelling to Gawler, South Australia.

Aaron, who has been successful in the Rescue competition is now too old to compete. He has been mentoring the younger students and would have been very useful to have with us, but we have an ageing puppy dog who was already pining for the master of the house, so Aaron got the job of house and dog sitting while Rohan and I flew to Adelaide with the other competitors and parents from All Saints’ College.

In all we were 4 teams; 10 students, 11 parents and several siblings and 1 school staff member. (Cat herding now seems simple in comparison.)

Open Dance: Pickle Jar Productions (Josh, Megan, Noah, Sarith and Rohan) with Priscilla the Gorilla

Secondary Rescue: Team Sonic (Jay, Liam and Mason)

Open Rescue: BEN (Pragash) & Vindaloo (Disura)

The competition venue was about a 40 min drive out of Adelaide (the state capital city) and accommodation for such a large group was scarce, so we ended up staying at Tanunda Discovery Holiday Park in the Barossa Valley, an area you may well know for its excellent wines.  Tanunda is a lovely, historic little village, still about 40 mins from Gawler, but without the city traffic. This was fine with me as I got the added task of driving the bus (a surprisingly speedy Hyundai iMax van) handed on to me thanks to David’s past efforts as chauffer extraordinaire.

I have to confess here, that despite being given strict instructions from David to follow all the teams and competitions, I am a Mum first and foremost, so I may have spent the vast majority of my time watching the Open Dance Competition, where Rohan’s team was competing.

I did watch some of the Secondary and Open Rescue competition and it is amazing to see the work and development that has gone into all the rescue robots.  Since we started this journey some 7 years ago, the standard of competition has improved incredibly.  From very unreliable, line-following robots that could navigate some simple obstacles to locate a “victim” (soft-drink can), this year I witnessed very sophisticated robots meet the challenges of ramps, speed bumps, sloping terrain and more.  In the finals of the Open Rescue the students’ robots had to autonomously navigate the course to the “chemical spill” and identify and rescue (in a controlled manner) multiple “victims” without falling off raised tiles. The following photos and video (apologies for the adjudicator’s legs) may explain that better:

Course1Example Course 1

Course2Example Course 2

RoboCup Junior Australia 2015 Open Rescue National Championships – BEN (direct link)


When you think that the competitors are mostly 12 – 16 year old school children, it gives me a lot of hope for our future. 

Teams had travelled from Korea and Croatia sent their National Team to compete in the Australian National competition.  The All Saints’ teams did well, but “Michael” from Box Hill High School (Victoria) won Secondary Rescue and “Marshmallow” from St George Christian College (New South Wales) took out the Open Rescue Competition.

Meanwhile, in the Open Dance Competition the stress levels were high.  This was Rohan’s last year of competing and the pressure was on the rest of his (younger) team mates to bring home the bacon.  You can look at the photos and watch the video but they will never truly convey the hours and hours of work that has gone into all the competition entries.  Without wanting to sound like I am bragging too much you need to know that the 5 kids in Pickle Jar Productions:

  • Selected and mixed the music
  • Built and painted the backdrop
  • Wired and soldered the LED lighting that runs along the backdrop
  • Choreographed Pricilla’s movements, the truck movements and their dance.
  • Built Pricilla, the truck and the spinning big top
  • Programmed Pricilla, the truck and the spinning big top
  • Made Pricilla’s feet, hands and face by painting latex over clay moulds that they also made
  • And probably a whole lot more that I have missed

Remember that once the “go” button is pressed the performance is totally autonomous without any input or interaction from the team.

Here is the video of Priscilla the Gorilla and the Pickle Jar Productions finals performance:

RoboCup Junior Australia 2015 Open Dance National Championships – Pickle JAR Productions – Finals (direct link)


Robocup Junior Australia – 4 controllers, 16 motors and one very cool monkey!


At the end of the day, when scores from the performances and interviews were tallied, Pickle Jar Productions came second, pipped at the post by the other West Australian team, The NX-Twins EVolv3 (Melville Senior High School). This reversed the results from the WA finals where Pickle Jar won and the NX-Twins came second. All I’m saying is that it must have been close.

PickleJar1Pricilla gets some love before for the big day

PickleJar2Pickle Jar Productions relieved it’s all over

After the competition was over the All Saints’ Teams and the NX-Twins with Mum and Dad enjoyed a rather noisy dinner together at a local tavern in Tanunda. We had a day to relax and see some sights before boarding the plane home.  We chose to visit the local hill lookout and sculpture park and the Adelaide Zoo.  Yes, and we managed to sneak in one (just one!) winery.

For the previous posts on the RoboCup robotics competition see:

This is the final year that our boys will be competing in the RoboCup Junior Australia competition as they are finishing or have finished secondary school. David will continue to be involved as a mentor to the All Saints College Robotics Club.

Till next time.


This article was originally posted on

Filed under: Robotics, Wombat Fitness Tagged: Fun, General, News, Wombat Fitness

See the article here:
RoboCup Junior Australia 2015 National Championships

November 16, 2015 · wombatfitness · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 32

#GPUGSummit 2015 – Day 3

David Meego - Click for blog homepageGPUGSummit_Logo

Day 3 started again with breakfast in the Meal Hall at the Convention Center, and this time there was hardly anyone there. Looks like the partying at the bowling alley the night before was taking its toll.

The first commitment for the day was the Mekorma partner showcase breakout session. This session was presented by Craig Klapman, Mariano Gomez & myself and demonstrated products from both the Mekorma and Winthrop Development Consultants ranges.

The session included the official announcement that Mariano Gomez is now working for Mekorma. It was a very badly kept “secret” as he had already presented a number of sessions which said he worked for Mekorma on the slide decks and had been wearing Mekorma branded shirts.

Before the session got started Mariano and I pumped up the crowd to help bring in more attendees from the hallway. Thanks to the audience for being good sports and playing along.

PST04 – 50 Companies 50 Checkbooks One Button + Power Tools

The product showcase covered the upcoming addition to Mekorma’s Multi-Batch Payment Processing solution. The new product is Multi-Batch Payment Builder which will be able to automatically create multiple payment batches based on previously defined rules, including batches in multiple companies. Combined with the Multi-Batch Print and Post and Mekorma MICR products, this will provide a highly automated solution for handling the Accounts Payable requirements for businesses with one or more Dynamics GP companies.

In the middle of the showcase, I was able to demonstrate a few features from GP Power Tools which should help make the lives of administrators and users of Microsoft Dynamics GP easier. The session was very popular and the audience response to everything shown was very enthusiastic.

After the showcase, we all headed down to the general session GEN04: Ask the GPUG All-Stars in the convention center. Here are some photos from the session:

The session started with a welcome from Kim Peterson

Kim was joined by Rose Spitzer who announced the GPUG Chapter of the year and the GPUG Chapter Leader of the year

Kim then started discussing the GPUG All Stars and the qualities they should have

Here is a list of the previous GPUG All Stars. All of these guys are awesome people who do lots for the community. They also happen to be really nice people that I am proud to have as friends

So now Kim prepares to announce this year’s winners for which I am one of the nominees

As soon as she started talking about working for Microsoft and creating the Support Debugging Tool. I (along with everyone else) knew that I was the first one to be named.

Once Viola, Steve and I had been awarded GPUG All Stars we were kept on stage and joined by some of the existing GPUG All Stars for a Q & A session hosted by Andy Hafer

Kim Peterson with the GPUG All Stars for 2015: David Musgrave, Viola Shoell, and Steve Erbach

Lots of GPUG All Stars
Left to Right: Kim Peterson, Beat Bucher, David Musgrave, Mark Polino, Viola Shoell, Andy Hafer, Belinda Allen, Steve Erbach, Bob McAdam, John Lowther, Zubin Gudwani

Wow. Thank you so much to GPUG and everyone who voted for the GPUG All Stars. I am humbled to receive the award which adds me to an elite group of awesome people. I do what I do in the community because I love doing it. I love helping people with responding on forums and writing blogs. I love writing software that helps make peoples’ lives easier. To be recognised for my contributions with both a Microsoft MVP Award and a GPUG All Star award in my first year since leaving Microsoft is exciting, gratifying and humbling at the same time. It brings my first year to an amazing conclusion, see my post: Winthrop Development Consultants … One year on.

After the session Beat, Mariano and I headed to the Meal Hall for lunch. On the way we came across Tanya Henderson pretending to work on her computer.

Mariano Gomez and Beat Bucher trying to drag a very tired Tanya Henderson to lunch

After lunch we headed back to the Atlantis for the final breakout session that Mariano and I were presenting. This session was a demonstration of GP Power Tools (GPPT) and its Service Based Architecture functionality. GPPT exposes five Service Enabled Procedures which can be used to run custom user defined code stored under a Script ID. The Script ID is created using Dexterity sanScript in the Runtime Execute window and is automatically populated with template code that shows show to pass data into and out of the script.

Because the code is being developed using GP Power Tools, you can leverage and re-use Dexterity code in the context of any dictionary, Transact-SQL code in the context of any database, as well as .Net code written in C# and/or VB.Net. Once the code is saved it is immediately available without any need to restart any services. While it does require some code, you can now make any functionality you want available as a web service. The possibilities are endless, limited only by your imagination.

TOT09 – Using GP Power Tools to Write Custom Web Services for Microsoft Dynamics GP

After the session, I went back to the Mekorma Hub to relax and socialise with other attendees. I had some Australian Lollies/Candies/Sweets and chocolate still and so offered that around including the dreaded Vegemite and the chocolate with Vegemite salted caramel.

While I was at the Mekorma Hub I caught up with Daisy Eck. I had to get a photo of Daisy saying hello to my friend from Perth, Kate Sexstone. Kate had been staying up late in Perth and remotely attending GPUG Academy training sessions and so had been working closely with Daisy. So here is Daisy and I thinking about you, Kate. Hope you can get to a future GPUG Summit.

Daisy Eck and David Musgrave

I had planned to hang around the Bistro Napa and offer Tim Tam Slams to anyone who was game to try. However, I ended up being committed to dinner with the Mekorma team and had to leave. Sorry if anyone tried to find me and couldn’t.

The Mekorma team and I went to the Wild River Grill in downtown Reno and had a lovely meal. We went round the table and discussed what we got out of the conference and I must say that this meal with its conversation just confirmed that I made the right decision when I decided to link my company’s future with Mekorma by having them exclusively distribute and support my products. Thank you for including me in your team.

MekormaDinner1The Mekorma team (a great bunch of people) and Yours Truely.

Left to Right: Mike McDowell, Jay Manley, Angel Blum, Steve Linz, Ora Goldman, Craig Klapman, Mariano Gomez and David Musgrave

After dinner we returned to the Atlantis and found that some of our friends were still hanging around the Bistro Napa (even though it was closing). So I spent the final part of the evening chatting with Leslie Vail, Shiela Jefferson-Ross, Mark Polino, Frank Heslin. I also handed out my last packets of Tim Tams and Chicos.

Finally, Leslie and Sheila dropped me back to the Peppermill and the conference was over. I was happy that the conference was over and that it had been a great success, but I was also sad as it will now be another year (11 months or so) before I get to see my Conference Buddies again.


This article was originally posted on

Filed under: Conference, Dynamics, GP, GPUG, Microsoft Tagged: Conference, GPUG Summit 2015

Follow this link:
#GPUGSummit 2015 – Day 3

November 6, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 50

#GPUGSummit – Getting There – Part 2 of 2

David Meego - Click for blog homepageGPUGSummit_Logo

Day two of the Road Trip had us heading out from our overnight stop in Chico, California and finishing the drive to Reno, Nevada.

Below is the map of the route for the second day:


Now, I know that Australia has some funny place names, but it seems that the United States has its share too. During the drive we passed the turn off for a town called Rough and Ready in Nevada County (which is still in California).

Rough and Ready Highway

We decided to pull off the highway in a town called Grass Valley so we could find some lunch. We ended up at the Holbrooke Hotel, where we had a very nice meal. I really appreciated that the waitress made a special effort to ensure that there were no flavour enhancers in the food. She also helped identify that Ranch Dressing (both bottled and packet mix versions) usually contains one or more flavour enhancers*. Shame as I like the taste, but can not longer risk eating it.

The Holbrooke Hotel in Grass Valley

Before we left Grass Valley, Craig decided he wanted to get a coffee for the road and dropped in to a small corner store called Cousin Jack Pasties.

Cousin Jack Pasties, Grass Valley, California

This small shop is not remarkable, what is remarkable is what we found on the shelf in the store. I did not expect to find Vegemite in a small store a small town in the remote northern California.

Vegemite and Marmite – Australian and English yeast extract spreads

Once we were back on the road we were treated to some great scenery again.

Driving through the pine trees

Another fantastic view over the wilderness

We are getting closer now, Reno is on the road signs

Wide straight roads – a nice change from yesterday

Still driving through the mountains

Crossing the state border into Nevada

Arriving in Reno, Nevada

Finally, we came over a crest and Reno, Nevada appeared in the distance. With a little bit of help from GPS on the phone we arrived at the Peppermill Resort Spa Casino on South Virginia Street where I would be staying for the conference.

Approaching the Peppermill Resort

The two day road trip was over and I had survived. Thanks Craig. :)

Now to get ready for GPUG Summit 2015.


* Common Flavour Enhancers which can cause headaches, nausea, irritable bowel, asthma attacks and more include:

  • 621 – Mono Sodium Glutamate (MSG),
  • 627 – Disodium Guanylate,
  • 631 – Disodium Inosinate,
  • 635 – Disodium Ribonucleotide

This article was originally posted on

Filed under: Conference, Dynamics, GP, GPUG, Microsoft Tagged: Conference, GPUG Summit 2015

Follow this link:
#GPUGSummit – Getting There – Part 2 of 2

October 30, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 52

Excel Copy/Paste feature not working on General Entry modified window

If you have grown used to the relatively new Excel Copy/Paste feature in the General Ledger Transaction Entry, you are probably enjoying the benefits of collecting journalized spreadsheets from around the company and simply integrating these into Microsoft Dynamics GP without too much effort.

Excel Copy/Paste in GL Transaction Entry window

The fact is, not having to run an integration from another tool for something apparently very simple, always seems to be the way to go.

Recently, however, I ran into a situation where this window had been customized with Modifier (but the same can be said for a third party alternate version of window) by a customer. The customer reorganized a few fields within the window and added a couple others with Modifier to address some specific business needs. As it turned out, the Excel Copy/Paste functionality no longer worked, even though the target fields remained the same. Reverting security to the original window rendered the feature usable once more.

If you must modify this window _and_ still require the Excel Copy/Paste feature, you will need to create an additional user with access to the original (core) window. This is very similar to what’s required for Integration Manager to function when a window has been modified with Modifier or changed by a third party product.

Well, now you know! Happy copy/pasting!

Until next post!

Mariano Gomez, MVP

See more here:
Excel Copy/Paste feature not working on General Entry modified window

October 23, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 48