Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Joe Scheidecker]

Does anyone know of an existing Excel listing of GP tables and fields? I’m looking for something like the old Dynamics GP 2013 Table Reference excel file that was around a while ago (I think Mark Polino built it) but I cannot find anything online for GP 2016 or 2018. I used the old one quite often and it was super helpful. Anyone still putting together a similar reference in Excel anywhere, for more recent versions of GP?

——————————
Joe Scheidecker
Accounting Manager
Guardian Energy
Hankinson ND
——————————

[Aleiha Hanson]

Following! All I have are “most commonly used” and it’s not in an Excel format.
I did see you could do an export from SQL to pull tables, but that’s cumbersome.

——————————
Aleiha Hanson
Royal Basket Trucks, Inc – IT Manager
GPUG Milwaukee WI Chapter Leader
ahanson@royal-basket.com
——————————
——————————————-

[Jo deRuiter]

@Mark Polino has one online – it is for GP2013, but is close enough.

 

https://app.box.com/s/8c0prp7widr81bc69w84

 

Otherwise, the absolute BEST location for looking for GP Table information is DynDeveloper, here:  http://dyndeveloper.com/DynModule.aspx

 

Thank You,

 

Kind Regards,

 

Jo A deRuiter Dynamics GP Practice Lead Aisling Dynamics Consulting, LLC 770-906-4504 |   Milwaukee, WI   IMPORTANT: The contents of this email and any attachments are confidential. They are intended for the named recipient(s) only. If you have received this email by mistake, please notify the sender immediately and do not disclose the contents to anyone or make copies thereof.

 

 

——Original Message——

Following! All I have are “most commonly used” and it’s not in an Excel format.
I did see you could do an export from SQL to pull tables, but that’s cumbersome.

——————————
Aleiha Hanson
Royal Basket Trucks, Inc – IT Manager
GPUG Milwaukee WI Chapter Leader
ahanson@royal-basket.com
——————————

[Jo deRuiter]

was the tag

All: See above, I accidentally responded from email as opposed to on the site.?

——————————
Jo deRuiter, MCP, DCP
“That GP Red Head”
AISLING DYNAMICS CONSULTING, LLC
WEBSITE: https://aislingdynamics.com/
BLOG: https://community.dynamics.com/gp/b/gplife
770-906-4504 (Cell)

——————————
——————————————-

[Mark Polino]

I stopped updating it for each version after GP 2013. Azurecurve’s site is better and Ian has more 3rd parties incorporated.

http://gptables.azurecurve.co.uk

Mark

——————————
Mark Polino , CPA
Director of Client Services
Fastpath
Altamonte Springs FL
——————————
——————————————-

[David Musgrave]

The best solution is using GP Power Tools, Resource Information window. This is the tool that provided the information for Mark’s spreadsheet and Ian’s website.

This way you can search quickly for all tables installed on your system for the exact version and build you are using as the data is read directly from the dexterity dictionaries.

Try it out, just install and activate the free 30 day trial period.

GPPT Portal http://WinthropDC.com/GPPT

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

Managing Director
Winthrop Development Consultants

Perth, Western Australia

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