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 help@albaspectrum.com ? 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 (help@albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

    Dowagiac prom limousines .. Lockport Chicago limo O’Hare
    In The News:

    Tech expert Kurt “CyberGuy" Knutsson says ChatGPT learns from chats, but you should avoid sharing sensitive information to protect your privacy.
    Beyond Aero's BYA-1: Hydrogen-electric jet with zero emissions, reduced costs, 2030 launch. Kurt “CyberGuy" Knutsson discusses a potential game changer in the evolution of air travel.
    Kurt "CyberGuy" Knutsson explains how you can creatively repurpose your old unused Android devices, which are full of potential and hidden value.
    Mech the super-humanoid robot can lift up to 132 pounds and is designed to tackle stressful and repetitive tasks that often lead to workplace injuries.
    Double-clicking is something we all do, often without giving it a second thought. But it could be giving hackers permission to do something dangerous.
    Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
    Kurt the CyberGuy offers some of his easy expert tips to free up storage space on your Android if your device is running short on storage.
    You can reset your internet router remotely if you're not home when your power goes out. Kurt "CyberGuy" Knutsson explains how this can be done.
    The EO Canopy is a self-sustaining, solar-powered camping platform designed to provide all the comforts of home while completely off the grid.
    Experts say hackers who used to focus on Windows operating systems are increasingly targeting Apple IDs as part of a new phishing campaign.
    Unitree, a Chinese robotics company that developed a backflipping robot, has now introduced a humanoid robot capable of doing a side flip.
    Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
    According to the FBI, cybercriminals are sending extortion letters, threatening to release victims' sensitive information unless a ransom is paid.
    FireSat is a satellite project designed to detect and track wildfires early, aiming to detect a fire that's the size of a classroom within 20 minutes.
    Tech expert Kurt “CyberGuy" Knutsson reports that researchers have uncovered a Chrome vulnerability used in a cyber espionage campaign.
    Preserving voicemails securely on Android: Tech expert Kurt “CyberGuy" Knutsson reveals easy methods to keep memories alive forever.
    This phishing kit bypasses 2FA via session hijacking and real-time credential theft. Kurt “CyberGuy" Knutsson offers four ways to stay safe from Astaroth phishing attacks.
    Tech expert Kurt “CyberGuy" Knutsson discusses Joby Aviation and Virgin Atlantic planning to launch 200-mph U.K. air taxis linking airports and cities.
    Fake Apple virus warnings, security alerts and messages are tactics used to prompt you to call a number or click on a malicious link. The CyberGuy explains how to protect your devices.
    The combination of artificial intelligence and neuroscience allows a paralyzed man to manipulate a robotic arm by using his brain to imagine movements.
    With the help of artificial intelligence, sophisticated fraud techniques emerging today are virtually undetectable to the untrained eye.
    Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents
    If you need to free up space on your Mac, consider deleting duplicate photos in your image library. Apple makes it easy to do, and the CyberGuy explains the process.
    Microsoft is discontinuing Skype in May after 22 years of service. Kurt the CyberGuy addresses other options for internet-based phone and video service.
    Tron 1, a Chinese company's two-legged robot, is versatile and can walk, roll and pivot, even on rough terrain. Tron 1 stands 33 inches tall and weighs 44 pounds.

    Linux Secrets

    The first thing that you will notice about Linux Red... Read More

    Blind CC (Bcc): Master Its Use When E-Mailing

    If you use Microsoft Outlook (or similar applications) for e-mailing,... Read More

    Software Companies: Generate New Revenue Streams and Decrease Costs with Custom e-Learning Content

    It's no secret that software companies operate in a very... Read More

    Kick-Ass Performance For Your PC? Its Easy

    Is your PC is slow and wimpy? Then you need... Read More

    Five Steps to Rapid Development with TierDeveloper 4.0

    Follow the steps below to quickly design, generate, and deploy... Read More

    Adware and Spyware Blockers

    The most important things you can do for your computer... Read More

    Microsoft Small Business Manager Customization Options - Overview

    Microsoft Business Solutions Small Business Manager is Great Plains Dexterity... Read More

    Simple Solution for Php Includes - IFrames

    I have recently created my first Php program. I wanted... Read More

    netstat - Linux Command to Display Networking Information

    In linux, one of great commands for finding out information... Read More

    Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL ? Development Options

    Microsoft bought Navision, Denmark based software development company, along with... Read More

    The True Meaning of Freeware

    The vast majority of us will have, at some point,... Read More

    Why Java RDBMS?

    It is a well known fact that Java as a... Read More

    Information Products: A Business Owners Best Friend

    We live in a post-industrial age where information is the... Read More

    Microsoft Great Plains SOP: Sales Order Processing

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

    Oracle Development: JDeveloper 10G ? Java, J2EE, EJB, MVC, XML - Overview For Programmer

    In 2004 Oracle, Inc. made its new step toward J2EE... Read More

    Microsoft Great Plains: Service Business Customization & Integration Example

    Microsoft Business Solutions Great Plains might be considered as ERP... Read More

    Antivirus Software ? Get The Bugs Before They Get You!

    You turn on your computer, and it doesn't look quite... Read More

    10 Programming Tips

    (1) Avoid using the same variable again and again for... Read More

    eConnect: eCommerce Development for Microsoft Great Plains

    Microsoft Business Solutions Great Plains has several options to enable... Read More

    Can You Calculate Complex Financial Calculations?

    Are you a whiz at calculating financial information? Not the... Read More

    Should I Use Windows Update?

    Should one use Windows Update?This topic has good and valid... Read More

    IT Department Skills to Support Microsoft Great Plains and Microsoft CRM

    Microsoft Great Plains as ERP and Microsoft CRM as... Read More

    ERP for Large Corporation ? New Selling Strategy

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

    Healthcare Preventive Maintenance Software

    Healthcare facilities such as clinics, hospitals, and biomedical laboratories can... Read More

    Selecting Corporate ERP: Microsoft Business Solutions Great Plains ? Estimation Parameters

    As we could imagine, if you are reading this article... Read More

    shuttle from O'Hare Lake Villa ..