Software Information |
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: andrewk@albaspectrum.com
MORE RESOURCES: Unable to open RSS Feed $XMLfilename with error HTTP ERROR: 404, exiting |
RELATED ARTICLES
Corel WordPerfect 7 Macro Programming Example Case study:A secretary using Corel WordPerfect 7 is often required to carry out calculations and insert the values into invoices or other documents.She does this by entering calculations into either a real calculator and transcribing the answer, or the Microsoft calculator and copying then pasting the result into the document. Dig Out That Worm Internet worms.Is your PC infected?If your computer has become infected with a worm, don't panic, it is not the end of the world. Monitoring Software Can be Used for Spying as Well We all already got used to computer monitoring both at work and at home. We got used to advertising monitoring software products as tools for parental control and workplace surveillance. Five Reasons for Using an O/R Mapping Tool So, why should you use any O/R mapping tool? I am not talking about a specific tool but rather all O/R mapping tools in general. There are a number of reasons for using an O/R mapping tool but before I dive into that, let me give you a brief overview of what an O/R mapping tool really is. Lotus Domino Implementation and Development: Infrastructure - Present and Future Domino server is a buffer between the operation system and the application. On the other hand Domino server - consists of the services which support development processing and executing of dynamic, secure applications for Internet, Intranet, or Extranet. Linux for Home Users Hey Guys! Don't raise your eyebrows or fear by hearing the word Linux. It is as user friendly as windows. Microsoft CRM - Typical Customizations Microsoft CRM was designed to be easily customizable. Microsoft CRM Software Development Kit (MS CRM SDK) which you can download from Microsoft website contains descriptions of the objects or classes, exposed for customization. Microsoft CRM Implementation - Fundamental CRM Principles Revision Microsoft CRM is relatively new player on the now becoming traditional CRM software applications market. We would like just to mention shift in the technical conception - Microsoft CRM is committed to Windows and Microsoft components: Exchange, Active Directory, SQL Server, etc (while traditional CRM applications, such as Siebel were biased toward multiplatform compatibility: Unix, Oracle, Windows, SQL Server) and move up to business logic paradigm shift. Microsoft Great Plains international implementation - USA / Mexico - overview for consultant Microsoft Business Solutions Great Plains was purchased from Great Plains Software and Great Plains Software itself had strong international marketing plans and campaigns. If we look back to 1990th - we'll see that GPS had Multilanguage support and Great Plains Dynamics / Dynamics C/S+ was localized and translated into multiple languages, including Spanish. Introducing GRML Creating a new markup language.Introduction. Behave, Word, Behave! If you copy something from a Web site or elsewhere.. Linux Vs. Windows This article will not attempt to advocate the use of Linux over Windows or vice versa. I will try to present the differences and similarities between Linux and Windows in a fair manner. RFID: Strengthen the Position for SAP; United States SAP Inc., a global leader in client/server enterprise application software that for years been the backbone to RFID application has seen a 1,000% spike year-over-year in customers, interested in RFID deployment. What is Spyware? Are You Being Watched? Find out why Spyware Removal from computers is important and how adware infestations affect your computer, your privacy and your family.Internet users worldwide spend several hours to several days each week browsing or searching the net. Microsoft Great Plains Oil & Gas - Implementation & Customization Highlights Microsoft Great Plains serves the wide spectrum of horizontal markets. Great Plains could be considered as ERP platform, which you could expand with third party modules or advance with your own in-house custom functionality. Microsoft Business Solutions - Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL Microsoft bought Navision, Denmark based software development company, along with Great Plains Software. Now Microsoft Business Solutions offers following ERP applications: Navision (former Navision Attain), Microsoft Great Plains (former Great Plains Dynamics/eEnterprise), Solomon, Axapta. Software Review: Xsitepro Total Site Management Software It's not very often I get excited about a software program, but today I'm so excited I just had to tell you about Xsitepro, the top tool for Internet marketers. In particular, those who have been using HTML applications programs like Dreamweaver and Frontpage to produce their Internet media will find this program revolutionary in that it can at least halve your time for site development. Software For Your Hard-Drive All your software is stored on a hard-drive. But how about software FOR your hard-drive - private disks, partition managers, disk defragmenters? Here is the scoop on the latest tools. Professional Software Icons For Your Standalone Application User interfaces and accessibility are some of the most important aspect of an application. It can have a million features, it can do a thousand things once, but if it doesn't look quite right then it will be a disaster. Microsoft Great Plains IV: Inventory Management Great Plains Inventory Management (IV) module gives your business a competitive edge. By achieving accurate visibility and effective control over inventory, and setting prices on a customer-by-customer basis, you can reduce operating costs and achieve the fast, efficient fulfillment that keeps customers coming back. |
home | site map | contact us |