Show only Parent Location of an Item in Item Saved Search

To show only Parent Location of an Item in Item Saved Search, use the following formula.

Under Criteria Tab include,

Filter: Formula (Text) 

 Description: is 1

Formula: CASE WHEN {‌inventorylocation.name}={‌inventorylocation.namenohierarchy} THEN 1 ELSE 0 END

Leave a comment

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