With trying to improve the workflow and keeping better track of all the orders and scheduling of jobs for a department I worked in, I expanded a Excel document, that I started with, to a point where I was looking to make it more effective and practical and got the idea to write my own application.
Now I have a working application that is used on a daily basis at that department. The application has significantly improved workflow and reduced time of monotonous tasks through automating them.
The application launched end of May 2017. I wrote the application in Java (Desktop application) and used MySQL for the database. For ‘live’ data there is also a connection to Sage’s database to get live data on products and their status.
Features and Benefits:
- Have one file/application to access all the information in one place.
- Have the file/application accessible to everyone in the department.
- Auto-complete job cards just by selecting the job number.
- View ‘live’ data for a specific item, what is on hand and what is on order from overseas suppliers in conjunction with a connection to Sage’s Database.
- Generate monthly report with all open orders and completed orders for the previous month.
- List all of the items and their components that are on order with quantities.
- Searching for information.
- Statistics for orders placed on a unit or on a component (By month for the current and previous 3 years).
- Check availability of component showing currently on order, what
Main Menu – Where it all starts…
Overview – See what is happening this week…You will be able to see what has been scheduled for today and this week. Overdue job/tasks can also be seen in this window.
Add Jobs – Well we will have to input some job’s, to begin with…Top section items are all mandatory, the second section is optional, the third section is for clear, create and back button and the fourth section give some notes for adding jobs.
View Jobs – Seeing all…View and filter through jobs.
Monthly Report…Here the monthly report is generated. The list shows all outstanding jobs in the first section and the second shows completed jobs in selected date ranges.
Viewing and/or searching components that are on order…Search which components are for which jobs and/or part numbers. Mainly used for the one brand item, but can be used for other ones as well.
To be or not to be machined…For the items it is set up for, can be seen what is required to order or to send for machining to get the final item. Also shows how many items are on order and what the shortages/overages are. Also shown is some information about the item that is made.
Product status…This shows a breakdown of the quantities of the selected product. Total of which is on order and what quantity is for what type of job.
Product Usage…In this window, a CSV or JPEG file is created showing quantities in which year/month that the product was ordered
Component status…This shows a breakdown of the quantities of the enter product. Total of which is on order and what quantity is for what type of job as well as on hand and on order at suppliers. The detail tables show more information about the product as quantities in which bin locations, on order with E.T.A. dates as well as the supplier and order number. The intransit quantities are also show, if any and the costs for the product.
Component Usage…In this window, a CSV or JPEG file is created showing quantities in which year/month that the product was ordered
Searching and Creating:
Search…There is searching for job card/ID numbers, searching jobs (through all information in the job), searching through part numbers and items set up for machining.
Generating…Selected the document opens up for review/modification before printing.
Job Card…Similar to the job card that I used at the beginning after creating the application.