Hi everyone. I have a search that pulls in the date last received and the qty last received by item. I am now trying to do this by location. I want to be able to set a filter on the header of the search and then see the last received date and last received qty at that location only. The way it currently works, it is only showing the most recent one without any regards to location. Another wish, but not requirement is to show last received date and qty, but not include item receipts created from RAs. These are the formulas I am currently using: Date last received: round({today}-{transaction.datecreated},0) Last Received Doc #: case when {transaction.type} = ‘Item Receipt’ then {transaction.number} else null end Qty Last Received: case when {transaction.type} = ‘Item Receipt’ then {transaction.quantity} else 0 end

Limit in the criteria by Transactions : Location. To remove the RA the criteria would be to remove Transaction : Type of type Item Receipt AND which have Transaction : Created From not including “Return Authorization”. You will have to work out that latter criteria as you cannot link from Item to Transaction to its Created from Transaction.