Quantity Available Shows as Blank Instead of Zero Value in Item Search

User needs  to see Zero values on Item Search where Quantity Available is indeed 0.

Edit the Search

2. Click  Results

3. Click Columns

4. Field:

  • Select  Formula (Numeric)
    •  Formula: Enter  nvl({‌locationquantityavailable},0)

5. Click Save 

Leave a comment

Your email address will not be published. Required fields are marked *