fms query

[Former Member]

Hi all,

I want formatted search at the row level of purchase order.The scenario is-

There are 2 udf's schedule qty1 & schedule qty2 ,i.e my plaaned qty what i want is the if my actual qty should not exceed the sum of two udf's i.e schedule qty1 + schedule qty2 .what should be the Query for that?

mona.

thanks in advance.

[former_member204969 · Accepted solution]

If you want to replace the entered quantity with the sum of the two scheduled quantity, you can try with the next query:

declare @q numeric(19,6)
set @q=$[POR1.Quantity]
if $[POR1.U_SchQty1].Number+$[POR1.U_SchQty2.Number]>=@q
 Select @q
else 
 Select $[POR1.U_SchQty1].Number+$[POR1.U_SchQty2.Number]

The question is how to activate this query, because you can connect only to the changing of one field. I would suggest to connect it to changing a header level field, and instruct the user to change it after entering all the row data.

[former_member187989]

fms won't work at row level of document.

Jeyakanthan