Resources for Microsoft Dynamics GP Fall 2020 Release

Microsoft released the Fall 2020 version of Dynamics GP. Version 18.3 contains new features and bug fixes. It can update GP 2018 and 18.2. Microsoft has several webpages users can visit to get more information about this release. Partners and customers can download the product on Microsoft’s Product Release Downloads for Microsoft Dynamics GP page.

You can update your existing Dynamics GP (2018 or 18.2) install from the Service Pack page and check out the cool features on the Microsoft Dynamics GP New Feature Blog Series.

This update includes all 1099-MISC and NEC payable and form changes. See the update specifics here. There will still be a year-end update for Payroll and other changes; details are forthcoming.

There is no year-end update for GP 2018 R2. Users on 2018 R2 will install the year-end update, which will update their systems to 18.3. 

If you are patching from the February Hotfix or midyear update, there is an issue with 1099s—see documentation on page 14 of the Microsoft Dynamics GP 18.3 release for details.

Run this script on each of your company databases after the upgrade:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PM40104]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
Begin
    update PM40104 
    set TEN99BOXTEXT = 9 , DOLRAMNT = 600
    where TEN99TYPE = 3 and TEN99BOXTEXT = '8'
        
    update PM40104 
    set TEN99BOXTEXT = 8 , DOLRAMNT = 10.00000
    where TEN99TYPE = 3 and TEN99BOXTEXT = '7'

    update PM40104 
    set  TEN99BOXTEXT = 10, DOLRAMNT = 0.01000 
    where TEN99TYPE = 3 and TEN99BOXTEXT = '10'

    update PM40104 
    set TEN99BOXTEXT = 12 ,DOLRAMNT = 600
    where TEN99TYPE = 3 and TEN99BOXTEXT = '13'

    update PM40104 
    set TEN99BOXTEXT = 13 ,  DOLRAMNT = 0.01000
    where TEN99TYPE = 3 and TEN99BOXTEXT = '14'

    update PM40104 
    set TEN99BOXTEXT = 14, DOLRAMNT = 0.01000
    where TEN99TYPE = 3 and TEN99BOXTEXT = '15a  '

    update PM40104 
    set TEN99BOXTEXT = 15 ,  DOLRAMNT = 0.01000
        where TEN99TYPE = 3 and TEN99BOXTEXT = '15b  '
        
    update PM40104 
    set TEN99BOXTEXT = 17 ,  DOLRAMNT = 0.01000
    where TEN99TYPE = 3 and TEN99BOXTEXT = '16'

    delete from  PM40104
    where TEN99TYPE = 3 and TEN99BOXNUMBER = 15 and  TEN99BOXTEXT = '18' 

    If not exists(select * from PM40104 where TEN99TYPE = 4)
    begin
        insert PM40104 values (4,  '1',   1,'                                        ',600)
        insert PM40104 values (4,  '2',   4,'                                        ',0.01000)
        insert PM40104 values (4,  '3',   5,'                                        ',0.01000)
        insert PM40104 values (4,  '4',   7,'                                        ',0.01000)
    end
End

In addition to Microsoft resources, make sure you register for our October 22 webinar, where we will demonstrate several new features in 18.3. 

For more information, reach out to your BKD Trusted Advisor™ or submit the Contact Us form below.