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.

    experienced cleaning professionals Northbrook ..
    In The News:

    Cybersecurity experts warn about one of the largest credential compilations ever found, urging users to check "Have I Been Pwned" and change passwords immediately.
    Quick iPhone and Android battery optimization techniques help your device stay powered all day by turning off hidden features that secretly drain power in the background.
    Kodiak Driver autonomous truck achieves perfect 98 safety score, matching top human fleets in groundbreaking AI evaluation by Nauto's VERA system.
    New 401k catch-up contribution rules in 2026 will change taxes for high earners over 50. Learn how scammers exploit these changes and protect your retirement savings.
    Kurt Knutsson's guide covers social media privacy protection through location settings, account privacy controls and two-factor authentication to prevent scams and data breaches.
    Revolutionary retinal implant restores central vision in 80% of patients with advanced macular degeneration, offering hope where treatments once only slowed blindness.
    Learn how to use passkeys on Windows and Mac computers without cameras or fingerprint readers. Discover secure authentication methods that replace passwords.
    Tesla's FSD v14.1.2 update reintroduces Mad Max mode, enabling higher speeds and more frequent lane changes than the standard Hurry profile setting.
    A phishing email scam targeting American Express customers shows how cybercriminals use fake urgent messages to steal personal and financial information.
    Facebook's new Meta AI feature analyzes your camera roll photos to create polished collages automatically, but requires cloud processing and raises privacy concerns.
    A New Jersey teenager filed a major lawsuit against AI/Robotics Venture Strategy 3 Ltd. over ClothOff, an AI tool that created fake nude images from her social media photos.
    Microsoft reports Storm-2657 cybercriminals sent phishing emails to 6,000 addresses at 25 universities to steal payroll credentials and redirect funds.
    Astronomers have discovered asteroid 2025 SC79, a skyscraper-sized space rock orbiting the sun in just 128 days. the second-fastest known.
    The Fox News AI Newsletter delivers the latest developments form the world of artificial intelligence, including the technology's challenges and opportunities.
    A cyberattack on SimonMed Imaging exposed personal information of 1.2 million patients, including medical records, financial details and identity papers.
    Spotify's managed accounts for kids under 13 now available in at least seven countries, allowing parents to filter and block explicit content and songs.
    Friendly text conversations about BBQs and social events can lead to WEEX gold trading scams that target older adults with fake investment opportunities.
    California company Skyeports creates self-healing glass spheres from Moon regolith that generate solar power and support plant growth for sustainable lunar living.
    Cleafy researchers discover fake VPN streaming app Mobdro Pro that installs Klopatra banking Trojan, giving attackers full control over Android devices.
    Police departments across the U.S. and Canada are adopting virtual reality training to better prepare officers for high-pressure, real-world situations.
    House Bill 469 would prevent AI systems from owning property, serving as executives, or gaining legal personhood in Ohio under Representative Thaddeus Claggett's proposal.
    Public voter records expose retirees' personal details to election scammers who create targeted cons using names, addresses, and voting history data.
    Instead of fearing what comes next with artificial intelligence, think outside the box. Here are high-earning AI jobs that don't require a computer science degree.
    OpenAI CEO Sam Altman says polite words like "please" and "thank you" cost millions annually, while direct prompts may improve ChatGPT accuracy by several points.
    Chattee Chat and GiMe Chat exposed intimate conversations and photos, revealing users spent up to $18,000 on AI companions before the breach.

    Computer Based Language Development and Spell-checking

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

    What is Software Piracy?

    There are several kinds of software piracy. The bottom line... Read More

    Unofficial Windows 98 SE Service Pack 2.0 RC2

    Microsoft has never released a service pack for Windows98 SE,... Read More

    Keeping Track

    One of the things we can be as certain of... Read More

    Understanding XML Server

    XML Server can be a Web Server that stores the... Read More

    Reduce TCO: The Java Database Way

    TCO (Total Cost Ownership) is the buzzword in... Read More

    Microsoft Great Plains PM: Payables Management

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

    Understanding Document Management

    The term "document management" and "paperless office" is the subject... Read More

    You Can Write Microsoft Office Program in About 60 Minutes

    Microsoft Office program is a programming tool called Visual Basic... Read More

    Antivirus Software ? Get The Bugs Before They Get You!

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

    Software For Your Hard-Drive

    All your software is stored on a hard-drive. But how... Read More

    An Easy Way to Deal with Email Viruses and Worms

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

    Off The Record - Tips For Picking Recording Software

    Need software to record your voice, streaming audio or musical... Read More

    How to Make Own CMS

    Every day millions of new web documents emerge on the... Read More

    Microsoft and Webmasters

    Does Microsoft care for WebmastersIt's always been a problem with... Read More

    An Introduction to .NET Framework

    .Net Framework is a platform or development environment to seamlessly... Read More

    Upgrading Great Plains Dexterity Customization ? switching to new technologies: SQL, Crystal, eConne

    1. Replace Dexterity cursor with SQL Stored Procedure Dexterity... Read More

    Brand Your Websites URL With a Favicon

    Have you ever noticed that when you look at your... Read More

    Cisco Certification: Introduction To ISDN, Part III

    Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More

    Tripwire for Linux File Integrity

    What is Tripwire?Tripwire is a form intrusion detection system (IDS)... Read More

    Lotus Domino/Notes - Microsoft Great Plains Tandem as ERP with Documents Workflow - Overview for IT

    Lotus Domino/Notes ? Microsoft Great Plains tandem as ERP with... Read More

    A Time-Saving Programming Tactic that Doesn?t Work

    Let's say that you have a software project that's under... Read More

    Microsoft Great Plains: Large Scale Implementation

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

    Put Some Pizazz in Your Software Arsenal

    The software giants don't do everything and don't always produce... 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

    best value cleaning service Northbrook ..