Microsoft Dynamics GP Roadmap to 2028 and Beyond

Microsoft Dynamics GPTerry Heley on the Dynamics GP Support and Services Blog posted an article on Friday on the exciting future of Microsoft Dynamics GP and giving a Lifecycle Update. As part of the article she inked to the published Lifecycle (Roadmap) for Microsoft Dynamics GP which extends to 2028 and beyond for Microsoft Dynamics GP.

The published roadmap also shows the end of mainstream and extended support for versions older versions of the product which predate the Modern Lifecycle:

Microsoft Dynamics GP Roadmap through to 2028

In brief:

  • 2013 and 2013 R2 are out of mainstream support and in extended support until 11/4/2023.
  • 2015 and 2015 R2 are out of mainstream support and in extended support until 14/4/2025.
  • 2016 and 2016 R2 are out of mainstream support on 13/7/2021 and in extended support until 7/4/2026.
  • 2018 and 2018 R2 in mainstream support until 10/1/2023 and in extended support until 7/4/2026.

Microsoft Dynamics GP is now under the Modern Lifecycle and has the same commitment from Microsoft as Dynamics 365. The Modern Lifecycle means there should be more frequent updates to Microsoft Dynamics GP with at least three updates a year in January, June/July and October.

Microsoft will continue to keep adding new features and improving it based on direct feedback from users. The best way to make sure you continue to benefit from the improvements is to keep up-to-date on upgrades and use the latest version of Microsoft Dynamics GP.

The key takeaway from the published Lifecycle is that Microsoft Dynamics GP is not going anywhere and development will continue under the Modern Lifecycle policy with multiple releases each year.

Microsoft Dynamics GP 2021 Mid-Year Update Released

Microsoft Dynamics GPThe 2021 Mid-Year update for Microsoft Dynamics GP 2016 and Fall 2020 (18.3) has been released. Full details of the release and download links are available on the Dynamics GP Support and Services Blog.

The key piece of new functionality is support for Group VAT functionality in the VAT 100 window in the 18.3 release (this new functionality has not been rolled back to Dynamics GP 2016).

The below fixes have been made to the Fall 2020 Release only ones noted with GP 2016 have been rolled back to that version):

  • MFA: GP calls MSGraphSignOut of form syEmailObj after every completed e-mail operation.
  • All Workflow escalation email notifications are not being sent as expected when a workflow is escalated.
  • Workflow Approval Email notification being sent instead of Final Approval Email when the step after it does not require approval.
  • A User is not able to receive more than two attachments in E-mail when MFA is enabled.
  • When assigning a Workflow Manager in a multi-domain environment, users from Domain B are unable to save a manager.
  • Failed logins are not properly tracked when using Activity Tracking in Dynamics GP.
  • All 1099 amounts (including less than minimums) print on 1099 incorrectly if any box in 1099 details meets a minimum required value (Fixed on GP 2016).
  • The 1099 NEC needs to work with Project Accounting employee expense and default into the entry window. (Fixed on GP 2016).
  • Remove Multi Currency Fully applied documents from PM HATB (Feature from Fall 2020 resolved).
  • Transfer pricing is not applied when you transfer from a contract to a quote.
  • You may receive an error Get/change operation on table ‘Batch Header’ when two users use the Sales Document look up.
  • You may notice a focus issue on the Purchase Order Entry window with Manufacturing installed and you enter 2 lines to link.
  • You may receive an error message ‘the budget does not exist for this Purchase Order, when you receive against a Project Accounting PO that was has multiple Projects.
  • When you approve Project Timesheets, you may see an error message The formal parameter @emailtemptable was not declared as an OUTPUT parameter.
  • Payables Copy and Paste feature does not work when MC (multi-currency) is not registered.
  • Human Resource VET 4212 report overstates the count if more than one VET box is marked on employee maintenance window.
  • Benefit Self Service Administer View does not recognize the Archive Flag when determining enrollment.
  • Payroll integration to Payables remit to address maybe incorrect when you post to payables.
  • VAT 100 Window Display issue after you install the January 2021.
  • Analytical Accounting CheckLinks updates the aaGLDistID and aaBrowseType incorrectly.
  • Protocol change for Australian ABN look up (Fixed on GP 2016).

