Hi
I have some problems creating an FMS:
SELECT T1.PlannedQty FROM OWOR T0 INNER JOIN WOR1 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.DocNum=$[IGE1.BaseRef.0] AND T1.[$37.15.0]=$[$13.60.0]
returns
SELECT T1.PlannedQty FROM OWOR T0 INNER JOIN WOR1 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.DocNum=N'11204 ' AND T1.[$37.15.0]=N'15 '
which turns out to be a problem with
T1.[$37.15.0]
Could anybody please tell me what I did wrong?
My target is to create a function for partial issue using the Ref.2 field to enter the base quantity to issue and using the returns of the FMS above to calculate the corrected issue quantity line by line.
Thanks
Franz