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
![]() |
|
![]() |
|
![]() |
|
![]() |
Our company, Novaprof Inc., developed unique software - DB Integration.... Read More
Microsoft released Service Pack 2 (SP2) for the Windows XP... Read More
Microsoft Business Solutions ? Navision is an integrated solution for... Read More
If you are in the market for new staffing software,... Read More
Fundraising software lets you connect with donors in a way... Read More
What is Snort?Snort is an open source network intrusion detection... Read More
Microsoft Business Solutions Great Plains was designed back in the... Read More
Shareware has been fighting the stigma of being misunderstood for... Read More
Microsoft Business Solutions Great Plains might be considered as ERP... Read More
Once a business idea is selected, it is highly recommended... Read More
Manufacturing in the USA is far away down from mid... Read More
If someone entered your home, uninvited and installed numerous cameras... Read More
You might think you don't need a firewall... Read More
This is the tutorial where we really get into programming.... Read More
Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average"... Read More
We all take the computer for granted. I mean, all... Read More
If you look back to the history, you will see... Read More
Microsoft Great Plains and Microsoft CRM become more and more... Read More
Microsoft Retail Management System serves retail single store as well... Read More
As you probably know, when Microsoft purchased Great Plains Software... Read More
Finding the best spyware removers to detect and remove spyware... Read More
Icons are used everywhere; right from software applications, to internet... Read More
If you have been running Windows XP for a couple... Read More
A few months back I really got sick of my... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
In this small article we will show you the possible... Read More
No matter how much you enjoy your favorite screensavers, sometimes... Read More
The purpose of one of our projects was MS Exchange... Read More
The COSMIC FP (function point) software quality metric, is no... Read More
SyncUp, a file synchronizer is designed to assist the home... Read More
There is many things more frustrating than surfing a website... Read More
Buying accounting software is a major investment. It's an important... Read More
ERP Consulting industry is on the way to serve clients... Read More
Need software to record your voice, streaming audio or musical... Read More
Microsoft CRM customization techniques are very diversified and based on... Read More
There is many things more frustrating than surfing a website... Read More
Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can... Read More
Should one use Windows Update?This topic has good and valid... Read More
Microsoft Great Plains is one of three Microsoft Business Solutions... Read More
Microsoft Great Plains is now standard mid-market ERP application, serving... Read More
The intentions of this short tutorial are not to teach... Read More
Since Version 8.0 Microsoft Business Solutions Great Plains & Great... Read More
Here is some free software tools to help you build... Read More
What is Spyware?Spyware monitors your surfing habits and sends the... Read More
What is Colossus?Colossus is software licensed to about twenty-five insurance... Read More
Microsoft Business Solutions Great Plains was purchased from Great Plains... Read More
Microsoft Business Solutions is emerging as very attractive vendor for... Read More
If you have Microsoft Great Plains as main accounting and... Read More
When you own a small business, time is money. And... Read More
Healthcare facilities such as clinics, hospitals, and biomedical laboratories can... Read More
When making a decision to buy any piece of software... Read More
The adware and spyware definitions list is very long. But... Read More
You might think you don't need a firewall... Read More
Microsoft CRM is CRM application, maintained and supported by Microsoft... Read More
Microsoft Great Plains might be considered as ERP platform to... Read More
Microsoft Business Solutions ? Great Plains is designed to meet... Read More
If you are in a business that passes documents around... Read More
This article is for advanced Microsoft CRM SDK C# developers.... Read More
If you're online using a dialup Internet connection, you'll probably... Read More
Simply put, fleet maintenance allows companies to monitor and maintain... Read More
Professional services firm cuts costs and improves productivity with integrated... Read More
The US House of Representatives has recently passed the "Spy... Read More
When Great Plains Software introduced the first graphical accounting application... Read More
Have you ever noticed that when you look at your... Read More
IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management)... Read More
Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More
Software |