Hello -
Here are the Table, Column and Parameter changes that we are aware of at this point in time for Microsoft Dynamics GP 2016 R2. 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 that were added to Microsoft Dynamics GP 2016 R2
Table Physical Name Table Technical Name
System Tables
ADH00106 ADH_Favorite_LookupAssignment
ASIEXP101 ASI_FavoritePassword_SETP
Company Tables
APR_DIA_Mandatory_HIST
CM30200 CM_Transaction_History
CM30300 CM_Receipt_History
UPR30700 uprEmployeeHistory
Data Type Change on an Existing Column:
The data type changed from 'STR17_LBAU' to 'STR30_LBAU' for the PAerdocnumber column in the following tables:
PA10502
PA30504
PA10504
PA30500
PA30501
PA30503
PA10500
PA10501
PDK10500
PTE10500
PTE30500
New columns added to existing tables (SYSTEM DB):
ASIEXP101 -- CMPANYID, SmartListPassword
SY40800 -- PowerBIWebClientID, PowerBIAppKey
New columns added to existing tables (COMPANY DB):
CM20200 – VNDCHKNM
FA49900 -- IncludeTaxInAcqustCost
FA01300 -- IncludeTaxInAcqustCost, ORTAXAMT
IVC10500 -- TXDTLPCTAMT
SOP10105 -- TXDTLPCTAMT
RM30601 -- TXDTLPCTAMT
RM10601 -- TXDTLPCTAMT
FA01400 -- IncludeTaxInAcqustCost
FA01401 -- IncludeTaxInAcqustCost
FA01100 -- IncludeTaxInAcqustCost
FA00100 -- IncludeTaxInAcqustCost
POP10310 -- OriginatingPPTaxAmount
POP30310 -- OriginatingPPTaxAmount
APR_PIP40100 -- ACTINDX, ADRSCODE
PTO00101 -- USERID
Microsoft Dynamics GP 2016 SDK
There has not been updated 2016 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 we have seen are listed HERE.
Check back to the Microsoft Dynamics GP 2016 R2 and Year-End Update Upgrade Blog Series Schedule page to review our blog posts related to Upgrading Microsoft Dynamics GP and other helpful resource links.
Thank you!
Sarah Purdy | SR Technical Advisor | Microsoft Dynamics GP

Like
Report
*This post is locked for comments