Page 1 of 2212345678910...20...Last »

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

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

#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: 67

"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: 411

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

Microsoft Dynamics GP 2015 Identity Management

Hi everyone! It’s been hectic around here with a few projects going live in these days, in addition to preparations for Convergence 2015 here in Atlanta.

I wanted to draw your attention to two videos currently posted on the Microsoft Dynamics YouTube channel, related to the Identity Management feature.

Identity Management was introduced with Microsoft Dynamics GP 2013 R2, so is probably good to go back and review the original feature design goal with Tara Higgins with the Partner Technical Consulting team.

With Dynamics GP 2015, the feature was extended to cover authentication with organizational accounts, which provides single sign-on capabilities for Microsoft Azure AD accounts. Identity Management for organizational accounts is a web client feature only. Take a look at this video by my buddy Jason Lech with the Escalation Engineering team.

My goal is to release a video showing a real life example on how to set this up. So stay tuned.

Until next post!

Mariano Gomez, MVP
Intelligent Partnerships, LLC

Originally posted here:
Microsoft Dynamics GP 2015 Identity Management

February 12, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 176

Welcome to the Microsoft Dynamics GP Engineering Team blog

Now, here’s something you don’t see every day: in the trench software development and testing engineers having time to write anything other than code. Well, the Microsoft Dynamics GP Engineering Team (consisting of the Development Engineering and Testing teams) have decided to break their ‘silence’ (so to speak) to pick up their digital pens and deliver some awesome content.

From this group you can expect content around the inner works of Service Based Architecture, Workflow and myriads of other engineering topics.

If you are an avid Microsoft Dynamics GP development engineer, a Microsoft Dynamics GP ISV, a technical consultant looking to propel your knowledge to new heights, then this new resource is for you! Expect coverage from folks like Alice Newsam, Rob Anderson, Michael Hammond, Chris Rudolph, Yuri Mikeev and others.

Below please find the link to the Dynamics GP Engineering Team Blog:

Dynamics GP Engineering Team Blog

Until next post!

Mariano Gomez, MVP
Intelligent Partnerships, LLC

Disclaimer: the above banner is not an official Microsoft or Microsoft Dynamics GP Engineering Team logo and was created solely for the purpose of bringing attention to the team’s new Community site.

View post:
Welcome to the Microsoft Dynamics GP Engineering Team blog

January 20, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 138