Free Articles, Free Web Content, Reprint Articles
Wednesday, June 19, 2019
Free Articles, Free Web Content, Reprint ArticlesRegisterAll CategoriesTop AuthorsSubmit Article (Article Submission)ContactSubscribe Free Articles, Free Web Content, Reprint Articles

Dexterity Customization: Support, Upgrade, Recovery, Great Plains Programming

Microsoft Dexterity or former name is Great Plains Dexterity is Integrated Development Environment and programming language (Sanscript).  Current version of Microsoft Dynamics GP is 10.0 and software programmers have broader number of customization tools: eConnect, SQL scripting, Visual Studio SDK, Modifier with VBA. 

However if you look at earlier versions: 5.0, 6.0, 7.5 then you will discover that large number of existing Great Plains ERP installations have modifications programmed in GP Dexterity.  Dex is still all-mighty and extremely powerful tool – you will see Dexterity foundation in GP tables, forms, atomic stored procedures (deployed by Dex table indexes).  Let’s review the bullets of Dex customization maintenance:

1.       Dexterity source dictionary.  Yes, this is typically first question – do you have DYNAMICS.DIC file with your source code?  This file should be given to you by your former GP ISV, Dexterity programmer or consultant.  If you are not sure, you should review your software archive, communication with former GPS partner.  If you can not get source dictionary, then Dex developer could try to recreate the code based on still available tables and forms, but of course you are not really happy to face this recreation and reprogramming

2.       Dex customization upgrade.  You should invite professional Dexterity programmer to do this job as Dex is pretty proprietary and complex and it is not feasible to train your in-house programmer to do the upgrade.  Code update itself is reviewing and comparing old and new forms and tables and making adjustments to existing sunscript code.  If you customization was created really long time ago, something like in 1999 and earlier, then Dexterity developer should recommend you to switch several Dex cursors to SQL Server Stored Procedures to boost performance

3.       GP modification recovery.  If you are trying to move GP from one server to another, if you are changing your server IP address or computer name, if you are reshuffling your network – then you may encounter the situation when GP or its custom feature stop working.  In the case when you are on MS SQL Server DB platform – all you need to do is to review your ODBC connection settings, however when you are on Pervasive SQL or Ctree – you will need to perform so-called location translation procedure, which requires professional Great Plains consultantFeature Articles, who has experience working with legacy versions of Great Plains Dynamics or eEnterprise

Source: Free Articles from


Andrew Karasev, Alba Spectrum 1-866-528-0577, 1-630-961-5918, serving Great Plains USA and Canada nationwide. Local service in Chicago, Houston, Dallas, San Diego. Please visit our information portal Pegas Planet: . If you need custom programming for GP, we are happy to help you with Dexterity, eConnect, VBA/Modifier, SQL Stored Procedures, Crystal Reports. We also provide instant support to new and existing clients via web sessions

Home Repair
Home Business
Self Help

Page loaded in 0.154 seconds