| Microsoft Retail Management System serves retail | | | | communicate with store database and have |
| single store as well as retail chains clientele. The | | | | transaction data updated over there. The other |
| customization scenarios, described in this article | | | | way is having all the stores as linked servers |
| deal with the chains, when Microsoft RMS has | | | | from Headquarters MS SQL Server Enterprise |
| multiple stores databases and Headquarters. | | | | Managero Integration with Great Plains or other |
| Microsoft RMS is SQL Server-based application, so | | | | SQL Server Accounting package. RMS normally |
| we will consider SQL programming - SQL queries, | | | | replicates transactions from the stores to |
| views and stored procedures. Also Microsoft RMS | | | | Headquarters upon the store business hours close. |
| could be integrated on the SQL level with other | | | | At this time they are ready to be integrated with |
| applications, such as Microsoft Great Plains, | | | | such accounting system as Microsoft Great Plains. |
| Microsoft CRM and non-Microsoft applications, such | | | | Here we are talking about custom integration, |
| as Lotus Notes/Dominoo Microsoft RMS | | | | which you can create as a stored procs set.o Gift |
| Architecture and data flow. As it is POS | | | | Card puzzle. There are few funny things in MS |
| automation application, it assumes that all the POS | | | | RMS you should be aware. Imagine - you issue |
| transactions are originated at the store. The | | | | Gift Certificate. It exists on the Headquarters level |
| mechanism used is worksheets. When store is | | | | and each store knows about the balance on the |
| closed - Headquarters pulls its transactions via | | | | card. Customer uses card in store A and then |
| worksheet. There are some exceptions - global | | | | walks in to the store B. If worksheet mechanism |
| data, such as global customers are updated on | | | | didn't play during this time interval - store B gift |
| the headquarters level and updates propagated to | | | | card balance will show incorrect value. To fix the |
| the stores.o Data Update. If you need custom | | | | issue you need to trigger worksheet creation and |
| logic work with the POS transaction - you have | | | | launch on the headquarter level to replicate new |
| to update store database data. If you try to | | | | balance to all the stores. |
| update Headquarters database - the chances are | | | | Good luck with customization and if you have |
| that it will be rolled back by the next worksheet, | | | | issues or concerns - we are here to help! If you |
| because original data sits on the store level and is | | | | want us to do the job - give us a call |
| different from your altered data in the HQo Store | | | | 1-866-528-0577! |
| Level Web Services. Yes - they will enable you to | | | | |