Early last week, the Dynamics GP Support and Services Blog posted about a problem whereby Microsoft Dynamics GP will crash when emailing after the latest Microsoft Office update.
This officially effects all versions from Microsoft Dynamics GP 2013 RTM onward, but one comment on the above blog post says it also effects Dynamics GP 2010.
The Microsoft Office update which causes the problem is:
- Office 365 - Version 1811 (Build 11029.20079) - Standard
- Office 365 - Version 1811 (Build 11029.20045) - Insider Edition
- Office 2019 - Version 1811 (Build 11029.20079)
To check your version of Office, launch Microsoft Outlook, click File then Office Account; on the right hand side of the screen is a section for About Outlook:
There are two options to resolve the issue (you should only have to apply one of them):
- Revert/Rollback Microsoft Office to the last build.
- Rename Dynamics GP Code folder and run a Repair (this will remove 3rd Parties).
Instructions for both options are available on the Dynamics GP Support and Services Blog.
We've found that for clients with the problem, rolling back the version of Microsoft Office fixes the issue.
The Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 R2 on which I am following and adding commentary. The series index for this series of posts is here.
The fifth Feature of the Day is print and e-mail Sales Order Processing documents.
This new feature add a new option to print and e-mail Sales Order Processing documents at the same time. In the Sales Document Print Options window, you can now select Print Document and Send Document in E-mail at the same time:
Previously, you had to e-mail the documents and then print the remaining but now you can do both at the same time.
On the surface, this sounds like it should be a nice little time saving new feature, but I'm wondering how this ties in with print remaining documents, introduced in Microsoft Dynamics GP 2013 R2. I'll have to wait until I can get hads on to find out.
Microsoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.
The series index for this series of posts is here and will automatically update as posts go live.
The next of the Microsoft Dynamics GP 2018 RTM additional products I am going to install, is the Web Services for Microsoft Dynamics GP; a few years ago I rarely bothered installing the web services as they were not used by many of my clients. However, the introduction of Workflow 2.0 in Microsoft Dynamics GP 2013 R2 changed this; now almost every client requires the installation of web services when they upgrade, as this allows them to use email actions for approving submitted documents.
To install the Web Services for Microsoft Dynamics GP, launch the Microsoft Dynamics GP 2018 setup utility from the downloaded media. Depending on server settings, you might receive multiple security warnings during the installation; click Run on each one as it appears:
Under Additional Products, select Web Services Runtime and then click Install on the popup menu:
Continue reading "Hands On With MDGP 2018 RTM: Install Web Services Runtime"
The Dynamics GP Support and Services Blog blog announced the availability of the Microsoft Dynamics GP July Hotfix - 2017 Mid Year Tax Update towards the end of June.
This hotfix is available for Microsoft Dynamics GP 2013 R2, 2015 r2 and 2016 R2.
While all of them have updates for the US and Canadian Payroll systems, there were three changes in the 2016 version which caught my eye:
You may not be able to view any document attachment for any OPEN Payables Document.
- Invoice Receipt Date field added for UK installs, click here for details.
- Scan functionality may not function with document attach
The fixes to Document Attachment are good to see, but the Invoice Receipt Date was especially interesting as it results from new legislation which came into effect on April 1st for businesses of a certain size in the UK with a duty to report on their payment practices, policies and performance. This new requirement was introduced to protect smaller businesses that suffer from late payments, which can adversely affect their cash flow and jeopardize their ability to trade.
The new Invoice Receipt Date field is available on Payables Transaction Entry ( ), Receivings Transaction Entry ( ) and Purchasing Invoice Entry ( ).
The Doc Attach changes only effect 2016, but the new field is available in 2013, 2015 and 2016.
I've posted a few times about errors in Workflow requiring the wfDeployCLRAssemblies stored procedure to be run again (1 2 3), but the Dynamics GP Support and Services Blog has posted an article about how this is sometimes not sufficient to resolve the problem and the procedures, functions and assemblies deployed by the wfDeployCLRAssemblies stored procedure need to be deleted.
To this end, the blog post contains a series of scripts which need to be run before thew wfDeployCLRAssemblies stored procedure is executed. There are versions of the script for Microsoft Dynamics 2013 R2, 2015 (including 2015 R2) and 2016 (including 2016 R2).
If your problem still isn't fixed, then a support case would need to be raised.
I don't usually post about releases, except for major version releases. However, the January Hotfix release caught my eye with a few of the included features in the 2016 R2 one.
As well as having the US Payroll updates there are updates to the following which would be of benefit to clients in the UK:
- VAT Daybook Summary reports may not show correct data in boxes 1, 6 and 7 if you voided a transaction.
- VAT detail report may show incorrect figures if you have 2 or more tax codes on a transaction.
- The Excel copy and paste function may not calculate the credit/debit column correctly when using an allocation account.
Fixed Asset Management
- Tax values may not update properly if a user marks to create multiple fixed assets in the Fixed Asset Purchase Order additional information window.
- You may experience performance issues with the Checkbook Register Inquiry window after you install GP 2016 R2.
- Ability to change line distributions for time and material projects in revenue recognition.
- Fee Accounts not available in line distributions button.
- Purchase Receiving's not reflecting WIP account edits from Purchase Order for non-inventory items.
- Fixed issues with Uncollated printing.
The hotfixes for Dynamics GP 2013 R2 and 2015 R2 only contain US Payroll fixes.
The post from the Dynamics GP Support and Services blog contains the download links.
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
Updated 19/1/2017 to add link for Microsoft Dynamics GP 2016 R2
Updated 14/11/2017 to add link for Microsoft Dynamics GP 2018 RTM
One of the major new features in Microsoft Dynamics GP 2016 R1 is the HTML5 web client; this replaces the Silverlight web client released in Microsoft Dynamics GP 2013 R2.
The new features of the web client are:
- Support for Multi-browser (IE, Chrome, Safari, Edge)
- Support for Multi-device (Windows, iOS, Android)
- New controls created for HTML client
- UI changes
- Window Search
- Office “banner”
- Navigation, color, etc.
While the Silverlight web client was quite good, it was hobbled by dint of being Silverlight. There are quite a lot of iOS and Android devices out there which were unable to be used with the web client. Making the web client HTML5 not only makes it available cross browser, but it should also make it more flexible in terms of the size of device on which it can be used (Steve Endow at Dynamics GP Land posted his views on the "hamburger" menu used as a space saver back in September).
I'm fairly relaxed about this type of menu as I have seen them used on quite a few sites now and have largely adapted to their use. If that is the trade off for HTML5 then I'll be happy.
I did an upgrade of a client from Microsoft Dynamics GP 2010 R2 to Dynamics GP2015 recently and encountered a problem with eConnect.
This particular client uses the eConnect incoming queue to integrate journals and payables invoices into Dynamics GP from a housing management system.
After installing eConnect and configuring the incoming queue I set about doing a test to ensure it was working.
Unfortunately, it didn't.
Continue reading "eConnect Incoming Queue In Microsoft Dynamics GP 2015 Does Not Work"
I am slightly behind the times with this post as this news is a few weeks old, but I have been busy and am now trying to catch up. When David Musgrave was working for Microsoft he wrote the Support Debugging Tool which contained some very useful functions. I did wonder what the future held for it when he left Microsoft last year, but he posted a while ago that he had negotiated an exclusive agreement with Microsoft which allows him to continue work on and release the tool.
There will be some changed to the Support Debugging Tool under this agreement. Most noticeable is the fact that it will now be called GP Power Tools.
GP Power Tools will be initially released for the following Microsoft Dynamics GP versions:
- v11.0: Microsoft Dynamics GP 2010
- v12.0: Microsoft Dynamics GP 2013 and GP 2013 R2
- v14.0: Microsoft Dynamics GP 2015
There is going to be some changes to the functionality when GP Power Tools is launched:
- New simpler Navigation with menus and area page
- Database Validation, to ensure that your upgrades work
- Numerous enhancements and the odd bug fix
- And lots more….
Another change is that GP Power Tools will now be available via an annual subscription for each customer site at the special introductory price of US$365.00. That’s a dollar a day, and every four years you will get a day for free.
For now continue to use the free Support Debugging Tool for Microsoft Dynamics GP 2010 and GP 2013 (inc. GP 2013 R2) which is available from http://winthropdc.com/SDT.
Stay tuned here or to the WInthrop DC blog for more information on when to upgrade to GP Power Tools for continued support and improved functionality.
Those of you on Microsoft Dynamics GP 2015 will need to be patient for a while longer and wait for the release of GP Power Tools.