I’ve recently been upgrading all of my demo and test environments from Microsoft Dynamics GP 2015 R2 to 2016 R1. Microsoft Dynamics GP 2015 R2 web client had a bug in the General Ledgers Transaction Entry windows Excel copy and paste function which prevented it from working.
It worked fine in the desktop client which meant for regular issues for those clients operating a hybrid installation with a mix of desktop and web clients. It could also cause problems when doing a demo and someone asked to see it while I had the web client open rather than the desktop client.
My understanding was that this bug was fixed in 2016, which I was really looking forward to; I also have a large client who was looking forward to this being fixed as well so they could minimise the use of Integration Manager for importing journals.
Unfortunately, after installing 2016 I did a quick test and found that copy and paste still did not work. I asked around and found that Belinda Allen had the exact same issue, she had found the issue already before I asked, which confirmed that it was not confined to my system.
Belinda raised a call with Microsoft and they have confirmed that it is a reproducible bug which has been escalated to the development team to look into.
It would be nice to have a hotfix, but I am guessing that it will be in Dynamics GP 2016 R2 at the earliest.
When you do a fresh install of Microsoft Dynamics GP, all of the required security roles and tasks are created. However, when Dynamics GP is upgraded, the new security roles and tasks are not automatically added. Microsoft do supply a set of scripts each time which can be run to add the roles and tasks.
This comes up every time we upgrade a client and I am tired of having to hunt out the posts from Microsoft, so I’m bringing together a list of the last few scripts and will add new ones here as each version is released.
The versions I could find again are listed below
- Microsoft Dynamics GP 2013 R2
- Microsoft Dynamics GP 2015 RTM
- Microsoft Dynamics GP 2015 R2
- Microsoft Dynamics GP 2016 RTM
- Microsoft Dynamics GP 2016 R2
To do this, launch the Microsoft Dynamics GP 2016 setup utility and select Web Components:
The final additional product to install, is the Service Based Architecture. This is a relatively new addition for Dynamics GP which allows for interaction using REST based web services, rather than the more traditional SOAP based ones made available via the Web Services for Microsoft Dynamics GP.
There are two steps to installing Service Based Architecture (SBA), the first of which, install the SBA feature to the Dynamics GP client. This is the one which we will cover in this post; the next post will cover the second.
I am going to add this feature to the desktop client installation on my web server, so need to use the Programs and Features Control Panel applet. Once it is loaded, select Microsoft Dynamics GP and click Change:
To install the Web Resource Cache start the setup utility from the download media and, under the Additional Products header click on GP Web Resource Cache:
Not having to install SilverLight on each PC or laptop which will run the web client is a definite plus; likewise it being cross platform and supported on Chrome, Safari and Firefox is another plus.
The HTML5 web client is also, in my opinion, quicker than the old SilverLight one.
However, there is one large negative which escaped me when doing initial testing and which Belinda Allen pointed out, although not on her blog, you can only have one open at a time; when you open a window the area pages are disabled, preventing you from opening another:
You can still drill down to other windows so you can for example drill from the Account Summary Inquiry to the Detailed Summary Inquiry or from Vendor Maintenance to Country Code Maintenance:
When you do open one window from a drill down the original window is then disabled. To toggle between them you need to use the Search for a Form or Report window:
This situation has created a bit of an outcry at Microsoft asking that they do further work to allow multiple window to be open at the same time. There is a post on the Microsoft Connect site where you can vote on this issue and impress upon Microsoft the importance that a resolution is found for this issue. You can vote here.
One of the main issues with the approach Microsoft have taken is that some ISV products rely on having more than one window open at the same time; another is it can seriously interrupt your workflow by being restricted to one window. Imagine, you’re half-way through creating a new vendor card when a customer rings up with an invoice query; you’d need to close the Vendor Maintenance window to open the Transactions by Debtor one.
With the web client installed and configured, it is now time to log in for the first time. With previous versions of the web client, this meant installing SilverLight, but the new web client is HTML5 based.
When you navigate to the GP app on the web server there is no apparent difference between the Microsoft Dynamics GP 2016 web client and the previous version; in both cases you need to login using your Domain Account:
The second of the wizards which pops up after the web client has been installed is the Web Components Help.
On the Welcome step click on Install to begin the installation:
Once the installation of the web client is complete, two wizards will be started. The first of these is the Microsoft Dynamics GP Web Components Configuration Wizard.
On the Welcome step click on Next:
To install the web client, launch the setup utility from the downloaded installation media. Under Additional Products click on Web Client: