Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Tags:
Former Member
Former Member replied

Hi Harshal,

Check below FMS.

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



Hope this helps


Thanks

--

--

Regards::::

Atul Chakraborty

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question