Article

Easier Administration: Discovering Free SQL Tools and Tips for Microsoft Dynamics GP

by Mark Polino
Director of Client Services, Fastpath, Integrated Business Group

New and experienced administrators of Microsoft Dynamics GP have similar sets of needs, just at different levels.

New administrators need to know what tools and SQL scripts are available to help them better manage Dynamics GP. Experienced administrators want to know about available tools and scripts that they may have missed. Everyone wants to know how to find the right table or tables for reporting.

There is no magic bullet to solving every need of a Dynamics GP administrator but there are a lot of tools available to help.  For example:

  • The Support Debugging Tool from Microsoft offers administrator's the ability to execute SQL code from within the application, trace SQL queries and hunt down table and field names.
  • DynamicAccounting.net provides an Excel based tool to find table and fields names along with hundreds of Dynamics GP-related SQL scripts curated from across the internet.
  • SQL views installed with SmartList Builder (whether registered or not) simplify advanced reporting.
  • A ton of bloggers have provided SQL code examples for use with Dynamics GP and for providing better administration of SQL Server.

All of these resources help administrators answer questions like:

  • What tables do I use to report on a particular area of Dynamics GP?
  • What companies do users have access to and how long have they been logged in?
  • What are the steps to reset the system password when an outgoing controller forgets to ...

    FREE Membership Required to View Full Content:

    Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
    Learn more about us here

    Get full access
Dynamics GP SmartList
About Mark Polino

Mark Polino is a Certified Public Accountant (CPA) and a former Microsoft MVP (2007-2018) for Business Solutions. He is the author or coauthor of 5 books related to Microsoft Dynamics GP.  Mark also maintains the Dynamics GP focused website DynamicAccounting.net. He speaks and writes regularly about ERP related topics. Mark has been a controller and CFO for a division of a publicly traded company and he has  worked as a consultant implementing ERP solutions. Mark holds additional certifications including Certified Information Technology Professional (CITP), Certified in Financial Forensics (CFF) , Chartered Global Management Accountant (CGMA). Dynamics Credentialed Professional for Dynamics GP 2015 (Core Install and Core Financials), Xero Certified. He holds a bachelor's degree in accounting from the University of Central Florida and an MBA from Rollins College. Mark lives with his family in Florida.

More about Mark Polino