any thoughts on how I would do this without scripting? I'm trying to pull "estimated availability date" from line item's on POs into an item field, which I am doing with a search and then copying the value with work flow. So I'm using summary of MIN on the PO, but if we have backorders that would leave no quantity available on that PO, I want to find the next PO (if it exists)

I'm guessing you already know the answer to this based on the complexity of what you are trying to accomplish.

I’m wondering if Sum(PO Qty) Over ID minus Item Qty Backorder and return the first Date where the calculation is positive.

@Netsuite Tragic i actually did do that, I think it will get me like 90% there, so less of "looking for the one below the MIN" and more of "looking for the right one" lol thanks!