How to Upgrade Dexterity Customization ? Tips for IT Manager

If you have Microsoft Great Plains and support it for your company and have light or heavy Great Plains customization, written in Dexterity ? you need to know your options in upgrading Great Plains or migrating it from ctree/Pervasive to MS SQL/MSDE.

Great Plains Dexterity is proprietary programming language/environment, which was created in early 1990-th to provide platform / database / graphical interface independence for Mac and Windows based Great Plains Dynamics. Today it is legacy and Microsoft Business Solutions is phasing Dexterity out.

However Great Plains 7.5 and even 8.0 is Dexterity based application, so you have to deal with it and it's customization.

Good news. Prior to version 7.0 Great Plains had plans on expanding GP functionality and so was changing tables structure ? forcing Dexterity customization to be analyzed and partially rewritten with each upgrade. Not any more ? GP structure stays the same ? Microsoft is doing new modules acquisition and unifying it's graphical interface to move all it's ERP packages: Great Plains, Solomon, Navision and Axapta to web-based Microsoft Business Portal.

Still pain. Dexterity has possibility to customize existing Great Plains screens, so called Alternative Great Plains forms. This was upgrade problem in the past and it stays now ? there is no way to do it in house (until you are willing to pay for full-time internal developer ? who is usually in the learning curve). You got to bring in consultant.

Recommended approach. You should have the strategy to migrate Dexterity customization to SQL, Crystal Reports, custom web publishing ? Visual Studio.net and slowly abandon Dexterity customization

  • SQL Stored procedures - performance improvement. Consider replacing dexterity data manipulation with SQL stored procedures. Dexterity is cursor-driven language and it is not efficient when processing huge datasets.
  • Crystal Reports. Take advantage of open and leading technology. Crystal Reports will eliminate the need in the future for painstaking Dexterity reports upgrade. Base you Crystal report on the SQL view or stored proc
  • Do direct web publishing off your GP database. Use Visual Studio ? it is easy to find specialists and have them in staff. We are in the World when web publishing is very easy.

    • Good luck and if you have issues or concerns ? we are here to help! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

    Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, Los Angeles, San Francisco, San Diego, Boston, New York, Houston, Dallas, Miami, Atlanta, Minneapolis, Seattle and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

    In The News:

    pen paper and inkwell


    cat break through


    Not All Project Management Software is Created Equal

    The purpose of Project Management Software is to provide an... Read More

    Microsoft CRM in Latin America: Implementation, Customization, Support ? Overview for Consultant

    Microsoft Business Solutions CRM is present several years on the... Read More

    What is Shareware?

    Shareware is software that you can try before you buy;... Read More

    Mozilla Vs. Firefox

    For those who are unclear on the differences between the... Read More

    10 Things You Can Do With Photoshop CS2 That You Couldnt Do Before Now

    Is Photoshop CS2 worth the upgrade? You bet it is!... Read More

    Free PDF Publishing Software

    In a previous article, I wrote about OpenOffice... Read More

    Four Easy Ways To Prevent Spyware

    How would you like to prevent spyware and adware from... Read More

    XML Parser and Their Types

    XML parser is a software module to read documents and... Read More

    Reduce Pop-ups and Annoying Ads

    There is many things more frustrating than surfing a website... Read More

    Dig Out That Worm

    Internet worms. Is your PC infected?If your computer has become... Read More

    OS 101: Suggestions for Choosing an Operating System

    An operating system (abbreviated OS) is essentially the path through... Read More

    New Web-Based HR Tool is Max From NAS, Hannibal, and InfoLink

    Three highly respected names in Human Resources have joined forces... Read More

    Corporate ERP: Standard vs. Rich functionality ? Microsoft Great Plains

    Traditionally we were considering functionally rich systems, such as SAP,... Read More

    Microsoft Blues

    With the advent of 'Service Pack 2' for Windows XP... Read More

    Most Dangerous Types of Spyware are on the Rise: How to Choose the Weapon

    Bad News - the Threat is Bigger than it SeemedHow... Read More

    Linux vs Windows Operating Systems

    With so many Microsoft Windows related viruses, errors, and other... Read More

    Best Practices In Choosing Network Monitoring Software

    Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More

    How to Tell You Have Spyware, Ad-ware or Viruses

    Usually, the easiest way to tell you have spyware is... Read More

    Ukraine IT Myths Dispersed

    While Ukraine is becoming a new popular IT outsourcing destination,... Read More

    Enterprise Resource Planning Overview

    ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More

    Free Program Removes Spyware not Detected by Premium Security Scan

    What is Spyware?Spyware monitors your surfing habits and sends the... Read More

    Microsoft Great Plains Implementation ? Overview for IT Director/Controller

    What is installation in the language of technology? Installation... Read More

    Guide to Software Marketing

    Intro This concise article will tell you in plain English... Read More

    Microsoft Moves to Small Business Accounting/Retail Market ? Stakes and Thoughts

    In this small article we will be looking at the... Read More

    Imagine if Everyone Working In Your Office Was In Synch?

    Microsoft-Outlook is a pretty amazing program. So much more than... Read More

    Why Stick With Email Clients Like Outlook?

    Trying to figure out a stream in banning one email... Read More

    Spyware Statistics -- Whats New in May 2005?

    Although statistics often is blamed for various deadly sins --... Read More

    Spyware, Adware, etc. -- Terms and Common Sense

    When reading an article where some term is used often,... Read More

    Microsoft Great Plains RW: Report Writer

    Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

    Getting Patched with Windows Service Pack

    Are you one of those people that keeps track of... Read More

    QuarkXpress Tips: How to Move Content Between Print and Web Layouts

    Since its release in 1987, QuarkXpress had made an immediate... Read More

    Selecting Microsoft Great Plains Partner/VAR/Reseller: ERP Implementation & Customization ? Overview

    In the case when you represent mid-size or mid-size-to-large business,... Read More

    Microsoft CRM Customization ? Programming Closed Email Activity

    Microsoft CRM is CRM answer from Microsoft and attempt to... Read More