Microsoft CRM Integration with Microsoft Retail Management System (RMS) ? Overview

Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS are both Microsoft SQL Server based applications, however historically Microsoft was purchasing industry leading software applications, such as QuickSell which is now Microsoft RMS. So, RMS design fundamentals were minted a long time before Microsoft CRM. But, still integration between the two is straightforward and what you need is consultant, who is familiar with both systems structures and customization scenarios. Microsoft CRM is currently integrated with Microsoft Great Plains and will be integrated with Microsoft Navision in the close future, RMS integration is not planned to our knowledge, so you should seek third party solutions or create your own integration. We see the need for such the integration when you sell on account in RMS and have customer support call center automated with Microsoft CRM. Let us give you highlights:

? Microsoft CRM custom lookup. More likely you will nee lookup to your RMS headquarters or store records for the customer transactions from Account screen. Microsoft CRM allows you to have custom navigation bar on Account screen by clicking on this bar you could call your custom web .Net application, which will call Microsoft RMS database and return you the grid of customer transactions

? RMS architecture excurse. Microsoft RMS has Headquarters and Store databases. The exchange between the two types of databases uses worksheet mechanism. Most of the transaction types are initiated on the store level and transferred to the Headquarters database (with some global data exception, global customers for example are handled on HQ level and then propagated down to the stores).

? Data Inquiry and Update. The MS RMS architecture suggests you to query primarily Headquarters database and do not change data in HQ database. If you need to change data on the store level from Microsoft CRM custom screen ? you should consider placing web service on the SQL Server hardware in the store to deal with the store-initiated transaction

? Microsoft CRM programming. Microsoft CRM has MS CRM SDK (Software Development Kit). This is open source tool, you can download it from Microsoft site and it is description of Microsoft CRM classes and methods with sample codes in C# and VB.Net. Microsoft technical support encourages you to use Microsoft CRM SDK objects and discourages you from direct SQL server programming. If you need to query MS CRM database ? you should create your custom database and place your objects: SQL views and stored procedures there. Do not place custom object into MS CRM databases Do your homework in 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 1-866-528-0577! 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


Microsoft Blues

With the advent of 'Service Pack 2' for Windows XP... Read More

Partitioning, Formatting and Reinstalling in Windows 98

Formatting and reinstalling windows 98 is very easy if you... Read More

Editing Your Photos Using Microsoft Picture It Publishing Platinum 2002 - A Great Dinosaur

I started using PIP (Picture It Publishing) Platinum 2002 right... Read More

Cisco Certification: Introduction To ISDN, Part III

Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More

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

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

The Truth: Netzero 3G

We've all seen the ads on TV for Netzero 3G.... Read More

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

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

The Secret of the Layer Styles Dialogue

When you double-click a layer in the Layer Palette, you... Read More

How to Tell You Have Spyware, Ad-ware or Viruses

Usually, the easiest way to tell you have spyware is... Read More

Microsoft Great Plains Dynamics on Pervasive SQL.2000 Data Repair ? Overview For DBAs

Some introduction into Great Plains Software products, now Microsoft Business... Read More

What is Preventive Maintenance Software?

Preventive Maintenance (PM) is defined as scheduled work done on... Read More

Intro to UNIX Shells

A UNIX Shell is in simplest terms, a command line... Read More

Ukraine: a Prospective Player on the World Software Outsourcing Market

The destruction of the Soviet Union about 15 years ago,... Read More

Is Your Family Protected?

When you think... Read More

Scrap Booking Online: Word Perfect or Corel Graphics Suite?

Scrapbooks are very popular these days. I think that almost... Read More

What to Do if All Screensavers Fun is Grayed Out?

Finally, you have some time to personalize your desktop with... Read More

Microsoft Great Plains Partner Selection: Overview

Microsoft Great Plains, Navision, Solomon and Axapta are Microsoft Business... Read More

MSN Messenger Is A Sweet Way To Communicate

MSN messenger is a pretty cool invention. I mean I'm... Read More

The Truth about Colossus: Are You Just A Magnetic Image?

What is Colossus?Colossus is software licensed to about twenty-five insurance... Read More

How to Backup Windows XP Home Edition

Your computer cost you from hundreds to thousands of dollars,... Read More

Microsoft Great Plains Integrations ? Retail Management Sample

Microsoft Business Solutions is emerging as very attractive vendor for... Read More

Linux Secrets

The first thing that you will notice about Linux Red... Read More

Microsoft CRM Customization: Integration with Third Party SQL Application/Database

Microsoft CRM ? Client Relationship Management package from Microsoft Business... Read More

Reporting for Microsoft Great Plains/Dynamics/eEnterprise: RW ? ReportWriter ? Tips for Developer

Microsoft Business Solutions Great Plains is written in Great Plains... Read More

Crystal Reports - Geterogeneus databases: SQL Server, Oracle, Unidata, Btrieve ? Tips For Developer

Crystal Reports is the most flexible tool on the market... Read More

OSI Layers Model

IntroductionDuring the early years of our modern computer era, very... Read More

15 Questions to Ask Your Software Vendor

When making a decision to buy any piece of software... Read More

Great Plains Dexterity Programming ? Overview For Developer

Looks like Microsoft Great Plains becomes more and more popular,... Read More

SSH (SCP) Send Files from Windows to Your Linux Box

Not all of us have the luxury of working both... Read More

Collaboration Software: Index of Collaboration Software Technologies

Collaboration SoftwareCollaboration Software, also known as group collaboration software or... Read More

Defining OLAP Solutions and Data Warehouse design

This tutorial covers OLAP solutions used by Data warehouses and... Read More

Top Questions to Ask Before Buying a Help Desk & Asset Management Software

#5 All your hardware components like Printers, PCs etc come... Read More

Outlook... Not Just for Email! Using Your Outlook Calendar

Microsoft Outlook is one of the most widely used software... Read More