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.

    Alto Pass chicago limos ..
    In The News:

    Four of the largest school boards in Ontario, Canada have launched lawsuits against TikTok, Meta, and Snapchat, claiming that they have impacted students' thinking and behavior.
    Finalists for the inaugural Women’s Prize for Nonfiction, aimed at addressing the gender imbalance in nonfiction publishing, were unveiled on Wednesday.
    Tech guru Kurt "CyberGuy" Knutsson breaks down whether the government is watching citizens and what they can do to protect online privacy.
    A benchmarking group for artificial intelligence has released new results evaluating the speed of hardware in running AI applications and responding to users.
    Sierra Space’s Dream Chaser spaceplane provides a glimpse into the future of space travel. Traveling to space may become a part of everyday life.
    The new European Hyperloop Center in the Netherlands aims bring in a new era of transportation. The center will use a steel tube as a proving ground for testing the new vehicle.
    Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
    While it may be incredibly tempting to have a “go with the flow" mindset like the rest of your vacation, your technology definitely should not be compromised while traveling.
    Have you ever accidentally deleted an app from your iPhone that you’ve already paid for? Don't worry. We’ve got a trick that will help you get it back without having to buy it again.
    Apple's new Journal app has raised privacy concerns among Apple's userbase. Tech expert Kim Komando examines social media rumors and explains what steps to take to protect yourself.
    Although Facebook has denied that our phones listen to us, they do have other ways of finding out what we are talking about, listening to and searching for.
    With the integration of OpenAI technology, Figure 01 has taken a significant leap forward, showcasing the potential of robots to understand and interact with us on a personal level.
    Port Ellen, newly reopened whisky distillery in Scotland, is using SmokeDNAi technology to understand mouth-feel and flavors during the whisky maturation process.
    Telly, a smart TV firm, is promising to give out their 4K 55-inch TV for free. What must you give in return? The innovative, yet potentially unsettling, answer might shock you.
    The moment a spam invite hits your calendar, it’s like an uninvited guest at a party. So, what do you do? Show it the door.
    Identity thieves are now targeting children and are making large sums of money by exploiting children's identities, possibly hurting their financial future.
    There's a clever way to change the notification sounds on your Android without having to look at your screen. Kurt "CyberGuy" Knutsson explains.
    If your bank accounted has been hacked, there are a number of steps you can take to prevent it from happening again. Kurt "CyberGuy" Knutsson explains.
    Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
    The Wave House, a data center in Heidelberg, Germany, is the the largest 3D-printed building in Europe. Its walls were built in about 140 hours.
    Some government agencies around the world are struggling to meet their staffing goals when it comes to hiring artificial intelligence experts.
    Google Maps' recent upgrades have introduced real-time ETA and turn-by-turn directions to your phone's lock screen while you are traveling.
    Kat Cammack says AI could disrupt the 2024 election. A report says shared AI image tools generate election disinformation in 41% of cases and voting disinformation in 59% of cases.
    Deepfakes have become commonplace, and the technology is only getting better, but there are certain elements that might give away the fact that an image is AI-generated.
    A stealthy technology known as EM Eye allows eavesdropping on your home security cameras, according to Northeastern University researchers.

    Microsoft Great Plains on Ctree or Pervasive SQL ? What to Do ? Tips for IT Manager

    As you probably know, when Microsoft purchased Great Plains Software... Read More

    SQL scripts for Project Accounting: Microsoft Great Plains series ? overview for developer

    Microsoft Business Solutions Great Plains has Project Accounting module where... Read More

    Corporate Accounting System: Microsoft Great Plains ? Overview

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

    Microsoft CRM Customization ? Programming Closed Email Activity

    Microsoft CRM is CRM answer from Microsoft and attempt to... Read More

    What to Do if All Screensavers Fun is Grayed Out?

    Finally, you have some time to personalize your desktop with... Read More

    Spyware, What is it?

    Spyware, what it is and what it does. Basically, spyware... Read More

    Can You Calculate Complex Financial Calculations?

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

    Interactive Mapping Brings Information to Life

    What is Interactive Mapping?Interactive mapping is a visual display medium... Read More

    Microsoft CRM Conversation Gateway: VoIP - Implementation & Customization

    Microsoft CRM is winning market share step-by-step from such the... Read More

    Corporate ERP Selection: Microsoft Great Plains

    In our opinion, traditional approach when you select ERP/MRP system... Read More

    Free Microsoft Word Online Training Tutorial Resources

    Microsoft Word is one of the most popular office applications... Read More

    Not All Project Management Software is Created Equal

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

    Software Piracy - Global Increase

    Pirated software is on the increase and now accounts for... Read More

    Microsoft Great Plains RW: Report Writer

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

    How To Develop Software For Your Business

    Software development is a risky business.Many software developers are barely... Read More

    How to Choose the Right Accounting Software for Your Business

    With any good luck and a good amount of hard... Read More

    Microsoft Business Solutions - Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL

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

    Microsoft Great Plains PM: Payables Management

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

    Great Plains Dexterity History and Programming Overview

    As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into... Read More

    Spyware: What It Is and How to Combat It

    Spyware is software or hardware installed on a computer without... Read More

    Screenplay and Script Writing Software

    When it comes to screenplay software each screenwriter needs to... Read More

    Destination: Desktop for Google

    First we had the original Google search that evolved into... Read More

    Defining OLAP Solutions and Data Warehouse design

    This tutorial covers OLAP solutions used by Data warehouses and... Read More

    Microsoft Great Plains Implementation & Customization: Computer Parts Retailer Example

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

    25 Things Mapping Software Can Do For You

    1. With mapping software you can create a report that... Read More

    Alto Pass cool limo ..