Skip to Content
0
Former Member
Apr 19, 2004 at 03:22 AM

SBO: Formatted Search won't work with just one line

56 Views

Hi

I have the following Formatted Search which I would like to load and have available behind a UDF on the Inventory Master File. I have done this and it works well but ONLY if there are multiple PO Order Lines per Inventory Item and we want to show the same info even if there is only one PO Order LIne. Can anyone help me please.

SELECT T0.DocNum,T1.LineNum,T1.ItemCode, T1.Dscription, T1.Quantity, T1.ShipDate AS "ETA Date", T1.OpenQty, T1.WhsCode, T1.DocDate, T0.DocStatus FROM OPOR T0 INNER JOIN POR1 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.DocStatus = 'O' AND T0.DocType = 'I' AND T1.ItemCode = $[$5.1.0] FOR BROWSE