Hello - Here are the Table, Column and Parameter changes that we are aware of at this point in time for Microsoft Dynamics GP 2018. 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 2018
Table Physical Name Table Technical NameCompany TablesWF70500 WF_Options_ROPTPM40106 pmPaymentBatchDefaultsSetupEHW40202 EHW_Code_LinkAPR_UPR40502 APR_UPR_SETP_Account_Import
New columns added to existing tables (SYSTEM DB):ASIEXP81 -- SmartListFavPassword
New columns added to existing tables (COMPANY DB):CM00002 -- PAYMENT_AMOUNT, DepAmtCO40100 -- AllowInInquiry, InquiryPasswordEHW20200 -- INACTIVE, EHW_DiscountEHW30200 -- INACTIVE, EHW_DiscountEHW40200 -- EHW_DiscountGL00100 -- Workflow_StatusPM00100 -- ONEPAYPERVENDINVPM00200 -- ONEPAYPERVENDINVPOP10300 -- Workflow_StatusPOP30300 -- Workflow_StatusPTE10000 -- wfShowOverBudgetWarningPTE10500 -- wfShowOverBudgetWarningWFI10004 -- WFReminderDueDate, WFReminderDueTime, WorkflowReminderSentWFI10003 -- WFStepReminderTimeLimit, WFStepRemTimeLimitUofMColumn name changes to existing tables (SYSTEM DB):SY40900 -- A few column names have changed but the Types of those columns have not:
DBNAME -- replaced INTERID Column_name
SQLOBJNAME -- replaced RESNAME Column_name
SVCDSPLNAME -- replaced DSPLNAME Column_name
2017 Mid-Year Update:If you had not previously installed the 2017 Mid-Year Update, you will also be getting this update within the year-end update as the updates are all-inclusive. Please take a look at the following article to note a new field that was introduced in that update:New 'Invoice Receipt Date' field added to comply with UK Legislation
Microsoft Dynamics GP 2018 SDKThere has not been an updated 2018 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 2016 and 2018 are listed HERE.
Continue to check back to the Microsoft Dynamics GP 2018 and Year-End Update Upgrade Blog Series Schedule page to review upcoming blog posts related to Upgrading Microsoft Dynamics GP and other helpful resource links.Thank you! Sarah Purdy | SR Technical Advisor | Microsoft Dynamics GP
GP Power Tools has the ability to show parameters for 95% of global and form procedures and functions in any dictionary (including 3rd party and ISV dictionaries)
It use Visual Studio to get the data and some scripts are not available in the files created by the Dictionary Assembly Generator tool.