I have a saved search that displays the sales order lines with Qty Ordered, Picked, Billed and a custom field value.
I want to email the search results to the sales rep each time a new item fulfillment is created against the sales order.
I have not identified a solution yet.
Is it possible to create a formula that would update a custom date time field on the sales order header with the last fulfillment create date? This field then could be used as the action for the saved search email.
Thank you