I have a search that shows the status of sales orders. I would like to create a result that I can use to show when an order has back ordered items. Our company currently has columns on a sales order that shows what we have on hand and what is available. Is there a way to add a result in the search that looks for these values and returns a value if one of them equals 0?

Isn't

backordered

just

quantity - quantity shipped - quantity committed

?

In the searches I've looked at, it is a formula as NVL({quantity},0)-NVL({quantitycommitted},0)-NVL({quantityshiprecv},0)

Yes, so what is the question then?

so what i currently have as a search is this

Your criteria is more interesting than the other columns... if your search is not on the line level then you can't get line level results

ah ok