Page 1 of 2312345678910...20...Last »

#GPUGSummit 2015 – Day 1 – Part 1 of 2

David Meego - Click for blog homepageGPUGSummit_Logo

Day 1 of the conference was finally here and I had three sessions to present including one with a brand new co-presenter. While this was officially the first day, it really felt like day three as I had already had two full days.

Breakfast in the meal hall was fairly quick affair. It is an amazing feat to be able cater for such a large group. There was even a table marked for GPUG members from Australia, which happened to be the first table in the meal hall. You will have to excuse Beat and Thomas who “crashed” the table to sit with me.

Breakfast in the Meal Hall

After breakfast we all headed to the Opening Session in Hall 3. As we walked into the hall we were treated to a huge photo of Frank Heslin with quote of his about the GPUG Community on the massive screen (using 4 projectors).

Opening Session

The session was packed, I was only able to capture about half of the hall in a photo, but imagine the other half being just as full.

The session has full to capacity as it included all four user groups

The session started with Andy Hafer, CEO of Dynamic Communities, welcoming us to Reno….

Andy Hafer welcomes the User Groups to Reno

Andy and Missy Heilman invite the User Group Leaders on stage

Acknowledging the conference sponsors takes an unusual turn

Andy introduces our guest keynote speaker, George Kourounis, host of Angry Planet

George talks to us about controlling fear while he is going to all kinds of dangerous locations

George ( showed us a video that explains what a day at the office was like for him.

GPUG Summit 2015 in Reno – Opening Session Keynote (direct link)


Epic Volcano Video (direct link)


World’s best selfie from the edge of the lava lake inside Marum volcano on Ambrym Island, Vanuatu

The opening session finished with a Q & A session with George and Andy

After the opening session, Mariano Gomez and I had our first breakout session in which we discussed Service Based Architecture and App technology and showed how you can call web services to retrieve data from your Microsoft Dynamics GP system. This was an overview that set a theme for a number of app related sessions.

TOT01 – Calling all Geeks! Find out how Apps work with Dynamics GP

Our second breakout session followed on from the first with demonstrations of how different companies had used App technology. It was originally planned to be a competition to decide on who had created the best app, but we did not get enough apps to show. Maybe, next year….

So, instead we used the session to highlight examples of apps created by a couple of partners. Thomas Garcia demoed a solution for handling transaction approvals from Icon Business Consulting. This solution does not use the GP 2015 Web Services, but that means that it can work with all supported versions of Dynamics GP. Chris Hanson (not Martin Olsen as shown on the slide deck) from eOne Solutions demoed an end to end solution that used a variety of technologies including their Service Builder and Smart Connect products.


David and Mariano with the “winners” of the GP App Off: Thomas Garcia and Chris Hanson

After the sessions, I headed over the to Mekorma Hub. My plan was to spend as much time as possible between sessions at the hub so that I was available if anyone had questions on my GP Power Tools (GPPT) and Batch Posting Service Toolkit (BPST) which are distributed and supported by Mekorma. On the way, I caught up with some of the Microsoft Dynamics GP Product Management team from Fargo.

Jodi Christiansen, Chad Sogge, Jennifer Ranz and Daryl Anderson

Mekorma Hub: Mariano Gomez, Ora Goldman, Jay Manley, Angel Blum

After having lunch with Mekorma team, I rushed down to the convention center to catch the end of the GPUG Welcome and Dynamics IDOL general session. I walked in just when Bob McAdam was demonstrating Field Level Security and giving me credit for developing it… perfect timing. Congratulations to Shawn Dorward for beating out Bob McAdam and Michelle Kocher to win the Dynamics IDOL title for 2015.

I caught up with Beat Bucher and we headed back to the Atlantis and the Mekorma Hub. Beat and I then went to the presenter’s preparation room to prepare for the next session. Normally Mariano Gomez co-presents with me, but Mariano had been double booked as he also had a session of his own in the same timeslot. Beat has always been an enthusiastic supporter and user of the Support Debugging Tool and now GP Power Tools and so it made sense to ask him to present the topic with me. We just spent a little time together to make sure he was happy with the session plan and also we made a few adjustments as the session was 90 minutes rather than the usual 60 minutes. This allowed us to demonstrate some of the new features only available in GP Power Tools.

TOT03 – Why is the Support Debugging Tool/GP Power Tools so Amazing?

The session was full and was a lot of fun. We brought back the question “Can GP Power Tools help?” and the response “Yes it can!”. It was funny as even when the question was not asked correctly or sometimes forgotten entirely, the audience still yelled out “Yes it can!”. Thanks to the attendees for helping make the session awesome, hopefully you learnt a few reasons why GP Power Tools is so amazing. :)

