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
![]() |
|
![]() |
|
![]() |
|
![]() |
Before September 1995, Microsoft Windows was an MS-DOS program. DOS... Read More
Three highly respected names in Human Resources have joined forces... Read More
Introduction to C++Why Learn C++?C++ may at first seem like... Read More
Our hosted solution allow you to run your own search... Read More
Microsoft Great Plains fits to majority of horizontals and retail... Read More
First we had the original Google search that evolved into... Read More
Fortunately one of the most common reasons cited for the... Read More
Introduction To ISDN, Part III: Configuring PPP PAP AuthenticationNow we... Read More
Linux essentials:It's free for download but you have to pay... Read More
With this small article we are continuing Microsoft Business Solutions... Read More
Microsoft Outlook is one of the most widely used software... Read More
Microsoft Great Plains may be recommended for international freight forwarding... Read More
All of us know that Microsoft bought former Great Plains... Read More
Now is the time to look at an alternative to... Read More
We don't think about mainframe software pricing anymore, we just... Read More
Microsoft has never released a service pack for Windows98 SE,... Read More
Microsoft-Outlook is a pretty amazing program. So much more than... Read More
How many steps does it take you to locate and... Read More
Is your PC is slow and wimpy? Then you need... Read More
Need software to record your voice, streaming audio or musical... Read More
The intentions of this short tutorial are not to teach... Read More
As Mozilla Firefox nears 10% market share, with well over... Read More
While Ukraine is becoming a new popular IT outsourcing destination,... Read More
Microsoft Business Solutions CRM data conversion deserves FAQ type of... Read More
Ok... Where to start?Well, I guess I will start at... Read More
In linux, one of great commands for finding out information... Read More
Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM... Read More
Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More
GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More
What is Spyware?Spyware monitors your surfing habits and sends the... Read More
Although statistics often is blamed for various deadly sins --... Read More
TikiWiki is open source software - it is written in... Read More
Microsoft Great Plains is main mid-market application from Microsoft Business... Read More
What is Groupware?Have you ever had to manage document collaboration... Read More
I have recently created my first Php program. I wanted... Read More
Looks like Microsoft Great Plains becomes more... Read More
So, why should you use any O/R mapping tool? I... Read More
C++ Function templates are those functions which can handle different... Read More
This short paper will expand on two key reasons to... Read More
Rapid Application Development (RAD) is a software development methodology. In... Read More
Document Manager and Version HistoryIn previous articles I have discussed... Read More
If you are to buy a HelpDesk & Asset Management... Read More
Microsoft has never released a service pack for Windows98 SE,... Read More
Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More
The Internet is reshaping every form of communications medium, and... Read More
Microsoft Great Plains and Microsoft CRM become more and more... Read More
For those who still don't know, Microsoft Publisher helps computer... Read More
I love new technology. I am still ready to wait... Read More
Let's say that you have a software project that's under... Read More
Should one use Windows Update?This topic has good and valid... Read More
One of the things we can be as certain of... Read More
If your company has regional and worldwide operations, you might... Read More
Microsoft Great Plains serves majority of US based horizontal and... Read More
I have always had a tendency to focus on the... Read More
Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can... Read More
Is Photoshop CS2 worth the upgrade? You bet it is!... Read More
SAP Inc., a global leader in client/server enterprise application software... Read More
Usually workflow & messaging is realized in CRM and then... Read More
... Read More
Follow the steps below to quickly design, generate, and deploy... Read More
We don't think about mainframe software pricing anymore, we just... Read More
MicroWorld Technologies, Inc. the leading solutions provider in the area... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Internet worms. Is your PC infected?If your computer has become... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
Cyberspace has opened up a new frontier with exciting possibilities... Read More
Software |