| |
| Web Based
Stock Management System |
| |
Login form: |
Enter the correct user name and password and it will be matching database. And if we enter the correct login details that going to next menu_header page otherwise popup invalid username and password. |
|
Menu header page :
|
Menu header page who is login display their name and the menus described following: |
- sales order
- repairing
- demand requisition
- report
- daily Expense
- stock
- new customer
|
 |
Sales order : |
They can selected any one of them customer name than related contact number, address will be display ,product code any one selected automatically displayed description, unit price sub-total , if you mention the brand ,quality , discount automatically adjust Select order details select status and submitted.
|
 |
Sales Payment : |
In this page displays all entered details in sales order page.So it display order details. we just enter the
paid amount in the textbox nearby paid label and then the onfocus of the balance . It display the balance amount.
Print Preview:while click the print preview button that display the screen which is to be print.
Print:While click the print button that prints the page which is viewed in printpreview page.
|
 |
| The print preview page will look like as below: |
Print Preview |
 |
View order listed: |
| It displays order number and status. We can search order number, status, customer name and then related information will be display it |
 |
Customer Details: |
Here we add the information of new customer. customer details for customer name ,contact number ,fax ,website ,address and remark get all details stored in add_new_customer table.
Just enter the values and click save button that saved. and clear button resets the fields that allows to enter the next data.
and one link Show customer name list that displays the details of all customers
|
 |
Stock Report : |
| Display the stock report category wise , total number of stock and sold stock , stock in hands. |
 |
Add New product: |
It adds the new products.Collect the product code, description, category, brand quantity, cost, location, reorder point and remark save into product table in database.
|
 |
Repairing: |
Collected information from customer, problem unit, technician information providing all the details product_id, quantity, problem, cust_id, employee_id, components stored in repairing table.In customer information
list of customer name displayed, if we select one customer name that displays the email id,phone no and address of them.
|
 |
Add Daily Expenses : |
| We may sort out the daily expenses. easily view by clicking the links view daily expenses and also
insert today expenses also by Select the location, date expense, amount then click the button that stored data in table . |
 |
View expense details: |
It displays the expenses per day. How many expenses per day, below table factory expense for water of amount Rs.50 that type of information will be display in table format.
|
 |
Demand Requisition: |
We may noticed our demands. just enter the details stored in database .How many requirement for wanted in production all details collected demand and those information are stored in database.
and view the previous demands by clicking the link view demad requisition |
 |
| |
| |
