This message was deleted.

AI generated answer (using internal Slack threads):

To add the Last Purchase Price for each inventory location to a saved search, you can use a formula field in your saved search. Here are the steps: 1. In your saved search, go to the Results tab. 2. Click on 'New Field' to create a new formula field. 3. In the formula field, you can use a formula like this:

CASE WHEN {transaction.type} = 'Purchase Order' THEN {transaction.item.rate} END

4. Set the Summary Type to 'Maximum'. 5. In the 'Sort By' field, select 'Transaction : Date'. 6. Set the 'Sort By Order' to 'Descending'. This formula will return the item rate when the transaction type is a Purchase Order. By setting the Summary Type to 'Maximum' and sorting by the transaction date in descending order, it will return the most recent purchase price for each item. Please note that this will return the last purchase price for each item, not for each inventory location. If you need to get the last purchase price for each inventory location, you might need to create separate saved searches for each location or use a SuiteScript to aggregate the data. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******