Projects

The Microsoft Dynamics - RMS is one of Mindfire's new and unique strength in providing retail level Solutions. Mindfire has deep experience in creating ADD-IN and custom application development with MS-RMS. We describe some of these project experiences below, and will be glad to share our expertise in detail with you.

  • POS Addin
  • Loyalty Bonus Pointer
  • Document Imprinter AddIn
  • Cheque Imprinter AddIn
  • Gift Receipt AddIn
  • Customer Data Flow
  • RMS Gas Pump Add-In
  • Discount Add-In
  • Liquor Connect Purchase Order Add-In
  • Discount Schedule
  • RMS Loyalty Add-In
  • Coupon Wizard
  • Receipt Generator
  • epos API Project
  • Plugin for Age Verification
  • Points Redeem


POS Addin

Client:
Software Service Provider
Industry:
Retail Management
Technologies:
VB.Net, SQL Server2005, Microsoft Retail Management System (MS RMS) & Crystal Report 9.0

The primary aim of the project is to serve as an Add-in to the MS RMS 2.0. This addin was responsible for handling the Transactions at the Point of Sale counters (POS).

The addin generated customized reports based on the daily sales. The addin was launched from a button in POS systems. It caputured all the data during the transactions at POS counters and generated reports like Item Status report, Profit Margin report.

It also generated Gift Certificates. Reports were generated on the basis of the transaction number selected. The addin was also reponsible for updating calculated data to the MS RMS Database..


Loyalty Bonus Pointer

Client:
Software Service Provider
Industry:
Retail Management
Technologies:
VB.Net, SQL Server2005, Microsoft Retail Management System (MS RMS) & Crystal Report 8.5

The Primary aim of this add-in was to help the store in implementing a bonus point system and provide discount on the basis of the points earned by the customer on purchasing specific items in specific categories over a period of time from the store.

While tendering, the user selects a customer from the list. This displays the complete information about the customer on the POS Screen's HTML header and with each purchase it adds/removes bonus points. The Configuration section allowed changing the bonus point settings like the number of bonus points one earns on a certain item and amount of purchase, the threshold for bonus point etc. Various levels are set for the bonus points by the store manager. Once a particular customer reaches the threshold point the

POS store manager is notified about it while tendering and if the customer wants to avail the points then discount is provided on subsequent purchases accordingly and the points are redeemed accordingly.


Document Imprinter AddIn

Client:
Software Service Provider
Industry:
Professional Services Industries
Technologies:
VB.NET (VS 2003), SQL 2005

The project deals with creating a custom button on the POS screen and imprint the transaction information on the document. When the imprint button is clicked the current transaction information such as Cashier Number, Date and Time, Register Number, Store Id, Extended Price and Item description is imprinted on the legal document. Each document corresponds to a line on the transaction. Imprinter is an Epson TM-U295 set up as a Windows printer.


Cheque Imprinter AddIn

Client:
Software Service Provider
Industry:
Professional Services Industries
Technologies:
VB.NET (VS 2003), SQL 2005

The project deals with opening a cheque input form with the ability to have unlimited number of cheque values entered via a custom POS button. When a cheque value is entered then the current Cashier ID /Date and Time /Register number/Store ID/Transaction number/Tender Type/Amount etc are imprinted on a document. If cursor is on the field then it imprints that line.  If the cursor is on an empty field, it imprints the line above. At the bottom of the form the cheque totals and remaining tender amount is displayed. On closing this form and opening the tender screen the cheque total amount is displayed against the cheque tender type. The user can edit or delete the cheque amounts. We have used the concept of invoking COM components from hooks to set the tender entry value for a particular transaction in a custom table in RMS database.


Gift Receipt AddIn

Client:
Software Service Provider
Industry:
Retail Trade Industry
Technologies:
VB.NET (VS 2003), SQL 2005

This project involves in creating and printing a gift receipt after tendering a sale. A custom POS button is created which open up a form to display the lookup code, description, quantity and price given a transaction number. User has the option to print all the items in a single receipt or each item in a different receipt for a particular transaction. Gift receipt looks exactly the same as the original sales receipt minus the pricing and sales totals. The printer used is Epson TM T 88IV.


Customer Data Flow

Client:
Software Service Provider
Industry:
Professional Services Industries
Technologies:
VB 6.0, SQL 2005

