Microsoft Retail Management System and Crystal Reports

Microsoft Retail Management System (MS RMS), formerly known as QuickSell 2000, is an integrated retail management software designed to help small and medium-sized retailers to automate their business processes. It runs on personal computers and can be used by practically any type of a retail environment: sporting goods, hobby stores, convenience food stores, appliance stores, liquor stores, just to name a few. It can also help manage a number of store and headquarters operations including inventory control, employee management, purchase orders, and sales tracking.

Microsoft RMS uses worksheet technology, wherein updates from Headquarters are deployed to the stores by generating a worksheet with a specified command. The stores, on the other hand, upload data including sales transaction and receipt journals back to Headquarters. These transactions are not generated from Headquarters. It is, therefore, not wise to attempt data integration of such transactions between the two entities (store and headquarters).

Crystal Reports is a report-writing software that can integrate itself to Microsoft RMS database. It goes beyond the report creation process of RMS