Display Item's Last Purchase Order Price on Saved Searches regardless of Purchase Order Status

Answer/Solution:

1. Navigate to Lists> Search> Saved Searches> New> Item
2. On the Criteria tab> Standard sub tab, set the following:
    - Transaction : Type is Purchase Order
      
3. Navigate to Results tab >Columns subtab select the following:
  Field | Summary Type | Formula
  -Name | Group
  -Formula (Currency) | Maximum | MAX({transaction.rate}) KEEP(dense_rank last order by {transaction.trandate}, {transaction.datecreated})

4. Enter Search Title and click Save & Run button