I ahve a search for purchase orders that are past the expected due date. It groups by document # on the summary page so I don't have multiple PO's showing up for different line items. I want to show the minimum (earliest) expected due date of the items NOT yet recieved. Is there a formula I can use to clarify this?

Does MIN on the date column not work?

it pseudo works but on the results page if you click on a purchase order to go past the summary to the results it only pulls that item with the minimum expected due date

While using Minimum grouping it sounds like you just need to remove any lines (via criteria) where received received quantity > 0 or received quantity = quantity... Depending on your goals.

this should be what i need thanks!