When doing a Physical and using the inventory wizard to import a CSV file there are only two options for items and quantities. Items have “Update matching items only and Update matching items and add new items.” This creates a problem, if I miss counting an item or the item is not at the store it does not show up on my discrepancy report. For example, I have one lamp at the store and miss counting it in the inventory. The lamp will not show up on my discrepancy report and will stay in RMS as if I did count it in. This also creates a problem. If an item before doing the Physical shows a quantity in the store and the item is not in the store and is not counted when I update the inventory it will still show up in the store as if I did count it. Is there a way I can do more than just “Update matching items and add new items?” I want to update all items even if it wasn’t a matching quantity and see what we may have missed counting and what is not is actually in inventory.
*This post is locked for comments
I have the same question (0)