Corporate ERP Selection: Microsoft Great Plains
By Andrew Karasev
Alba Spectrum Technologies
1-866-528-0577,
1-630-961-5918,
help@albaspectrum.com
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