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


    Microsoft Great Plains Implementation for Midsize & Large Corporation: Lockbox Processing

    Microsoft Great Plains is now targeting large and midsize businesses... Read More

    Four Desktop Tools To Drastically Increase Your Productivity

    Sticky Noteshttp://www.deprice.com/stickynote.htmWith StickyNote 9.0, you can create beautiful 3D notes... Read More

    Will Adobe Manage to Replace Industry Work Horse Quark Express by Giving Adobe InDesign for Free?

    Heard about the Quark "killer"?Adobe InDesign CS2. Will it really... Read More

    Microsoft CRM Implementation - US Market Lessons

    Microsoft CRM is CRM answer from Microsoft Business Solutions. If... Read More

    Constructionalist Parsing - Deciphering Natural Language

    The research in the field of Natural Language Processing usually... Read More

    Professional Software Icons For Your Standalone Application

    User interfaces and accessibility are some of the most important... Read More

    Artificial Intelligence And Intuition

    The intuitive algorithm.Roger Penrose considered it impossible. Thinking could never... Read More

    Causes of ERP Failures

    ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More

    Microsoft Great Plains Chemicals & Paint Industry Implementation & Customization Notes

    Microsoft Great Plains fits to majority of industries, in the... Read More

    Microsoft Great Plains Multicurrency ? Overview For Implementation Consultant

    When you first think about multicurrency ? you probably have... Read More

    Great Plains Dynamics on Pervasive/Ctree support ? overview for consultant

    All of us know that Microsoft bought former Great Plains... Read More

    Microsoft CRM Integration & Customization: SharePoint Document Gateway

    MS CRM is very close to document workflow automation, including... Read More

    What is Spyware? Are You Being Watched?

    Find out why Spyware Removal from computers is important and... Read More

    Unwanted Files

    A LOT OF UNWANTED FILES.When you uninstall an item of... Read More

    Microsoft CRM Implementation & Customization: MS CRM Fax Gateway

    With this small article we are continuing Microsoft Business Solutions... Read More

    How to Get The Best Accounting Software For Your Small Business

    Buying accounting software is a major investment. It's an important... Read More

    Software: What Suits Me?

    Almost all new and major brand of PCs come with... Read More

    A Guide To Purchasing Professional XP Icons Online And Enhancing Your Applications

    Icons are used everywhere; right from software applications, to internet... Read More

    7 Things to Consider Before Buying Small Business Accounting Software

    The world of small business accounting software can be a... Read More

    Microsoft Business Solutions Customization Options - Overview for Programmer

    Several years ago Microsoft purchased Great Plains Software, then Navision... Read More

    Microsoft Great Plains Implementation: Verticals - Wholesale Order Entry center ? overview

    Microsoft Business Solutions Great Plains has substantial market share and... Read More

    Software Process Improvement -A Successful Journey

    Background: For many organizations like ours, the interim target of... Read More

    Microsoft Great Plains implementation: Restaurants Supply Chain Management Example

    Microsoft Great Plains serves majority of US based horizontal and... Read More

    Design a Web Album Using Adobe Photoshop- Part 2

    So let's begin crunching down these 300 images using Adobe... Read More

    Snort for Network IDS

    What is Snort?Snort is an open source network intrusion detection... Read More

    History of Java

    The java programming language is becoming more and more popular... Read More

    An Easy Way to Deal with Email Viruses and Worms

    If you feel intimidated when someone tries to teach you... Read More

    Exactly What Does FTP Stand for and What Can it do for Me?

    FTP stands for "file transfer protocol". FTP is basically a... Read More

    Chinese Input - Step by Step Instruction on How to Input Chinese Characters in English Windows XP

    Enabling Chinese input is quick and easy, there are only... Read More

    Razzle Dazzle Them

    Once upon a time not so long ago, there was... Read More

    10 Ways to Learn a Software

    Following tips help you to learn a software in lesser... Read More

    ERP for Large Corporation ? New Selling Strategy

    Our opinion is based on our Microsoft Business Solutions Great... Read More

    Who?s Watching What You Type?

    If someone entered your home, uninvited and installed numerous cameras... Read More