Hello QBPOS users! We are using Quickbooks POS v18.0 Desktop PRO, and yesterday completed a Physical Inventory. We checked the box at the bottom of the page "set all items not counted to zero" and we counted for 8 hours. We did the final "Enter" and the items counted were all correctly adjusted, but the items not counted were not adjusted to zero. Therefore, there are still negative and positive inventory showing up on some items, which is incorrect. This has happened during physical inventory for about the past 3-4 years. We check the box but the items we don't count are not zeroed out. How can we fix this?
Thanks for giving us the opportunity to help, CapCellarsKY.
I'd love to to help you with while working with physical inventory in QuicKBooks Desktop.
Did you apply the changes after hitting set all items not counted to zero? The negative and positive inventory usually shows up if you failed to save it.
I've added an article to learn more about the process of performing Physical Inventory for QuickBooks Point of Sale: Perform a physical inventory
If the same issue persist, I'd recommend contacting our QuickBooks Point of Sale so they can take a closer look at the issue. They have the necessary tools to properly investigate on what's causing these negative and positive inventory showing up on some items.
Should you have additional questions while working with Physical Inventory, just fill me in and I'll get back to you.
Thank you. We did keep the box checked while we were doing inventory, and we "saved and continued" through out the process. At the end you have to "accept changes" and that was how we saved it. But the products that were not counted were not set back to zero.
Hi there, @CapCellarsKY.
Thank you for the quick response. I'd be happy to get you to the right support to get this resolved.
POS should have set the account of all uncounted items to zero. Since you've already placed a check on the appropriate box and still didn't effect, there could be an issue with either the data file or POS application.
To fix this, let' try to run the Verify Data utility in QuickBooks Desktop Point of Sale to find damaged transactions, lists or SQL table structure in your company file. To start, let's make the Debug mode accessible.
After that, you can run the Verify utility.
If you get the same result, I recommend the following article for more troubleshooting steps: Use the Clean Up Company Data Utility.
For additional help, I suggest calling our QuickBooks Point of Sale Support. The phone support agents have the tools to check your account and can initiate a screen sharing session to assist you in getting this resolved.
Please know that the Community has your back if you need assistance about inventory. Wishing you and your business continued success.
I see that the question has been solved, but I think for future reference I think the following is how you fix (at least) negative inventory.
To locate any negative inventory, you’ll need to run an Inventory Valuation Detail (IVD) report in QuickBooks:
So, you’ve found when negative inventory has taken place, so let’s move onto how to fix it:
Alternatively, you could check out the QuickBooks App Store for a solution to tracking your raw material and finished goods. For example, Katana can integrate with your QuickBooks account, allowing you to manage your entire business (especially your manufacturing processes) in Katana, and simply push over your receipts and invoices back to Katana to keep on top of your finances.