Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I'm trying to enter inventory quantity adjustments for year end. When I run the inventory valuation reports I'm seeing quantities on hand for all of the products that are very different from the quantity on hand that is populating on the "inventory quantity adjustment" sheet in QBO.
For example, one product is showing 37 units on both the inventory valuation report (which is correct) and the products/services listing, but when we bring up the inventory quantity adjustment sheet it's showing 227 for quantity on hand.
I have no idea where the 227 is coming from, how to drill into it or how to fix it. Needless to say, we can't update the inventory for year end because the quantities are not correct.
Any insight would be greatly appreciated
Hello there, @JessP1. I want to ensure you'll be able to adjust your inventory quantity smoothly.
To isolate the issue, let's first run the Inventory Valuation Detail report to drill down the information and activities made for the specific items in your product and services lists. Here's how:
You can also perform basic troubleshooting steps. To start, let's run your QBO account in an incognito browser. The private mode does not store data files that might cause issues when running websites. Below are the shortcut keys you can use:
Once signed in, attempt to enter and Inventory Quantity Adjustment again. If this works, clear the cache of your regular browsers to eliminate old files and to have a clean slate. If the same thing happens, I'd recommend using another supported browser. To optimize your QBO experience, we have to ensure that your browser meets the minimum requirements when running the program.
However, if the issue persists, I'd suggest reaching out to our Customer support team. You can request a screen-sharing session so they can further investigate why your Inventory Valuation report does and the Inventory Quantity Adjustment page doesn't match.
In case you need helpful articles or links to serve as your reference in performing your QuickBooks task, feel free to browse through our QuickBooks Help articles page.
Feel free to leave a reply below if you have any other QuickBooks concerns. I'm just a few clicks away to help. Have a good one.
Thank you so much for these helpful tips! I tried all of them and I'm still seeing the same thing in that inventory quantity adjustment screen. There is so place within the inventory valuation report that shows over 200 of this specific product which is so strange. I'm filtering on the same dates and the valuation shows 39 as of 12/31 and the inventory quantity adjustment has 227. I'm going to reach out to customer support to see if we can do the screen share per your suggestion.
I did notice that this weird problem seems to be for 3 specific products and the rest are working just fine (the valuation report matches the inventory qty adj sheet). I did find a workaround for the 3 problem products - going into the Product listing screen and adjusting the quantity as of today's date, then updating the inventory qty adj to be as of 12/31/21 with some tweaks get us there. It's not ideal but for now it should work.
Thanks again!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here