web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / Dynamics GP Support and Services Blog / Table, Column, and Paramete...

Table, Column, and Parameter Changes in Microsoft Dynamics GP 2016 R2 and Year-End Update

Views (7600)
Sarah Purdy Profile Picture Sarah Purdy

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

Comments

*This post is locked for comments

  • Martin Haramburu Profile Picture Martin Haramburu 187
    Posted at

    Hi Sarah:

    I second David, we really need a clear understanding of the parameters in each version, taking into account we develop localizations of Dynamics GP. We would like to vbe able to dowload CoreParams_160.txt,

  • SaintFrag Profile Picture SaintFrag 207
    Posted at

    Microsoft confirmed that this information is incorrect:

    PTO00101 --    USERID

  • Tim Wappat Profile Picture Tim Wappat 5,711
    Posted at

    Agree - its a key developer resource, especially for things like parameter changes. Diffing blog posts to work out what has changed through editions is not the same.

  • Lou@ACE Profile Picture Lou@ACE 447
    Posted at

    The SDK has been an invaluable resource for integrating Dynamics GP with other solutions for many, many years.  It is most unfortunate to see its demise.  I hope the product team will reconsider.

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture David Musgrave MVP ... 14,095 Most Valuable Professional
    Posted at

    Hi Sarah

    The Common parameter changes document is missing many other procedures have have been changed between versions.  Most have added optional parameters which work alright when you call them without the new parameters, but fail when you attempt to register triggers against them.

    It would be nice to have full list of changes or better still and updated copy of the CoreParams_XX0.txt document.

    Thanks

    David