Skip to main content
December 11, 2024
Question

Filter out zero inventory - no longer functioning option!

  • December 11, 2024
  • 1 reply
  • 0 views

Every Monday for months now, I have printed an inventory report showing all of my stock but filtering out any product that is not greater than zero. However, on Monday 12/9/24, this option no longer functions and it appears QBO has removed it entirely. I'm not sure why they would have removed this feature or how to get it turned back on but I can no longer provide reports to my customers of what we have currently in-stock. How can this be fixed so I can get back to business and provide my customers a professional looking report to show what we have in-stock? 

 

BTW, I tried chatting with a QBO rep online but they wanted me to spend 1-2 hours with them troubleshooting the problem rather than just reporting it and getting back to me. Apparently, Intuit doesn't understand small business and their time is limited and we pay for this product and have an expectation it works.

1 reply

Candice C
December 11, 2024

Hey, @jay87.


Thanks for bringing this to the Community! We appreciate you reaching out about filtering your inventory report to exclude items with zero quantity.


To help us pinpoint the issue, could you clarify which inventory report you're using?


In the meantime, you could try the Inventory Valuation Summary or Inventory Valuation Detail reports and see if their customization options help achieve what you need. Another option is to use the Physical Inventory Worksheet under reports and sort it by quantity (high to low) to push all zero-quantity items to the bottom.
 


Here are some resources that might be helpful:

 


We're here to help you find the best solution! Please let us know if you have any more questions.

jay87Author
December 11, 2024

I am using the product/service list report and customizing it with filters to only show products in-stock. Those other reports do not show what we need and aren't useful to our customers. This report has worked flawlessly for months and now they've decided to screw that up. The Intuit software engineers, just can't leave well enough alone.

JenoP
December 11, 2024

We appreciate your feedback about the changes to the inventory reports in QuickBooks Online, jay87. I know that it can be a little challenging when an update alters a familiar workflow that has been reliable for months. Let me address your question about this.

 

As you may have observed, the majority of the reports have already been migrated into the Modern view settings, including the Product and Service List.

 

Currently, the ability to filter out items with zero quantity on hand is not available in this new format. You can read more details about using the update in these articles:

 

 

For now, you can export the report as an Excel or CSV file so you can apply more filters to your data. Just click More actions and choose Export to Excel or Export as CSV.

 

I know this is a significant change from what you're used to. We're constantly working to improve our software based on user feedback.

 

Having said that, I'd like to guide you on how to submit feedback about the changes to the reporting function in QBO. You can send them directly from your QBO account. Let me share this article as a guide: How do I submit feedback?

 

To help you navigate the reporting features in QuickBooks Online, I've put together these resources:

 

 

If you have any more questions or need further assistance, please don't hesitate to reach out. Whether you're looking to fine-tune your reporting or need help interpreting your financial data in QBO, The QuickBooks Team is always ready to lend a hand.