Table, Column, and Parameter Changes in Microsoft Dynamics GP October 2019 Release & 2019 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 2019 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:

SY01406 - User Master Staging / Users Master
SY10501 - Security Assignment User Role Staging / Security User Assignment
SY10601 - Security Assignment Role Task Staging / Security Setup
SY10701 - Security Task Assign Operations Staging / Security Setup
SY60101 - Company Access Sort /  User-Company Access

New Table in Company DB:

WF30101 - Workflow Security Change History / Workflow

New columns added to existing tables (SYSTEM DB):

SY01400 - Workflow_Status, WorkflowOriginCompany
SY09100 - Workflow_Status, WorkflowOriginCompany, SecurityRoleNameModified, SecurityRoleNameModified
SY10550 - Workflow_Status, WorkflowOriginCompany, secmodaltformsidmodified
SY09000 - Workflow_Status, SecurityTaskNameModified, SecurityTaskDescModified, SECURITYTASKCATEGORY, Workflow_Status

New columns added to existing tables (COMPANY DB):

PM10000 - LNGDESC
PM10300 - LNGDESC
PM20000 - LNGDESC
PM30200 - LNGDESC
PM40100 - ENBLNGDESC
UPR30600 - Workflow_Action_Date
WF40500 - Selected
UPR10200- PayRunIncAddlFedTax, PayRunIncAddLocalTax, PayRunIncAddStateTax
UPR10210- PayRunIncAddlFedTax, PayRunIncAddLocalTax, PayRunIncAddStateTax
UPR30700 - Reason_for_Change
DD20100 - Workflow_Action_Date
UPR42101- Workflow_Action_Date
UPR30604 -Workflow_Action_Date
POP40100 - GeneratePOMessageOption
IV00101 - USERID
FA00800 - FromClassID
FA00801 - TOCLASSID, FromClassID
APR_PIP40100 - VADCDTRO

2019 U.S. Year-end

UPR30604 - Workflow history new fields multiplejobs dependentclaimamt deductionamt (not used)

UPR00300 - Employee tax information new field dependentclaimamt

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.

Thanks

Terry Heley

Microsoft