FMS Required !

[Former Member]

Hi all,

I have created 2 UDF's say Bales(Numeric) and Tare Weight(Numeric). So my requirement is when I enter quantity in Bales UDF, Tare weight should calculate automatically through FMS.

I have created FMS as SELECT $[POR1.U_Bales]*0.5 and assigned to Tare Weight UDF but when I click on mirror icon to fetch data its giving me an error as 1). [Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow error converting nvarchar to data type numeric.  '' (SWEI)

Please anyone guide me on how to solve this.

Thanks,

Harshal Makwana

[Former Member · Accepted solution]

Hi Harshal,

Check below FMS.

SELECT ($[POR1.U_Bales.Number]*0.5)

Hope this helps

Thanks

--

--

Regards::::

Atul Chakraborty

[Former Member · Accepted solution]

Hi Atul,

Thanks its working now but problem is if I take say 170 quantity it will give 85 correct value but if I take 165 quantity then system throws an error as Invalid numeric value (ODBC -1030)  [131-183]

Please suggest.

Thanks,

Harshal Makwana

[Former Member]

Thanks Atul and Kmalesh,

Your query works fine.

Thanks,

Harshal Makwana

[former_member227598]

Hi ,

Please try the below FMS

Select (SELECT $[POR1.U_Bales.decimal]) *0.5

Thanks  & Regrads ,

Kamlesh Naware