Share
ReportHi Folks
Looking for a way to speed-up our inventory taking. Here is how we did it in the pass - download a CSV from RMS by department ie: Itemlookupcode, Qty, Description . We put this data into a spreedsheet on a laptop (watching on how we import since we have ILC which are alphanumeric) - sorted by ILC.
Go around store Ctrl-F (enter ILC number) , count quantity, add amount in new column - if off by alot we put a star beside it - in case we have some more items somewhere else.
I do have an extra USB Metrologic USB scanner - so I could add Alias to the download which is the existing barcode on the item in addition to our ILC. Not sure that would save me alot of time or not? We also have done in the past, a paper version - print-outs of spreedsheets and had inventory takers highlight any ILC where quantities On-hand didn't match. This was good since it provided us with a hardcopy of the inventory - to track down potential mistakes.
After inventory is done we do a CSV inventory import via RMS inventory> Physical Inventory etc...
Any suggestions would be appreciated. We usually setup a few laptops and each person goes and does a different department.
Thanks
Danny
Single Store about 5000 unique ILC, 20,000 items in 11 Departments
*This post is locked for comments
All responses (
Answers (
35
