Store Ops Physical Inventory Process

It is easy to use a portable data collector to scan UPC barcodes, RMS barcodes, etc. My problem begins when the delimited text file is being imported.

About 1% or 2% of the time, my scanning people scan the wrong label. They get the manufacturer's internal barcode, or whatever might be on the packaging. If one looks at the text file, it looks normal. You only know that you have a problem while in the middle of the import process. If the barcode doesn't match an ILC or an Alias, it is flagged as an "Entry with errors". Now, I have no idea what they were scanning.

In my previous POS system, one could at least see what came immediately before, and immediately after the 'bad' data.

0099999 Glove XL 0099997 Glove L 009120 "entry with errors" 0099996 Glove S Once I saw this data, I could tell them "Go re-scan whatever came between the large & small gloves".

I wish I could print the data that is on the screen at that point in the import process. I can't print it or copy it to the clipboard. I can only take screenshots.

Surely someone else has this problem. Any workarounds?

It would help to know which tables hold the data in the StoreOps database. I could at least get at it with a report.

Tim Gale Bicycle Garage Indy, Inc.

Reply to
timgale
Loading thread data ...

Store Operation can't add an item that is not in database. The inventory process allow to add new item if the itemlookupcode isn't present.

Do you have file with items, or make the list by hand?

Antonio

Reply to
Antonio Mazzeo

Reply to
timgale

i don't use the file import feature but scan our items directly into RMS during the physical count process. during this process we can scan either the UPC (our itemlookup code) or other barcodes on the box that we have set as an alias for that item (like the vendor part number, etc.) i'm assuming that if you import an alias, it will add it to the correct itemlookup code. if i'm wrong i apoligize

having said that, have you considered adding these other barcodes on your items as alias? obviously this won't work if these barcodes are unique to each individual item and change all the time, like serial numbers. i cannot tell from your post what specifically these other barcodes represent.

so you may be able to avoid the trouble of RMS not recognizing these barcodes when an employee scans them, but adding them as an alias to the itemlookupcode of the item box that they are on.

hth kevin

Reply to
kskinne

Tim,

If you want to see where it was scanned, try going into Notepad and find the code in question. Using the surrounding items on the list you should know where they were when it was scanned.

Good luck, Matt

Reply to
Matt

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.