I have a very specific question with regards to creating a GridView report from Order Entry. I would like to know what a filter should specify if I want to, in the column named "Qty Backordered" only see the orders that have quantities greater than zero. The other half of this filter would be the column named "Complete?", I would like to see only the "False"

Thank you.

Hello Barb9,

If you want to show information from both the Order Lines (Qty Backordered) and Order Header (Customer Number and name) in the same View, then you need to start by selecting a composite table - in this case Adagio {Composite Tables 8.0A} | OE Ord Detaill w Head.

You'd want to apply the following filter to see the records you need:

code:

---

AND(
  {OELine Qty Backordered} > 0,
  {Complete?} = FALSE()
  )

---

You should be able to copy this filter from this post and paste it into the filter box.