Freigeben über


Identifying Microsoft Dynamics GP version information

David Meego - Click for blog homepageI had a case recently where the customer's auditors were asking the customer to prove the version and build of Microsoft Dynamics GP was the same as the version they claimed it was. Basically, the auditor said "provide me proof that you are running GP X SP Y".

So during this case, I discussed a number of methods with the customer and let them choose what worked best for them. In this case, I was dealing with the customer's DBA, who did not have access to run the Dynamics GP client, so not all of the methods I provided would have worked for him.

Here is the list I came up with:

  1. From the Login window
     
    When you launch GP the primary Dynamics product dictionary's version is displayed on the bottom of the Login window.
     

  2. From inside Microsoft Dynamics GP, you can select Help >> About Dynamics. 
     
    This will show the main Dynamics product version as well as the Dexterity version and SmartList version. Other about windows are available for other modules, but have different navigation paths.
     

  3. From the SQL Server we can run select statements to see version data in the Dynamics Utilities tables.
     
    -- List of Company IDs
    select CMPANYID, INTERID, CMPNYNAM from DYNAMICS..SY01500
     
    -- List of Product Versions for Company specified by Database
    select U.*, C.INTERID, C.CMPNYNAM from DYNAMICS..DU000020 U
    join Dynamics..SY01500 C on C.CMPANYID = U.companyID
    where C.INTERID = 'TWO' -- Enter desired Company DB name
    order by U.PRODID
     
    -- List of Product Versions for System Database
    select * from DYNAMICS..DU000020
    where companyID = -32767
    order by PRODID
     

  4. From Dictionary file properties.
     
    Depending on the version and if the registry associations are working, you can right click on a DIC file and then click Properties. This will show the dictionary version in a Dictionary tab. The version information can also be shown using the tooltip if you hover over a DIC file.
     
    Note: Open DYNAMICS.SET file with Notepad.exe to see installed products. The first line in the file contains the number of products installed. Then the following lines are a list of products with the Product ID followed on the next line by the Product Name. .
     

  5. Support Debugging Tool
     
    Using Support Debugging Tool's Screenshot feature you can obtain the system status report which lists all dictionaries and their version numbers. SDT Portal: https://aka.ms/SDT
     

  6. CustomerSource
     
    Link: https://mbs.microsoft.com/customersource/ 
     
    Other direct links are available via my blog on the Developer & Consultant Articles & Links page
     
    These include the Service Pack pages:

    Service Pack, Hotfix, and Compliance Update Patch Releases for Microsoft Dynamics GP 10.0 Secure Link
    Service Pack, Hotfix, and Compliance Update Patch Releases for Microsoft Dynamics GP 2010 Secure Link
    Service Pack, Hotfix, and Compliance Update Patch Releases for Microsoft Dynamics GP 2013 Secure Link 
     

  7. Version Information Spreadsheets
     
    Look at the Notes sections on the Service Pack pages (links above) for the Excel Version spreadsheets. Below are the direct links:
     
    Microsoft Dynamics GP 10.0 Version spreadsheet 
    Microsoft Dynamics GP 2010 (v11.0) Version spreadsheet 
    Microsoft Dynamics GP 2013 (v12.0) Version spreadsheet 

With all of these options you should be able to easily confirm your version and compare it against the Version Information Spreadsheets to identify the exactly release you are on.

Enjoy 

David

Comments

  • Anonymous
    February 25, 2014
    I want documentation of Visual Studio Tools for Microsoft Dynamics GP 2013? can you help me.

  • Anonymous
    February 25, 2014
    Hi Mia That questions is not quite relevant for this post. Anyway, just install Visual Studio Tools for Microsoft Dynamics GP 2013 from the ToolsSDKVS Tools folder of the DVD image. It has the manuals as part of the install. David

  • Anonymous
    February 26, 2014
    Thanks David..

  • Anonymous
    April 02, 2014
    Posting from Mark Polino at DynamicAccounting.net mpolino.com/.../identifying-microsoft-dynamics-gp-version-information-developing-dynamics-gp

  • Anonymous
    May 20, 2014
    This is a great post, and the links are very helpful as well.  As part of an IT audit I required to show how many  changes (upgrades/hotfixes/version changes) we have done to GP during a specific time.  They would like this data to come from SQL.  Are you aware of any table to tracks version changes? Thanks

  • Anonymous
    May 20, 2014
    Hi Joe The Dynamics Utilities tables track the previous version and the current version so they can perform upgrades, but they don't track a full history. You could add triggers to the tables to write to a logging table when changes are made. David

  • Anonymous
    November 04, 2015
    Is there a Master table containing the Dictionary ID's(DICTID) and Dictionary name including all 3rd party application in the database?

  • Anonymous
    December 08, 2015
    Hi David Yes and no. Microsoft internally have the database of assigned Product IDs. However, this is not available externally and not every Product ID assigned to a partner or customer ends up as an ISV product. Many are for customisations or are no longer used. For what is on your system, just read the Dynamics.set launch file. David