Home
>
Software
>
Microsoft Retail Management System (RMS) SQL Customization ? Overview for Programmer

Microsoft Retail Management System (RMS) SQL Customization ? Overview for Programmer

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

Willow Springs limo O'Hare .. Lockport Chicago limo O’Hare

In The News:

Tech expert Kurt “CyberGuy" Knutsson discusses how robots can milk, feed and clean cows on dairy farms, boosting efficiency and comfort.

Tech expert Kurt “CyberGuy" Knutsson says quantum internet ensures unhackable security and redefines online privacy and speed.

Kawasaki's CORLEO is a hydrogen-powered, AI-driven rideable robot. Tech expert Kurt “CyberGuy" Knutsson reports on this new way of thinking about off-road transportation.

The CyberGuy breaks down five mobile privacy terms that could make a difference when it comes to keeping your personal information safe.

A groundbreaking robot that's like a real-life Wall-E uses advanced artificial intelligence to replicate natural gestures and deliberate actions with striking accuracy.

If not properly managed, Windows Defender Application Control, a security feature with Windows, could be a potential security vulnerability.

Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.

FlashBot Arm, a semi-humanoid robot, acts more like a human than traditional robots, and you may see it working at a restaurant, healthcare center or hotel.

There are multiple ways to find your missing Android phone after it goes missing. One method involves using a smartwatch to ping your phone.

The NeuroOne OneRF Ablation System is a new device with FDA-cleared technology designed for both diagnosing and treating neurological disorders in one procedure.

The CyberGuy provides tips to protect yourself from criminals who use various methods to make unauthorized transactions using your account information.

New drone technology maps land and water with stunning accuracy, giving researchers and conservationists a new way to understand our planet.

Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.

X hit with massive data breach with 200 million records leaked, including emails. Tech expert Kurt “CyberGuy" Knutsson offers seven tips to help protect yourself.

Atlas robot by Boston Dynamics amazes tech expert Kurt “CyberGuy" Knutsson with its breakdancing moves.

Tech expert Kurt “CyberGuy" Knutsson talks about how Google kept Android SafetyCore details quiet until it scanned users' photos.

Hydrogen trucks debut in Georgia, sparking debates on costs and green freight gains. Kurt “CyberGuy" Knutsson comments on this promising chapter in green logistics evolution.

Tech expert Kurt “CyberGuy" Knutsson says ChatGPT learns from chats, but you should avoid sharing sensitive information to protect your privacy.

Beyond Aero's BYA-1: Hydrogen-electric jet with zero emissions, reduced costs, 2030 launch. Kurt “CyberGuy" Knutsson discusses a potential game changer in the evolution of air travel.

Kurt "CyberGuy" Knutsson explains how you can creatively repurpose your old unused Android devices, which are full of potential and hidden value.

Mech the super-humanoid robot can lift up to 132 pounds and is designed to tackle stressful and repetitive tasks that often lead to workplace injuries.

Double-clicking is something we all do, often without giving it a second thought. But it could be giving hackers permission to do something dangerous.

Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.

Kurt the CyberGuy offers some of his easy expert tips to free up storage space on your Android if your device is running short on storage.

You can reset your internet router remotely if you're not home when your power goes out. Kurt "CyberGuy" Knutsson explains how this can be done.

Microsoft Retail Management System (RMS) SQL Customization ? Overview for Programmer

Software