1. Home
  2. Point-Of-Sale Software
  3. Inventory Update

Inventory Update

I have just completed a complete count of my inventory using a scanner on version 1.2 of RMS. The physical inventory report shows what I counted and what the expected qty was - no problems. However review of my system shows that there are a large number of inventory items showing a negative count ( ie -1 ) and there are items showing showing a quantity in stock ( ie 2 ) when I did not count stock for that item after I have completed my inventory. I thought a complete inventory count would zero all items that I had not actually counted as having stock. Any thoughts on what I have done wrong ?? Thanks

Reply to
Ned
Loading thread data ...

Ned,

Have you sold or received product since your count time & date?

Reply to
Jeff

To add to Jeff's question, did you create a blank count sheet or did you choose all items?

Rob

Reply to
Rob

Ned,

I'm confused. If you didn't count it and make an entry for it, why do you think it would have changed from 2 to anything else? If you really only had

1, you should have counted it and made an entry saying that you only had 1 on hand. The other would have shown up as a discrepancy.
Reply to
Jeff

When using a blank count sheet if you don't count the item it does not get added to the discrepency report. So what you could do to fix this issue would be to recount using a count sheet that has all the items added to the count sheet to begin with. That way if you don't count an item then that item gets changed to 0 and if the system is expecting something other than 0 then you have a discrepency. Or take your existing count sheet and...

  1. Press the Calculate button.
  2. Then press the Print button and when you get the filter screen just Press OK.
  3. Right click on the body of ther report and remove all the columns except for the Item Lookup Code and add Date Counted and Quantity Counted.
  4. Export the report to a CSV file by pressing the Export button in the Toolbar at the top of the report window.
  5. Next hold down the Shift key and Right Click on the save CSV file and Open With Notepad. (Reason being if you have any items that contain only numbers and start with zeros, opening with Excel will delete those zeros.)
  6. Delete the report information from the top of the file and Save the report.
  7. Next create a new Inventory count sheet with all your items.
  8. Press the Import button and follow the Wizard to import into the newly created count sheet. You should now have a count sheet with the items that you counted and all the other ones you did not. Calculate and Commit the count.

Rob

Reply to
Rob

Thanks for the reply. I'll follow your instructions and create my new Inventory count using the following path: Inventory / Physical inventory / New generation selection - generate for all items in the selected group group selection - all items

I'll let you know what happens.

"Rob" wrote:

Reply to
Ned

Hello Rob,

Thanks for the > When using a blank count sheet if you don't count the item it does not get

Reply to
Ned

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.