If you are using GP 10 SP2, FRx Cannot Report on Analytical Accounting History Following an Year End Close.

With Microsoft Dynamics GP 10.0 Service Pack 2 - Microsoft has made some Database changes . When the year end close process is run - it automatically…

My Excel based table references for Dynamics GP 9 and Dynamics GP 10 have been downloaded more than 3,000 times so some of you like them. Now I’m happy to announce the availability of the Excel based table reference for Dynamics GP 2010.

This version is in the Excel 2007 and up XLSX format since most people upgrading to the latest version of Dynamics GP will be moving to newer versions of Microsoft Office. There are viewers and converters available if you are on an…

A client recently told me they were very confused by the table naming conventions for Dynamics GP. I’m so used to those legacy table names that I don’t appreciate what a wonder it must be for a new user trying to write reports.

In fact, any class I train that involves pulling data from tables (Extender, SmartList Builder, Excel ReportBuilder, ListBuilder, Report Writer, SSRS, Crystal Reports, etc.) sooner or later results in the question “How do we know which table to use”. This query spawned the on-line class I will be doing for GPUG Thursday http://www.gpug.com/events/GPAcademyGPData070810 entitled “Finding the GP Data you Need”

What do the table names mean?

There is actually a very good naming convention for Dynamics GP data tables. This is only a convention, however. It is followed by the GP programmers pretty diligently, but not so much by some 3rd party programmers. Here’s the basics, the first 2 or 3 characters will indicate the module name, the numbers indicate the type of table.

The modules (prefix)

Some of the more popular module abbreviations are in the table below.

We’ve all tackled the “How do I find the right table?” question in Dynamics GP at various…