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


    Off The Record - Tips For Picking Recording Software

    Need software to record your voice, streaming audio or musical... Read More

    ERP Implementation: Success Factors

    As seeing large number of implementations ? in our case... Read More

    Getting Technical Support Help Online

    Sometimes your PC will start acting strange for no apparent... Read More

    Antivirus Software ? Get The Bugs Before They Get You!

    You turn on your computer, and it doesn't look quite... Read More

    The XP Firewall Isnt Enough

    You might think you don't need a firewall... Read More

    Great Plains Dexterity: Customizations & Source Code Programming

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

    Great Plains Dexterity Development: FAQ

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

    Microsoft Great Plains Logistics & Warehouse Management ? Implementation & Customization Highlights

    Logistics automation is often considered as barcoding extension to Sales... Read More

    Software Automation Helps Increase your Bottom Line

    When you own a small business, time is money. And... Read More

    DVD Burning Tips

    CD and DVD replication is a process that works by... Read More

    The Importance of Timely Timesheets

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

    6 Easy Steps for a Smoother CD/DVD Order

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

    Groove Network. Are you in it?

    If you are in a business that passes documents around... Read More

    Running a Program on a Remote Server Using SSH

    How do you run a program on a remote server... Read More

    Microsoft CRM Data Import FAQ

    Microsoft CRM has built-in conversion tool, however you should probably... Read More

    Keep Your Software Simple! A Review of EditPlus

    I like my software simple. If it's too complex or... Read More

    Software Upgrades Arent Always the Best Move

    When my daughter was getting into AOL instant messaging (AIM)... Read More

    Microsoft Business Solutions Products Selection: ERP, CRM, Retail Management

    Let's first look at your ERP system selection (without Retail... Read More

    Microsoft Great Plains Distribution, Barcoding, Consignment ? overview for consultant

    Microsoft Great Plains ? ERM from Microsoft Business Solutions and... Read More

    Microsoft Great Plains e-Commerce ? additional considerations for programmer

    Microsoft Great Plains, designed back in 1990th as database transferable... Read More

    Protect Your Computer...and Your Business!

    We all take the computer for granted. I mean, all... Read More

    Hear It in Digits

    Music downloads are off the charts! We're listening to digital... Read More

    Save Your Resources - Combine Your IM Clients

    There are so many different programs that clutter up your... Read More

    Fundraising Software ? How Can That Help Me?

    Fundraising software lets you connect with donors in a way... Read More

    Linux Vs. Windows

    This article will not attempt to advocate the use of... Read More

    Microsoft Great Plains Implementation for Midsize & Large Corporation: Lockbox Processing

    Microsoft Great Plains is now targeting large and midsize businesses... Read More

    What You Must Know About Spyware Right Now

    Spyware is like the new technological nuclear weapon on the... Read More

    Tools for Customizing Great Plains

    Microsoft Business Solutions ? Great Plains has captured the US... Read More

    Removing Incoming Email in MS Exchange, C# Example

    The purpose of one of our projects was MS Exchange... Read More

    Microsoft CRM Development

    Microsoft CRM is CRM answer from Microsoft Business Solutions.The whole... Read More

    Microsoft Great Plains Jewelry ? Implementation & Customization Overview

    Each Industry and market niche has business specific and unique... Read More

    Interactive Mapping Brings Information to Life

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

    Microsoft Great Plains Remote Support - Overview

    Microsoft Great Plains is now standard mid-market ERP application, serving... Read More