Beat Bucher did a great job presenting for our first time together

That completed the work part of the day for me. Three of the seven sessions I was involved in were completed.


This article was originally posted on

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

See the original post:
#GPUGSummit 2015 – Day 1 – Part 1 of 2

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

#reIMAGINE2015 – Day 3

David Meego - Click for blog homepagereIMAGINE2015_Logo

The final day of reIMAGINE 2015 combined breakfast with another Rapid Fire Partner Solution session. Then we had a Closing session which included a great keynote by one of the fathers of Dexterity (the language behind Dynamics GP), Tim Brookins.

Tim discussed the Internet Of Things (IOT) and how gathering data can help make smarter decisions. For example, understanding the driving habits of different demographic groups allows insurance companies to offer policies and premiums appropriately so they can still run a profitable business. He mentioned that some insurance companies now offer lower premiums to “safe” drivers if they are willing to install a dongle into their car which monitors car usage and metrics such as hard acceleration and braking. If you decide to protect your privacy and not use the dongle, you will be left in the “risky” drivers group. Over time the premium for the safe group will drop and rise for the risky group. Even if you are a safe driver, protecting your privacy will cost you.

Tim’s final example related to email and whether you are paying for your email service. If you are not paying and are using a “free” service, you will have to accept that your privacy will be diminished as the service provider is going to either serve up adverts or is expecting you to also use other paid services.

In summary, you will need to pay in one way or another if you want to protect your privacy. The service providers have to make their money somewhere. An Australian TV show about advertising called “The Gruen Factor“, summed it up as “If you are getting a service without paying for it, then you not the customer, you are the product”.

The Closing Session finished with the details of when the next conference will be, mark your calendars now for reIMAGINE 2016. It will be back in Fargo, September 19-21, 2016. More details will be available later this year, but it will be at the Hilton Garden Inn again.

