B
B
L
L
A
A
Z
Z
E
E
T
T
E
E
C
C
H
H
N
N
O
O
L
L
O
O
G
G
Y
Y
S
S
O
O
L
L
U
U
T
T
I
I
O
O
N
N
S
S
Inventory and Loan
Management System
SL.NO CONTENTS 1. Overview 2. Features 3. Screen Shots 4. Technologies1. Overview
The Objective of the Project is to maintain inventory and loan information such
as stock details, sales, invoice generation, Supplier, Supplier item, sales bill and
Sales return, Delivery Chelan and Loan details. This system keeps track of
inventory information for two sections, one is the main branch and the other is
its Sub-branches. Main branch controls all the sub-branches.
2. Features
• Creating and assigning rights to users. Restricted access rights for the
each and every module and its related operations. Only persons with
sufficient rights can access the different modules. Rights are given in
such a way that users can be restricted from viewing the details alone
or making new entries or editing the previous entries made or delete
the entries made.
• Search option is included in all possible modules. Search option
enables the end user to get the required data in an easy and quick
manner.
• Customer Module:
This module Takes care of storing the Personal details. Maintains
information’s like customer name and full contact information.
• Item Master Module:
This module helps the user in maintaining the item details, which
includes Name of the item, Quantity In Hand, Reorder level, Rate, unit
of measurement. The items are displayed in tree structure form, which
and organized as Main category and sub category. A main category
can contain ‘n’ number of sub categories.
• Supplier Module:
This module stores the details about supplier personal information. The
supplier name and all the possible combinations of contact
information’s are collected and maintained.
• Supplier Item:
This module assigns the various items available in the main branch item
master to the list of suppliers. On selecting a supplier, the list of items
supplied is displayed. Provisions are given to maintain price details of
every supplier.
• The Branch Master:
Helps the user in maintaining the sub branch details of the main
branch. The branch master store details of the sub branches like the
branch name, its address and the concerned person responsible for
that branch.
• Branch Item Master:
The module maintains the stock details of the different sub branches.
Items enter into the stock of sub branches in two-way. Either by
assigning items directly to sub branches through this Branch item
master or by raising a sales DC to particular sub branch. Entries can be
made only for the items available in main branch. So provision is given
for adding item directly to the main branch item master through this
• Invoice:
This module helps the user to maintain the detail about the incoming
stock details. Invoices are raised for ordering items from suppliers.
Provisions are given to select suppliers from a multiple list. The item
stock is updated as and when an invoice is made and removed.
• Purchase Payment:
This module includes the payment details for the purchase made from
suppliers. Provisions are given to view the pending payment. The
payment detail maintains record of the net balance and the details of
the pervious payments.
• Sales Bill:
This module helps the user to make entries for sales made The sales bill
module stores details of the Sales such as bill number, bill date, to
whom this sales bill is assigned, either Credit or Cash sales, discount,
tax, total amount, item name, price and quantity. While making sales
entry for the item the application automatically detects the quantity in
hand from the stock details and also alerts the user when the item
reaches reorder level. Provisions are given to make this entry to a
regular customer or to an anonymous customer.
• Sales Adjustments:
The module maintains details of the items returned via a sales bill.
Details such as Sales Bill No, Item Name, return date and quantity are
• Sales Payment:
The module stores the details of the payment made for the Sales bill.
Provisions are made to view pending payments. The payment details
tell the net balance and the details of the pervious payments. And this
payment details is maintained only for the credit sales.
• Sales DC:
Sales DC (Sales Delivery Chelan) entries are made when an item is
transferred form main branch to sub branches This module stores the
information about the Date of Sales DC, Sales DC number, Branch
Name, Item Name, quantity, price. After transferring items to sub
branches the item stock both main branch and the sub branch
involved in the DC are updated.
• Branch Sales Monitor:
This module includes the Sales details of the sub branches. Provisions
are given for the user to add and verify the details about each branch
sales. After making sales entries the corresponding sub branch stocks
are updated.
• Branch Sales DC:
Branch sales DC (Sales delivery Chelan) entries are made when an
item is transferred from sub-branch to main branch. This is similar to
Sales DC explained above, but all the DC will be made to the main
branch from different sub branches. After making sales DC entries, the
• Loan Member Master:
This module takes care of storing the Loan member personal details.
The loan member details include Member Id, Member Name,
Father’s/Husband’s Name Address and age.
• Loan Member Employment:
This module stores the employment details of the Loan member. The
Department name, date of joining, occupation, length of service,
monthly emoluments, less (if any) are collected and records are
maintained. Here user can view the present employment and previous
employment details
• Reports:
Separate reports are generated for main branch and sub branches for
all the modules detailed above. Dynamic item stock reports, sales
3. Screen shots
3.1 Main Screen
3.3 Invoice details
3.5 Sales Bill
3.7 Reports
4. Technologies
Operating System : Windows 2000
Language : VB.NET
Database : SQL Server 2000
