edvella.com software portfolio - order database software

The Order Database program is a software developed in Java. It allows the Procurement Department to keep track of the company's orders and their status. The program can either work as a stand-alone application or as an applet on a website. A MySQL server installation (available freely) is requried.

When I started working on this program, the goal of the order database was to replace an existing system where records were stored on an Excel spreadsheet and reports had to be worked out manually at the end of each month. Moreover, implementing a client-server architecture would allow the database to be accessed from multiple locations and from multiple users simultaneously. This program was my first 'real' application in Java and it turned out to be very useful.

The program includes common supply-related fields which can be added during the different stages of the ordering process, such as purchase order number, project name, order date, supplier reference, invoice number and description. The user can manage the product categories as well. Each order can be tagged as processed for payment and reports showing order details and orders pending for payment are automatically generated.

Order Database screenshot: (data in image is grained to protect privacy)