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
Hello Marilyn,
I guess the solution for your problem is quite simple:
when you receive more than one result from a formatted search, you get a seperate window with a list of all results matching your query. When there's only one match, it will be taken immediately to the field. In your case you won't see the whole list, but only the entry of the first column will be taken to your UDF.
Did you define it in the correct way? I tested your query and on my machine it works fine also with single entries... By the way: how do you store a result list in a UDF...!? You surely are only able to select ONE...
If you just want to be able to see the list without storing the info, just select the query from the menu, when you're in the items managment. No need for a formatted search then.
Regrads,
Dierk
Add a comment