Saved search to show last item receipt date

Saved Search to Show the Last Item Receipt Date (in case of item receipt of a transfer order, current date should be based on the To Location).

Navigate to Lists > Search > Saved Searches > New > Item

Under Criteria tab, enter the required criteria.

Under Results tab, enter the following:

Formula (Date) | Summary Type = Maximum

Add this formula,

CASE WHEN {transaction.customform}= 'Custom Item Receipt' AND {transaction.quantity}>0 AND {inventorylocation}={transaction.location} THEN {transaction.trandate} ELSE CASE WHEN {transaction.customform}= 'Custom Item Receipt 2'  AND {transaction.quantity}>0 AND {inventorylocation}={transaction.location}THEN {transaction.trandate} ELSE CASE WHEN {transaction.customform}= 'Standard Item Receipt'  AND {transaction.quantity}>0 AND {inventorylocation}={transaction.location}THEN {transaction.trandate} ELSE null END END END

Enter a Search Title and hit Save.

The search result shows last item receipt date based on inventory location.