Hi,
That query makes no sense at all.
Don't you mean that FMS to be in the U_NoOfPcs UDF, triggered by each change in DocTotal, and shouldn't the query be something like this?
SELECT SUM(ISNULL(t1.Quantity,0)) FROM ORDR t0 INNER JOIN RDR1 t1 ON t0.DocEntry = t1.DocEntry WHERE t0.DocNum = $[ORDR.DocNum]
Regards,
Johan
Hi,
Could you post your working FMS here to check? Your first post and reply is not related.
Regards,
Nagarajan
Add comment