Saved Search to Show the Last Item Receipt Date per Item and its Age as of Today

1. Navigate to Lists > Search > Saved SearchesNew > Item.

2. Under Criteria tab, enter the following:

   a. Type: Inventory Item
   b. Transaction Fields..Type: Item Receipt

3. Under Results tab, enter the following:

   a. NameSummary Type: Group

   b. Display Name | Summary Type: Group

   c.Transaction Fields..Date Summary Type: Maximum

   d.Formula (Text) | Summary Type = Maximum | Formula = round({today}-{transaction.datecreated},0)

4. Enter a Search Title and hit Save.

Leave a comment

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