I was wondering if anyone knows where to get the full database schema and field information for MS Dynamics GP Version 18R2
Thank you,
I was wondering if anyone knows where to get the full database schema and field information for MS Dynamics GP Version 18R2
Thank you,
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.
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 Update
https://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 Update
https://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 2016
https://community.dynamics.com/gp/b/dynamicsgp/posts/table-and-column-changes-in-microsoft-dynamics-gp-2016
>>Table and Column Changes in Dynamics GP 2015
https://community.dynamics.com/gp/b/dynamicsgp/posts/table-and-column-changes-in-dynamics-gp-2015
>>Table and Column Changes in Dynamics GP 2013 R2
https://community.dynamics.com/gp/b/dynamicsgp/posts/table-and-column-changes-in-dynamics-gp-2013-r2
Thanks
André Arnaud de Cal...
292,516
Super User 2025 Season 1
Martin Dráb
231,409
Most Valuable Professional
nmaenpaa
101,156