on 09-17-2011 1:05 PM
Dear expert,
I want do FMS for Production planned Qty * Extra 2% Qty (UDF field name - U_EX) in production order screen . I have done below FMS but not working.
SELECT ((convert(Numeric(19,6),$[OWOR.PlannedQty]) * Convert(Numeric(19,6),$[OWOR.U_EX]/100)) + (convert(Numeric(19,6),$[OWOR.PlannedQty]))
regards
sridharan
Hi Sridharan,
Try:
SELECT $[OWOR.PlannedQty.number\] * (1+$[OWOR.U_EX.number\]/100)
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.