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: http://www.albaspectrum.com
limo prices to midway Crystal Lake west of Randal .. Lockport Chicago limo O’HareWhat is Tripwire?Tripwire is a form intrusion detection system (IDS)... Read More
Find out why Spyware Removal from computers is important and... Read More
Currently Microsoft Business Solutions is on the way of creating... Read More
The destruction of the Soviet Union about 15 years ago,... Read More
Microsoft PowerPoint has dramatically changed the way in which academic... Read More
You might think you don't need a firewall... Read More
One day, you suddenly realize that your computer started to... Read More
Table of Contents1) Introduction 2) Related Work 3) Framework 4)... Read More
Microsoft Business Solutions CRM is web-based CRM application, deploying all... Read More
Microsoft CRM is CRM answer from Microsoft Business Solutions.The whole... Read More
If you feel intimidated when someone tries to teach you... Read More
Remember nice and prosperous Clinton era? When you implemented innovative... Read More
Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average"... Read More
One of the things we can be as certain of... Read More
Once upon a time not so long ago, there was... Read More
Just imagine: you are walking, say, towards your car, and... Read More
TCO (Total Cost Ownership) is the buzzword in... Read More
The research in the field of Natural Language Processing usually... Read More
If someone entered your home, uninvited and installed numerous cameras... Read More
Microsoft Business Solutions Great Plains is very generic accounting application... Read More
If you've been using MySQL database to store your important... Read More
Viruses and spyware usually show up on your computer one... Read More
We would like to give you pluses and minuses of... Read More
In this short FAQ style article we would like to... Read More
This is the tutorial where we really get into programming.... Read More
taxi o'hare Auburn ..Following tips help you to learn a software in lesser... Read More
Looks like Microsoft Great Plains becomes more... Read More
The java programming language is becoming more and more popular... Read More
Former Great Plains Software Dynamics/eEnterprise, and currently Microsoft Business Solutions... Read More
Just the thought of a duel-boot scares many people away,... Read More
Now is the time to look at an alternative to... Read More
Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More
Before being able to choose a secure Internet communication system,... Read More
When reading an article where some term is used often,... Read More
Adobe Photoshop is one of the world's leading graphics editing... Read More
IntroductionPHP can be used for a lot of different things,... Read More
2005 ? Back to the Future.What does the future hold?... Read More
A few months back I really got sick of my... Read More
This article is for advanced Microsoft CRM SDK C# developers.... Read More
In the Clinton era the status quo was simple: you... Read More
C/SIDE (Client/Server Integrated Development Environment) - The core of... Read More
Microsoft Business Solutions Navision is main ERP application for European,... Read More
GroupwareThe internet is full of 1.5 million to 7 million... Read More
When Great Plains Software was designing and developing Great Plains... Read More
In the real world a "fire wall" is a fireproof... Read More
Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More
Linux essentials:It's free for download but you have to pay... Read More
The intuitive algorithm.Roger Penrose considered it impossible. Thinking could never... Read More
All of us know that Microsoft bought former Great Plains... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Software |