Integrating Microsoft Great Plains Accounting/ERP: RMS, CRM, eCommerce, Lotus Domino ? overview

Microsoft Business Solutions Great Plains has substantial market share among horizontal and vertical clientele in the USA, Canada (including French version for Quebec/Montreal), UK, Australia, New Zealand, Spanish speaking Latin and Central America, South Africa and Middle East. Nowadays ERP can not stay as it is off-the-shelf product ? it requires integration with Legacy or newly implemented systems, such as CRM, Retail Management applications, custom in-house made business systems (transportation/cargo tracking, etc). The tendency is that if company uses Microsoft-driven computer park (Windows domain, SQL Servers, MS Exchange) the rest of the ERP/CRM applications are Windows-oriented. However you can have successful bridge between non-Microsoft ERP and Great Plains: Oracle, IBM Lotus Notes/Domino, DB2 or others), usually it involves Java/CORBA/EJB/JSP type of expertise.

? Microsoft RMS-Great Plains integration. There are few options ? first one is to use standard integration, coming with MS RMS. It has Dexterity interface in Great Plains, does integration to single company at the time. Doesn't integration on SOP/AR level, however. Second option is to use integration, maintained by Alba Spectrum Technologies ? it integrates unlimited number of stores, SOP/AR/POP, posts through Bank Reconciliation module and so allows to track Check Books/Credit Card balances. This integration also has Dexterity interface for Stores-GP Companies mapping and could work as nightly or real time SQL Server routine

? Microsoft CRM-Great Plains integration. This integration is maintained by Microsoft Business Solutions and allows you to synchronize SOP and Customers in Great Plains with Microsoft CRM Quotes and Orders. Microsoft CRM has open Microsoft CRM SDK and so you can customize and integrate Microsoft CRM at will, having C# or VB.Net in-house expertise. The above mentioned integration could be altered and tuned by programming MS BizTalk server (it can use either BizTalk runtime or regular license)

? Microsoft Great Plains as Back office for eCommerce web-site. Here we need to mention interesting thing, The product, created and dedicated to eCommerce developers ? Great Plains eConnect is often considered as a bit expensive and licensing-restricting solution. If your company is ISV and implements eCommerce product, integrating to Great Plains ? you would rather prefer set of open and simple stored procedures, moving data to and retrieving from Microsoft Great Plains Sales Order Processing (SOP) module

? Microsoft Great Plains integration with Oracle. Well ? you can do it either from Oracle or from MS SQL Server side ? in both cases you have linking tools and heterogeneous queries mechanisms

? Microsoft Great Plains integration with Lotus Notes/Domino. ? If you want Great Plains documents lookup from Lotus ? you typically use ODBC connection to MS SQL Server. You need to know Great Plains tables structure (Tools->Resource Description->Tables in Great Plains) Good luck in upgrading and if you have issues or concerns ? we are here to help! If you want us to do the job - give us a call 1-866-528-0577, 1-630-961-5918! help@albaspectrum.com

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, serving clients in Chicago, California, Texas, Florida, New York, Georgia, Arizona, Minnesota, UK, Australia and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is CMA, Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. You can contact Andrew: andrewk@albaspectrum.com

In The News:


pen paper and inkwell


cat break through


DB Integration - Software for Combine MS Access Databases

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

Microsoft Update - 5 Reasons to Update Service Pack 2

Microsoft released Service Pack 2 (SP2) for the Windows XP... Read More

Microsoft Navision and Crystal Reports - An Overview

Microsoft Business Solutions ? Navision is an integrated solution for... Read More

How to Evaluate Staffing Software

If you are in the market for new staffing software,... Read More

Fundraising Software ? How Can That Help Me?

Fundraising software lets you connect with donors in a way... Read More

Snort for Network IDS

What is Snort?Snort is an open source network intrusion detection... Read More

Microsoft Great Plains eCommerce: overview for developer

Microsoft Business Solutions Great Plains was designed back in the... Read More

Benefits of Shareware

Shareware has been fighting the stigma of being misunderstood for... Read More

Microsoft Great Plains: Service Business Customization & Integration Example

Microsoft Business Solutions Great Plains might be considered as ERP... Read More

Business Planning Software

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

Manufacturing Outsourcing: Microsoft Great Plains Implementation, Customization & Reporting

Manufacturing in the USA is far away down from mid... Read More

Who?s Watching What You Type?

If someone entered your home, uninvited and installed numerous cameras... Read More

The XP Firewall Isnt Enough

You might think you don't need a firewall... Read More

C++ Tutorial 2, Input and Variables

This is the tutorial where we really get into programming.... Read More

OLAP, An Alternative Technology Over Spreadsheets

Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average"... Read More

Protect Your Computer...and Your Business!

We all take the computer for granted. I mean, all... Read More

MultiNational Corporation ERP Implementation ? Microsoft Business Solutions Great Plains

If you look back to the history, you will see... Read More

Microsoft Business Solutions VAR/Partner Selection ? Overview for IT Director/Manager/Controller

Microsoft Great Plains and Microsoft CRM become more and more... Read More

Microsoft Retail Management System (RMS) SQL Customization ? Overview for Programmer

Microsoft Retail Management System serves retail single store as well... Read More

Microsoft Great Plains on Ctree or Pervasive SQL ? What to Do ? Tips for IT Manager

As you probably know, when Microsoft purchased Great Plains Software... Read More

Best Spyware Removers

Finding the best spyware removers to detect and remove spyware... Read More

A Guide To Purchasing Professional XP Icons Online And Enhancing Your Applications

Icons are used everywhere; right from software applications, to internet... Read More

Reloading Windows XP

If you have been running Windows XP for a couple... Read More

How the Firefox: How to... Manual Helped Me

A few months back I really got sick of my... Read More

Microsoft Great Plains Inventory Control ? Overview For Consultant

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

Microsoft Great Plains: carpet, textile, fabric, felt distributor ? implementation overview

In this small article we will show you the possible... Read More

Putting Screensavers Under Control

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

Removing Incoming Email in MS Exchange, C# Example

The purpose of one of our projects was MS Exchange... Read More

COSMIC: A Small Improvement on the Symons Method

The COSMIC FP (function point) software quality metric, is no... Read More

SyncUp ? A File/Folder Synchronizer For Windows

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

Reduce Pop-ups and Annoying Ads

There is many things more frustrating than surfing a website... Read More

How to Get The Best Accounting Software For Your Small Business

Buying accounting software is a major investment. It's an important... Read More

Microsoft Great Plains Nationwide Remote Support

ERP Consulting industry is on the way to serve clients... Read More