"String or binary data would be truncated. The statement has been terminated" most probably means that the size of value you want to insert is larger than column size.
According to money and smallmoney (Transact-SQL), the range of money is from -922,337,203,685,477.5808 to 922,337,203,685,477.5807.
When you got the message, please check size of every parameter and make sure they are in the range of corresponding field.