123ArticleOnline Logo
Welcome to 123ArticleOnline.com!
ALL >> Computer-Programming >> View Article

Microsoft Retail Management System (rms) Sql Customization -

Profile Picture
By Author: Andrew Karasev
Total Articles: 27
Comment this article
Facebook ShareTwitter ShareGoogle+ ShareTwitter Share

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


ABOUT THE AUTHOR


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: andrewk@albaspectrum.com

Total Views: 339Word Count: 544See All articles From Author

Add Comment

Computer Programming Articles

1. How Digital Publishing Solutions Improve Content Distribution?
Author: tribotz

2. The Evolution And Relevance Of Ibm I (as/400, Iseries) In Modern Business
Author: Siddhant Saxena

3. Ai Software Development Services In Japan: Shaping The Future Of Technology
Author: jagpreet

4. Predictive Maintenance Market Set To Surge To $79.1 Billion By 2032
Author: Rutuja kadam

5. Why Every Business Needs A Custom Mobile App In The Digital Age
Author: Miachael Williams

6. Building A Strong Foundation: Beginner Programming Courses For Young Learners
Author: stem-xpert

7. How Web Design Chicago Is Revolutionizing The User Experience For Businesses
Author: Tim Harrison

8. Best It Courses | Which Course In It Is Best?
Author: Kodestree

9. Uv Stabilizers Market Poised To Hit $1.90 Billion By 2032: Growth Trends & Insights
Author: Rutuja Kadam

10. The Ultimate Guide To Choosing The Best Cross-platform App Development Company For Your Business Success
Author: Siddharth

11. Stand-up Pouches Market To Be Worth $52.1 Billion By 2032
Author: Rutuja Kadam

12. Top Full Stack Development Services For Web And Mobile Apps In 2025
Author: jonathan

13. Revolutionize Your Online Presence With Cutting-edge Web Development!
Author: Hitvanshi

14. Top 10 Ibm I Service Providers Right Now
Author: Siddhant Saxena

15. How Mobile Applications Helps Local Businesses Grow?
Author: Ritesh Sharma

Login To Account
Login Email:
Password:
Forgot Password?
New User?
Sign Up Newsletter
Email Address: