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.

Okay so I have managed to filter the P/O Details 1 table down so it's not duplicated by using this:

AND(
{Qty Backordered} > 0,
OR(
{Doc Type Det} = "1",
{Doc Type Det} = "2"
))

The only problem I am having now is I want to add this line to the filter but it's not working. What am I doing wrong??

{Line Modified?} = "False"

I figured it out on my own. Thanks anyway.

{Line Modified?} = FALSE(),