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
|
|
|
|
|
|
|
Cisco Certification: Introduction To ISDN, Part IV
In part III of this ISDN primer, we learned that... Read More
Does Microsoft have any real competition?
Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More
Professional Software Icons For Your Standalone Application
User interfaces and accessibility are some of the most important... Read More
Great Plains Accounting Migration to Microsoft Great Plains - Overview for IT Specialist
This is a short article, written in question/answer/FAQ style to... Read More
Are You Waiting for Microsoft Longhorn Operating System
I love new technology. I am still ready to wait... Read More
Software Review: Xsitepro Total Site Management Software
It's not very often I get excited about a software... Read More
Internet Security Threats: Who Can Read Your Email?
Before being able to choose a secure Internet communication system,... Read More
Microsoft Great Plains: Getting New Users Licenses ? Annual Service Plan FAQ
Microsoft Business Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM... Read More
Microsoft Great Plains customization ? Freight Forwarding/Transportation industry example
Microsoft Business Solutions Great Plains version 8.5, 8.0, 7.5, Great... Read More
Microsoft CRM and No-Frills Cadillacs
In today's business world it's all but impossible to escape... Read More
5 Easy File Management Tips in Microsoft Word
How many steps does it take you to locate and... Read More
SQL Administrator Skills Required to Support Microsoft Great Plains
Microsoft Great Plains is becoming more and more popular and... Read More
Does your Company have Documentum?
Are you lost in the mess of documents that get... Read More
Microsoft RMS ? Great Plains Integration ? Overview For IT Specialist
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... 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
Helping Newbies Understand Professional Software
The Windows registry is a huge database that ensures normal... Read More
MultiNational Corporation ERP Implementation ? Microsoft Business Solutions Great Plains
If you look back to the history, you will see... Read More
Microsoft Great Plains Implementation: Verticals - Wholesale Order Entry center ? overview
Microsoft Business Solutions Great Plains has substantial market share and... Read More
Spyware, Adware, etc. -- Terms and Common Sense
When reading an article where some term is used often,... Read More
Online PowerPoint Presentation ? Convert PowerPoint to Flash
Although we don't know whether Microsoft ever envisioned such a... Read More
Microsoft Great Plains: Service Business Customization & Integration Example
Microsoft Business Solutions Great Plains might be considered as ERP... Read More
XML Parser and Their Types
XML parser is a software module to read documents and... 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
eCommerce development for Microsoft Great Plains: tools and highlights for programmer
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
Scrap Booking Online: Word Perfect or Corel Graphics Suite?
Scrapbooks are very popular these days. I think that almost... Read More
15 Questions to Ask Your Software Vendor
When making a decision to buy any piece of software... Read More
Microsoft Great Plains Implementation for Large Corporation ? Overview for VP IT
Microsoft Business Solutions Great Plains was historically designed to serve... Read More
Getting Technical Support Help Online
Sometimes your PC will start acting strange for no apparent... Read More
Microsoft CRM Data Conversion FAQ
Microsoft Business Solutions CRM data conversion deserves FAQ type of... Read More
Microsoft Great Plains Installation ? Overview for IT Director/Controller
Microsoft Great Plains is main mid-market application from Microsoft Business... Read More
Microsoft Great Plains version 8.5: Upgrade, Customization, VBA, Crystal Reports - Highlights
Microsoft Great Plains is one of the Microsoft Business Solutions... Read More
QuarkXpress Tips: How to Move Content Between Print and Web Layouts
Since its release in 1987, QuarkXpress had made an immediate... Read More
Downloading Spyware Removers: Think Before, not After
Just imagine: you are walking, say, towards your car, and... Read More
Microsoft Great Plains e-Commerce ? additional considerations for programmer
Microsoft Great Plains, designed back in 1990th as database transferable... Read More
IT Strategy for Midsize Business: Microsoft vs. Java, Great Plains & CRM
Midsize business or non-profit organization should decide if one-vendor solution... Read More
10 Things You Can Do With Photoshop CS2 That You Couldnt Do Before Now
Is Photoshop CS2 worth the upgrade? You bet it is!... Read More
C++ Function Templates
C++ Function templates are those functions which can handle different... Read More
Open Source Concepts: Dual Licensing Explained
We were recently faced with a decision: either to let... Read More
Dreamweaver vs FrontPage
There are two major WYSIWYG(What You See Is What You... Read More
Chinese Input - Step by Step Instruction on How to Input Chinese Characters in English Windows XP
Enabling Chinese input is quick and easy, there are only... Read More
Microsoft CRM Integration With Microsoft Office Documents ? Overview For System Integrator
Microsoft CRM is CRM application, maintained and supported by Microsoft... Read More
Microsoft Great Plains: Offshore Customization & Development ? Overview for Consultant
When you visit department stores and see that majority of... Read More
Basic Tips and tricks for Windows XP
Running Applications in Compatibility Mode With Windows XP, you can... Read More
MCP Market News: Microsoft SQL Server & SQL Reporting Services
Are you ready? SQL Server 2005, the next-generation data management... Read More
Adware and Spyware Blockers
The most important things you can do for your computer... Read More
When is a Software Engineer Not a Software Engineer?
The title of "software engineer" has got to be among... Read More
Benefits of Integrating Online Chat Software with CRM
Customer Relationship Management (CRM) is a strategy and processes used... Read More
Spyware: What It Is and How to Combat It
Spyware is software or hardware installed on a computer without... Read More
Great Plains Custom Development: Dexterity, VBA, SQL, Crystal, eConnect ? Overview For Programmer
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
Groupware: What Works the Way Businesses Do?
GroupwareThe internet is full of 1.5 million to 7 million... Read More
Is Your Family Protected?
When you think... Read More
Microsoft Great Plains - Typical Problems And Fixes ? Overview For IT Administrators
How to delete the user? This is the first problem... Read More
Microsoft Great Plains - Microsoft RMS Integration ? overview
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
A Symons Mark II Function Point Counting Example
I provide, here clear explanations and a count of function... Read More
Industry Experts Answer the One Million-dollar Question - Why Genie Backup Manager?
Many reasons made GBM a unanimous choice for experts, one... Read More
Microsoft CRM ? Consulting in the Post-Recession Time
New post-recession era has new features, which didn't exist in... Read More
Microsoft Great Plains implementation: Restaurants Supply Chain Management Example
Microsoft Great Plains serves majority of US based horizontal and... Read More
Pros and Cons of Using FREE Software in Your Business
Itâ??s easy to understand why you might be drawn to... Read More
Business Planning Software
Once a business idea is selected, it is highly recommended... Read More
Begun, The Browser Wars Have
As Mozilla Firefox nears 10% market share, with well over... Read More
The Death of Windows
I have always regretted how Microsoft price gouges and rips... Read More
Computer Phones ? Facts and Fallacies
The stakes are high when considering security, privacy, and savings,... Read More
SQL Administrator Skills Required to Support Microsoft Great Plains
Microsoft Great Plains is becoming more and more popular and... Read More
Introduction To ISDN, Part II
In the previous ISDN article, we looked at how and... Read More
Examining the Substance of Studio MX
To all web designers out there, this article is for... Read More
Simple Solution for Php Includes - IFrames
I have recently created my first Php program. I wanted... Read More
Software |