Table, Column, and Parameter Changes in Microsoft Dynamics GP October 2020 Release & 2020 Year-End

Here are the Table, Column and Parameter changes that we are aware of at this point in time for Microsoft Dynamics GP October 2020 release.  Please note that this blog is a work in progress, and is not all-inclusive meaning as more content becomes available we will be updating this blog.

New Tables in SYSTEM DB:

None

New Table in Company DB:

PMVendorMapCreditCardSetup - PM40107 with two fields OriginText and VENDORID

PMCreditCardAccountSetup - PM40108 – 3 fields CreditCardTrxType, ACTINDX, ACTNUMBR

New columns added to existing tables (SYSTEM DB):

STN41100 - ST_Printer_Options_MSTR - A new field 'UseNamedPrnForWordTemplate' is added to this table

New columns added to existing tables (COMPANY DB):

SY04900 - MSGraphClientID

General Ledger Setup - GL40000 columns - - usrdrpr5 and usrdrpr6

General Ledger Transaction tables - GL10000, GL20000, GL30000 - - user_defined_text01, user_defined_text02

PM00200 new column VENDDBA

2020 U.S. Year-end

For GP 2016 Feature rolled back for payables

PM00200 new column VENDDBA

2020 Canadian Year-end

No table changes needed.

Microsoft Dynamics GP SDK

There has not been an updated SDK (Software Development Kit) at this time, hence you only see GP 2015 SDK when you install it.  There are no plans for this to be updated in the future.  Common parameter changes that we have seen for GP will be documented in this blog.

You can also use GP Power Tools as part of the free version you can look up parameter changes.

Thanks

Terry Heley

Microsoft