Software Information

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 Alba Spectrum Technologies - 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 (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.


    MORE RESOURCES:

    Earthtimes (press release)

    Elliott Terminates Tender Offer to Acquire Epicor Software Corporation
    MarketWatch - Nov 21, 2008
    ... LP and Elliott International, LP (collectively, "Elliott" or "we"), a major shareholder of Epicor Software Corporation (the "Company" or "Epicor"), ...
    Epicor drops after hedge fund ends hostile bid Forbes
    Hedge Fund Elliott Associates Withdraws Offer for Epicor Software Orange County Business Journal
    UPDATE 1-Hedge Fund ends offer for Epicor Reuters
    RTT News - Barron's Blogs
    all 45 news articles


    New York Times

    The best thing about the 2.2 iPhone software update
    CNET News, CA - Nov 21, 2008
    When it some to iPhone software updates, I'm all about the basics. Apple could enable the iPhone to cook my dinner every night, but if it added multimedia ...
    First Look: Apple's iPhone 2.2 Software Hits The Street (And ... CRN
    Lots to like about new iPhone 2.2 software update Ars Technica
    Apple releases iPhone Software v2.2 Apple Insider
    G4 TV - infoSync World
    all 144 news articles


    Canada.com

    Microsoft to offer free security software to attract beginners
    eTaiwan News, Taiwan - Nov 21, 2008
    19 to stop selling personal computer security software and to use free personal anti-virus software instead. The new software called Morro can support seven ...
    Microsoft: New software not Symantec, McAfee rival Reuters
    Microsoft Plans to Introduce Free PC Security Software Wall Street Journal
    Spamhaus: Microsoft Now 5th Most Spam Friendly ISP Washington Post
    NetworkWorld.com - Bizjournals.com
    all 304 news articles


    Vertical Releases Feature-Rich Software Update for Wave
    MarketWatch - 20 hours ago
    ... today announced the release of the Wave 1.5 software upgrade to it's award winning Wave IP 2500(TM) Business Communications Solution, the industry's ...


    Hann’s On Software bouht by Mediware
    Bizjournals.com, NC - Nov 21, 2008
    Mediware Information Systems Inc. has bought the assets of Hann’s On Software, a pharmacy-management software provider based in Santa Rosa, for $3.5 million ...
    Mediware Acquisition Adds 320 Pharmacy Facilities MarketWatch
    Mediware Information buys assets of Hann's On Software - Quick Facts RTT News
    Mediware Acquisition Adds 320 Pharmacy Facilities International Business Times
    all 19 news articles


    AVG Sees Uphill Battle for Microsoft in Its Launch of Free Anti ...
    MarketWatch - Nov 21, 2008
    AVG, which for eight years has offered free anti-virus software to users worldwide, noted the multiple challenges Microsoft faces in supporting a free ...
    AVG sees 'uphill battle' for Microsoft Morro TechRadar UK
    Microsoft Announces Upcoming Events for the Financial Community NewsBlaze
    Microsoft Announces Upcoming Events for the Financial Community MarketWatch
    all 30 news articles


    Microsoft’s Mike Neil Keynotes at SYS-CON's 4th International ...
    SYS-CON Media, NJ - 19 hours ago
    ... Black Duck Software, Blackbaud, Blade Network Technologies, Blue Coat, Blue Lane, BlueArc, BlueNote Networks, BluePheonix Solutions, BMC Software, ...
    Teaching Everyone to Speak Big Blue New York Times
    IBM To Acquire Virtualization Specialist Transitive InformationWeek
    IBM To Buy Virtualization-Software Company Transitive NewsFactor Network
    eWeek - SearchDataCenter.com
    all 95 news articles


    Frankly speaking, speech software better but still not great
    Seattle Times, United States - 11 hours ago
    Getting a computer to turn your speech into words on the screen requires buying expensive, resource-intensive software and mastering a sometimes confusing ...


    Microsoft purges phony security software from 1 million PCs
    Computerworld, MA - 22 hours ago
    Windows users have been plagued with a flood of worthless security software in recent months as criminals have discovered that they're money-makers. ...


    Authoria Appoints New President and CEO
    MarketWatch - Nov 21, 2008
    Prior to joining Authoria, Mr. McDevitt was most recently Chief Operating Officer of CDC Software, a $360 million division of CDC Corporation and a global ...

    Software - Google News

    home | site map
    © 2006