Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Renee Anter]

Hi Everyone,

I was wondering if there is a resource that will make it available for users information on GP Available Tables, their elements and what are they used for….Thanks

I’m trying to understand where information is stored and the correct table to access for this information…Thanks

——————————
Ernesto Rivero
Controller
Alternative Home Health Care
Tamarac FL
——————————

[David Musgrave]

Hi Ernesto

I would suggest installing the SDK (Software Development Kit) from the Tools folder of the Microsoft Dynamics GP installation DVD image. It contains ER (Entity Relationship) diagrams as well as documentation on transaction flows and table contents.

Victoria Yudin MVP also has a great reference on her site: https://victoriayudin.com/gp-tables/

I would also look at my blog post on the topic.

https://blogs.msdn.microsoft.com/developingfordynamicsgp/2008/10/04/finding-table-and-field-information-in-microsoft-dynamics-gp/

On point 12 of the above article it mentions using the SDT’s Resource Information window. The SDT has been replaced by GP Power Tools and the Resource Information window is even more powerful. See http://WinthropDC.com/GPPT

There is lots of information out there.

David

——————————
David Musgrave MVP, GPUG All-Star

Managing Director
Winthrop Development Consultants

Perth, Western Australia

http://www.winthropdc.com
——————————
——————————————-

[Catheriya Goedeking]

I find Victoria Yudon’s site very useful for this:
https://victoriayudin.com/gp-tables/

——————————
Catheriya Goedeking
IT Manager
Leeco Steel, LLC
Lisle IL
——————————
——————————————-

[Lou Spevack]

In addition to the resources already mentioned, I also use DynDeveloper.com

——————————
Lou Spevack
Systems Accountant | Dynamics Credentialed Professional
American Council on Education
Washington DC
——————————
——————————————-

[Karl Bar]

I frequently use a site called DynDeveloper (http://dyndeveloper.com/)  It has the tables broken down by module, as well as additional info on eConnect, Visual Studio Tools, .NET development, etc.

——————————
Karl Bar
Controller
Rio Marine Inc
Houston TX
kbar@riomarineinc.com
832-452-8884
——————————
——————————————-