1. Home
  2. Point-Of-Sale Software
  3. performing physical inventory check

performing physical inventory check

Hi all,

We trying to do an inventory check of our store with over 25,000 items.

All my items are scattered everywhere (two floors) and it seems almost impossible to filter by supplier, department or catergory. I think my only option is to check "all items" at once.

I plan on using 2-3 notebooks with barcode scanner attached for the counting. I want to know if there is any way 2-3 people can start counting on the same count sheet created under "Physical Inventory"?

When I tried it, it doesn't automatically add up counts from multiple computers. Or is there a feature in RMS that allows CSV output of counting? Then I can output CSV file from each computer and add them all at the end?

Sorry for the long write up but any help/comments from experienced users will be really appreaciated!!

Thank you in advance,

Ken

Reply to
Ken
Loading thread data ...

One thing you may want to consider to make it easier in the future(but probably wouldn't help you now) would be to use bin locations. Maybe with the upstairs as one location and the downstairs as the second location. I know it seems like a daunting task, but it really would be worth the effort to try and set up some bin locations to help sort your counts. Craig

Reply to
Craig

Reply to
convoluted

Dear Craigs,

Thanks for the reply. I understand your point.

The problem is some items are stored at the main floor and basement.

Ken

"Craig" wrote:

Reply to
Ken

Dear Convoluted,

Thanks for the reply.

I actually don't have handhelds. I have notebooks with barcode scanners that are wirelessly connected to the RMS server.

One person could start a count sheet and finish one floor then move to the second floor and keet adding to the same count sheet. This would be the easiest but may take upto a week since only one person can work on the sheet.

I would like to know if multiple ppl could the count at the same time. The problem I have is they could be counting the same items at the same time at different floors.

Thanks again! any comments are welcome!!

"c> Hi Ken - my understanding is that you only want to "add counts" in one

Reply to
Ken

You could use the notebooks like a data collector by scanning into a file on each of the laptops. I am not sure what the file format is for inventory count imports sheets, but I think you can map the fields and it should not be hard to work out.

Reply to
Marc

Reply to
convoluted

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.