Our Case Studies
Project Name: Sales Transaction Processing
Client
Inventory control software owned by the client is powerful enough to support companies with up to $99 billion a year in sales. The client offers a wide range of Inventory Software and accounting solutions, from a single user version to the 3000+ user SQL Client-Server Edition.Why STPL?
STPL's experience in building applications in a distributed development environment was particularly useful.Client has been building the application over several years through its own development resources in Canada and taking help of some resources located in the Europe..
STPL's experience in understanding ERP based applications coupled with long technology experience of Dot Net technologies, made STPL as the natural choice for the client.
Project Overview
This CRM application is a 100% Microsoft .NET- based CRM application suite which houses and automates all the critical business information an organization needs to develop effective sales, marketing and customer service strategies.In this project STPL is to provide a module for the creation of quotes, sales order and invoice. The challenges that we encountered were as follows:
Account Management
History of all interactions
with customers and prospects, on an individual or company-wide level,
are contained in this powerful CRM software application.
Marketing
Also, included in the CRM package is marketing functionality complete
with call center features. This will maximize the marketing dollars by
allowing creating, executing, managing and tracking successful
campaigns that increase leads and generate sales.
Easy To Use
This CRM application is easy to use. Designed with a logical interface,
the instantly-familiar Microsoft look and feel and convenient tab
orientation allows the team to navigate effortlessly through the system
using the intuitive navigation tree and bar. User can view, edit and
search for important customer data in record time. This ultimately
empowers the organization to build stronger, more profitable
relationships with customers and prospects.
Challenges
The challenges that we encountered were as follows:1. Client required navigation and interface similar to Quick books.
2. Number
of item included were as high as 150,000 and a fast search on the basis
of
several criteria like item name, code or description was desirable.
3. To provide facility for the creation of items and adding them to a new transaction without
any flicker.
4. To
provide a facility to apply several taxes on the transaction items as
soon as there is a
new entry or a change in the previous entry.
like an actual transaction on a paper.
Solution
The solution we provided addressed the above challenges:1. We used Ajax (auto complete feature) to get the partial list of items on the basis of
letters typed in a textbox.
2. We provided the facility of creation of items using Ajax.
3. We used client side scripting (JavaScript) for the calculation of total amount with
all the
taxes applied on that transaction.
4. We
provided look and feel of the transaction as an actual transaction with
all the items
listed and calculated in one page.
Technology Used
- . NET FRAMEWORK 2.0
- ASP.NET 2.0
- C# 2.0
- AJAX
- XML
- CSS
- IIS 6.0
- Scripting Languages - JavaScript, VB Script
- Database - SQL Server 2005
- Testing Tools - QTP 9.2 , Dev Partner