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


    An Easy Way to Develop JAVA Enterprise Applications

    Research bears that less than 70 percent of development projects... Read More

    Beware of The Pirated Software E-Mail Scams!

    You have gotten those E_Mails buy software at deep discounts.... Read More

    15 Questions to Ask Your Software Vendor

    When making a decision to buy any piece of software... Read More

    Microsoft CRM for Corporate Business ? Working Offline

    If your company has regional and worldwide operations, you might... Read More

    Configure Windows Indexing Service for Performance

    The Windows Indexing Service provides you with the ability to... Read More

    Make 2005 the Year You Save Time!

    Today's business world is fast-paced. No matter what it is... Read More

    The Top 5 Wrong Reasons For Not Hiring Testers

    Considering whether or not your software company should hire a... 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

    Crystal Reports for Microsoft Great Plains

    Microsoft Business Solutions ? Great Plains is designed to meet... Read More

    Microsoft Great Plains RW: Report Writer

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

    Dig Out That Worm

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

    Corporate Accounting System: Microsoft Great Plains ? Overview

    Corporate ERP/MRP selection might be tough one, especially considering very... Read More

    Most Common Ways to Accumulate Spyware (where It is Downloaded to Your PC)

    It is possible that if one avoided all sources of... Read More

    Linux vs Windows Operating Systems

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

    Microsoft Great Plains Integration Manager: Using Continuum ? Overview for Developer

    Microsoft Business Solutions Great Plains has I'd say end user... Read More

    Reduce Pop-ups and Annoying Ads

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

    Getting Patched with Windows Service Pack

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

    Microsoft Great Plains Furniture & Fixtures ? Implementation & Customization Highlights

    Microsoft Great Plains, former Great Plains Software Dynamics / eEnterprise... Read More

    OSI Layers Model

    IntroductionDuring the early years of our modern computer era, very... Read More

    The Importance of Timely Timesheets

    Whether you are a small consultancy firm, a medium sized... Read More

    Enterprise Resource Planning Overview

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

    C++ Tutorial 2, Input and Variables

    This is the tutorial where we really get into programming.... Read More

    Need of Document Management System (DMS)

    Document Management or Enterprise Information Management is perhaps one of... Read More

    Microsoft Great Plains Customization Tools Evolution ? Overview for Consultant

    When Great Plains Software introduced the first graphical accounting application... Read More

    Four Easy Ways To Prevent Spyware

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

    10 Ways to Learn a Software

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

    Spyware Definitions List

    The adware and spyware definitions list is very long. But... Read More

    Corporate ERP Selection: Microsoft Great Plains

    In our opinion, traditional approach when you select ERP/MRP system... Read More

    Windows x: Basic Windows ?Security? Issues

    Language development computer: Computer-based method for aiding language development seems... Read More

    Navision Attain C/ODBC Crystal Report ? Customization Example

    Microsoft Business Solutions Navision is main ERP application for European,... Read More

    Know Linux

    Linux essentials:It's free for download but you have to pay... Read More

    Free Software: How Not To Get More Than You Bargained For!

    I completed an experiment recently. I wanted to find out... Read More

    FreeDOS

    Before September 1995, Microsoft Windows was an MS-DOS program. DOS... Read More