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

    Dowagiac prom limousines .. Lockport Chicago limo O’Hare
    In The News:

    Tech expert Kurt “CyberGuy" Knutsson says ChatGPT learns from chats, but you should avoid sharing sensitive information to protect your privacy.
    Beyond Aero's BYA-1: Hydrogen-electric jet with zero emissions, reduced costs, 2030 launch. Kurt “CyberGuy" Knutsson discusses a potential game changer in the evolution of air travel.
    Kurt "CyberGuy" Knutsson explains how you can creatively repurpose your old unused Android devices, which are full of potential and hidden value.
    Mech the super-humanoid robot can lift up to 132 pounds and is designed to tackle stressful and repetitive tasks that often lead to workplace injuries.
    Double-clicking is something we all do, often without giving it a second thought. But it could be giving hackers permission to do something dangerous.
    Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
    Kurt the CyberGuy offers some of his easy expert tips to free up storage space on your Android if your device is running short on storage.
    You can reset your internet router remotely if you're not home when your power goes out. Kurt "CyberGuy" Knutsson explains how this can be done.
    The EO Canopy is a self-sustaining, solar-powered camping platform designed to provide all the comforts of home while completely off the grid.
    Experts say hackers who used to focus on Windows operating systems are increasingly targeting Apple IDs as part of a new phishing campaign.
    Unitree, a Chinese robotics company that developed a backflipping robot, has now introduced a humanoid robot capable of doing a side flip.
    Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
    According to the FBI, cybercriminals are sending extortion letters, threatening to release victims' sensitive information unless a ransom is paid.
    FireSat is a satellite project designed to detect and track wildfires early, aiming to detect a fire that's the size of a classroom within 20 minutes.
    Tech expert Kurt “CyberGuy" Knutsson reports that researchers have uncovered a Chrome vulnerability used in a cyber espionage campaign.
    Preserving voicemails securely on Android: Tech expert Kurt “CyberGuy" Knutsson reveals easy methods to keep memories alive forever.
    This phishing kit bypasses 2FA via session hijacking and real-time credential theft. Kurt “CyberGuy" Knutsson offers four ways to stay safe from Astaroth phishing attacks.
    Tech expert Kurt “CyberGuy" Knutsson discusses Joby Aviation and Virgin Atlantic planning to launch 200-mph U.K. air taxis linking airports and cities.
    Fake Apple virus warnings, security alerts and messages are tactics used to prompt you to call a number or click on a malicious link. The CyberGuy explains how to protect your devices.
    The combination of artificial intelligence and neuroscience allows a paralyzed man to manipulate a robotic arm by using his brain to imagine movements.
    With the help of artificial intelligence, sophisticated fraud techniques emerging today are virtually undetectable to the untrained eye.
    Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents
    If you need to free up space on your Mac, consider deleting duplicate photos in your image library. Apple makes it easy to do, and the CyberGuy explains the process.
    Microsoft is discontinuing Skype in May after 22 years of service. Kurt the CyberGuy addresses other options for internet-based phone and video service.
    Tron 1, a Chinese company's two-legged robot, is versatile and can walk, roll and pivot, even on rough terrain. Tron 1 stands 33 inches tall and weighs 44 pounds.

    Microsoft Axapta, Navision or Great Plains: ERP Selection for Large Corporation

    If you would like to pick something from Microsoft, or... Read More

    Increase Office Efficiency With One Simple Tool

    When you need a phone number, you do a quick... Read More

    10 Steps To Secure And Manage Your Passwords

    Passwords protect your most sensitive personal, financial and business information.... Read More

    Passwords Used In Microsoft Word Documents

    You would like to protect your documents, wouldn't you? Reasons... Read More

    ERP for Large Corporation ? New Selling Strategy

    Our opinion is based on our Microsoft Business Solutions Great... Read More

    Great Plains Bill of Materials Setup & Customization for Process Manufacturing ? Overview

    Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity... Read More

    Scrap Booking Online: Word Perfect or Corel Graphics Suite?

    Scrapbooks are very popular these days. I think that almost... Read More

    10 Things You Could be Using Photoshop For, But Probably Arent

    Most people don't use Photoshop to its fullest capabilities. Here... Read More

    Keeping Track

    One of the things we can be as certain of... Read More

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

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

    DVD Burning Tips

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

    Microsoft Great Plains GL: General Ledger ? Overview For Consultant

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

    What is Spyware? Are You Being Watched?

    Find out why Spyware Removal from computers is important and... 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

    Great Plains Dexterity Programming ? Overview For Developer

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

    Off The Record - Tips For Picking Recording Software

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

    Dashboard Widgets for Windows

    For a windows user like me, just can watch with... Read More

    The Dreaded Paper Label - Should it be Used?

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

    RFID: Strengthen the Position for SAP; United States

    SAP Inc., a global leader in client/server enterprise application software... Read More

    Programming Language Migration Path

    While I was preparing some personal background information for a... Read More

    Introduction To ISDN, Part II

    In the previous ISDN article, we looked at how and... Read More

    Microsoft CRM USA Nationwide Remote Support

    Remember old good days when your company probably had Great... Read More

    Business Planning Software

    Once a business idea is selected, it is highly recommended... Read More

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

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

    Ukraine IT Myths Dispersed

    While Ukraine is becoming a new popular IT outsourcing destination,... Read More

    shuttle from O'Hare Lake Villa ..