Resolve Multiple Lines Result in Saved Search When join field 'Item: Inventory location' is Added

_{1. Navigate to Lists> Search> Save searches> New}

_{2. Select Transactions}

_{3. Under the Criteria tab> Select the following filters:}

_{---Type is Purchase Order}

_{---Location is none of -none-}

_{---Location field is Inactive = No}

_---Date

_{---Formula (Text)}

_{DECODE({location}, {item.inventorylocation},'1','0')}

_{Starts with = 1}

_{4. Under the Results tab> Add the following columns:}

_{---Item fields is Inventory Location}

_{---Item fields is Location On hand}

_{5. Rename the search and hit Save and Run.}