Display Last Invoice Date of Item on Saved Search

Answer/ Solution:

1. Navigate to List > Search > Saved Searches > New > Item

2. Under Criteria Tab > Standard Subtab, add the following filters.
       Transaction : Type = is Invoice
       Inactive = No

3. Under Results Tab > Columns Subtab, add the following fields with Summary Type:
       Name = Group
       Formula (Text) = Maximum ; Formula = case when {transaction.type}='Invoice' then {transaction.trandate} end ; Summary Label = Last Invoice Date    

4. Click Save & Run button