Hi everyone,
I created a formatted search to multiply the Planned quantity by a numeric multiplier, which is in a UDF-row in Production Order. The product is displayed in another UDF-row also in Production Order. I am getting the correct result, but the formatted search returns all the previous calculations made from the earlier Production orders I created. When I manually trigger the formatted search, I will have to select the correct product from a list of earlier results.
Is there a way to select automatically only the product for the production order that we are currently working on? Here is my query:
SELECT distinct(T0.[PlannedQty] * T0.[U_SG]) FROM WOR1 T0 where T0.[ItemCode] = $[WOR1.ItemCode]
Thanks in advance for the help.
Regards,
Derrick