Notifications
Announcements
I was wondering if anyone knows where to get the full database schema and field information for MS Dynamics GP Version 18R2
Thank you,
Are you looking for more table changes from version to version or a type of schematic that shows how each window works with each other in the application?
The schematic, we do not have that I'm aware, that shows how each window flows from each window and each process, but if you're looking for table changes and related information that we used to put in SDKs, we now put that information in blogs such as the following:
After GP 2013 or 2015, we’re no longer putting out an actual SDK for newer versions of Dynamics GP. Instead, we’re putting this information into blogs that state the table changes, new tables and column name changes, such as these: >>Table, Column, and Parameter Changes in Microsoft Dynamics GP October 2020 Release & 2020 Year-End (18.3)https://community.dynamics.com/gp/b/dynamicsgp/posts/table-column-and-parameter-changes-in-microsoft-dynamics-gp-october-2020-release-2020-year-end
>>Table, Column, and Parameter Changes in Microsoft Dynamics GP October 2019 Release & 2019 Year-End (18.2)https://community.dynamics.com/gp/b/dynamicsgp/posts/table-column-and-parameter-changes-in-microsoft-dynamics-gp-october-2019-release-2019-year-end
>>Table, Column, and Parameter Changes in Microsoft Dynamics GP 2018 R2 and Year-End Updatehttps://community.dynamics.com/gp/b/dynamicsgp/posts/table-column-and-parameter-changes-in-microsoft-dynamics-gp-2018-r2-and-year-end-update
>>Table, Column, and Parameter Changes in Microsoft Dynamics GP 2018 and Year-End Updatehttps://community.dynamics.com/gp/b/dynamicsgp/posts/table-column-and-parameter-changes-in-microsoft-dynamics-gp-2018-and-year-end-update
>>Table and Column Changes in Microsoft Dynamics GP 2016https://community.dynamics.com/gp/b/dynamicsgp/posts/table-and-column-changes-in-microsoft-dynamics-gp-2016
>>Table and Column Changes in Dynamics GP 2015https://community.dynamics.com/gp/b/dynamicsgp/posts/table-and-column-changes-in-dynamics-gp-2015
>>Table and Column Changes in Dynamics GP 2013 R2https://community.dynamics.com/gp/b/dynamicsgp/posts/table-and-column-changes-in-dynamics-gp-2013-r2
Thanks
Hi Quartz,
As @Derek mentioned, your best bet to get a diagram of the table relationships for the various modules is to install the Dynamics GP SDK (can be found on the DVD image), but that hasn't been updated since GP 2013 or 2015.. Still very pertinent since not much of the structure has changed in the last years and versions of GP. The references about table changes should fill the gap.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 629 Super User 2025 Season 2
Abhilash Warrier 444 Super User 2025 Season 2
BillurSamdancioglu 288 Most Valuable Professional