This application is designed to create and update data in the customer table of the RMS database. A custom form is made in VB 6.0 as an addin to the RMS POS screen and user is able to add new customers and edit existing customers. The same form opens up while clicking on F12 to open the tender screen using the begin-tender hook concept.
The next phase of this project involves around creating daily activity reports regarding the transaction details depending on customers.


RMS Gas Pump Add-In

Client:
Software Service Provider
Industry:
Retail Management
Technologies:
VB.NET (VS 2003), SQL 2005, MS RMS ,RMS GPI software

The sole purpose of this application is to create an interface as a POS Add-in to establish a link between RMS POS and RMS GPI Software application. The gas pump sale done through RMS GPI application are processed by reading and parsing the various text files generated by GPI. The GPI data is populated in the Custom POS Add-In form and when these gas sale transactions are tendered creates appropriate response file to update RMS database as well as RMS GPI. Application is implemented to handle stacking and non-stacking sales, pre-paid sales etc. Customized RMS reports are also being created to show the gas sales at different pumps in multiple tills.


Discount Add-In

Client:
Software Service Provider
Industry:
Retail Management
Technologies:
C#.NET (VS 2003), SQL 2005, MS RMS

The main purpose of the Add-In is to provide functionality to apply discounts on selected items for specific period of time. Depending on different search criteria such as description, department, category, item lookup code etc the application searches for items in the RMS database and displays the search result items in a grid. Users can then select items, discount name, start date and end date for applying the discounts within a particular date range of the selected items.

A windows service is developed which runs at a particular time in the day that is set through the application and updates the items with the discounts set. When the date range is elapsed the discounts are re-set in the database again. The windows service is re-started programmatically every time a change is made to the process that sets the discount time from within the application. Reports have been implemented and output produced as CSV files. These reports can be used by store manager / staffs to check the current and future discounts that are applied on items.


Liquor Connect Purchase Order Add-In

Client:
RMS Solution Provider
Industry:
Retail Industry
Technologies:
VB.NET, SQL 2005, MS RMS 2.0

The primary goal of the Add-In was to enable the Integration to Liquor Connect. We provided the gateway through the Add-In to connect to liquor connect and provide the ability to make a purchase order right from within the point of sale system.
This application is designed to create a Purchase order module for specially customized for liquor retailers. The add-in will allow users to create purchase orders based on manual entry or restocking information from RMS database, edit / delete / print purchase orders. Users can generate order according to specific format and also import orders from external text files to the RMS database. The add-in is also responsible for receiving and committing entries purchase orders upon delivery.


Discount Schedule

Client:
Software Service Provider
Industry:
Retail Industry
Technologies:
C#.NET (VS 2003), SQL 2005 , MS RMS  2.0

The application searches for items in the RMS database depending on different search criteria such as description, department, category, item lookup code etc and displays the search result items in a grid. Users can then select items, discount name, start date and end date for applying the discounts within a particular range to the selected items.
A windows service is developed which runs at a particular time in the day that is set through the application and updates the items with the discounts. After the date range elapsed the discounts are re-set in the database. The windows service is re-started programmatically every time a change is made to the process settings time from the application.
User can create reports as CSV files to check the current and future discounts applied on items.


RMS Loyalty Add-In

Client:
Software Service Provider for Retail Stores
Industry:
Retail and Online & Mobile Payment and Transaction Processing
Technologies:
VB.NET (VS 2008), SQL 2005 ,MS RMS 2.0

The project involves integrating Clients proprietary web services to RMS custom add-in. The add-in uses Clients proprietary web services reader and Clients proprietary web services tags to read the loyalty points, coupons and pre-paid amount associated with each tag assigned to customer and apply the discounts by redeeming those on purchase.



The add-in calls the methods of Clients proprietary web services to accumulate points and redeem points on any purchases. Appropriate discounts and free items are added to transactions and the same is also reflected in the RMS receipt.



There is a settings form which has the information regarding Clients proprietary web services customers terminals. Code is implemented to have only manager the required permission to edit the settings.


Coupon Wizard

Client:
Software Service Provider
Industry:
Retail Industry
Technologies:
VB.NET (VS 2008) , SQL 2005 Express , MS RMS 2.0

