Category: VB projects

The Bank Salary System is useful for the employee‟s of the branch and reduce the manual calculation and saves lot of time and will give precise answers for all the fields of earnings. The reports of pay slip, register and loans are also complete and accurate.

Front – end : Microsoft Visual Basic 6.0
Back – end : Microsoft Access 2000
Project duration : 200 hours approximately

ABOUT EXISTING SYSTEM
In the existing Bank Salary System the salary of the employee of the SBI branch is calculated manually. The staff of the branch is divided in three categories.
1.) Officers (Management).
2.) Award Staff (Clerical).
3.) Subordinate Staff.

The above-described categories are further divided in the following Designations.

1.) Officers (Management): –

i.) JMG (Joint Manager)
ii.) MM – II (Main Manager – II)
iii.) MM – III (Main Manager – III)
iv.) SMG – IV (Subordinate Manager –IV)
v.) SMG – V (Subordinate Manager – V)
2.) Award Staff (Clerical): –

i.) Clerk
ii.) Sr. Assistant
iii.) Special Assistant
 3.) Subordinate Staff :-

i.) Messenger
ii.) Watch Man
iii.) Record Keeper
In the existing Bank Salary System the calculation of the salary is done on the bases of Basic Pay of an employee according to categories of the employee.
The salary of an employee is mainly based on the Earnings and the Deduction. There are number of fields in the earnings and the deduction from the salary of an employee. The calculation of each and every field is mainly based on the Basic Pay of an employee. And some of the fields of earnings and deduction are maintained with fix amount according to the status, seniority, and post or according to the designation of an employee.

The Basic Pay of an employee is fixed according to the designation and seniority of an employee working in the bank. And calculations of other fields are done on some fix percentage of Basic Pay of an employee according to the Memoranda of Settlements.
In the existing system the calculation of the fields of the earnings and deduction is calculated manually. So while calculating the amount of each and every field manually the chances of errors and calculation of wrong values are always possible.
In the existing system the salary of an employee is done manually and the person who is doing the salary of the branch fills the amount of each and every field of earnings and deduction. The fields whose amount are fixed are directly written at proper place and the fields whose value is depend on the fix percentage of Basic Pay is calculate and then are written in the Pay Slip. So the person who is doing the salary of the branch has to first of all fill all the information of an employee like employee number, employee name, designation of an employee, grade of an employee, department, date of salary etc. and then has to calculate the value of each and every field and then total the all fields of Earnings and Deduction and by deducting the total of deduction from the total of earnings the net pay is calculated. Now while doing the salary of an employee the person also has to maintain the Register in which all the information of the salary of an employee is noted. Register is maintained for the purpose of keeping the record of each employee for calculation of Income Tax and for the calculation of Provident Fund etc.
As mentioned above the salary of all employee of the branch are calculated with large calculations, manpower and handling of the large documents with chance of having lots of errors and time consumption.

PROBLEM IDENTIFICATION

Drawbacks of existing system.

1.) Register Maintenance.
2.) Time Consumption.
3.) Pay Slip Preparation.
4.) Problem In Calculating Income Tax.
5.) Problem In Calculating the amount of Loans.
6.) Calculating the field amount.

1.) Register Maintenance: –

At the time of calculating the salary of the branch the register is also maintained and a person who is doing the salary has to copy all the amounts of fields in the pay slip from the register.
A register is maintained for whole year and the salary of each employee is noted in the register. So if an employee wants to know his salary of previous month he/she has to refer the whole register and find his/her employee number from the register, the particular month he/she wants etc. and then he/she will be able to get the salary record. Now if he/she wants the copy of the salary slip he/she has to manually write the whole pay slip. Now there is also problem of storage of all the registers, because there are so many factors by which the registers can be destroyed like fire, water, stolen, etc.

2.) Time Consumption: –

The process of calculating the amount of each field whose value is depend on the basis of percentage of basic pay is very much time consuming and it is having lots of calculations.
If an employee wants more than one copy of the pay slip then also it will take lots of time for preparing another copies of the pay slip. The process of calculating the salary of an employee is very much time consuming and boring for a person who is doing the salary of the whole branch.

3.) Pay Slip Preparation: –

As mentioned above the process of register maintenance, and then the pay slip is prepared from the register is very much time consuming and the chances of errors and mistakes is always present.

4.) Problem In Calculating Income Tax: –

The employer is required to deduct income tax from the salary paid to an employee. The income tax is calculated based on gross salary paid to the employee during a year, if it exceeds a limit. Because of the manual system the calculation the income tax amount become very difficult and time consuming.

