cancel
Showing results for 
Search instead for 
Did you mean: 

FMS in Production Order

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Sridharan,

Try:

SELECT $[OWOR.PlannedQty.number\] * (1+$[OWOR.U_EX.number\]/100)

Thanks,

Gordon

Former Member
0 Kudos

Dear Mr.Gordon,

I work with FMS but, below error coming

1). [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'OWOR.U_EX.number'.

2). [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement 'Service Contracts' (OCTR) (s) could not be prepared.

thanks

Former Member
0 Kudos

Dear Mr.GorDon,

Thanks Problem Solved.

I missed $ in your FMS.

Thanks

Sridharan.R

Answers (0)