Skip to Content
0
Former Member
Jan 13, 2011 at 03:39 AM

Issue: Formatted search displays results even from previous document.

40 Views

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