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.

    quick home cleaning Highland Park ...
    In The News:

    Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
    Meta removed over 600,000 predatory accounts from Instagram and Facebook while launching enhanced safety protections for teenage users on both platforms.
    Facebook crypto scams trick users with fake celebrity endorsements and legitimate-looking cryptocurrency exchange ads that install malware on victims' devices.
    Create private chat rooms using the iPhone Notes app collaboration feature with instant messaging capabilities and full control over conversation privacy.
    Lyft rolled out safety upgrades with a new Safety Hub, driver blocking capability and a favorite driver option to give riders more control over their experience.
    New research shows Americans increasingly trust AI for wellness guidance over social media, with 63% finding artificial intelligence reliable for health.
    Luxury fashion brand Dior experienced a January 2025 data breach affecting customer personal information, and notifications were sent months after the discovery.
    The commercial Unitree H1 humanoid robot weighs 104 pounds with 365 pound-feet torque per joint and demonstrates dangerous potential when software glitches occur.
    Americans average 10-plus hours online daily, according to recent survey, splitting time between streaming shows on TV and browsing websites on multiple devices.
    Boost your smartphone privacy instantly with these security tweaks for iPhone and Android that limit ad tracking, hide notifications and prevent unauthorized access.
    Platforms like Hoax Tech and JS Click Cloaker help cybercriminals bypass detection systems using machine learning to selectively display scam content to victims.
    A new battery recycling technique transforms old lithium-ion batteries into high-performance components that retain 88% capacity after 500 cycles with minimal waste.
    Google's Android operating system can warn users about earthquakes before the shaking even begins – and there are ways to do it on your iPhone, too.
    Meta's new gesture control wristband might just be the most seamless way to control a computer yet. And no, it doesn't require surgery, a camera, or even a touchscreen. All it needs is your wrist.
    Long-haul trucks are now being upgraded with a surprising twist, thanks to California-based startup Revoy. Their electric boost doesn't replace diesel but works alongside it to cut emissions and fuel costs without major disruption.
    PayPal and Venmo just rolled out something big: AI-powered scam alerts for Friends and Family payments.
    As data centers multiply across the United States, energy demand is increasing at a rapid pace. This has not escaped the notice of large investment firms from Wall Street.
    The Unicode Consortium, the nonprofit organization that maintains the Unicode Standard to ensure emojis work across devices, has announced Unicode 17.0, which includes nine new emojis slated for release this fall, in September 2025.
    OpenAI is one of the world's leading AI research labs. Founded in 2015, it's behind some of today's most talked-about tools, including GPT, DALL·E, and ChatGPT.
    Ever catch your dog staring at the screen during movie night and wonder if they're actually watching? Turns out, they might be. A new scientific study from Auburn University found that many dogs really do engage with television, and not all pups react the same way.
    Stop the scammers from making contact in the first place. They're getting your parents' contact information and much more personal data besides, from somewhere.
    The Walker S2 robot from UBTech autonomously exchanges its batteries in just three minutes, allowing continuous operation in car factories operated by BYD, Nio and Zeekr.
    The FX Super One electric MPV from Faraday Future offers flexible seating, zero-gravity recliners and an AI system that creates a personal connection between driver and vehicle.
    Practical solutions for reducing unwanted charity mail, political texts and email spam by opting out of shared lists, replying "STOP" and using data removal services.
    Delta's new AI pricing system eliminates static airfares for personalized rates based on individual data, raising questions about fairness while promising optimized revenue.

    Protect Your Most Vital Business Asset with Security Software

    Homeland security, airport security, Internet security ??" these days we???re... Read More

    Make or Break Factors - When Considering Estimating Software

    Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can... Read More

    Manufacturing Solutions for Microsoft Great Plains ? Overview for Consultant

    Microsoft Business Solutions Great Plains has full-featured manufacturing set of... Read More

    Microsoft CRM Lotus Notes Domino Connector FAQ

    Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More

    Business Plan Software Review: Ultimate Business Planner?

    One of the main reasons business owners and entrepreneurs use... Read More

    Not All Project Management Software is Created Equal

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

    Brief Notes About Mainframe Software Pricing

    We don't think about mainframe software pricing anymore, we just... Read More

    Cross-Platform Custom Software Development & Integration ? IT Strategy for Large Corporation

    Microsoft Business Solutions products: Great Plains, MS CRM, Navision, Axapta,... Read More

    Great Plains Dynamics/eEnterprise Upgrade ? Things to Consider and FAQ

    If you have Great Plains Dynamics/eEnterprise (version 6.0 or earlier)... Read More

    Does your Company have Documentum?

    Are you lost in the mess of documents that get... Read More

    The XP Firewall Isnt Enough

    You might think you don't need a firewall... Read More

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

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

    Microsoft Great Plains Installation ? Overview for IT Director/Controller

    Microsoft Great Plains is main mid-market application from Microsoft Business... Read More

    Reporting for Microsoft Great Plains/Dynamics/eEnterprise: RW ? ReportWriter ? Tips for Developer

    Microsoft Business Solutions Great Plains is written in Great Plains... Read More

    Microsoft Great Plains Middle East - Arabic Language Support

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

    Assertion in Java

    Assertion facility is added in J2SE 1.4. In order to... Read More

    Intro to UNIX Shells

    A UNIX Shell is in simplest terms, a command line... Read More

    How to Backup Windows XP Home Edition

    Your computer cost you from hundreds to thousands of dollars,... Read More

    Microsoft Great Plains: Large Scale Implementation

    Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM... Read More

    Causes of ERP Failures

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

    Beware of Spyware

    One day, you suddenly realize that your computer started to... Read More

    Microsoft CRM Customization

    Microsoft CRM customization techniques are very diversified and based on... Read More

    Linux Secrets

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

    How to Build a Basic CSS Layout

    Designing without tables by using CSS layouts is fast becoming... Read More

    Corporate Accounting System: Microsoft Great Plains ? Overview

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

    professional cleaning service Arlington Heights ...