Insert great photo here of David with Tim Brookins. :-(

The conference was not over yet with the last sessions still to come.

I actually was able to attend my first breakout session that I was not directly involved with. I sat in on Brian Roney’s “Tried and True Practices for Developing SBA Operations”. This was a great session which covered Service Based Architecture, .Net objects and .Net Interop as well as window linked and decoupled service enabled procedures.

Now, it was time for another new (and experimental) session presented by Mariano and myself. The “Developing in Dexterity” session was designed to be a bit of an introduction into Dexterity development while still having some advanced topics covered. Mariano and I have covered Dexterity before we have usually skipped over some of the steps involved or used macros to speed them up.

This time I decided to raise the bar and challenge myself. With Mariano’s help, I would code an example customisation live in a 60 minute session. To prove it was live, we got the audience to select the window (from a list of 3 suggestions) and to provide the names for a string field and a drop down list field. This fields would be added to the window as user defined fields and stored in a parallel table. The default value for the string and the contents (3 items) of the drop down list were also chosen by the audience.

After creating the fields and the table and adding the fields to the window, I used previously exported scripts to drive the windows. To make them work, I had to perform a number of find and replace steps to rename all the objects as required. I then created and deployed the chunk and showed it working in a live application.

The next step was to create a set of Service Based Architecture services to allow the additional fields to created, updated, deleted and retrieved. While I messed up one of the find and replace steps, I was able to get the code compiled and deployed into the live system. Hopefully, the attendees enjoyed the session seeing me put under pressure and almost screwing up.

Insert photo of session attendees here. Sorry guys can’t make you famous.

After the Dexterity session was over, we had a quick boxed lunch and then I had a couple of meetings with the Dynamics GP development team and Dynamics GP product managers. These meetings were very productive, but I can’t tell you any details. If I did, then I would have to get someone else to shoot you…. I don’t own a gun.

After the meetings, we assembled at Sheila JR and Leslie’s room at the Home2 Suites for some pre-dinner drinks before we all headed over to Passage to India for what has become an annual tradition. Yummy Butter Chicken, Rogan Josh and Garlic Naan.

DinnerClockwise: Mariano Gomez, John Lowther, Sheila Jefferson-Ross, David Musgrave, Belinda Allen, Jen Kuntz, Leslie Vaile, Sheila Ochoa, & Emily Halverson.

This brought the conference to a close with most of the attendees flying out the next day (except for the locals). You have already heard of some of my exploits on the next day with the destruction of all my photos.

Conference Wrap Up in the next post…


This article was originally posted on

Filed under: Conference, Dynamics, GP, Microsoft Tagged: Conference, reIMAGINE 2015

Read More:
#reIMAGINE2015 – Day 3

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

Microsoft Dynamics GP Web Client no longer working on Google Chrome 45

If you had gotten used to running the Microsoft Dynamics GP web client on Google Chrome, chances are you have just woken up to the constant requests for installing the Silverlight plugin. You may have attempted the installation a few times by now, only to notice that you are still being requested to install Silverlight.

Microsoft Dynamics GP Web Client on Chrome 45 

Google Chrome users who normally relied on functionality that NPAPI plugins provided won’t be able to make use of them anymore with the release of Chrome 45. NPAPI-only plugins such as Java or Silverlight are used throughout the web and while their use is declining, there are numerous applications and services that make use of either one or another plugin – for example, your beloved Microsoft Dynamics GP web client.

This Chrome Extensions article explains the security concerns behind the use of NPAPI-based plugins, mainly, the ability of said plugins to gain access to a user’s local machines. Any security gaps in such plugins would render a user’s machine vulnerable to exploits by malicious code.

However, this should not at all come as a surprise, since Google had it in the works to remove NPAPI support since September of 2013, see Saying Goodbye to Our Old Friend NPAPI, with Chrome 45 selected as target for final deprecation.

So what are the alternatives?

Well, you can fall back once more to Internet Explorer 10 (desktop), Mozilla Firefox, or even Apple’s Safari. If my mind serves me correctly, the latter two will have some minor limitations (as in “may not be fully compatible”).

Option number 2 would have you downgrading Chrome, if you are willing to get the installer from non-Google sites like Old Apps or File Hippo.

As a final note, the following browsers DO NOT support Silverlight:

Microsoft Internet Explorer 10 modern UI
Microsoft Edge (formerly code name Spartan, available on Windows 10)
Google Chrome (version 45 and above)
Opera (version 20 and above, current version is 32)

Until next post!

Mariano Gomez, MVP
Intelligent Partnerships, LLC

Read More:
Microsoft Dynamics GP Web Client no longer working on Google Chrome 45

September 18, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 62

Vote now for your 2015 GPUG All Stars

David Meego - Click for blog homepageEach year GPUG (Dynamics GP User Group) recognises three individuals from the Microsoft Dynamics GP community who go above and beyond to help others.

These individuals will be recognised as GPUG All Stars at the upcoming GPUG Summit in Reno, NV, USA.

GPUP All Star

Please vote now… there are only 2 weeks left before the poll closes.

OK, before we go any further, I will admit that I am one of the nominees for this year and that I would love you to vote for me.

That said, there also many other very deserving individuals from both customer and partner organisations.

For more details on the award and the link to the voting poll, please check out Kim “Mamma” Peterson’s blog post

Voting closes on the 31st August 2015, so please vote now.

Happy voting.


This article was originally posted on

Filed under: GPUG, News Tagged: GPUG, News

Visit site:
Vote now for your 2015 GPUG All Stars

August 15, 2015 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 67

#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.

The functions provided by the custom service enabled procedures are controlled by the contents of the Runtime Execute Script ID identified in the URI or first parameter when the procedure was called.

Using the Runtime Execute window you can select one of the five procedures as a custom script purpose, this will populate the script with the template code needed to pass the parameters between the service enabled procedure and the Runtime Execute script.

To provide a flexible multi-purpose parameter format that can work for all version of Dynamics GP, the parameters in and out are passed using the Text datatype. Each line of the Text parameter can be used to represent a separate data field.

The template code populated, when you choose one of the service enabled procedures as a custom script purpose, provides example code using the Customer Master table.

  • ServiceCreateCustom – Create a new record
  • ServiceDeleteCustom – Delete a record
  • ServiceGetCustom – Retrieve a record
  • ServiceUpdateCustom – Update an existing record
  • ServicePostCustom – Perform any additional function (the demo code does maths)

The screenshot below shows the Runtime Execute window with the ServiceDeleteCustom template code. The template code retrieves the Customer ID to be deleted from the first line of the text parameter and then executes the code to locate and remove the record, returning any error codes as the status.


While the base language for the Runtime Execute window is Dexterity sanScript, you have the option of using Helper Functions to call SQL Execute (T-SQL) scripts, or .Net Execute (Visual C# or Visual Basic.Net) scripts.

In summary, this means that GP Power Tools provides custom web services which can be coded in any combination of Dexterity sanScript, SQL Transact-SQL, Visual C# or Visual Basic.Net.

The possibilities are endless.



This article was originally posted on

Filed under: 2010, 2013, 2013 R2, 2015, 2015 R2, Dynamics, GP, GP Power Tools, Microsoft, Products Tagged: GP 2010, GP 2013, GP 2015, GP Power Tools, GPPT, What’s New

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

August 14, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 100

"A SQL Server login already exists for . Delete the user and create a new user" error when switching a user ID from web client only to mixed…

I’m completing the deployment of Microsoft Dynamics GP 2013 R2’s Project Accounting and Time Entry approval workflow for a customer in Alabama who is currently deploying web client for extranet access (and timesheet entry) and desktop client for intranet access.

As a result, since time entry employees are remote, we decided to setup these user accounts as web client only. However, the customer wanted to provide an alternative to the web client in case it became unavailable. This meant that these users would needed the ability to access the Microsoft Dynamics GP desktop client via a Terminal Server provisioned (albeit temporarily) to support this goal.

The Problem

To meet this requirement, we needed to adjust the user accounts in Dynamics GP to also support SQL Server authentication (in addition to web client access), by deselecting the Web Client user only check mark and completing the SQL Login credentials information. Upon attempting to save the changes we received the following error:

A SQL Server login already exists for userID. Delete the user and create a new user.

As it so turns out with most application errors, you cannot just follow the instructions literally to fix the problem. In this case, we had more than 85 web client only user accounts created so “Delete the user and create a new user” wasn’t an option and I don’t know why I had a gut instinct this recommendation would not work anyways.

It also turns out that I tested this in Microsoft Dynamics GP 2015 and had no issues switching a user account from Web Client user only to a mixed mode access user account.

NOTE: “mixed mode access” user is a terminology I came up with to identify a Microsoft Dynamics GP user account with access capabilities from both the web client and desktop client.

The Solution

In troubleshooting this problem, the first thing is to focus on the first part of the error message, “A SQL Server login already exists”. If a login already exists on SQL Server, then it should be visible under Management Studio – bear in mind that each Dynamics GP user account was setup as a web client only account to begin with. In principle, there should be no SQL Server security principal for these type of accounts.

Management Studio did not show any account created for the Dynamics GP under the Security folder. So the next logical thing would be to run a statement to check for a SID for the account in question:

SELECT suser_sid(‘TheUserID’);

This statement returned an actual SID number (a long hexadecimal set of characters), confirming at least there was a corresponding SID for the account, even though we could not see the actual account in Management Studio.

Next was to verify then, what account was assigned to that SID. In order to do this, I ran the following SQL statement:

SELECT name FROM sys.server_principals where sid = (SELECT suser_sid(‘TheUserID’));

As it turned out, this statement returned no results. So here’s the conundrum… GP thinks there’s a SQL login for a user account that doesn’t really exists on SQL, but has a SID.

Now, because there wasn’t an actual SQL login for the user ID in question, I went ahead and setup a new SQL login with the user account by running the following statement:

sp_addlogin(‘TheUserID’, ‘somePassword’);

The statement was successful and I could now see the SQL login under the security folder.

The next thing was to then reset the Dynamics GP web client user flag and assign the SQL login to the user account:

UPDATE SY01400 SET WCUser = 0,  SQLLoginID = ‘TheUserID’ WHERE USERID = ‘TheUserID';

Since Microsoft Dynamics GP passwords are encrypted on SQL Server, you will now need to log into Dynamics GP, pull up the user account under the User Maintenance window, and change the password in the SQL login credentials section.

I cannot assess whether this is a bug or not, but suffice to say the same behavior is not present in GP 2015, so I must lean towards it being a bug.

I hope you find these troubleshooting steps useful.

Until next post!

Mariano Gomez, MVP
Intelligent Partnerships, LLC

Continued here:
"A SQL Server login already exists for . Delete the user and create a new user" error when switching a user ID from web client only to mixed…

May 29, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 516

Microsoft Convergence Atlanta 2015 (#CONV15) – Day 3

Ok, I’m officially tired! Day 2 did not leave much room to sleep with a presentation, expo, dinner, and Rock-n-Rave (even though I did not stay long).

However, today I had to gut it out for our repeat session, CS15G024-R2 Microsoft Dynamics GP 2015: Customizing the user interface, which was scheduled for 11:00 AM.

CS15G024-R2 Microsoft Dynamics GP 2015: Customizing the user interface
Mariano Gomez and David Musgrave

We had 64 people in our session and really had an enthusiastic crowd despite the Rock-n-Rave precedent. The session went on as planned and we feel we had a bit more organization in our delivery.

Once our session finished, I ran off to Kevin and Dan’s session, CS15G014 – Leveraging Microsoft Dynamics GP 2015: Service Based Architecture for better integrations.

Kevin Racer and Dan Lothspeich

This session was truly informative as Kevin and Dan walked through the evolution of the work environment and how it has been impacted by the ever increasing hours we spend working, the ever decreasing workforce age, our own understanding of the Internet, the increasing workload many of us are challenged with, and the endless ways to communicate. This all has led companies to seek increased computing resources to process massive amounts of data which cloud computing seems to deliver well via a service oriented architecture model. This service model has driven the appification of software functionality, a technique by which software functions are exposed as services to be consumed by other software applications.

This brings us to the Microsoft Dynamics GP Service Based Architecture model, which seeks to expose parts of Dynamics GP as services to be consumed by other applications, also allowing Dynamics GP to consume services.

Microsoft Dynamics GP Service Based Architecture

The key to this technology evolution has been the enhanced interoperability with Microsoft .NET built within the Microsoft Dexterity toolset and leveraged via the Dynamics GP application. Kevin then went on to conduct a short demo on the endpoint URI structure and patterns to access the Dynamics GP services and showed off some of the cool discovery tools available, while detailing the security flow and authentication mechanisms required to access the Dynamics GP services.

Then we had eOne demoing their latest product, Service Builder which allows users and developers to expose any part of GP as a service, similar to how SmartList Builder exposes GP data. In fact, the idea is to also allow users to expose smart lists as services. Other applications include being able to expose Microsoft Dynamics GP windows and the underlying Dexterity scripts as services, conceivably allowing any function within GP to be consumed by other applications.

Well, I could go on and on, but hopefully you get the point. Kevin and Dan’s session is available on the Virtual Convergence site, here.

I returned to the Expo to try and catch up with David who had attended another session, but decided to go visit some folks I hadn’t seen yet. After saying hi and catching up with David, we returned to the Omni Hotel in preparation for the OneRepublic concert and to decompress from the day. I had invited a good friend of mine and I left to pick her up and return to the Phillips Arena.

The OneRepublic concert motto: “One Believable Convergence Celebration”

Once inside the arena, we quickly head to the floor area to get a good view of the group for the opening. In the meantime, we were enjoying some of the cool music being played. The group came on stage with their song Light it Up to open the concert.

The concert got progressively better with the group artists hitting some solos.

Well, the night was really a good one, but it was time to wrap up and get home.

Until next post!

Mariano Gomez, MVP
Intelligent Partnerships, LLC

Read more here:
Microsoft Convergence Atlanta 2015 (#CONV15) – Day 3

April 2, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 151