INVENTORY-BARCODE MANAGEMENT SYSTEM

Abstract

The client Richa Creation is a jewellery importer and wholesaler in the United States of America. The company has its manufacturing facilities in New Delhi from where it imports the jewellery. Richa creation decided to make its inventory management, sales analysis and other operations very effective. The assignment for the development of the application has been awarded to Cosmic Softech ltd. Inventory-Sales Management and Analysis System provides the user and manager a fast way to handle multi store inventory transfers from their representative at any position to Home (Head Office) and from Home to their representative at any place, manage physical inventory, maintain turnover of sales and provide trend/analysis of the style in demand along with the reasons behind it. The administrator can maintain the database and also import the new inventory details This report gives development environment and application development of the Inventory and Barcode Management. The Inventory management aims to help the user to enter or import the inventory details. Once the details are in the system the user can control the inventory flow for proper inventory management. This module gives ease to the user to enter the inventory details. User can import the data coming from the vendor/factory on the ASCII file directly into the system. Inventory Management also deals in generating BarCode for the new items coming from Vendors. BarCode are also generated for items whose any information is. edited or updated in the database on server. BarCodes allows data to be collected rapidly and with extreme accuracy. There are various symbologies available for generating BarCodes and symbology used for this particular project in Code 128B. The Code 128 character set includes the digits 0-9, the letters A-Z (upper and- lower case), and all standard ASCII symbols and control codes. BarCode Printer are special type of printer and they have their own instruction set available for printing BarCodes. Instructions are executed at printer only. BarCodes are printed for Inventory Number of items for easy identification, apart from this information like item's Price, Style, Description and Vendor Name from whom Item has come is also printed on the Label. Microsoft Visual Basic 6.0 is used at Client Side to give application better look and feel, whereas MSSQL Server 7 is used at Back End for Database Handling. This application has been developed on Intel Platform with 128 MB RAM with Windows 98 and Windows ME as Operating System