You are currently offline, waiting for your internet to reconnect

How to determine which Great Plains product is currently being run through Dexterity sanScript code

This article has been archived. It is offered "as is" and will no longer be updated.
TechKnowledge Content

This article contains a Dexterity code sample that determines which Great Plains product is currently running.


1. Examine the "SQL Server" of globals system variable. This integer value indicates which product is currently being used. The following table lists the constants that correspond to the active product:

Version 6.0 and 7.0

Value ConstantDescription

0 DYNAMICS Dynamics or Great Plains Select
5 SMALL BUSINESS MANAGER Small Business Manager
10 DYNAMICSSQL Dynamics for SQL Server (not used after Great Plains name change)
100 EENTERPRISESQL eEnterprise or Great Plains Edition

Version 7.5

0 DYNAMICS Great Plains Standard ISAM
5 SMALL BUSINESS MANAGER Small Business Manager
100 EENTERPRISESQL Great Plains Professional on MSSQL
100 EENTERPRISESQL Great Plains Standard on MSDE or SBS

2. On Great Plains version 7.0 and later, IsModuleRegistered(SM_CS) of form syRegKeyObj can be used to verify Great Plains Professional vs. Great Plains Standard because the "SQL Server" of globals value is the same for both of these products.

Version 7.0 and 7.5n

Value Description
FALSE Small Business Manager
FALSE Great Plains Standard
TRUE Great Plains Professional

Shown below is an example of how this can be referenced in your sanScript code:

if 'SQL Server' of globals > 0 then case 'SQL Server' of globals in [5] {Small Business Manager} in [10] {Dynamics on SQL Server 6.0, not used on 7.0 or 7.5} in [100] {Great Plains Professional or Great Plains Standard}  if IsModuleRegistered(SM_CS) of form syRegKeyObj then{Great Plains Professional on MSSQL}else{Great Plains Standard on MSDE or on Small Business Server}end if;end case; else {Great Plains Standard ISAM(P.SQL/Btrieve or Faircom ctree} end if;
This article was TechKnowledge Document ID: 34505

Article ID: 878415 - Last Review: 12/27/2014 02:27:56 - Revision: 3.0

  • kbnosurvey kbarchive kbmbsmigrate KB878415