Microsoft Dynamics GP 2016 Now Out of Mainstream Support

Microsoft Dynamics GPA couple of days ago, I posted about the updated Microsoft Dynamics GP roadmap which goes through 2028. One item which is worth noting, is that Microsoft Dynamics GP 2016 RTM and 2016 R2 are both out of mainstream support as of yesterday and those versions are now in extended support.

This means that critical security issues found will be fixed, but no feature enhancements or other bugs will be added or fixed. This does of course include changes to the VAT Daybook module which are very important to users in the UK with the ever changing requirements from HMRC for MTD.

If you are using Dynamics GP 2016, I would recommend contacting your partner to discuss an upgrade to a version under mainstream support. If you are in the UK it is important you do this as you will only get updates to the MTD functionality if you are on the latest build of Microsoft Dynamics GP and under the Modern Lifecycle policy.

For those clients with MTD requirements, but who, for whatever reason cannot upgrade at the moment, ISC have an add-on available for all versions of Microsoft Dynamics GP which will support the MTD submissions to HMRC. If you’d like to discuss requirements in this area, please use the contact form below.

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

Microsoft Dynamics GP Fall 2020 Release fixes recent Word template issue

Microsoft Dynamics GPA recent update to Microsoft Office broke the Word templates produced from Dynamics GP for both workflow notification/action emails and emailing of Word template documents (such as remittances, orders, invoices and so on). A few days after Microsoft shared details of the problem, they said a fix would be forthcoming and it is included in the 2020 Release.

This does mean that if you are on any version of Dynamics GP 2018 or on the 2019 Release, you will need to apply the 2020 Release update; a fix for Dynamics GP 2016 will also be released, but the method of approach is still being determined.

Feature Explained: Invoice Receipt Date

Microsoft Dynamics GPBack in 2017, regulations in the UK changed so that business of a certain minimum size, had to start recording the date an invoice was received. To support this new regulation, Microsoft introduced a new Invoice Receipt Date field to a number of windows in the Purchasing series. This new field was introduced in the July 2017 hotfix.

The presence of this field does not seem especially well-known, so I figured I do a quick post covering where it is and how it would be used.

The Invoice Receipt Date has been added to the Date Entry windows for the three types of transaction:

  • Payables Transaction Entry (Purchasing area page » Transactions » Transaction Entry)
  • Receivings Transaction Entry (Purchasing area page » Transactions » Receivings Transaction Entry)
  • Purchasing Invoice Entry (Purchasing area page » Transactions » Enter/Match Invoice)

Taking Payables Transaction Entry as an example, to access the Payables Date Entry field, click the expansion arrow next to the Doc. Date field:

Payables Transaction Entry

Continue reading “Feature Explained: Invoice Receipt Date”

Making Tax Digital Now Available in Dynamics GP 2016 and 2018

Microsoft Dynamics GPMicrosoft’s Jodi Christiansen has, on the Inside Microsoft Dynamics GP blog, announced the release of the January hotfix which includes the Making Tax Digital (MTD) updates required for VAT submissions to HMRC from April.

The Microsoft Docs site has been updated with setup instructions; I need to get it downloaded and installed to confirm the functionality, as all of the setup is around the VAT 100 and not VAT Daybook. Clients with more complex VAT often need VAT Daybook which allows them to define which tax codes appear in which boxes on the VAT Return. We’ve previously been assured by Microsoft that the MTD update would include both VAT 100 and VAT Daybook so I need to check that this is in fact the case.

The hotfix can be downloaded from CustomerSource (login required):

  1. Microsoft Dynamics GP 2016 lock
  2. Microsoft Dynamics GP 2018 lock

The MTD changes are only available for Microsoft Dynamics GP 2016 and 2018; applying the hotfix will update you to the latest version of the R2 release of these versions. If you’re on a prior version you will need to either upgrade to 2016 or 2018 or source an alternative way of submitting to MTD, such as ISC Software’s Making Tax Digital add-in.

Microsoft Dynamics GP Crashes/Closes When Emailing After Microsoft Office Update

Microsoft Dynamics GPEarly 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:

About Office section showing version number

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.

Microsoft Dynamics GP 2018 U.S. Year End Update Released (Includes Critical VAT Daybook Fixes)

Microsoft Dynamics GPDon’t be fooled by the name; the Microsoft Dynamics GP 2018 U.S. Year End Update includes other fixes, some of which are critical to clients running the Vat Daybook module.

This fix has all the usual stuff for the Payroll (US) module which you can read about here.

The other good stuff in this version is:

  • System
  • VAT Daybook
    • Purchasing tax amounts from GL entries are subtracting from boxes 2 and 7, instead of adding to boxes 4 and 7 on the VAT Summary.
    • Sales returns and credit memos are not deducting total taxable amount from box 6 on VAT return, and voids from box 1 and box 6.
    • Purchasing returns & credit memo’s, voids are not deducting total taxable amount from box 7 on VAT return, and invoices not updating box 4.

The Microsoft Dynamics GP hot fix is available from: Customer Source lock or PartnerSource lock.

The VAT Daybook fixes have also been rolled back into Microsoft Dynamics GP 2016 (but no earlier): Customer Source lock or PartnerSource lock.

Microsoft Dynamics GP Book Roundup

Microsoft Dynamics GPThere are a number of books available for Microsoft Dynamics GP which have been written by various people across a umber of years (although a few names crop up repeatedly). I thought it might be useful to list the books which are currently available for each version of Microsoft Dynamics GP; some of the books are only available for older versions of Dynamics GP, but the information within is still mostly relevant.

To avoid any appearence of favouritism, I have listed them in Dynamics GP version and author surname order (when multiple authors, the first listed author’s name is used).

Where there is no version in the name I have made by best guess as to which version it was written against.

Microsoft Dynamics GP 2018

Microsoft Dynamics GP 2016

Continue reading “Microsoft Dynamics GP Book Roundup”

GP Transaction Search v2: Customising the Configuration

Winthrop DCThis post is part of the series on installing and configuring version 2 of this free GP Transaction Search addin from Steve Endow of Precipio Services.

GP Transaction Search is usable as soon as it has been installed, but can be customised in two ways by amending the GP.TransactionSearch.dll.config which is in the addins folder.

Firstly, you can change the SearchAsYouType valuer from True to False; I’d recommend this change for large datasets or where speed issues are detected:

GP.TransactionSearch.dll.config

Continue reading “GP Transaction Search v2: Customising the Configuration”

GP Transaction Search v2: Downloading and Installing

Winthrop DCThis post is part of the series on installing and configuring version 2 of this free GP Transaction Search addin from Steve Endow of Precipio Services.

Now that the prerequisites are installed we can download and install the addin. GP Transaction Search can be downloaded from Precipio Services:

Precipio Services

Continue reading “GP Transaction Search v2: Downloading and Installing”