Microsoft Dynamics GP 2020 - Mid-Year Update Released!

It is Summer and that means it is time to release the 2020 Mid-Year Update for GP.

The Canadian Payroll T4127 released, seems like there are no Federal changes, but there are changes for Yukon and British Columbia.

I know with COVID there is a lot of ask would GP 2015 support be extended, the answer is unfortunately not.  There is NO update this year for Dynamics GP 2015 - you know my theme song, you need to upgrade!!  If you are a Canada customer and on Dynamics GP 2015 and need these tax changes, you can reach out to Joesoftware Inc.  They will provide the update to you for a fee. (Thank you Joes!!)

Below is a list of what is fixed in this release:

Microsoft Dynamics GP (version 18.2.1100)

***NOTE***

There was a noted issue found if you applied the GP 2016 Mid-Year update, then tried to upgrade to 18.2 Mid-Year you received this error message:

Failure encountered Error:  Product 1632 does not support upgrading from version 16.0.838.

A new MSP has been released for 18.2 to fix this issue, KB4569348, please use it going forward.

Canadian Payroll - 18.2.1106
The mid-year 2020 Canadian Payroll Tax Update contains changes for Yukon and British Columbia.
Your RL-1 XML may be rejected with Box O and label RJ.
QPIP Rate and maximum amount updated for 2020 amounts.

System
Missing the Create New Table script when upgrading to 18.2 from prior versions of Microsoft Dynamics GP 2016.
You may notice Word Templates with Record Level notes print with additional spaces between characters, are not wrapped correctly, and do not keep carriage returns in the Word Template.

VAT
VAT 100 window should not require the system password when using the calculate button.  (GP2016)
VAT 100 Purchase Return w/Credit transactions not pulling tax amount in box 2 & box 4, 6 and 9. (GP2016)
VAT 100 Net Amount overstated on VAT Return Detail Purchase report if multiple tax detail codes on single transaction
VAT Daybook Detail report may have an incorrect total for Box 4 if multiple tax detail codes on a single purchasing transaction

To support the MTD for VAT requirements the HMRC requires the VAT API to supply header information to prevent fraud. To prevent fraud, these APIs from HMRC provide HTTP headers that must be used. Therefore, changes have been made only in the fraud prevention header information that is passed via the API. The actual calculation of VAT has not changed. (GP2016)

Financials 
You may receive an error message Unknown Identifier ‘Customer PO Number’ when using additional sorts in Cash Receipts window.
The payables check number may increment incorrectly in Print Checks window when vendor is setup to use EFT.
Payables Non Negotiable Check is not being printed when 'Use Check Numbers' is selected in Checkbook EFT Payables Options window.
The Receivables Transaction Inquiry - Document window may not display correctly with Regional Settings using a DDMMYYYY.
You may receive this error on the All Purchasing Transactions Navigation List Expression services limit has been reached with SQL 2019.
The Receivables Transaction Entry may hang with a UK install where multi currency is not enabled.
You may receive an error Conversion failed when converting the varchar value to data type Int when printing a General Ledger edit list with AA and RED active on SQL 2019.
Credit Card Payment batch updates Bank Rec incorrectly when Computer Checks origin is used and default Checkbook ID is populated in Payables Management Setup.

Payroll
Payroll Default Employee SmartList does not display employee filing status correctly after W4/2020 tax table changes. (GP2016)

There are NO table changes in this update, but there is a parameter change only for 18.2

The main changes done in the script PM_Generate_Next_Check_Number where a new optional Boolean parameter was added in the script which will be set as true if check number increment is not required.
Since the Boolean parameter is added hence the below forms are modified for adding the Boolean parameter.

PM_Manual_Payments
popPOPrepaymentWorkHist
PM_Void_Computer_Checks
PM_Transaction_Entry
PM_Print_Computer_Checks
PM_Manual_Payments

Microsoft Dynamics GP 2016 (version 16.00.0814) 

Fix list items above indicated with (GP2016) means that issue was fixed on Dynamics GP 2016 as well.

Canadian Payroll - 16.00.0847
The mid-year 2020 Canadian Payroll Tax Update contains changes for Yukon and British Columbia.
QPIP Rate and maximum amount updated for 2020 amounts.

Download links:
Microsoft Dynamics GP Service Packs
Microsoft Dynamics GP 2016 Service Packs

Have a wonderful rest of your summer!

Thanks

Terry Heley

Microsoft