an inventory/accounting system using java?
First let me introduce myself.
I am a complete noob to java. I have done an OO programming course which used java, and i struggled on it because i had no experience of java. i spent hundreds of hours going through coding by trial and error to complete assignments which i eventually did ok on, but the terminology hasn't stuck nor has the principles! But what i have done is variables, methods, selection, iteration, classes, sub-classes, inheritance,creating objects, dealing with arrays, sets, maps and lists, etc.
However, from my limited experience, I think that Java is probably the best way to undertake a project that i have, but what i'm wondering is - does something already exist - either open source or paid-for packages?
if not can somebody give me some advice if this really is the best way. Or, if there are any other software packages that will do the job. I have come across some accounting/inventory control packages for manufacturing companies, (which are expensive) but I would like something a lot simpler which would be customised to my needs.
The project is buying blank cd's, cases, labels, etc. manufacturing various cd box sets - single cd's, 2cd packs, 3 cd packs, 4 cd packs, etc, then eventually selling the box sets.
What I need to do is to record the purchases of each of the consumable items - blank discs, cases, etc. increasing stock levels and values of each consumable, then when i create a product - such as a 4cd box set, for example, I would decrease the consumable levels by the amount used to make each product, and then increase the stock levels of the individual product. Then when I sell that product, to decrease the stock level of that product.
So for example:
Purchase 100 blank discs - increase stock level & values of discs by 100.
purchase 100 labels - increase stock levels & values of labels by 100
purchase 50 cases - increase stock levels & values of cases by 50.
manufacture 20 of 'product a (1 disc, 1 case)' - increase stock levels of 'product a' by 20
but also... decrease stock level and values of discs by 20, of labels by 20 and cases by 20.
Then when i sell, say 2 product a's, decrease the stock level and values of the number of product a's i have.
The program should also enable me to:
look up and check the stock level and value of anything at anytime,
add new consumables,
add new products - by inputting name, etc, number to be added and also what consumables are used to create that product, so then when I manufacture more of the product, it automatically decreases the stock level of consumables used, etc.
give a summary of how many of each product has been manufactured and sold,
give a summary of how many of each consumable has been ordered, and how many converted into products.
The system is not simply 1cd to 1 case, but there will also be 2cd's in a 2cd case sets, 3 and 4 cd's in a 4 cd case, and 5 or 6 cd's in a 6 cd case set.
So there will be, in total, about 5 different types of cases, blank cd's, blank dvd's, labels, sheets of paper (to print case sleeves on).
And then, eventually hundreds of different products comprising of different quantities of each.
It would also be good if it could be in a windows type interface, or in html.
Would it have to also have access to a database, or can the program just add to arrays or lists or sets or whatever to keep track of everything?
I've probably bitten off more than i can chew with this, but I'm sure that OO programming is the best way to do this.
I'd appreciate any help/advice you can give.