Software informational articles

Microsoft retail management approach (rms) sql customization ? overview for programmer - software


Microsoft Retail Management Classification serves retail free store as well as retail chains clientele. The customization scenarios, described in this clause deal with the chains, when Microsoft RMS has numerous food databases and Headquarters. Microsoft RMS is SQL Server-based application, so we will be concerned about SQL training - 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 computerization application, it assumes that all the POS transactions are originated at the store. The instrument used is worksheets. When store is bunged - H. Q. pulls its transactions via worksheet. There are some exceptions - large-scale data, such as large-scale customers are rationalized on the command center level and updates propagated to the stores.

? Data Update. If you need custom logic work with the POS transaction - you have to inform store file data. If you try to bring up to date Command center folder - the probability are that it will be rolled back by the next worksheet, since creative data sits on the store level and is another from your distorted data in the HQ

? Store Level Web Services. Yes - they will allow you to commune with store file and have transaction data modernized over there. The other way is having all the food as allied servers from Center of operations MS SQL Ma?tre d'h?tel Endeavor Manager

? Integration with Great Plains or other SQL Ma?tre d' Accounting package. RMS as normal replicates transactions from the provisions to Center of operations upon the store affair hours close. At this time they are ready to be integrated with such accounting coordination as Microsoft Great Plains. Here we are chatting about custom integration, which you can build as a stored procs set.

? Gift Card puzzle. There are few funny clothes in MS RMS you be supposed to be aware. Dream up - you issue Gift Certificate. It exists on the Center of operations level and each store knows about the assess on the card. Consumer uses card in store A and then walks in to the store B. If database apparatus didn't play at some stage in this time hiatus - store B gift card consider will show faulty value. To fix the issue you need to trigger spreadsheet conception and launch on the headquarter level to imitate new assess 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 Know-how Administrator in Alba Spectrum Technologies - USA countrywide Microsoft RMS, Great Plains, Microsoft CRM customization company, allocation clients in Chicago, California, Texas, Florida, New York, Georgia, Arizona, Minnesota, UK, Australia and having locations in compound states and globally ( http://www. albaspectrum. com ), he is CMA, Great Plains Expert Master, Dexterity, SQL, C#. Net, Gem Information and Microsoft CRM SDK developer. You can acquaintance Andrew: andrewk@albaspectrum. com

Developed by:
home | site map © 2018