5 replies to this topic

[hewbahrami]

Hi,

I have a scanner which reads Code 128. I am looking to create some sort of inventory control system via scanning my assets and having an excel worksheet be populated with relative information (i.e. Description, Serial Number, Location, Price, etc.). Most of the information I want to be gathered is fixed, while some need to be entered by the user. Can anybody help me with this?

Much appreciated

[WingedPanther]

A barcode scanner is just a funny looking keyboard. I have an application for handling barcode entry that I test using a regular keyboard. The real issue is: what do you want to accomplish with this?

[hewbahrami]

I need to track the movement and costs of consumable goods. That way I'll know which departments in my company are consuming which items and what/when to order more supplies, etc. Thanks for your help.

[WingedPanther]

You need to be a little more specific. There are a LOT of different ways to handle inventory tracking. This ranges from every time an item is brought in/out of an area it gets scanned, to entering information about where it's going or whether it's being received, to ...

You have to decide what the user will see, what information will be collected, etc. Then you'll be able to start programming this.

[hewbahrami]

I will try to be as specific as possible, but I'm not sure if I'm certain on how this works to begin with, so please bear with my description. Essentially, I want a system where I can scan incoming items that our company orders regularly, such as a Cyan Dell 5110CN toner in and out of different locations. Each of these items would have a general barcode (that I create for a each Make and Model) that automatically indicated Description and a default location. Users would then be prompted to enter information such as Price, Serial Number, and Asset ID Number manually. This information would be stored in the scanner's Pocket Excel and then later synced with my computer. At this point items would be scanned in, indicating their receival. When items are moved, (now I'm not sure if this is possible) they are scanned again and the user is prompted to change the location. And finally, hopefully I can import the Excel spreadsheet in Access to manipulate the information and track items and cost recovery.
Is this realistic?

[WingedPanther]

It's very realistic. I know of several companies that sell software that can handle this (inventory management systems).