The 2020 - U.S. Year end update has released for all versions, Microsoft Dynamics GP and GP 2016.  As a reminder, these updates are ALL inclusive of prior patches.  This is especially important for GP as it will include the October 2020 release (18.3) so make sure you test your upgrade, customizations, 3rd party/ISV solutions and business process to verify everything is working as it should.

We are now on Microsoft Docs, very exciting!!  Review U.S. Payroll specific documentation and install steps.

All you want to know about year end changes my module, check out the Year-End Blog Series

Below is a list of changes in this update by product version.  We do recommend customers to install this update based on the required year end changes and quality report fixes below.


*****If you receive an error message during the utilities update, when you install the 2020 U.S. Year-end Update released 11/19/2020 Violation of PRIMARY KEY constraint 'PKPM00204'. Cannot insert duplicate key in object 'dbo.PM00204' follow the Known Upgrade blog for a workaround.*****

Microsoft Dynamics GP (version18.3.1200) (Includes October release 18.3.1200) 
MicrosoftDynamicsGP18-KB4569474-ENU.msp
**All items that are fixed below on GP 2016 are also fixed on 18.3.1200, along with the below changes**

You may notice based on data size the Tax reports (Tax Details and Tax Transaction Summary reports) have performance degradation.
SQL 2019 issue on 18.2 “There is insufficient system memory in resource pool ‘default’ to run this query” Rolling down account segment description.
The Payroll Recreate Paystub includes Business Expense in Current Amount field which is incorrect.
Changes to new Print Sales Documents feature in 18.3.
1099 description for Misc and NEC and HR SSN mask are not updating when upgrading form mid year 2020.
General Ledger user defined fields cannot be searched on in SmartList.
When you install 18.3 General Ledger Copy and paste does not seem to work in certain cases.
You may notice the HATB is not printing correctly after the upgrade and dropping applied information.

Microsoft Dynamics GP 2016 (version 16.00.0814)
MicrosoftDynamicsGP16-KB4569476-ENU.msp

VAT Daybook Summary & VAT Daybook Detail reports do not include ALL records for JE's from GL (SERIES=5) in box 7 and Box 9 net purchasing amounts
VAT Return window unable to SAVE edits after installing 2020 Mid-year update
2020 Year-end update Form 1096 to include the totals for 1099-NEC verify 1099 too
Template Issues with recent Office Update – September 2020 – FIXED
Fixed Assets Enhancements Australian install a get/change operation on table 'FA_General_Information_MSTR' failed accessing SQL Data
Changes were made to the Payables Utility Update 1099 information around updating vendors from 1099 to 1099-NEC

Fixed Asset Luxury Auto Depreciation changes.
Payroll Box 14 open for all pay types to report COVID pay on W2's.
Payables 1096 form updated for 1099 NEC amounts.
Payables NEC and 1099-MISC
Payroll 941 format changes
ACA form and instruction changes

Table changes:

Review table changes in the U.S. Year-end Update.


Due to table changes with 18.3 release for General Ledger, after applying any update, you should Reconfigure change tracking for your MR Data Mart.  This is located In the Management Reporter Configuration Console, under the data mart integration, Reconfigure change tracking.

**The above regulatory changes are also included in Dynamics GP 2016 and Dynamics GP.**

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

Terry Heley

Year-end Enthusiast

Microsoft