Would like to use scanner for physical inventory

Question

So far we have managed to do our physical inventory manually, which is rather cumbersome. I would like to use a scanner to scan in the items, enter the quantity counts, then total all quantities per item and import into RMS SO (using V2, SP2).

I am looking for some suggestions for a good scanner and some instructructions for the RMS update.

Thanks in advance.

Gerd

DW · Accepted Answer

Gerd,Are you looking for a wireless, Batch, or wired scanner?Daniel          Tech SupportNuRol Point of Sale404-352-3587"Gerd" wrote:

Mikeh · Answer

Mikeh had written this in response to :The standard process in RMS is a bit cumbersome. There are many differentadd-ons with different pricing and features that can make it a breeze.Call me or email me and I can send you some options. Mike 800-513-5917 x123-------------------------------------Gerd wrote:##-----------------------------------------------##Newsgroup Access Courtesy Tax and Accounting Software ForumsWeb and RSS accessto your favorite newsgroup - microsoft.public.pos - 36648 messages andcounting!##-----------------------------------------------##

Doug Pic-N-Pac · Answer

Hey Gerd Im not a retailer just like you. Look on ebay for a batch scanner you can pick one up for under $150 and use what you have been using. Its very easy and in my opinon you dont need any add on software unless you jsut like spending money. "Gerd" wrote:

Paul Houston / · Answer

Just a point of Fact we have been using a PSC PT2000 Top Gun with good success. However It is no longer available. I've been testing the Metrologic Optimus R and it seems to fit our needs as a replacement. It is also not going to break the bank.

Also the Metrologic scanpal 2 seemed as if it would also work.

We do use wired batch terminals. Wireless is also available

Paul H

"Doug Pic-N-Pac" wrote:

Marc · Answer

We also use the Metrologic Optimus as a data collector. We use it for receiving and collecting sku's for label printing too. It works good for the price.

We use the Worth Data Tricoder too, more than twice the price but rugged (w/ rubber case) and louder beep tone. Just replaced one after 14 years! We find the low volume beep tone on the Optimus to be a problem, especially in a noisy environment, . it is hard to always hear the beep, so we have issues with double scans or missed scans. if they would put a louder/better speaker on the Optimus it would be awesome for the price.

Marc

Gerd · Answer

Thanks for all your suggestions. Very helpful.

But one question remains. Now you have all the inventory in the scanner, how do you "consolidate" it and then import it into RMS? That was always a manual step for me. Do you then use that "not supported" import tool that existed from Quick Sell times. It sure always (and still does) bothered me that MS could not even provide a supported import tool. That should be part of any base package.

Gerd · Answer

Probably a wired scanner. I am not familiar with a batch scanner but saw that mentioned at other places.

Sammy · Answer

In Store Ops Manager, under Inventory then Physical Inventory create a new inventory count.  If counting entire store set it to selected group and all items.  This will load all items. Enter a Reference number and Description for your physical inventory.  Upload the data from the data collector.  In Store Operations Manager Click Import File.Chose Next on the welcome screen.  Screen displays File to import and File type. Chose Next set field delimiter and field positions.Chose Next.  select import options. and chose next.  Screen shows import results.Take note of any entries marked with a red !.  This entries will not be added to the counts.Chose import.  Periodically chose ok at the bottom of the Physical Inventory Count sheet to save your progressChose Properties to recall Count Sheet.  When inventory count is complete click Calculate to compare the physical inventory to the Store Operations databaseClick ok  To go back and re-enter counts for any entries click RecountTo approve the...

Would like to use scanner for physical inventory

Join the Discussion

Didn't find your answer?