5.) Problem in calculating the amount of Loans: –

The handling of the loan amount and the calculation of loan amount is very difficult and time consuming in the existing bank salary system. The problems with the handling of loan amount is that sometimes the amount is wrongly written by the person who is doing the salary, the employee has to pay more amount from his/her salary.

6.) Calculating the field amount: –

The calculation of the field amount of the earnings and deduction is very hard and time consuming when the field amount is based on the basis of the fix percentage of the Basic Pay of the employee. The chances of errors and mistake are very much in the existing bank salary system.The above described are the drawbacks of the manual bank salary system with makes the process difficult, time consuming and very hard for the person who is doing the salary of the branch and is also not beneficial to the employees of the branch

PROJECT SPECIFICATION:

Multi Chain Market Monitoring deals with the processing of accessories rates and product maintenance with the three data files to store data permanently. The user should maintain two databases about the customer and products. The customer database consist of customer code, customer name, address, city are the fields. In product database product code, product name, quantity in hand, price of item are the fields. It has a capability to display all the details in a tabular format.

VALIDATIONS:

–    Customer number shouldn’t repeat.
–    Make sure to save the details of customer after input.
–    Supply customer code to modify the customer records.
–    Restrict unauthorized usage of product details.
–    Make ensure that update the stock when it is purchased.
–    Confirm update of product details.
–    Make sure that customer code is registered.
–    Make ensure the product code is valid while selling product.
–    Allow the user to get discount if he is valid.
–    Discount criteria

PROJECT DESCRIPTION

Sales automation system deals with the purchase, billing system of sales and stock availability information. In this system we have maintain three files, which will store information permanently. The three files consist of customer, stock, transaction information. We can retrieve data when we need of those files. When the purchase transaction done by the user, automatically this information will adds to stock data file. If the sales transaction made by the user then the stock and customer data will get updated. According to the transaction in the sales the stock record should be updated. It doesn’t mean that it should obey the business rules, which are standard. Simultaneously the transaction data file gets updated according to the transaction.

Customer information is maintained with all details about name, address, and customer number. Product information maintains details about product code, product name, quantity available, and amount of product. Transaction information consists of sales and bill of product. Each and every screen has an option to come back to previous screen from where the screen came.

In the first screen we have three options of customer, product, transactions options with the input cursor, which is waiting for any one of these four. Where the fourth option is to come out of the project.
When you get into the customer option it will take to select the options to register a new customer. When you select it, the user has to fill up all the details about the customer. The user can continue this process up to

when the user gives input as no to continue. The second option is to list all the customers in a tabular format who are all registered early. It gives with all information about customer. Third option can be used to modify the customer record. The user should know the customer number to modify his details. When the customer is not available with the given number, it gives a message that the customer is not available. Next option deals to delete the unwanted customer details to reduce the size of the data file. If it doesn’t find the details about the customer, it gives a not found message. At last we return to the main screen when the user selected the corresponding option.

When you get into the customer option it will take to select the options to register a new customer. When you selected this option, the user has fill up all the detail about the customer. The user can continue this process up to when the user gives input as no to add user.  The second option is to list all the customers in a tabular format who are all registered early. It gives with all information about customer.

Third option can be used to modify the customer record. The user should know the customer number to modify his details. When the customer is not available with the given number, it gives a message that the customer is not available. Next option deals to delete the unwanted customer details to reduce the size of the data file. If it doesn’t find the details about the customer, it gives a not found message. When user want to turn back after fulfillment of requirements he has to tap enter key.

If user wants to get into the details about products he has to select product maintenance option from main menu. But it’s restricted. By giving password the user can enter into options available about products. Product menu consist of five options. To add a new product details we have an option called new product details. The user has to input for product code, product name, and quantity on hand, price of individual item.

The user should take care not to repeat the Product code. Is it so, the cursor won’t allow filling the next field information. This option allows storing data about product. It allows adding many products continuously. The next option gives the list of products available in the store in a tabular format. To modify any details of products select ‘Modify the Product details’ option from the main menu of products.

The user should enter the product code, which he wants to edit. When the user gives conformation about the modified information the data will be stored in the disk permanently. To delete an unnecessary product details the user has to select ‘Delete Product details’ from menu of product. User should supply the product code. The deletion will be confirmed when the ‘deletion completed’ message displays else ‘product not found’ message will be followed. To get back to the screens where the user came from, select ‘Back’ option. When user want to turn back after fulfillment of requirements he has to tap enter key.

