I am using table "P/O Details 1" with a filter "{Qty Backordered} > 0" so that I can see the expected receipt date on an item that is on a PO. It is working great except when the item has been partially received where the Gridview lists the item twice. First it shows Doc Type 2 for the RC and second it shows Doc Type 4 for the ADJ. When the order has not been partially received it shows Doc Type 1 for the PO. How can I filter the results to show each PO with a back order only one time in this gridview?

Just to clarify, I am using another gridview showing the items that customers have back orders for and linking it to this gridview by the item code, so we can see the expected receipt date for any specific item.