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.

    apartment cleaning near Des Plaines ...
    In The News:

    Ahold Delhaize's cybersecurity incident knocked online ordering and digital coupons offline at Stop & Shop, Food Lion, Hannaford and Giant Food stores.
    The Fox News AI Newsletter covers the latest artificial intelligence technology advancements, including the challenges and opportunities AI presents now and for the future.
    Amazon's About You feature includes personality details from your shopping history, and some shoppers are finding hilariously awkward results.
    Identity theft recovery starts with securing bank accounts, freezing credit and enabling two-factor authentication within the first 24 hours.
    Apple's $299 HomeView smart display uses facial recognition to personalize screens for up to six household members and show live security camera feeds.
    Domonique DuBose spotted red flags when a man on Hinge with 85,000 followers and a blue checkmark claimed to be a San Francisco 49ers player.
    Your phone's location data can expose visits to doctors, pharmacies and places of worship. The FTC took action against data brokers selling this data.
    Hackers targeted Danfoss refrigerator controls across French supermarkets, forcing chains like Carrefour and Monoprix to discard massive food stocks.
    iOS 27 finally lets iPhone Shared Albums store photos and videos at full resolution in iCloud, but new items count toward the owner's storage.
    A fake Facebook Marketplace text scam uses your real name as the seller to trick you into replying, and Malwarebytes warns even one response helps.
    The Pentagon data breach exposed 2.76 million Social Security numbers and military records, raising long-term identity theft concerns for veterans.
    Kodiak AI plans to haul IKEA freight on Texas highways with no one in the cab, raising urgent cybersecurity and safety questions for drivers.
    Apple Intelligence in iOS 27 adds Extend and Reframe tools to Photos, letting iPhones generate new background areas beyond your original borders.
    Microsoft's X account was hijacked to promote a crypto pump-and-dump scheme, exposing its more than 13 million followers to a scam campaign.
    Scammers can combine your name, phone number and address with data breach details to attempt SIM swaps, phishing and even identity theft schemes.
    ChatGPT Work, Meta Muse and Gemini Spark can monitor flight prices, sort your email inbox and track important deadlines, but savvy users start small.
    iPhone, Samsung Galaxy and Google Pixel each hide a built-in tool that turns a video frame into a separate photo without any screenshot needed.
    Operation KillSwitch dismantled KillSec's ransomware infrastructure, but investigators say a 16-year-old allegedly ran the entire cybercrime operation.
    The Fox News Artificial Intelligence newsletter covers where voters will decide on AI data center ballot measures and Jeff Bezos' tech vision.
    Apple's Impersonation Risk Detection in iOS 27 can flag suspicious activity inside apps, but the setting is off by default and must be enabled.
    Federal Election Commission records can expose your name, address, employer and donation history once contributions exceed the $200 threshold.
    Cybersecurity expert Morgan Wright says human skepticism remains the strongest defense against AI-driven phishing scams and voice cloning fraud schemes.
    iPhone, Google Pixel and Samsung Galaxy each handle security updates differently, and one screen saying "up to date" may not tell the whole story.
    Deborah Del Mastro heard what sounded like her daughter's terrified voice on the phone, launching a five-hour virtual kidnapping scam ordeal.
    Hotel TV privacy risks go beyond forgotten passwords when you sign into Netflix or other streaming apps on shared devices you don't control.

    These Items Are A Must Before Making The Decision To Purchase Any Off-The-Shelf Software

    1. What determines the software price? Is it Per Seat... Read More

    Linux Dual Boot-How To Format

    Just the thought of a duel-boot scares many people away,... Read More

    Groupware and Online Collaboration: Collaboration Series #4

    This article is the fourth of a series of articles... Read More

    How to Choose the BEST Charting Software

    I suggest that you do not spend a lot of... Read More

    OEComplete ? A Personal Information Manager

    OEComplete is a utility for managing the personal information of... Read More

    IBM Lotus Domino or Microsoft Exchange?

    IBM Lotus Domino or Microsoft Exchange?The severe competition continues for... Read More

    The Religion And Philosophy Of Small Internet Business

    I have always had a tendency to focus on the... Read More

    How To Choose A Fire Wall Software Program

    In the real world a "fire wall" is a fireproof... Read More

    Create A Flash Presentation For Free With Open Office

    The intentions of this short tutorial are not to teach... Read More

    Seven Reasons Why a Hosted Inventory Management Solution Might Be Right For Your Organization

    Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More

    The Importance of Timely Timesheets

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

    Unwanted Files

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

    You Can Write Microsoft Office Program in About 60 Minutes

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

    Microsoft RMS ? Great Plains Integration ? Overview For IT Specialist

    Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More

    6 Easy Steps for a Smoother CD/DVD Order

    It's all about turn times in the eMedia industry! The... Read More

    Great Plains Dexterity: Customizations & Source Code Programming

    Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on... Read More

    Microsoft Moves to Small Business Accounting/Retail Market ? Stakes and Thoughts

    In this small article we will be looking at the... Read More

    Unofficial Windows 98 SE Service Pack 2.0 RC2

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

    Lotus Notes Domino and Microsoft CRM Integration

    Well, even if the combination might look very unusual, we... Read More

    Algebra Help Software

    Need help making sense of algebra? Have algebra lectures in... Read More

    Benefits of Integrating Online Chat Software with CRM

    Customer Relationship Management (CRM) is a strategy and processes used... Read More

    5 Easy File Management Tips in Microsoft Word

    How many steps does it take you to locate and... Read More

    Should I Use Windows Update?

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

    Need of Document Management System (DMS)

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

    5 Time-Saving Tips in Microsoft Word

    Whether you have used Microsoft Word for years, have just... Read More

    home cleaning services Northbrook ...