Does anyone know how to reference the amount an item was sold for in a saved search? The only field I can find is the item's rate (usual price), not actual sold for price. What I am trying to accomplish: (XYZ costs $200, we sell for $100, PO is created at rate of $200 -> Warning pops up on PO) I got it working if the item is the only item in the sales order as I can go off totals, but when there's more products in a sales order, the logic does not work.

This would need to be scripted and you need to use one of the oddball joins if this is a special order or drop ship PO situation. The applied to or applied from or something like that