Posts: 5,362
Threads: 2,998
Joined: Feb 2011
Presented by,
M.Gnaneshwaran
[attachment=12067]
HARDWARE SPECIFICATION
Processor : Intel core
Memory : 1GB RAM
Hard Disk : 320 GB HDD
Monitor : 15ColorMonitor
Keyboard : 104 Keys
SOFTWARE SPECIFICATION
Platform : Windows XP
Front End : VB.Net
Back End : SQL Server 2000
SYNOPSIS:
The stock maintenance system is the inventory control where the product are purchase from the supplier and stored in the warehouse and again the products are sold to the customer by making bill.
So this type of transaction is known as the stock maintenance.
Some times the products is send to the another warehouse if they have branches in another place.
Stock also has to be maintenance when the raw material are send to the job order to another place or when job work.
Differently the stock is to be maintenance for raw materials, semi finished goods, finished goods so these types of transactions are done in garments exports, large industries where manufacturing is done
Here the stock maintenance is the main process by which the stock is to controlled when purchase or selling products.
User Management :
We can add new user in this module by entering the name , address, phone,email etc. If a person want to login first the user has to be created using this module. Already existing user can also be changed using this module. The administrator can modify the list of user details and also the administrator can remove the unwanted user (user who last login was before one month).
Login :
The user has to login in to the system if he wants to make the transaction. If he is a new user it has to be created if he is already existing user he can login if he forgot his password a question will be asked or he has to enter email and then submit the password will be sent to his email
Purchase Order :
The company places the purchase order to the supplier before making the item purchase. The supplier in turn places the order to the company and then the company purchases the item.
Purchase :
The company purchases the items from the supplier by placing the purchase order and then the items are purchased by quoting the itemname, quantity, rate etc.
Sales Order :
The customer send us the sale order before selling the items to the customer or the customer without making the sale order he can purchase the items from the company. They will quote us the product name,quantity, rate for checking the quantity of that items is available or not.
sales :
The customer purchases the items from the company by making sale order or without making sale order. The customer has to enter all the details of his company and then he can order his items by entering the item name, quantity and rate.
Stock Transaction :
The stock adjustment can be made whenever the company receives the credit note and debit note and also the stock transaction like ware house to warehouse transfers can be done.
Stock Transaction :
The stock adjustment can be made whenever the company receives the credit note and debit note and also the stock transaction like ware house to warehouse transfers can be done.
Reports :
The company can view the various reports like stock statement, daily sales statement, purchase made on this month etc can be viewed using this report
Posts: 2,051
Threads: 1,405
Joined: Jun 2011
[attachment=14283]
1. INTRODUCTION
1.1 PROBLEM
Stock Maintenance gives an idea about how products are maintained in the particular concern. The products that are to be purchased, the products that are to be sold are maintained here.
This project also gives idea about the faults in the purchased product and the products that are to be replaced also been given. Further some additional details of the current stock that is available in the store is also given.
Stock maintenance in this project is done in an authorized way. The password and user id has been set here. As a whole the marketing process can be improved if the stock is maintained properly.
1.2PROBLEM DEFINITION:
The stock has to be maintained properly since the whole marketing process can be improved. Stock maintenance in this project gives the idea about how products are maintained in a particular concern.
The stock details which includes the amount of stock available, the stock is to be purchased, the date or the time it is being bought or delivered, the amount that is already available are maintained in this project.
The stock maintenance in this project is understood by goin through the modules that is being involved. The whole economic status is being improved properly if stock is maintained.
2. SOFTWARE TOOLS
2.1 MS-VISUAL BASIC:
Visual Basic 6.0 is fastest and easiest way to create single user and client/server applications for Microsoft Windows. Visual Basic 6.0 provides complete set of tools to simplify rapid application development both for the experienced professional and new windows programmers.The “Visual” part refers to the method used to create Graphical User Interface.The “Basic” part refers to the BASIC language used by more programmers than any other language in the history of computing. It is an ideal programming language for developing sophisticated professional applications for Microsoft.
2.2 ORACLE 9i:
Oracle 9i makes most necessary conversion to the code automatically when we convert our data base. However the conversion process makes some changes to code that need to aware of, and there are some additional changes that must made in order to run the application successfully in oracle.
3. METHODOLOGY
3.1 CONCEPT
Storing of information about the stock values and updating the stock values for each organization which is using this system, keeps track of all the information about the stock exchange that are made by the customers, having registration feature of adding up new customers to the organization are provided in this system.
3.2 DATABASE CONNECTIVITY:
The front end used for implementation of this project is Visual Basic 6.0 and the back end that is used for this project is Oracle9i.The database connectivity between Visual Basic 6..0 and oracle9i is provided by using Microsoft ADO Data control 6.0(OLEDB). Thus the project makes use of the internal feature of ADODC for communicating with the database and this is responsible for transfer of data to and from the table from and to the front end.
A term used to a database or database server used as a source of data. ODBC data source are referred to by their Data Source Name (DSN). Data sources can be created by using the windows control panel or the register database method. A standard protocol that permits application to connect to a variety of external database servers or files. ODBC drivers used by the Microsoft database engine permit access to Microsoft SQL server and several other databases.
To add ADO data control to the toolbox go to the components and select Microsoft ado Data control 6.0(OLEDB). There are three different options insetting connection string. They are as follows
1. Use data page link file : any data page link file already stored can be specified.
2. Use ODBC Data source name : any ODBC DSN can be specified.
3. Use connection string : choose build to create a new connection String
specifying the OLEDB provider.
4.SYSTEM REQUIREMENT
4.1 Hardware Requirements:
Processor : Intel Pentium III or later.
CPU Speed : 1.0 GHZ
Strorage Capacity : 20 GB
RAM Capacity : 512 MB
4.2 Software Requirements:
Front End : VISUAL BASIC 6.0
Back End : Oracle 9i
Operating System : Windows Family
Application Software : Rational Rose
Posts: 1
Threads: 0
Joined: Aug 2011
plz send me project file..
Posts: 6,566
Threads: 1,107
Joined: Jul 2011
To get more information about the topic "STOCK MAINTENANCE SYSTEM " please refer the page link below
http://studentbank.in/report-stock-maint...9#pid53829
Posts: 4,577
Threads: 25
Joined: Mar 2013
To get full information or details of STOCK MAINTENANCE SYSTEM please have a look on the pages
http://studentbank.in/report-stock-maint...e=threaded
http://studentbank.in/report-stock-maintenance-system
if you again feel trouble on STOCK MAINTENANCE SYSTEM please reply in that page and ask specific fields in STOCK MAINTENANCE SYSTEM
