I want a saved search with a number of items that can be pulled from the item record, but I want to add the last purchase order number and the vendor from that purchase order.
How do I write a formula to pull that data from the related transaction fields?
I have tried the following:
RANK() OVER (PARTITION by {transaction.internalid}ORDER BY {transaction.mainname})
{transaction.mainname} max when ordered by {transaction.internalid}