I have a need to track some inventory running through my plant. I want to do it by barcodes. I have found many purchased systems and they are just overloaded with features and are extremely expensive.
All I need to track is a work order going through 4 check points and how long they work order was in that location for.
Information that needs to be included are:
Work Order number
There is a slight kink in the mix where I need to possibly adjust quantities in a work order because sometimes the Work order gets broken up into two work orders. Same work order number just different ID and quantity.
I would like to use SQL or possibly Access. Anyone know of a great off the shelf simply cheap solution here or would my best bet be to just program a solution myself?