Inventory Management System

The client

The client is a leading exhibition software development and management services provider in Canada. It specializes in delivering services to leading exhibition producers and industry associations.

What the client wanted

Our client needed a web based application which would enable its warehouse and technical staff to manage its IT asset inventory. This application should include the basic functions such as user authentication, data add/edit/delete, combination search, administration, report, data dictionary etc. In addition, scanner support should be available. Quick response as well as good performance was also demanded with the addition of data records and functionality in the future. The design could be scaleable due to the future additional functions like item export, diversified report support and jpg/gif pictures' addition.

Approach

In virtue of the proven methods and rich experience in the field, Abstract Technology's skilful engineers promptly completed the development with ASP.NET on top of SQL Server 2000 database.

The prototype and database designs were performed after requirement analysis. The structure of the tables in database was furthest optimised to meet the demand of quick response and scalability. The engineers utilized CSS to design the user interfaces.

With this system, users could be enabled or disabled in user set-up area and search information by item's ID, type, use purpose, location, status, manufacturer etc. The reports by location, use purpose, status or type were achieved; moreover, the Casio DT-X10 wireless LAN scanner was supported.

Benefits

• A quick response and good performance application.
• The application made the asset management more effective.
• A scalable and expandable application.

Download the complete case study Contact sales