Skip to Content
avatar image
Former Member

FMS Required !

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 27, 2015 at 09:11 AM

    Hi Harshal,

    Check below FMS.

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



    Hope this helps 😊


    Thanks

    --

    --

    Regards::::

    Atul Chakraborty

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • Oct 27, 2015 at 09:30 AM

    Hi ,

    Please try the below FMS

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

    Thanks  & Regrads ,

    Kamlesh Naware

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 27, 2015 at 09:35 AM

    Thanks Atul and Kmalesh,

    Your query works fine.

    Thanks,

    Harshal Makwana

    Add comment
    10|10000 characters needed characters exceeded