Create an Item search that will show zero instead of null if there are no On Hand, Committed and Available quantity

Adding On Hand, Available, and Committed returns a null value if the value of the field is zero

 

Create an Item saved search through the following:

1.       Go to Reports > Saved Searches > All Saved Searches > New > Item

2.       Add Formula (Numeric) | Formula = nvl ({quantityonhand},0)

3.       Repeat step 2 and select the corresponding fields for Quantity Available and Committed


Note: This is a workaround for Enhancement 187927 and this can also be used for Location On Hand, Available, and Committed quantity