I built a gridview using the PO Details table. It has a column for the Item #, Order #, Qty Ordered, Qty Received and Qty Backordered. I would like to filter it down to show only the items that are CURRENTLY still on back order.

The problem is that the Qty Backordered column still shows a quantity on items that DO NOT CURRENTLY have any outstanding back orders. For example, an item we ordered QTY 1000 was received on 2 separate receipts for QTY 500 each. Now this item shows up on my Gridview twice and reports the Qty Backordered as 500 both times. So how do I filter this view to not show this item since it is already completely received?