Does anyone know how to access the last purchase price field by location in an Item saved search? I tried using the location fields (location quantity, location onhand, ....), but there is NO location Last Purchase Price. Very strange. Even tried a formula, but can't seem to access that field. Need to do a saved search since I'm also pulling in information from the most current sales order. Thanks in advance.

You could use a formula, summarise maximum when sorted by date, the formula would then be when transaction type is purchase order then item rate

Hi Michael - Hummm. I'll have to see if I can make that work. If I understand correctly I would need to look at all the item receipts from the underlying transactions for that location. Is that what you are saying? Great idea!