Count Inventory with a USB Barcode Scanner

I just purchased headquarters for all of my locations running RMS. I need to do physical inventory counts. I would like to bring my laptop to each location and hook up a USB scanner to do the physical inventory counts. We have many matrix items (Size, Style, and Color) and it would be much easier to just scan the barcodes and let the computer determine the counts.

Is there an affordable way to do this?

Reply to
Scott S
Loading thread data ...

I have a category called "Supplies" that I would put all of that in. However, "personal care" will give you more detail, if you need the detail.

I used to categorize in great detail. After I found I didn't need much detail, I consolidated categories. If an item isn't tax or business oriented, I don't need much category resolution. I don't use the budget feature in Q either so I'm not the best one to respond. If you don't use the budget, ask yourself, "Do I ever foresee the need to make a report on what I spend for personal care?"

Reply to
Rick Hess

Hi Scott

You could connect the USB scanner to your laptop, open a text editor like NOTEPAD, put the laptop on a pushcart and start scanning away. Each scanned barcode will get saved in the notepad document (.txt file)

Then open the notepad file with excel and put a "1" in the second column, so that your excel spreadsheet has the barcode scanned on the first column and a "1" in the second column. Save the excel spreadsheet as a TAB delimited text file. Transfer the file to the machine running store operations manager.

Create a PI in the store operations manager, and use the IMPORT FILE button to bring in your text file as your "counts". Finish the PI as you normally would.

H> I just purchased headquarters for all of my locations running RMS. I need

Reply to
convoluted

Scott,

We rent inventory scanners for $300 a week, we have 2 different kinds, Both are batch scanners and can be used to scan all your items, they will add a date code so that when your doing your inventory you dont have to close your store.

The scanners have different options, you can use the ones that you can load a lookup file so if something is scanned that is not in your ssytem it will beep at you to set it aside, other options provide just scan the barcode and it continually adds 1 with a date stamp or you scan the barcode and enter a qty.

If your interested let me know.

Give me a shout if your interested.

Reply to
maurice

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.