Develop a Purchase Order System

Project Description:

Purchase Order (PO) is one of the first steps in the ordering process of a store. Before, we rely on manual computation to merge the POs we made, we use papers to locate the preceding orders we made to a specific supplier. Presently, we put our POs in an excel file for consolidation and for provision of a simple summary. Since the data base we input into the Excel file is getting bigger, and our computer is a little old, the process is getting really unreliable and slow. Also, because this is handled by only one encoder, it is overriding a lot of time.

What we require is to have a web-based application to transfer the complete processing load to the server and to have multiple users access the system to hasten the transaction. We also require summary reports via online and via Jasper Report.

Description of System:

1. It is a Purchase Order System. I believe it is a little similar to an Inventory System. This can be deployed locally.

2. A User should have a login and logout module, with User Groups (Encoder, Administrator etc.), and Modules (Add, Delete, Edit, etc.) for permission.

3. Apache Tomcat Server and Java EE for the web-based application.

4. MS Access or MySQL for the database.

5. The flow will be like this:

• Buyer can make a PO.
• Heads will approve first before receiving is allowed.
• Once approved, Receiver can receive PO.
• Heads will see summary of purchases.

Coming from the Excel file we are using, these are the modules I will see that needs to be done to restrict users accessing the system to their designated task:

1. Add Purchase Order

2. Edit Purchase Order (Disabled when Received)

3. Delete Purchase Order (Disabled when Received)

4. Receive Purchase Order (Can only be Cancelled)

5. Cancel Purchase Order (Can be deleted but not edited)

6. View Purchase Order (Search By: Supplier, Sub-Category, Main Category, Delivery Date, Payment Date, PO Number, PO Date)

7. Approve Purchase Order (Department Head)

8. Approve Purchase Order (Division Head)

9. View Purchase Report (Purchase Summary - Category, Purchase Summary - Category/ Buyer, Purchase Summary - Category/ Supplier)

10. View Purchase Report via Jasper Reports

Skills required are Java, JSP, Microsoft Access, MySQL