Great Plains Customization Upgrade? Overview For CIO/IT Director

Around the same time Microsoft made its move with .Net introduction and tried to gain portion of cheaper databases market: Pervasive SQL/Btrieve, Ctree/Faircom - and launched free MSDE database program. General direction for all its accounting systems was chosen - Microsoft announced future releases of so called Microsoft suites: Microsoft Financial, Microsoft HR, Microsoft Logistics, Microsoft Manufacturing to name a few. However Microsoft did not announce which product (Great Plains, Solomon or Navision) will become the base or will be transformed into each specific suite. Al these suites will be integrated into web-based Microsoft Business Portal

This move, probably wise in the long run, exposed businesses with heavily customized MBS products to serious customization upgrade problems. We'll give you our recommendation, based on our practice. In this article we'll talk about Microsoft Great Plains.

  • Great Plains Dexterity Customizations ? Microsoft announced that its products will be moved to .Net platform. This means that Dexterity will be phased out/discontinued. However, even now Microsoft Great Plains 8.0 is still Dexterity-based application. So, if you have Dexterity customization - our recommendation is to phase it out or consider replacing it with these: Crystal Reports, SQL Stored Procs and triggers, Web Publishing (Visual Studio.Net) from Great Plains database, eConnect (SDK created to eCommerce developers to deploy Great Plains as back end)

  • Pervasive SQL/Ctree migration to MS SQL - If you are still on these old platforms - then you are in trouble - you will be without Microsoft technical support by the end of 2004. When you do standard data migration via migration tool - Great Plains tables are migrated by the tool, however migration tooll has no info about your custom tables - these tables should be migrated manually. You can use MSSQL Server Linked Server construction to link to Pervasive/Ctree data. ODBC drivers can be installed from GP CDs.

  • VBA/Modifier/Continuum ? all these are good candidates for replacement by newer technologies, because these will not have their place in .Net platform.

    • Additional notes: When Great Plains Software designed Dexterity as the replacement to its discontinued Great Plains Accounting - it proclaimed that Dexterity is DB independent - which is true to some extent. However there are specifics, and Dexterity customization should be analyzed and tuned to work with MS SQL Server, if it was originally designed for btrieve/ctree. We are talking about customization upgrade for Great Plains Dynamics/eEnterprise 5.0, 5.5, 6.0, 7.0 to Microsoft Great Plains 8.0 or 7.5.

    Happy upgrading! 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, California, Colorado, Arizona, Texas, Florida, Georgia, New York, Canada, UK, Australia and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

    In The News:

    pen paper and inkwell


    cat break through


    Microsoft CRM Integration with Microsoft Retail Management System (RMS) ? Overview

    Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More

    What is Software Piracy?

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

    Things You Can Do With Windows XP!

    Did you ever give a thought to the number of... Read More

    Microsoft CRM Implementation & Customization: MS CRM Fax Gateway

    With this small article we are continuing Microsoft Business Solutions... Read More

    The Dreaded Paper Label - Should it be Used?

    While paper labeling CDs and DVDs may appear to be... Read More

    Microsoft CRM or Siebel

    Siebel is traditional CRM market leader, however and mostly due... Read More

    A Guide To Purchasing Professional XP Icons Online And Enhancing Your Applications

    Icons are used everywhere; right from software applications, to internet... Read More

    Great Plains Custom Development: Dexterity, VBA, SQL, Crystal, eConnect ? Overview For Programmer

    Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More

    A Case Study on Selecting Contract Management Software

    Professional services firm cuts costs and improves productivity with integrated... Read More

    Beware of Spyware

    One day, you suddenly realize that your computer started to... Read More

    Device Driver Basics

    Most people understand that the "hardware" part of their computer... Read More

    What is Shareware?

    Shareware is software that you can try before you buy;... Read More

    25 Things Mapping Software Can Do For You

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

    Brand Your Websites URL With a Favicon

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

    New Web-Based HR Tool is Max From NAS, Hannibal, and InfoLink

    Three highly respected names in Human Resources have joined forces... Read More

    Industry Experts Answer the One Million-dollar Question - Why Genie Backup Manager?

    Many reasons made GBM a unanimous choice for experts, one... Read More

    IBM Lotus Domino or Microsoft Exchange?

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

    Easy Guide to RAID Recovery

    What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive... Read More

    Microsoft Great Plains: Government & Non-Profit Organization ? Workflow Implementation

    Usually workflow & messaging is realized in CRM and then... Read More

    Great Plains Dexterity Development: FAQ

    Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More

    Think Of This

    Think of this, first we had the HAM Radio, then... Read More

    Lotus Domino: Application Integration ? A Programmer View

    There are two approaches for application integration:? Programmer's approach ?... Read More

    Marketing Your WinRunner Team

    It won't matter how effective your WinRunner Team is if... Read More

    Microsoft Great Plains POP: Purchase Order Processing ? Overview For Consultants

    Great Plains Purchase Order Processing (POP) module makes up one-third... Read More

    Helping Newbies Understand Professional Software

    The Windows registry is a huge database that ensures normal... Read More

    Microsoft Great Plains IV: Inventory Management

    Great Plains Inventory Management (IV) module gives your business a... Read More

    Spyware Protection: A Must for Any Home Computer

    Now that spyware is the single most dangerous threat to... Read More

    Linux Dual Boot-How To Format

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

    eConnect: eCommerce Development for Microsoft Great Plains

    Microsoft Business Solutions Great Plains has several options to enable... Read More

    Online PowerPoint Presentation ? Convert PowerPoint to Flash

    Although we don't know whether Microsoft ever envisioned such a... Read More

    Microsoft Great Plains FA: Fixed Assets ? Overview For Consultant

    Great Plains Fixed Assets Management module is a robust tool... Read More

    Run Your Own Search Engine

    Our hosted solution allow you to run your own search... Read More

    Change Your Word Docs in Record Time!

    Anyone who has ever used Microsoft Word knows that it... Read More