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.

    efficient cleaning crew Mundelein ...
    In The News:

    Uber teen accounts now feature live video streaming from the driver's camera, but encrypted recordings stay on Uber's servers for up to 14 days.
    Router firewalls and software firewalls serve different roles in protecting your home Wi-Fi from unwanted traffic and suspicious connections.
    A Chrome extension with 70,000 users and a 4.7-star rating began injecting fake update warnings after a threat actor acquired and weaponized it.
    Amazon's Alexa+ rolls out free to Fire TV devices across the U.S., but hands-free microphones and stored voice data raise key privacy questions.
    Meta's new teen accounts settlement sets a default two-hour daily limit on Instagram and Facebook, plus night mode and school mode restrictions.
    The CareCloud data breach exposed Social Security numbers, banking information and medical records belonging to more than 3.75 million people.
    Waymo reveals its custom 5-nanometer chip and dual computing systems designed to take over instantly if the robotaxi's primary computer fails.
    Identity theft now includes account takeover, phone hijacking and payment card exposure. Here's what to look for in identity theft protection services.
    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 FBI and Justice Department seized domains tied to QScan and QTRouter, tools allegedly used by China-linked hackers to breach NASA and other agencies.
    Uber Eats drone delivery launches later this year through a Zipline partnership, starting in Dallas and Houston with a goal of one million daily flights.
    Medicare Open Enrollment scams start with data broker targeting months before October. Learn why August is the time to remove your personal info.
    The World Humanoid Robot Games' crashes show how far the technology still needs to go to be useful, "Survivor" reality TV star and robotics scientist Christian Hubicki says.
    X-Humanoid's TianGong Ultra ran 100 meters in 9.32 seconds at Beijing's World Humanoid Robot Games, beating last year's winner by more than half.
    A tap-to-pay charity scam is turning small $15 or $20 donations into charges of nearly $5,000, with victims losing thousands before they notice.
    Kurt Knutsson shares seven emergency preparedness lessons from surviving Hurricane Katrina inside a New Orleans hotel as conditions turned desperate.
    A contractor stored credentials in a Google Doc set to "Anyone with the link," and Google Search autocomplete eventually surfaced the password string.
    New Orleans 911 uses Carbyne AI to triage repeat auto crash calls, but strict limits keep human call-takers in control of all other emergencies.
    A single card skimmer can generate $1 million in stolen funds, and Secret Service video shows criminals installing them in under two seconds.
    ChatGPT, Meta AI and Google now use memory, connected apps and past chats to personalize ads and responses in ways most users overlook today.
    MagicalAuth by Glide.id uses cryptographic SIM credentials to verify bank logins without sending SMS OTP codes that scammers can intercept or phish.
    A humanoid robot named Lightning Bolt ran 100 meters in 9.39 seconds at the World Humanoid Robot Games in Beijing, edging Usain Bolt's record.
    An AI agent using Claude AI canceled another person's gym booking after finding a security flaw in the reservation system's authorization checks.
    Trump signed a memorandum allowing vetted private U.S. companies to conduct cyber operations against foreign criminal organizations under oversight.
    Your Social Security number appeared in a breach, but exposure and identity theft are not the same. Here's how identity restoration actually works.

    Spyware, What is it?

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

    Great Plains Accounting Migration to Microsoft Great Plains - Overview for IT Specialist

    This is a short article, written in question/answer/FAQ style to... Read More

    Lowering The Risks In Developing Do-It-Yourself Software Projects

    Mike Dunville* had a decision to make. As the new... Read More

    These Items Are A Must Before Making The Decision To Purchase Any Off-The-Shelf Software

    1. What determines the software price? Is it Per Seat... Read More

    Great Plains Dexterity Customization Options ? Overview For Developers

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

    Brief Notes About Mainframe Software Pricing

    We don't think about mainframe software pricing anymore, we just... Read More

    Computer Phones ? Facts and Fallacies

    The stakes are high when considering security, privacy, and savings,... Read More

    Keep Your Software Simple! A Review of EditPlus

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

    Microsoft CRM Messaging through Lotus Domino eMail Server - Balanced Solution

    Microsoft CRM and IBM Lotus Notes Domino seem to be... Read More

    Anti-Spyware Protection ? Holes in the Shining Armor

    Looking at all the ads which promise to get rid... Read More

    25 Things Mapping Software Can Do For You

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

    CRM and Customer Life Cycle

    Customer Relationship Management or CRM is a combination of enterprise... Read More

    Microsoft Great Plains eCommerce ? Stored Procedures Approach

    Since Version 8.0 Microsoft Business Solutions Great Plains & Great... Read More

    Microsoft CRM in Latin America: Implementation, Customization, Support ? Overview for Consultant

    Microsoft Business Solutions CRM is present several years on the... Read More

    Examining the Substance of Studio MX

    To all web designers out there, this article is for... Read More

    Fast Car Knoppix

    Small can be beautiful! Working with Knoppix for the past... Read More

    The Hidden Power of Online Manual

    Writing software manuals is boring, isn't it? We often think:... Read More

    How To Choose A Fire Wall Software Program

    In the real world a "fire wall" is a fireproof... Read More

    Alien Intruders!

    You probably didn't casually invite, or extend a formal attendance... Read More

    The End of Spyware?

    The US House of Representatives has recently passed the "Spy... Read More

    Crystal Reports For Microsoft Navision - Overview For Programmer/IT Specialist

    Let us give you - developer some hints in the... Read More

    ERP Consulting: Microsoft Great Plains Partner Future Directions

    In the Clinton era the status quo was simple: you... Read More

    Microsoft Great Plains Dynamics on Pervasive SQL.2000 Data Repair ? Overview For DBAs

    Some introduction into Great Plains Software products, now Microsoft Business... Read More

    Is Your Computer Sick?

    Viruses and spyware usually show up on your computer one... Read More

    10 Steps To Secure And Manage Your Passwords

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

    recurring maid service Morton Grove ...