cancel
Showing results for 
Search instead for 
Did you mean: 
JessP1
Level 1

Inventory Valuation vs Inventory Quantity Adj

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

 

2 Comments 2
DivinaMercy_N
Moderator

Inventory Valuation vs Inventory Quantity Adj

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:

  1. In your QuickBooks Online (QBO) account, go to the Reports menu.
  2. Type Inventory Valuation Detail in the search field.
  3. Once opened, set the specific date range. You can also select All Dates to further examine where the 227 is coming from.
  4. Then, to make the report more specific, click the Customize button.
  5. From there, apply filters and add or remove the columns you need.

 

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:

  • Ctrl+ Shift + N for Google Chrome 
  • Ctrl + Shift + P for Mozilla Firefox 
  • Ctrl + Shift + P for Edge 
  • Command + Shift + N for Safari

 

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. 

JessP1
Level 1

Inventory Valuation vs Inventory Quantity Adj

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!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us