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

Microsoft Retail Management System serves retail single store as well as retail chains clientele. The customization scenarios, described in this article deal with the chains, when Microsoft RMS has multiple stores databases and Headquarters. Microsoft RMS is SQL Server-based application, so we will consider SQL programming ? SQL queries, views and stored procedures. Also Microsoft RMS could be integrated on the SQL level with other applications, such as Microsoft Great Plains, Microsoft CRM and non-Microsoft applications, such as Lotus Notes/Domino

? Microsoft RMS Architecture and data flow. As it is POS automation application, it assumes that all the POS transactions are originated at the store. The mechanism used is worksheets. When store is closed ? Headquarters pulls its transactions via worksheet. There are some exceptions ? global data, such as global customers are updated on the headquarters level and updates propagated to the stores.

? Data Update. If you need custom logic work with the POS transaction ? you have to update store database data. If you try to update Headquarters database ? the chances are that it will be rolled back by the next worksheet, because original data sits on the store level and is different from your altered data in the HQ

? Store Level Web Services. Yes ? they will enable you to communicate with store database and have transaction data updated over there. The other way is having all the stores as linked servers from Headquarters MS SQL Server Enterprise Manager

? Integration with Great Plains or other SQL Server Accounting package. RMS normally replicates transactions from the stores to Headquarters upon the store business hours close. At this time they are ready to be integrated with such accounting system as Microsoft Great Plains. Here we are talking about custom integration, which you can create as a stored procs set.

? Gift Card puzzle. There are few funny things in MS RMS you should be aware. Imagine ? you issue Gift Certificate. It exists on the Headquarters level and each store knows about the balance on the card. Customer uses card in store A and then walks in to the store B. If worksheet mechanism didn't play during this time interval ? store B gift card balance will show incorrect value. To fix the issue you need to trigger worksheet creation and launch on the headquarter level to replicate new balance to all the stores.

Good luck with customization 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 Microsoft RMS, 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

---

Linux for Home Users

Hey Guys! Don't raise your eyebrows or fear by hearing... Read More

Know-how in Microsoft Publisher

For those who still don't know, Microsoft Publisher helps computer... Read More

Need of Document Management System (DMS)

Document Management or Enterprise Information Management is perhaps one of... Read More

Linux Secrets

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

S is for Spying, Surveillance -- and for Software as Well

Words we choose to describe things and phenomena often show... Read More

Can You Calculate Complex Financial Calculations?

Are you a whiz at calculating financial information? Not the... 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 in Construction & Building ? Implementation & Customization Highlights

Microsoft Great Plains could be tuned and setup to fit... Read More

Microsoft Small Business Manager eCommerce ? Overview

Microsoft Business Solutions Small Business Manager is scaled down Great... Read More

Implementing ERP for Large Publicly Traded Corporation ? Microsoft Great Plains

We would like first emphasize the change in the paradigm.... Read More

Microsoft CRM Customization Secrets ? Second Edition

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

Five Tips For A Great Software Demo

Whether you need to close a sale, gather end-user feedback,... Read More

Mozilla Vs. Firefox

For those who are unclear on the differences between the... Read More

About Microsoft Sysprep (System Preparation) Utility (Windows 2000)

The Microsoft system preparation utility for Windows 2000 is a... Read More

Document Templates Give You The Perfect Framework For Your Documents

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

OS 101: Suggestions for Choosing an Operating System

An operating system (abbreviated OS) is essentially the path through... Read More

Corporate ERP: Microsoft Great Plains For The Plant In Brazil ? Overview For CIO

Microsoft Business Solutions Great Plains as new ERP for multinational... Read More

Microsoft CRM ? Consulting in the Post-Recession Time

New post-recession era has new features, which didn't exist in... Read More

Information Products: A Business Owners Best Friend

We live in a post-industrial age where information is the... Read More

eStore Advantage ? Extending Microsoft eConnect for MBS Great Plains

eStore Advantage allows front-office applications to communicate with back-office business... Read More

How To Avoid Getting Hooked By Pfishing

"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More

Performance Tuning of a Daffodil DB / One$DB -JDBC Application

This article illustrates the best practices to improve the performance... 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

Microsoft CRM Conversation Gateway: VoIP - Implementation & Customization

Microsoft CRM is winning market share step-by-step from such the... Read More

Internet Security Threats: Who Can Read Your Email?

Before being able to choose a secure Internet communication system,... Read More

Microsoft CRM Messaging through Lotus Domino eMail Server - Balanced Solution

Microsoft CRM and IBM Lotus Notes Domino seem to be... 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

The Importance of Timely Timesheets

Whether you are a small consultancy firm, a medium sized... Read More

Microsoft Great Plains Middle East - Arabic Language Support

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

SpyBot - Search and Destroy versus Microsoft AntiSpyware (Beta).... My personal experiences...

Ok... Where to start?Well, I guess I will start at... Read More

Microsoft CRM and No-Frills Cadillacs

In today's business world it's all but impossible to escape... Read More

Unofficial Windows 98 SE Service Pack 2.0 RC2

Microsoft has never released a service pack for Windows98 SE,... Read More

Microsoft Great Plains Upgrade ? Version 8.0 Overview for IT Director/Controller

If you have Microsoft Great Plains as main accounting and... Read More