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.

    monthly home cleaning Buffalo Grove ..
    In The News:

    Smart home hacking fears overblown? Expert reveals real cybersecurity risks and simple protection tips to keep your connected devices safe from hackers.
    MIT develops needle-free glucose monitor using light technology. Revolutionary device could replace painful finger pricks for diabetes management.
    The ClickFix campaign disguises malware as legitimate Windows updates, using steganography to hide shellcode in PNG files and bypass security detection systems.
    Researchers from Osaka Metropolitan University designed a 21-foot dome that combines aquaculture and hydroponics to create a self-sustaining urban food system.
    The Fox News AI Newsletter gives readers the latest AI technology advancements, covering the challenges and opportunities AI presents.
    ChatGPT data breach exposes personal info of users through partner Mixpanel. OpenAI confirms names, emails compromised in security incident.
    Android rolls out Emergency Live Video for 911 calls, letting dispatchers see real-time scenes during emergencies. Great for holiday travel safety.
    Malicious Chrome and Edge extensions collected browsing history, keystrokes and personal data from millions of users before Google and Microsoft removed them.
    Google's new Call Reason feature lets Android users mark calls as urgent before dialing, displaying an urgent label to recipients using Phone by Google app.
    Medical history made as surgeons successfully restore sight to legally blind patient using world's first 3D printed corneal implant grown from human cells.
    Data brokers aggressively collect your holiday shopping data to fuel scams and targeted ads. Learn how to delete your digital profile before 2025 starts.
    Scammers are sending fake MetaMask wallet verification emails using official branding to steal crypto information through phishing links and fraudulent domains.
    Learn what background permissions, push notifications, security updates, auto-join networks and app refresh mean to better manage your phone's privacy settings.
    Criminals test stolen data by applying for deposit accounts in victims' names to prepare bigger attacks. Learn why banks won't share fraud details.
    New study of 10,500+ kids reveals early smartphone ownership linked to depression, obesity, and poor sleep by age 12. Earlier phones mean higher risks.
    A phone phishing attack compromised Harvard's alumni and donor database, marking the second security incident at the university in recent months.
    AutoFlight's zero-carbon floating vertiport uses solar power to charge eVTOL aircraft while supporting emergency response, tourism, and marine energy maintenance.
    A new phone return scam targets recent buyers with fake carrier calls. Learn how criminals steal devices and steps to protect yourself from this fraud.
    New Anthropic research reveals how AI reward hacking leads to dangerous behaviors, including models giving harmful advice like drinking bleach to users seeking help.
    The Fox News AI Newsletter gives readers the latest AI technology advancements, covering the challenges and opportunities AI presents.
    Holiday email scams, including non-delivery fraud and gift card schemes, spike in November and December, costing victims hundreds of millions, the FBI says.
    Holiday visits offer the perfect opportunity to help older parents with technology updates, scam protection and basic troubleshooting skills for safer digital experiences.
    Swiss scientists create grain-sized robot that surgeons control with magnets to deliver medicine precisely through blood vessels in medical breakthrough.
    Researchers exploited WhatsApp's API vulnerability to scrape 3.5 billion phone numbers. Learn how this massive data breach happened and protect yourself.
    Travel companies share passenger data with third parties during holidays, but travelers can protect themselves by removing data from broker sites and using aliases.

    Adware and Spyware

    What is 'adware'?Adware is basically software or scripts that are... Read More

    Microsoft CRM ? Consulting in the Post-Recession Time

    New post-recession era has new features, which didn't exist in... Read More

    Microsoft Great Plains Upgrade ? Things to Consider and FAQ

    If you have Microsoft Great Plains and support it for... Read More

    Reduce Pop-ups and Annoying Ads

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

    Microsoft Great Plains Integration with Microsoft Access ? Overview for Developer

    ... Read More

    Microsoft Great Plains Reporting ? Overview for Developer

    Looks like Microsoft Great Plains becomes more and more... Read More

    Groupware as a Document Manager: Collaboration Series #3

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

    Software Piracy

    SOFTWARE PIRACY We regularly hear reports... Read More

    Microsoft Great Plains Implementation: Verticals - Wholesale Order Entry center ? overview

    Microsoft Business Solutions Great Plains has substantial market share and... Read More

    The Top 5 Wrong Reasons For Not Hiring Testers

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

    Crystal Reports for Microsoft Great Plains ? Overview for Developer

    Microsoft Great Plains is main accounting / ERP application... Read More

    History of Java

    The java programming language is becoming more and more popular... Read More

    Microsoft Great Plains Data Conversion ? Overview For Developer

    Looks like Microsoft Great Plains becomes more and more popular,... Read More

    Start Developing Your Own Software

    Learning how to program software seems like a daunting task... Read More

    Microsoft Great Plains Implementation & Customization: Computer Parts Retailer Example

    Microsoft Great Plains fits to majority of horizontals and retail... Read More

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

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

    Great Plains Dexterity Customization Options ? Overview For Developers

    Looks like Microsoft Great Plains becomes more and more popular,... Read More

    Backing Up And Restoring Your MySQL Database

    If you've been using MySQL database to store your important... Read More

    What is a Document Manager without Version History?

    Document Manager and Version HistoryIn previous articles I have discussed... Read More

    Great Plains Accounting Migration to Microsoft Great Plains - Overview for IT Specialist

    This is a short article, written in question/answer/FAQ style to... Read More

    Perfectly New Database Query Tool - Foxy SQL Pro Released

    Are you a database professional? Do you work with a... Read More

    Do You Want Your Own Fully Programmable ERP? - Part 1

    We are in a transition phase in the Managerial Administration... Read More

    Did You Ever Want to Completely Erase Everything on Your Computer?

    Did you ever want to erase everything on your computer?... Read More

    SSH (SCP) Send Files from Windows to Your Linux Box

    Not all of us have the luxury of working both... Read More

    scheduled maid service Mundelein ..