Corporate ERP Selection: Microsoft Great Plains

In our opinion, traditional approach when you select ERP/MRP system for large or mid-size company by functionality, database and hardware platform should be revised. We are convinced that new generation of Windows servers plus the reliability of relatively inexpensive database platform, such as Microsoft SQL Server, enable large corporation to decrease the cost of hardware, database and ERM software, plus have good internal support by hiring Microsoft certified professionals, available on the market in your area. In this small article we'll give you short review of what you should expect from Microsoft Business Solutions Great Plains, its implementation, customization, reporting, integration as well as web publishing and eCommerce or web ordering system for your existing customers.

? Hardware. PC Hardware and Windows server were considered as a solution for small and mid-size business, this opinion was wide spread in 1990th, when you needed to have scheduled rebooting of Windows server to deal with known issues, such as memory leaks, etc. Nowadays ? Windows 2003 could be counted on.

? Database. Microsoft SQL Server 6.5, if you remember old good days required a lot of maintenance and support. When Microsoft introduced MS SQL Server 7.0 and later on 2000 ? the problem of maintenance in our opinion was resolved and the database maintenance is now considered as part of data workflow side: application logic data fixes SQL queries, data feeding into SQL Server tables, data archiving and restoring.

? ERP System. In our opinion you should consider ERP as a platform for light or heavy customization to address your company unique business processes. The second approach would be purchasing the application, which would be very rich in its functionality: Oracle Financials, PeopleSoft, SAP. In this second case you "overpay" for the functionality you do not use and also pay for extended implementation and user training.

? Customization. You should consider balancing internal developers and external consultants. Internal development should be done by SQL programmers, web exposure ? by VB.Net or C#.Net developers ? you might need eConnect. Internal developers could also do light customization of Great Plains logic via Modifier with VBA. Consultants should help you with Great Plains business logic change, which requires Great Plains Dexterity programming and specification writing skills.

? Integration. In the past we saw a lot of Great Plains Integration Manager usage, today the trend is to deploy SQL scripts and stored procedures, including eConnect and its extensions (such as automatic transaction posting)

? User Training. In the case of large publicly traded company, you should probably dedicate internal Great Plains support person, who will be trained by consultant and then will provide training for end users. In this case you will avoid having consultant train the same common interface feature multiple time to different groups of users.

We encourage you to analyze your alternatives. You can always appeal to our help, give us a call: 1-866-528-0577 or 1-630-961-5918, help@albaspectrum.com

Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http://www.albaspectrum.com ), serving Microsoft Great Plains, CRM, Navision to mid-size and large clients in California, Illinois, New York, Georgia, Florida, Texas, Arizona, Washington, Minnesota, Ohio, Michigan

In The News:


pen paper and inkwell


cat break through


Keep Your Software Simple! A Review of EditPlus

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

Does your Company have Documentum?

Are you lost in the mess of documents that get... Read More

IT Strategy for Large Corporation: ERP/MRP/CRM, Unix/Linux/Windows, Microsoft/Java

Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business... Read More

Microsoft Great Plains Customization Recovery & Upgrade for Large Corporation

At the end of XX century, in the late 1990th... Read More

Builders Beware

Which Type of Shop Can Rely On A Home Built... Read More

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

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

Microsoft eCommerce Web-development: Great Plains eConnect .Net ? Highlights for Programmer

In our small article we'll consider Microsoft Business Solutions Great... Read More

Great Plains Dexterity Development: FAQ

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

Enterprise Resource Planning Overview

ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More

Microsoft Great Plains Security Setup - Overview For Consultant

Microsoft Business Solutions Great Plains is very good fit for... Read More

Upgrading Great Plains Dexterity Customization ? switching to new technologies: SQL, Crystal, eConne

1. Replace Dexterity cursor with SQL Stored Procedure Dexterity... Read More

How To Make Good Use of Spreadsheets

Most computer users use spreadsheets software such as Microsoft Excel... Read More

Microsoft CRM USA Nationwide Remote Support

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

DB Integration - Software for Combine MS Access Databases

Our company, Novaprof Inc., developed unique software - DB Integration.... Read More

MicroWorld Releases New Version of MailScan Ver. 4.5 - Antivirus and Content Security Software

MicroWorld Technologies, Inc. the leading solutions provider in the area... Read More

Crystal Reports for Microsoft Great Plains

Microsoft Business Solutions ? Great Plains is designed to meet... Read More

Microsoft Great Plains international implementation ? USA / Mexico ? overview for consultant

Microsoft Business Solutions Great Plains was purchased from Great Plains... Read More

Information Products: A Business Owners Best Friend

We live in a post-industrial age where information is the... Read More

Spyware, Adware, etc. -- Terms and Common Sense

When reading an article where some term is used often,... Read More

Putting Screensavers Under Control

No matter how much you enjoy your favorite screensavers, sometimes... Read More

Microsoft Great Plains: exchange & brokerage ? implementation notes

If you company is small or mid-size special products or... Read More

Microsoft CRM Customization - Processing In/Out-Going Email Messages

We would like to give you several situations, when you... Read More

What You Must Know About Spyware Right Now

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

Groupware: Answers the 5 Questions of Document Collaboration

Every organization which creates collaborative documents, whether they are budgets,... Read More

Microsoft Great Plains Implementation ? Overview for IT Director/Controller

What is installation in the language of technology? Installation... Read More

Intro to UNIX Shells

A UNIX Shell is in simplest terms, a command line... Read More

Microsoft CRM Customization Secrets ? Second Edition

This article is for advanced Microsoft CRM SDK C# developers.... Read More

Microsoft Great Plains in Metal Distribution: Implementation & Customization ? Consultant Overview

Microsoft Business Solutions Great Plains serves to the wide spectrum... Read More

Microsoft Great Plains Remote Support - Overview

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

Microsoft CRM or Siebel

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

ERP System of the Future: Database, Business Logic and Interface

We will base our prognosis on our Microsoft Business Solutions... Read More

Story Development Software: Good or Evil?

In the early days of the personal computer, we're talking... Read More

10 Ways to Learn a Software

Following tips help you to learn a software in lesser... Read More