The purpose of coupon wizard utility is to check for each transaction and validate against certain parameters to qualify for a coupon generation. The coupon has  an expiry date and serial number and that must be validated while redeeming coupons in the store. At each transaction the sale amount is checked and if its greater than equal to a minimum threshold defined in the settings then a coupon receipt is generated.

The application involves creating vouchers and printing them on tender and coupon redeem. Also it has a reprint option which allows cashier to print the coupons even after a certain time delay.


Receipt Generator

Client:
Software Service Provider
Industry:
Retail Industry
Technologies:
VB.NET (VS 2008) , SQL 2005 Express , MS RMS 2.0

This project involves printing and emailing the PDF versions of receipts as attachments to the selected customer after tendering a sale.
A custom POS button was created which opens up a form and allows the User to set the email credentials on which the PDF version of the receipt is to be emailed.
This application provides the user with three options to either Print or Email or both Print and Email the receipts generated after the tender has been made for the transactions.
There are two Printers that were used for this purpose:  Epson TM T 88IV, Custom PDF Writer.

On tendering the Transaction it opens up a form with the three options such as Print, Email, Print & Email for the user to select. On click of the Print button it Prints the Receipt in both the Printers, generates the PDF version  automatically for the Receipt and keeps it in a particular folder location. On click of the Email button this opens up a form to send the Email to the selected Customer.
On click of the Print & Email button Prints the Receipt in both the printers, generates the PDF document automatically for the Receipt and keeps it in a particular folder and a form opens up to send the Email to the selected Customer. On click of SendMail button will send Email to the Customer with the attached PDF version of the receipt created.

The user will also have the option to update the Email address of the Customer on Send mail form. The copy of Receipts for the transactions made are kept in Journal for Reprinting purpose.


epos API Project

Client:
IT Service Provider
Industry:
Retail Trade Industry
Technologies:
VS 2010,MiS SQL 2008,C#.Net,WCF,Linq to SQL

This project involves creating the web service APIs using WCF. It is all about the system, where an epos system is present at the client side/counter that can read a card data or bar code. At the point of sale, this card/barcode is presented by the consumer which is read by the epos system.That client system capture the consumer's identity from the data read and is rewarded by discounts based on their previous purchases and also by any special offers valid at that time.This project includes a number of WCF operations which includes returning list of available vouchers for the customer card, Add funds to customer prepay account, Perform a refund of a previous pre-pay deposit using the given Customer Card,Redeem funds from the customer's pre-pay balance to pay for the basket's value,Perform a refund of a previous pre-pay redemption using the given customer Card and amount to refund etc. These APIs as developed would then be consumed by a separate RMS Add On being developed.


Plugin for Age Verification

Industry:
Retail
Technologies:
Microsoft Visual Studio 2008 , .NET Framework 3.5, SQL Server 2008, RMS POS, VB.NET

Whenever a cashier opens the Store Operations POS and does the transaction for selected items, an age verification form is opened if any selected item is 'Age Restricted'.The form asks for Customer's Birth Date. Only after his/her age is validated against the restricted age of items that the transaction is processed and completed. The transaction is aborted otherwise and the cashier is returned back to the POS transaction screen with selected items on it.In case of successful transactions, the DoB entered into the table. There is also an entry of the Birth date in the Receipt as well.


Points Redeem

Client:
IT Service
Industry:
Retail
Technologies:
VS 2010, SQL 2005, RMS 2.0

A webservice and several libraries were already developed by the client which operates a number of loyalty, coupons and pre-pay services for retail customers. We developed the RMS AddIn allows retail customers to add these services directly on POS system. The add-in offers several services like loyalty points, coupons, prepaid gifts, customer registration etc. User needs to add the merchant and terminal information for authentication. The add-in will calculate the points detail on transaction screen and apply required discounts on the items. At the end a customized receipt is also printed which shows the details of loyalty points & coupons earned and redeemed.


News & Updates

  • January 17

    DDM IT Quiz, Inspired by Mindfire, is Spreading its Wings!

  • December 16

    Santa in a different Avatar- International vacations gifted to All Mindfireans!

Let us Connect!

Related Pages

  • Our SQL Server Skills
  • Our Crystal Reports Skills
  • Our VB Skills
  • Our Development Skills

Awards and Achievements

Red Herringcolor DeloitteFast50 DB ZInnov1   Nascome  DB Stpi

This site uses cookies. We respect your privacy.copyright (c) Mindfire Solutions 2007-2018. Login