Inventory
Management

PROPOSAL FOR INVENTORY SOFTWARE

The software, which we are proposing you, will be using the front end and .Net and Back end will be SQL Server. The software is exclusively made for total inventory management system.

The Software Contains the Following Modules

Master Module. Purchase Module. Sales Module.
Verification Module Reports Module. Utilities Module.

Master Module

The Master Module consists of Master screens for Main Category, Category, Unit Master, Item Master, Payment/Receive heads, Salesman Master, Supplier Master, Customer Master, User Master and purchase rate Code.

Main Category : This screen is used to enter the different main Categories.

Category Master : This screen is used to enter the sub categories of items available. There will be a provision to select the category, which the sub category belongs to from the combo box, which gets populated from the category master.

Unit master : This screen is used to enter the different units like box, Pieces etc.

Item master : This screen is used to enter the product details. All the products will be added to the master with its name and short name (which will be printed on the barcode sticker) and Purchase Rate & Selling rate if you want to put in this screen it can be added and according to the prices we are giving here based on which the rates will get automatically get captured in purchase & sales modules. There will be a provision to which sub category it belongs to from the combo box, which will get populated from the details entered in Sub Category Master.

Payment/Receive Heads : This screen is used to enter the different payment/Receive heads. These heads are used in the payment and receive transactions.

Salesman Master : This screen is used to enter the salesman details. The salesman details like Name, Address, phone numbers etc.

Supplier Master : This screen is used to enter the Supplier Details. The details of the supplier like name address & other details etc.

Customer Master : This screen is used to enter the Customer Details. The details of the customer like name address & other details etc.

User Master : This screen is used to enter the users, which is given for users for log in to the software. The details entered will be User name and password.

Purchase Rate Code : This screen is used to enter the 10-digit purchase rate code. This code will help us to print the items purchase rate in the barcode label and only the person can decode it who knows the purchase rate code.

Purchase Module

This module consists of all the purchase related transaction. The purchase module consists of Purchase entry, Purchase modify, purchase Return, Purchase View, Stock Update and Barcode Print.

Purchase Entry : This screen is used to enter purchase details. In this screen the purchase number will get automatically displayed. Then Supplier name, Supplier Invoice Number, Purchase Date, Receipt Date, Item details and quantity of items purchasing & the purchase rate etc. When the purchase details are saved it will ask you do you want to take the barcode printout for the purchase you made. If you say yes, the barcode prints out for the items purchased for the quantity will get printed through the barcode printer attached to the system. In this screen the user need to give the information whether the payment is given or if it is credit give the credit days against the purchase. And if any advance amount is paid it has to be allocated to the purchase number in the payment voucher.

Purchase Modify : This screen is used to modify the purchase details previously stored.

Purchase Return Entry : This screen is used to enter Purchase return details. As the name implicates it will allow you to return any items, which is purchased. For returning the items, you need to give the purchase number from which the item you are returning the item. When the purchase number is given on the basis of which we are doing the purchase return it will cross check the item you are returning is purchased through the purchase number you had given and give you the proper error messages. And when saving it the stock will get automatically get affected.

Purchase View : This screen is used to view the Purchase report of a single purchase.

Stock Update : This screen is used to update the stock quantity of the item manually.

Bar Code : From Purchase - In this the user select one purchase number and print the barcodes for the items in that purchase.
Individual Printing - In this the user can manually enter the item code and quantity for print barcode.

Sales Module

The sales Module consists of the screens for sales, Sales Return & Sales Print etc.

Sales Entry : This screen is used enter the sales. The customer can be selected from the combo box. Then scan the items, which you are doing sales and automatically the item name and rate will get displayed. The selling rate of the item can be given in the item master & or at the time of purchase in purchase entry screen. When the sale is saved the bill will get printed to the printed connected. The stock will get adjusted at the time of sale details getting saved.

Sales Return Entry : This screen is used return the sale items. In this screen invoice number of the item for which sales return is making will be typed and the item will be scanned or selected and the sales return details will get saved and accordingly the stock will get adjusted. User can take the printout of the sales return. For this sales return you need to allocate the location code to which your location you are going to keep the item.

Sales Print : This screen is used reprint the sales invoice. The date can be selected and after the date is selected the invoice numbers will get displayed for the selected date. User can select the invoice number and either you can view the invoice details or can take the print out.

Verification Module

This module has one sub module for verify the current stock with the software database for find out for any mismatching with current database and stock.

Others Module

The others module has two sub modules for payment transactions. The two sub modules are Payment voucher and Receive voucher.

Payment Voucher : This screen is used to enter the payment voucher details like Payment/Receive heads, Amount and Remarks etc. Here there will be an option to select the payment you are making against purchase and if it is you can allocate the same while you are giving the payment with all the other details like cheque number or bank account information.

Receive Voucher : This screen is used to enter the Receive voucher details like Payment Receive heads, Amount and Remarks etc. Here there will be an option to select the receipt made against the customer invoice numbers and allocate the same.

Quick Reports

Stock-Display the stock details of the item user selected.
Daily Sales-Display the daily sails report.
Cash Balance-Display the cash balance of the day user selected.

Reports Module

The Reports module consists of different type of reports for your requirement. The details of all reports are mentioned below.
Master Reports Purchase Reports Purchase Return Reports Sales Reports
Sales Return Reports Stock Reports Others

Master Reports

Main Category Report. -It displays all the main category details
Category Detail Report. -Display all the sub Category Details.
Unit Details Report. -Displays all the units.
Item Details Reports. -Displays all the Item Details.
Salesman Details Reports. -Display all the salesman details.
Supplier Details Reports. -Displays all the supplier details
Customer Details Reports. -Displays all the customer details.

Purchase Reports

Date wise Purchase Report.
Date wise & Supplier Wise Purchase Report.
Category, Sub Category, Brand, Department & date wise Purchase Report.
Purchase View.
Purchase Register
Purchase Payment Pending Report (Date wise & Supplier Wise).

Purchase Return Reports

Date wise Purchase Return Report.
Date Wise & Supplier Wise Purchase Return Report.
Category, Sub Category, Brand, Department & date wise Purchase Return Report.
Purchase Return View.
Purchase Return Register.

Sales Reports

Date Wise Sales Report.
Date Wise & Customer Wise Sales Report.
Category, Sub Category, Brand, Department & date wise Sales Report.
Sales Bill View.
Sales Register.

Sales Return Reports

Date Wise Sales Return Report.
Date Wise & Customer Wise Sales Return Report.
Category, Sub Category, Brand, Department & date wise Sales Return Report.
Sales Return View.
Sales Return Register.

Stock Reports

Stock Register Report.
Category, Sub Category, Brand, Department & date wise Stock Return Report.
Quick Stock View.
By giving the item code this will give you the quick detail of stock quantity available and the location of the stock of the item.

Other Reports

Payment
Displays all the payment vouchers.
Receive
Displays all the receive vouchers.

Utilities Module

The module consists of Backup Data Option & User Permissions Option.

Backup Data : The Backup date screen is used to take the backup of the database. It is recommended to take the data backup manually once in a while.

User Permissions : This screen is used to give permission to the users for the screens they can access and work. Admin user will be having the power to give permissions to the screens to each user. When user log in to the software if it is admin all the screens will be visible & access to the admin user & for all the other users log in to the software will be able to have taken only the screens which had given permission and saved in the user permission screen by taking the tree view of the software options.

Inventory Management