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
Alto Pass chicago limos ..CD and DVD replication is a process that works by... Read More
In today's business world it's all but impossible to escape... Read More
It's no secret that software companies operate in a very... Read More
Microsoft Great Plains has substantial mid-market share in the USA... Read More
It???s easy to understand why you might be drawn to... Read More
Accounts payable is just one area of office management where... Read More
Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More
Before being able to choose a secure Internet communication system,... Read More
Adware is a type of Spyware program that displays some... Read More
Sticky Noteshttp://www.deprice.com/stickynote.htmWith StickyNote 9.0, you can create beautiful 3D notes... Read More
The research in the field of Natural Language Processing usually... Read More
Microsoft Business Solutions Great Plains has substantial market share and... Read More
All your software is stored on a hard-drive. But how... Read More
Writing software manuals is boring, isn't it? We often think:... Read More
Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More
Features Additionally, Vista will include many other new features.Aero Vista... Read More
It is now common thing when large corporation selects mid-market... Read More
Microsoft Great Plains ? ERM from Microsoft Business Solutions and... Read More
RSS (Really Simple Syndication) is a way for a site... Read More
Microsoft CRM is winning market share step-by-step from such the... Read More
Now is the time to look at an alternative to... Read More
Lotus Domino/Notes ? Microsoft Great Plains tandem as ERP with... Read More
Words we choose to describe things and phenomena often show... Read More
We all take the computer for granted. I mean, all... Read More
Adobe Photoshop is one of the world's leading graphics editing... Read More
Alto Pass cool limo ..Here is some free software tools to help you build... Read More
If you are in a business that passes documents around... Read More
Finally, you have some time to personalize your desktop with... Read More
The java programming language is becoming more and more popular... Read More
If you copy something from a Web site or elsewhere...... Read More
Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More
The world of small business accounting software can be a... Read More
Midsize business or non-profit organization should decide if one-vendor solution... Read More
We've all seen the ads on TV for Netzero 3G.... Read More
Whether you are an experienced web programmer or a complete... Read More
Preventive Maintenance (PM) is defined as scheduled work done on... Read More
Have you ever noticed that when you look at your... Read More
The intentions of this short tutorial are not to teach... Read More
ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More
How many steps does it take you to locate and... Read More
MSN messenger is a pretty cool invention. I mean I'm... Read More
Small can be beautiful! Working with Knoppix for the past... Read More
We all already got used to computer monitoring both at... Read More
In this small article we will show you the possible... Read More
You might think you don't need a firewall... Read More
This short paper will expand on two key reasons to... Read More
SOFTWARE PIRACY We regularly hear reports... Read More
IBM Lotus Domino or Microsoft Exchange?The severe competition continues for... Read More
Microsoft Business Solutions Great Plains and MS CRM (client relation... Read More
Microsoft Retail Management System serves retail single store as well... Read More
Software |