IT Strategy for Midsize Business: Microsoft vs. Java, Great Plains & CRM

Midsize business or non-profit organization should decide if one-vendor solution would be appropriate and the associated risk acceptable. In our opinion, balancing the risk of one-vendor-approach is not economically feasible and should be avoided. This means that you need to decide if you plan to be Microsoft-oriented or Java/Unix/Linux/Oracle oriented. In the case of Java direction ? you again have to further consider your options and if possible do not deploy too many systems from different vendors. Even if you host your systems with somebody else ? we think that in the future you might have a risk of complex data conversion from one system to another. In this small article we'll show you typical way if you follow Microsoft direction: Microsoft Business Solutions Great Plains and Microsoft CRM

? Sales Automation. It was actual at all the times, however now it is becoming critical to have decent Client Relation Management (CRM) system implemented. You order takers or sales people should be working exclusively in CRM, where you should have sales workflow, approvals, pipeline of pending deals, reporting with future cash flow prediction. Use Microsoft CRM Sales module.

? Servicing. If you would like to avoid tame wasting when your service and sales people are talking to each other and have long meetings to fulfill customer order, you have to organize them around CRM Service module: Contract, Case, Activity, workflow and assignments to service technicians, plus email to/from your customers should be captured in MS CRM

? ERP. Currently, Microsoft Business Solutions has MS CRM integrated with Microsoft Great Plains. Great Plains is good ERP solution for majority midsize business and fits to variety of business niches. Great Plains is integrated with MS CRM on the level of Sales Order Processing module (SOP).

? Customization. Usually each midsize business has unique procedures which should be mapped into their CRM and ERP. So, be ready to have minor or major customization implemented. In the case of MS CRM ? majority of the customizations are done in C# or VB.Net ? so called Microsoft CRM SDK programming and development. It is open technology ? you can download MS CRM SDK and have anyone with C#/VB.Net skills do the job. In the case of Microsoft Great Plains he technology is not that open and you might need somebody with Great Plains Dexterity, VBA/Modifier, Integration Manager, eConnect, SQL coding ? this combination of skills is usually available from one of the Microsoft Business Solutions Customization Partners

? Integration. If you have something else, besides Microsoft CRM and Great Plains, then you might need the integration. Assuming that your major systems are on the Microsoft platform ? integrations should be done via heterogeneous queries from the side of Microsoft SQL server ? through linked servers

? Reporting. In our opinion ? the best tool for non-financial reports (financial ? use FRx) is Crystal Reports. Base your Crystal report on heterogeneous view or stored procedure to pull the data from multiple systems. You can deploy Crystal reports in your web application, if needed

Good luck with implementation, customization and integration and if you have issues or concerns ? we are here to help! If you want us to do the job - give us a call 866-528-0577 or 630-961-5918! help@albaspectrum.com

Andrew is Great Plains specialist in Alba Spectrum Technologies ( http://www.albaspectrum.com ) ? Microsoft Great Plains, Navision, Microsoft CRM Partner, serving clients in California, Minnesota, Illinois, Washington, Florida, Arizona, New York, New Jersey, Virginia, Georgia, Louisiana, Texas, Canada, UK, Australia, Brazil, Germany, Russia

In The News:


pen paper and inkwell


cat break through


Microsoft Great Plains as ERP and Microsoft CRM as CRM

If you have Microsoft Great Plains and support it for... Read More

Why Java RDBMS?

It is a well known fact that Java as a... Read More

Great Plains DOS Support ? Notes for Consultant

Great Plains Accounting, accounting package for mid-size and small companies... Read More

Keeping Track

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

Behave, Word, Behave!

If you copy something from a Web site or elsewhere...... Read More

Most Common Ways to Accumulate Spyware (where It is Downloaded to Your PC)

It is possible that if one avoided all sources of... Read More

Document Templates Give You The Perfect Framework For Your Documents

When it comes to running an office, the SOHO entrepreneur... Read More

Free Software for Newbies and Web Developers

Here is some free software tools to help you build... Read More

Is Your Small Business Ready For A CRM Software Solution?

I have yet to see a business that, sometimes in... Read More

Microsoft Great Plains: Manufacturing or Bill of Materials - Overview for IT Specialist

Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More

Secure File Transfer Using SSH Plus Additional Audit & Automation - FSA Reporting

In order to meet regulatory and corporate compliance requirements reporting... Read More

Crystal Reports for Microsoft Great Plains

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

Who Is Minding Your Sensitive Data?

Stealing company information used to be the specialty of spies... Read More

Great Plains Dexterity History and Programming Overview

As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into... Read More

Microsoft Great Plains: Interest Calculation Example ? Stored Procedure for Crystal Report

This is intermediate level SQL scripting article for DB Administrator,... Read More

Instant Messenger Clients

If you have been using the Internet for any amount... Read More

Configure Windows Indexing Service for Performance

The Windows Indexing Service provides you with the ability to... Read More

Microsoft CRM Customization Secrets ? Second Edition

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

New SQL Delta Version 3.1

COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More

Understanding XML Server

XML Server can be a Web Server that stores the... Read More

netstat - Linux Command to Display Networking Information

In linux, one of great commands for finding out information... Read More

Downloading Spyware Removers: Think Before, not After

Just imagine: you are walking, say, towards your car, and... Read More

Beware of The Pirated Software E-Mail Scams!

You have gotten those E_Mails buy software at deep discounts.... 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 Bluebird Project

The objective for Zandi Digital is to make available clever... Read More

Importance of Coding Standards

Programming Help for BeginnersWe write programs to instruct computers. When... Read More

It?s Back!! WordPerfect?s Amazing Comeback

Have you noticed WordPerfect is gearing up for a comeback... Read More

Adware and Spyware

What is 'adware'?Adware is basically software or scripts that are... Read More

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

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

Microsoft CRM Integration with IBM Lotus Notes Domino ? Machinery Dealership Example

IBM Lotus Notes with Domino email server is traditional document... Read More

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

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

Free Software: How Not To Get More Than You Bargained For!

I completed an experiment recently. I wanted to find out... Read More

SyncUp ? A File/Folder Synchronizer For Windows

SyncUp, a file synchronizer is designed to assist the home... Read More