The third option in main menu is transactions. It consists sales and bills. The members of the Multi Chain Market only can purchase products. The non-member of market is trying to purchase the goods it gives a message to register you. This menu allows the user to buy several products. If the product is out of stock the user may know by ‘quantity on hand’ option. It displays availability of stock.

To get total bill of purchased products get back to transaction menu and select bill option. It gives the total amount. If the customer is allowed to give discount that amount will be subtracted from total amount and net amount be on the screen.  When user want to turn back after fulfillment of requirements he has to tap enter key.
Conclusion:
The automation of Multi Chain Market monitoring is very helpful to maintain data and reduce the time while comparing to manual operations. It improves accuracy. It’s compatible and platform independence. The program can be executed at minimum system requirements also. The project consists of user-friendly a screen that is helpful to the user with out taking any assistance of skilled person.  I hope that this project will help the users and benefit from it immensely.

ABSTRACT:

The allotment of houses for various people is due for automation. There are various data that are maintained. One of them is the employee detail. The various details include the code, the dress, the designation, name the confirmation data and the retirement date etc. there are also details like the various grades and designation that are maintained.

The employee has to request forma quarters and the various details are maintained. The details of allotment of the quarters are also maintained. The details of the persons occupying the quarters are also maintained. Once the above details are automated then the allotment is considered to be completed.

SYNOPSIS

The system provides an easy way to perform computer based testing for small computer firms. It also helps to allotment  of  houses to the employees. This system will be customized according to the clients requirements and will be installed for them. This also focus on to allot the houses depending upon their grades quickly and efficiently.

Managing the activities while allotting the houses is not an easy task to allot the houses if  the no.of  employees is more and the no.of houses is less. if the no.of employees is more and the no.of houses is also more, then it is tougher to allot houses and maintain records manually.

In case of employee details , many activities such as collecting the employee name , employee id , address, grade ….etc. by using this employee details we can allocate houses to them quickly and fastly.

Thus the project house allotments was successfully completed.this software is fully functional and operational. since, this project is implemented using VB 6.0, it provides a more direct and easier way to allotment of houses. This project is very flexible and that are lot of provisions made for the future enhancement of this project.

The project entitled “SALES ORDER PROCESSING” has been designed and developed for any Electrical and Electronics Enterprises or any other.

The main aim of this project is to computerization of daily activities in the enterprise. It is a database system for creating a selective related information, for subsequent analysis manipulation and application.

This project contains several modules to record the details about the Product, Customer details, Order details and Bill details about the goods which the Customer has purchased from the enterprise. And it maintains the reports about the Products, Customers,Orders and Bills. This project is very useful to sale the goods in any enterprise.

The project entitled “SALES ORDER PROCESSING” has been designed and developed for any Electrical and Electronics Enterprises or any other.

The main aim of this project is to computerization of daily activities in the enterprise. It is a database system for creating a selective related information, for subsequent analysis manipulation and application.

The system has different modules for various activities. The various modules of the system are recording of new products(addition,modification,deletion), maintaining the Customer details, maintaining the Order details from the Customer and recording the Bill details of goods which was purchased by the Customer.

Basic

Each module is designed for each activity that should be recorded every time. Using this system the management can record easily and stored in the database. Retrieving the old records also made easy in this system. So that the management can retrieve the records and make use of them.

The database system is developed perfectly which does not allow the user to enter the wrong data hence it facilitate the management. This database management is developed for retrieving records with correct records so that it is reliable. Implementation of this system requires the use of computers with most versatile system. Hence, this software is developed on MS-Windows platform using Visual Basic 6.0

The SALES ORDER PROCESSING is developed for the daily sales that are going in the particular firm or an Enterprise.

The major kind of transactions that are being carried in SALES ORDER PROCESSING are

• PRODUCT DETAILS
• CUSTOMER DETAILS
• ORDERS DETAILS
• BILLS DETAILS
• REPORTS

PRODUCT DETAILS :-

Pcode,desc,companme,capacity,cost,items_available

CUSTOMER DETAILS :-

Ccode,cname,addr,phone,pin

ORDER DETAILS :-

Ordno,order_date,customer_code,pcode,company_name.quantity_ordered,amount

BILLS DETAILS :-

Receipt_no,order_no,receipt_date,type(cash or cheque),amount_paid,

discount,total_amount,cheque_no,cheque_date,bank_name

SOFTWARE ENVIRONMENT:

FRONTEND                  : VISUAL BASIC

BACKEND                    : MS ACCESS

REPORTS                     : DATA REPORTS