Guest I need an inventory control solution. I get items in for training, store them, and then issue them out to customers. I then receive them back and need a system that will track what I have on hand and who it is issued to. I would like a system that can assign a bar code to each items so I can scan it out and in. I also need to be able to save my data to Excel or Access or be able to export it to Excel or Access

Since your application involves checking items in and out to specific users I would suggest the RedBeam Check In/Check Out software. This software tracks all items individually and by their location/user. Each item will have a unique bar code and as you issue the products to users you can scan each one to assign it to that specific user. Return dates can be assigned to each item and with the host of reporting options you will always be able to see what you have in house and who has what checked out items. This system can be paired with a tethered scanner like the Honeywell 1300g if you are at a fixed station as well as with a device like the Motorola MC55A for a full solution. All of the data can also be exported to an Excel file for further logging or processing.

Filed under: Question and Answer

Posted August 18, 2010