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
![]() |
|
![]() |
|
![]() |
|
![]() |
OEComplete is a utility for managing the personal information of... Read More
(1) Avoid using the same variable again and again for... Read More
The vast majority of us will have, at some point,... Read More
Microsoft Great Plains serves the wide spectrum of horizontal markets.... Read More
Manufacturing in the USA is far away down from mid... Read More
It is possible that if one avoided all sources of... Read More
When it comes to running an office, the SOHO entrepreneur... Read More
Microsoft CRM is new player on the CRM software... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
When you first think about multicurrency ? you probably have... Read More
Domino server is a buffer between the operation system and... Read More
It's not very often I get excited about a software... Read More
1. Replace Dexterity cursor with SQL Stored Procedure Dexterity... Read More
Document Manager and Version HistoryIn previous articles I have discussed... Read More
Bill of Lading is required report for Logistics and Freight... Read More
Microsoft Business Solutions Great Plains was historically designed to serve... Read More
Microsoft Business Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM... Read More
We were recently faced with a decision: either to let... Read More
Intro This concise article will tell you in plain English... Read More
Traditionally we were considering functionally rich systems, such as SAP,... Read More
When you own a small business, time is money. And... Read More
Let's say that you have a software project that's under... Read More
It won't matter how effective your WinRunner Team is if... Read More
Siebel is traditional CRM market leader, however and mostly due... Read More
I like my software simple. If it's too complex or... Read More
Microsoft Business Solutions CRM is now approaching the phase of... Read More
While Ukraine is becoming a new popular IT outsourcing destination,... Read More
Hi, Guys,I believe a lot of programmers are trying to... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Microsoft CRM is CRM answer from Microsoft and attempt to... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
Crystal Reports is the most flexible tool on the market... Read More
The major reason I recommend getting your hands on real... Read More
Pirated software is on the increase and now accounts for... Read More
Microsoft Great Plains is main mid-market application from Microsoft Business... Read More
I have always had a tendency to focus on the... Read More
Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on... Read More
IntroductionDuring the early years of our modern computer era, very... Read More
Every organization which creates collaborative documents, whether they are budgets,... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
In order to meet regulatory and corporate compliance requirements reporting... Read More
How many steps does it take you to locate and... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
If you have Microsoft Great Plains and support it... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Microsoft CRM is now on the scene and it is... Read More
Microsoft Business Solutions products: Great Plains, MS CRM, Navision, Axapta,... Read More
Rapid Application Development (RAD) is a software development methodology. In... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
With this small article we are continuing Microsoft Business Solutions... Read More
A UNIX Shell is in simplest terms, a command line... Read More
Microsoft Business Solutions Small Business Manager is Great Plains Dexterity... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
Microsoft Business Solutions Great Plains was historically designed to serve... Read More
Just stress testing one of the latest Linux distributions. Been... Read More
There are plenty of articles out there about how to... Read More
With thousands of web pages added to the Net every... Read More
The Internet is reshaping every form of communications medium, and... Read More
We would like first emphasize the change in the paradigm.... Read More
If you have Microsoft Great Plains and support it for... Read More
.NET platform does not support multiple inheritance. Do not confuse... Read More
One of the main reasons business owners and entrepreneurs use... Read More
Hey Guys! Don't raise your eyebrows or fear by hearing... Read More
When Great Plains Software was designing and developing Great Plains... Read More
Three highly respected names in Human Resources have joined forces... Read More
It's all about turn times in the eMedia industry! The... Read More
Software |