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?

I don't know if this is the ONLY thing that will solve your problem, but you definitely need to add to your filter {Doc Type} = "1". Without that you will be getting Receipts and Adjustments and all you want is PO's.

Steve

Is document type 1 = PO? What is document type 2? and 3? and so on?

Hi Susan,

1=PO. 2=Receipt. 4=Invoice/Adjustment. These are the important ones.
3=Return, which is legacy and Adagio PurchaseOrders does not use.

If you are ever interested in what Document Type values are, in GridView when a Doc Type field is included in a view, you can right-click on column title and choose Field Properties. If a 'lookup table' has been created for this field, then the list of possible values and what they mean will be displayed here. Also, these lookup values are automatically used in your inquiry if you enable the option to 'Translate coded fields' in the View Definition. So the column would show 'PO' instead of simply '1'.

Thanks it's working now.

AND(
{Doc Type Det} = "1",
{Qty Ordered} > 0,
{Qty Backordered} > 0,
{Complete?} = 0,
{Expected Date} < TODAY()
)

My team will test it out and let me know if there are any issues.