lightbulb Important note regarding Dynamics GP 2016

Microsoft have announced that this will be the last update for Dynamics GP 2016; you will not receive a year end update for this version. If you are using Dynamics GP 2016, it is recommended that you start planning to upgrade to the 18.3 release or 18.4 release due in Fall 2021.

The announcement post on the available on the Dynamics GP Support and Services Blog has more details including download links for other languages, or you can download the English language hotfixes using the direct links below (logon to CustomerSource required):

Web Services for Microsoft Dynamics GP: How to Setup an Active Directory Security Store

Microsoft Dynamics GPTo use the Web Services for Microsoft Dynamics GP with TLS 1.2 you need to do two things:

  1. Upgrade to the Fall 2020 Release; you can’t just apply the hotfix to an October 2019 or earlier release, but have to use the full download media.
  2. Create an Active Directory Security Store.

Upgrading Dynamics GP is not a problem, but Active Directory isn’t my area of expertise. Fortunately, Microsoft have a set of instructions on the Dynamics GP Support and Services Blog which takes you through the creation of the security store.

Once the security store has been created, you need three pieces of information for the install of the web services:

  1. Name of the domain controller.
  2. Port 389.
  3. The partition string entered when creating the security store.

Microsoft Dynamics GP Fall 2020 Release Documentation

Microsoft Dynamics GPAs of the October 2019 release, Microsoft Dynamics GP moved onto the Modern Lifecycle which offers continuous support and servicing, including bug fixes, new features and the latest tax updates. There will be one major release per year along with at last two hotfix releases through the year.

There are a number of resource pages available or updated for the Fall 2020 Release of Microsoft Dynamics GP which has recently been released.

The Microsoft Dynamics GP Directory holds a wealth of information and links which will be useful to you, sorted by version and learning by module.

In addition to the Microsoft resources, I have also done two series on the Fall 2020 Release which you may find useful:

Missing Security Roles and Tasks After Upgrading to Microsoft Dynamics GP Fall 2020 Release

Microsoft Dynamics GPWhen upgrading Microsoft Dynamics GP, the security roles and tasks are not automatically updated; this is to avoid overwriting or causing problems with any customizations to these roles and tasks which might have been made. Instead Microsoft provide a set of scripts which you can choose to run to add the missing items.

I always recommend clients not directly amend the standard tasks, but make copies and amend the copy (this provides a way to roll back to the standard versions should there be a need).

The update scripts are available from the Dynamics GP Support and Services Blog and I have updated my links on the GP Missing Security Scripts page to link to that blog and the script directly; if you’re using an additional product such as Project Accounting, Enhanced Intrastat, VAT Daybook or HR & Payroll there are additional scripts on the blog post which you can run.

Microsoft Dynamics GP Fall 2020 Release New Features: Mask SSN on Human Resource Reports

Microsoft Dynamics GPThis post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available.

This post is on the Mask SSN on Human Resource Reports Human Resource & Payroll enhancement.

A few versions back, Microsoft added the Social Security Number (SSN) mask for payroll; this original change has prompted a request for this new functionality.

In the Human Resources Preferences window (Microsoft Dynamics GP menu » Tools » Setup » System » Human Resources Preferences), towards the bottom of the window a new SSN Mask button has been added.

Human Resources Preferences and Report Masking

By default on the install, everything will be marked as masked, so if you would like to see the SSN on the report you will need to unmark it from this window.

If you open the Report Masking window and no reports are listed, this script from Microsoft can be run to populate the default information. The selected reports can be amended through the window.

Click to show/hide the Microsoft Dynamics GP Fall 2020 Release New Features Series Index

