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
experienced cleaning professionals Northbrook ..When you double-click a layer in the Layer Palette, you... Read More
There are plenty of articles out there about how to... Read More
If someone entered your home, uninvited and installed numerous cameras... Read More
Follow the steps below to quickly design, generate, and deploy... Read More
Many Webmasters have never bothered to view their website's server... Read More
Pirated software is on the increase and now accounts for... Read More
Microsoft Business Solutions CRM is web-based CRM application, deploying all... Read More
There are several kinds of software piracy. The bottom line... Read More
For those who still don't know, Microsoft Publisher helps computer... Read More
Usually, the easiest way to tell you have spyware is... Read More
If you are in a business that passes documents around... Read More
Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More
When Windows fails to boot it is normally caused by... Read More
First we had the original Google search that evolved into... Read More
People often ask me: What image file formats will Photoshop... Read More
Microsoft Business Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM... Read More
Mapping Software Improves Data VisualizationFrom the outset, it is important... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Lotus Notes Domino is very efficient in electronic document workflow... Read More
(1) Avoid using the same variable again and again for... Read More
Mike Dunville* had a decision to make. As the new... Read More
Spyware, what it is and what it does. Basically, spyware... Read More
Ad-Aware and Spybot are probably the two most well known... Read More
The intentions of this short tutorial are not to teach... Read More
Microsoft Great Plains might be considered as ERP platform to... Read More
best value cleaning service Northbrook ..2005 ? Back to the Future.What does the future hold?... Read More
We all take the computer for granted. I mean, all... Read More
... Read More
ERP Consulting industry is on the way to serve clients... Read More
Some introduction into Great Plains Software products, now Microsoft Business... Read More
In this short FAQ style article we would like to... Read More
Remember back in the days where screensavers were the coolest... Read More
The most important benefit of XML is its simplicity. Though... Read More
Microsoft Great Plains is now targeting large and midsize businesses... Read More
You would like to protect your documents, wouldn't you? Reasons... Read More
It would be easy to think, like most people apparently... Read More
Microsoft Great Plains ? ERM from Microsoft Business Solutions and... Read More
eStore Advantage allows front-office applications to communicate with back-office business... Read More
In 2004 Oracle, Inc. made its new step toward J2EE... Read More
Microsoft Business Solutions Great Plains has many years of successful... Read More
Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More
Microsoft Great Plains is now standard mid-market ERP application, serving... Read More
Should one use Windows Update?This topic has good and valid... Read More
The stakes are high when considering security, privacy, and savings,... Read More
The cornerstone of successful automated office systems is the ability... Read More
Microsoft has never released a service pack for Windows98 SE,... Read More
When you first think about multicurrency ? you probably have... Read More
While several preventive maintenance software manufacturers offer free trials for... Read More
It's all about turn times in the eMedia industry! The... Read More
OEComplete is a utility for managing the personal information of... Read More
| Software |