Tag: Item receipt date

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

1. Navigate to Lists > Search > Saved Searches> New > 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. Name| Summary 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.