Microsoft Dynamics GP Fall 2020 Release New Features: Disable system print dialog box when printing a Word Template

Microsoft Dynamics GPThis post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available.

This post is on the Disable system print dialog box when printing a Word Template Distribution enhancement.

With the Fall 2020 GP update, you can now use Named Printers to skip the Print Dialog and enable one-click printing of Word Templates.

To enable this feature you must first have Named Printers setup, you can find instructions for a new setup here.

Once you have the basic Named Printers setup, you can mark each printer to use Named Printers for Templates. Just open the Assign Named Printers window. Go to Tool, click setup, choose system, and click Named Printers.

Once you open this window, all you need to do is click the Setup button and select the Printer ID the users usually use, then mark the ‘Use Named Printer when printing word Templates’ checkbox. Click Save on the Setup Named Printers window, and now when users click print the document will be sent directly to the printer after generation.

Assign Named Printers
Setup Named Printers

Click to show/hide the Microsoft Dynamics GP Fall 2020 Release New Features Series Index

Microsoft Dynamics GP Fall 2020 Release New Features: Print all Sales Documents

Microsoft Dynamics GPThis post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available.

This post is on the Print all Sales Documents Distribution enhancement.

In the Print Sales documents window, there is now an option called “Print ALL Documents”. With the addition of this option there is now even more flexibility to print/email exactly how you want.

The Print All Documents, gives you the ability to tell Microsoft Dynamics GP when you want to actually print out all documents regardless if it was emailed or not. When you select E-mail and Print All documents the system will E-mail every document it can, then print all documents included in the range regardless if emailed or not. You can also select both ‘Print Document’ and ‘Send Document in E-mail’, and Microsoft Dynamics GP will E-mail every document it can, then print all other documents not setup for email.

Print Sales Documents

The Microsoft blog post includes some examples of how this functionality can be used.

As Béat Bucher notes in the comments, this may be useful to clients who want to retain a PDF copy of the documents produced, even when they have been emailed.

Click to show/hide the Microsoft Dynamics GP Fall 2020 Release New Features Series Index

Microsoft Dynamics GP Fall 2020 Release New Features: Export/Import stock counts to Excel

Microsoft Dynamics GPThis post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available.

This post is on the Export/Import stock counts to Excel Distribution enhancement.

The Stock Count Schedule and Stock Count Entry windows have had an Export/Import option added. When a stock count schedule is created, you can now export the data to excel. Then once the stock has been counted, Excel spreadsheet can be imported into the Stock Count Entry window where the Inventory variance can be posted.

To use this functionality, open the Stock Count Schedule window (Inventory area page » Transactions » Stock Count Schedule). When the count is started, the Export/Import option will become available allowing the user to export rhe count data to an Excel worksheet:

Stock Count Schedule

Continue reading “Microsoft Dynamics GP Fall 2020 Release New Features: Export/Import stock counts to Excel”

Microsoft Dynamics GP Fall 2020 Release New Features: Remove Fully applied Multicurrency documents from PM HATB

Microsoft Dynamics GPThis post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available.

This post is on the Remove Fully applied Multicurrency documents from PM HATB Financial enhancement.

For those of you working with different currencies we all know that seeing fully applied Multicurrency documents on the PM HATB can create a much longer report than necessary. With the new release of GP you will now have the ability to remove fully applied Multicurrency documents from your Payables Historical Aged Trial Balance making it easier to focus just on those documents that are outstanding.

In example below I have a customer with and invoice and payment that went through a revalue and are now fully applied. They do not show on the PM HATB where in previous versions they would have appeared on the report.

Payables Detailed Historical Aged Trial Balance

exclamation Important

An issue has been found in the Fall 2020 Release (18.3.1173) whereby the PM HATB is not showing the correct figures; this will be fixed in the U.S. Year-end Update due to release 11/20/2020.

Until this time a workaround would be to revert back to the 18.2 procedure for this report.

Click to show/hide the Microsoft Dynamics GP Fall 2020 Release New Features Series Index