Scenario:
A user seeks a way to customize their Inventory Valuation Report, specifically aiming to exclude items with zero value.
They already tried to unmark the Show Zeros in the Inventory Valuation Report options, however, they still see items that have more than 0 quantity but with zero value.
Solution:
To be able to exclude items with zero value from the Inventory Valuation Report:
- Navigate to Reports > Inventory/Items > Inventory Valuation
- Click Customize
- Go to the Filters tab
- In the Add Fields section, expand the Quantity On Hand folder
- Click On Hand Value field to add it to the report filters
- Set the filter value to "not equal to 0"
- Enter a Name for the custom report
- Click Save
Related article: NSC | Hide Zero Quantity Items in Inventory Valuation Report
-----
If you find this information useful, let us know by reacting or commenting on this post!