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.


Harshal Makwana

Former Member
Former Member replied

Hi Harshal,

Check below FMS.

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

Hope this helps





Atul Chakraborty

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