Factory Management System
A Complete Guide
Software Product Version 1.0
Software Manual, October 2010
BlueScope Lysaght Lanka (Pvt) Ltd.
26 & 27, Pattaavali Road, Industrial Estate,
Sapugaskanda
Srilanka
SRILANKA INSTITUTE OF INFORMATION TECHNOLOGY
# 25, 16th floor, BOC Merchant Tower, St. Michaels Road, Colombo – 03.
www.sliit.lk
DISCLAIMER OF WARRANTIES AND LIMITATION OF LIABILITIES
BLUESCOPE LYSAGHT LANKA (PVT) LTD. (“BSL”) RESERVES ALL RIGHTS IN THE PROGRAM
AS DELIVERED. THE PROGRAM OR ANY PORTION THEREOF MAY NOT BE REPRODUCED IN
ANY FORM WHATSOEVER EXCEPT AS PROVIDED BY LICENSE, WITHOUT THE CONSENT OF
BSL.
A LICENSE UNDER BSL'S RIGHTS IN THE PROGRAM CAN BE OBTAINED DIRECTLY FROM BSL.
THIS NOTICE MAY NOT BE REMOVED FROM THE PROGRAM BY ANY USER THEREOF.
NEITHER BSL, ANY MEMBER OF BSL, THE ORGANIZATION(S) BELOW, NOR ANY PERSON
ACTING ON BEHALF OF ANY OF THEM:
1. MAKES ANY WARRANTY OR REPRESENTATION WHATSOEVER, EXPRESS OR IMPLIED,
INCLUDING ANY WARRANTY OF MERCHANTABILITY OR FITNESS OF ANY PURPOSE WITH
RESPECT TO THE PROGRAM ; OR
2. ASSUMES ANY LIABILITY WHATSOEVER WITH RESPECT TO ANY USE OF THE PROGRAM
OR ANY PORTION THEREOF OR WITH RESPECT TO ANY DAMAGES WHICH MAY RESULT
FROM SUCH USE.
Research Contractor Company Name (add others on lines below if more than one)
NOTICE: THIS REPORT CONTAINS PROPRIETARY INFORMATION THAT IS THE INTELLECTUAL
PROPERTY OF BSL, ACCORDINGLY, IT IS AVAILABLE ONLY UNDER LICENSE FROM BSL
AND MAY NOT BE REPRODUCED OR DISCLOSED, WHOLLY OR IN PART, BY ANY
LICENSEE TO ANY OTHER PERSON OR ORGANIZATION.
Copyright © 2010 Srilanka Institute of Information Technology. All rights reserved.
CITATIONS
This report was prepared by
Team members of WD_B_14
Batch 2009
Srilanka Institute of Information Technology
# 25, 16th floor, BOC Merchant Tower,
St. Michaels Road,
Colombo – 03.
This report describes research sponsored by the BlueScope Lysaght Lanka (Pvt) Ltd., (BSL).
The report is a corporate document that should be cited in the literature in the following manner:
Factory Management System: A Complete Guide, BSL, Sapugaskanda, Srilanka, 2010. Software
Product Version 1.0:
iii
SOFTWARE DESCRIPTION
This Factory Management System helps to manage routine of the BSL.
Description
The main system roofs three subsystems, they are, Customer Information management,
Employee Information Management and Inventory Management. They can handle fully
automated processes. Therefore, if information is entered in one place it will be automatically
updated everywhere. Printing invoices for customers, calculating salary, maintaining sales
history, calculating the remaining amount of stock (Coil), Alert when stock reaches the minimum
order limit and several other functions have been included in this system.
Benefits and Value
Inventory Management System
The inventory management system will be fully automated.
Can view the remaining length of coil.
Automatic Alert for Reorder level
Employee Management System
Administrator restricted access
Automatic salary calculation
Customer Management System
User levels for Ease of Access
Restricted search
v
Software Platform Requirements
Server Machine
MySQL 5.0
Windows Server 2003
Client Machine
Windows XP/ Windows Vista/ Windows 7
JDK 1.6
Hardware Platform Requirements
Server Machine
Intel® Xeon® processor 5600 (or higher)
1 TB Hard Disk (7200 rpm) (or higher)
8 GB DDR III Memory (or higher)
Suitable Server Chassis (or higher)
Intel® Server Board S5520UR (or higher)
Client Machine
Intel® any processor above Pentium IV
120 GB Hard Disk
2 GB DDR II
Compatible Intel Motherboard
USB Mouse & Keyboard
vi
MANDATORY SOFTWARE INSTALLATION
INFORMATION
Installation of Factory Management System (FMS) Software at Client Site
The system is developed using a number of third party software products and tools that run on
various operating systems and server platforms. Reports from the software industry suggest
there are known security issues with some products and systems. It is recommended that, if you
are using FMS software, you review its use with your Information Technology (IT) department
and their overall strategy to ensure that all recommended security updates and patches are
installed as needed in your corporation. The initial installation will be done by the developers
and the configuration and database connections will be done as well free of charge.
If you experience difficulties accessing the application
If you experience difficulties accessing the application after standard installation on Windows
XP, Windows Vista, or Windows 7 please consult your IT department personnel to have proper
access permissions setup for your use.
vii
BSL Proprietary Licensed Material
CONTENTS
1 GETTING STARTED ............................................................................................................1-1
Welcome Screen .................................................................................................................1-1
User Levels .........................................................................................................................1-1
Sales Representative......................................................................................................1-2
Supervisor ......................................................................................................................1-2
Administrator ..................................................................................................................1-2
2 INVENTORY MANAGEMENT SYSTEM...............................................................................2-1
Adding A New Coil ..............................................................................................................2-1
Processing A Coil ................................................................................................................2-2
Errors in Inventory Management System.............................................................................2-3
Empty Fields...................................................................................................................2-3
Duplicate Values.............................................................................................................2-4
Other Errors....................................................................................................................2-4
3 CUSTOMER MANAGEMENT SYSTEM ...............................................................................3-1
Add Client............................................................................................................................3-1
Update Client ......................................................................................................................3-2
Delete Client........................................................................................................................3-2
Display Client ......................................................................................................................3-2
Client History.......................................................................................................................3-2
4 EMPLOYEE MANAGEMENT SYSTEM................................................................................4-1
Enter Employee Details .......................................................................................................4-1
Update Employee Details ....................................................................................................4-2
Delete Employee Details .....................................................................................................4-2
Search Employee Details ....................................................................................................4-2
View Final Salary.................................................................................................................4-2
Enter Allowances and Deduction to the system ...................................................................4-2
ix
Update Allowances and Deduction to the system ................................................................4-3
Delete Allowances and Deduction from the system .............................................................4-4
Set Allowances and Deduction to an employee...................................................................4-5
5 PROJECT DETAILS MANAGER..........................................................................................5-1
Manage Projects .................................................................................................................5-1
View Reports.......................................................................................................................5-2
6 CREATING USER ACCOUNTS ...........................................................................................6-1
x
EPRI Proprietary Licensed Material
1
GETTING STARTED
This software is tailor made for BSL therefore, this has to be installed by the developing team.
Incorrect installation might cause permanent damage to the existing data or database.
Welcome Screen
To open the Factory Management System (FMS) double click on the software icon located in
desktop. You will see the welcome screen displayed as below at the start. It will show you a
login window. Enter your user name and correct password and select the correct user level from
the drop down menu to enter your respective area.
Figure 1: Welcome Screen
User Levels
The system has the following User Levels. Sales Representative, Administrator, Supervisor.
1-1
EPRI Proprietary Licensed Material
Getting started
Sales Representative
The least powerful user level in this system. Can only insert and search BSL client details. Even
deleting the records are not permitted. Only can handle only Customer Management System.
Figure 2: Representative Home
Supervisor
The only person assigned to handle the Inventory Management System. Total power is given to
insert, update and delete.
Administrator
Most powerful user level in this system. Can enter into any subsystem other than Inventory
Management System. Project Management will be done by Administrator.
1-2
EPRI Proprietary Licensed Material
Getting started
Figure 3 : Administrator Home
1-3
EPRI Proprietary Licensed Material
2
INVENTORY MANAGEMENT SYSTEM
Inventory Management System allows the supervisor to handle the inventory of the BSL.
Adding A New Coil
Please Follow the following steps to add a new coil.
1. Enter Coil number in "Coil no" field.
2. Enter Colour in "Colour" field.
3. Enter Metal Type in "Metal Type" field.
4. Select Received date from the date picker.
5. Select coil thickness from the dropdown menu.
6. Enter the weight of the coil in the "Remaining Weight" field.
7. Enter Weight per length in "Weight Per length" field.
Figure 4 | Inventory Management System: Add a new coil.
2-1
EPRI Proprietary Licensed Material
Inventory Management System
Processing A Coil
Please follow the following instructions while a coil is being processed.
1. Choose one coil from stock table.
2. You can view the date the coil has been first processed.
3. You can view the respective project for which that coil is being processed.
4. Enter used coil length in “Used Length” field.
5. You can view the remaining coil length.
6. The system will show the used percentage of the coil.
Figure 5 | Inventory Management System : Coil Processing
2-2
EPRI Proprietary Licensed Material
Inventory Management System
Errors in Inventory Management System
Empty Fields
I. Please enter the Coil Number
Solution: You have left coil no field blank or you have entered in a wrong format. Please
check the format and enter the coil number.
II. Please enter the Weight Per Length
Solution: You have left weight per length field blank or you have entered in a wrong
format. Please check the format and enter the weight per length.
III. Please enter the Metal Type
Solution: You have left metal type field blank or you have entered in a wrong format.
Please check the format and enter the metal type.
IV. Please enter the Received Date
Solution: You have left received date field blank or you have entered in a wrong format.
Please use the date picker to enter the received date.
V. Please enter the Remaining Weight
Solution: You have left Remaining Weight field blank or you have entered in a wrong
format. Please check the format and enter the Remaining Weight.
VI. Please enter the Colour
Solution: You have left colour field blank or you have entered in a wrong format. Please
check the format and enter the colour.
VII. Please enter the Project Id
Solution: You have left Project ID field blank or you have entered in a wrong format.
Please check the format and enter the Project ID.
VIII. Please enter the Used Length
Solution: You have left Used Length field blank or you have entered in a wrong format.
Please check the format and enter the Used Length.
2-3
EPRI Proprietary Licensed Material
Inventory Management System
IX. Please enter the End Date
Solution: You have left end date field blank or you have entered in a wrong format.
Please use the date picker to enter the end date.
Duplicate Values
I. A Coil already exists under the provided Client ID
Solution: Duplicate coil number for inventory. There can’t be two coils with the same
number. Please check back and enter.
II. A Coil already selected to process
Solution: Already selected coil cannot be re selected to process. Choose a different coil to
process.
Other Errors
I. Enter valid length
This happens when used length is bigger than remaining length. Please enter the correct
used length.
2-4
EPRI Proprietary Licensed Material
3
CUSTOMER MANAGEMENT SYSTEM
Customer Management System allows to handle the customer deals of BSL. Only sales
representative
Add Client
1. Enter Client ID
2. Enter Client Name
3. Choose Rep Code
4. Enter Credit Limit
5. Fill Other fields as necessary (Can be left blank)
6. Click Add.
Figure 6 | Client Management System
3-1
EPRI Proprietary Licensed Material
Customer Management System
Update Client
1. Enter Client ID / Select record from table and move to form.
2. Update fields as necessary.
3. Client ID Client name fields are not allowed for updating.
4. Click update.
Delete Client
1. Enter Client / Select record from table and move to form.
2. Click Delete.
Display Client
1. Enter Client ID / Name/ Select Record and move to form.
2. Click Display.
Client History
1. Enter Client ID / Name/ Select Record and move to form
2. Click Client History.
3-2
EPRI Proprietary Licensed Material
4
EMPLOYEE MANAGEMENT SYSTEM
Employee Management System helps to manage the information about the employees of BSL.
Figure 7 : Employee Management System
Enter Employee Details
1. Enter Employee ID
2. Enter First Name
3. Enter Sur Name
4. Choose Department
5. Fill other fields as necessary (can be left blank)
6. Click Insert
4-1
EPRI Proprietary Licensed Material
Employee Management System
Update Employee Details
1. Enter Employee ID or select record from table.
2. Update fields as necessary
3. Employee ID field cannot be updated.
4. Click update
Delete Employee Details
1. Enter Employee ID or Select record from table.
2. Click Delete
Search Employee Details
1. Enter Employee ID.
2. Click Search
View Final Salary
1. Please go to the Salary section and follow the instruction given there
Enter Allowances and Deduction to the system
1. Please go to the salary section and follow the instruction to enter allowances. Standard
instructions apply.
4-2
EPRI Proprietary Licensed Material
Employee Management System
Figure 8 : Add Allowance
Update Allowances and Deduction to the system
1. To update allowances and deduction please follow normal procedures.
4-3
EPRI Proprietary Licensed Material
Employee Management System
Figure 9 : Update Allowance
Delete Allowances and Deduction from the system
1. To delete allowances and deduction from the system please follow the normal procedure.
4-4
EPRI Proprietary Licensed Material
Employee Management System
Figure 10 : Delete Allowance from System
Set Allowances and Deduction to an employee
1. Select an employee from the list
2. Add allowances and deduction to him
4-5
EPRI Proprietary Licensed Material
Employee Management System
Figure 11 : Set Allowances and Deductions
4-6
EPRI Proprietary Licensed Material
5
PROJECT DETAILS MANAGER
This manager helps to maintain details about the clients of BSL.
Figure 12 : Project Details Manager
Manage Projects
It has the common add, update & delete features. Go to Project Manager and follow the interface
instructions.
5-1
EPRI Proprietary Licensed Material
Project Details Manager
View Reports
Figure 13 : Reports home
5-2
EPRI Proprietary Licensed Material
6
CREATING USER ACCOUNTS
1. Enter Username
2. Enter Password
3. Confirm Password
4. Enter Employee Id
5. Click Add.
All fields cannot be left blank.
Same ID and username cannot exist for two users.
All fields are validated.
Figure 14 : Create User Accounts
6-1
EPRI Proprietary Licensed Material
6-1
