Arithmetic overflow error

[Thiagarajan]

Trx Error #5: Arithmetic overflow error for data type smallmoney, value = 243525.
The statement has been terminated.

When Reliance Rs.255 and Rs.349 and more value recharge id done come this type of error

how to solve this error

[attachment deleted by admin]

[Yusuf]

You need to change the data-type of all smallmoney columns on transaksi table. Use SQL Server Management Studio (SSMS) to change those column's datatype to money instead of smallmoney.

[Thiagarajan]

Dear Yusif,

I cant understand but more loss to me last 3 days of reliance product

[Yusuf]

Please contact your seller or Hariyanto for fast technical support.

You can find the contact person here: http://forum.orisinil.com/index.php/topic,8617.0.html

Hope you will get solution ASAP.

[yogesh]

hello sir when change small money instead money then harga_beli and saldo all price is change to hiher vaule.
after that not proper check daily report or sale.if we do recharge rs.29 and i set price 0.995 and sell price is 1.00 then value i want to come this 28.855 but value comes 28,855.00 this higher now tell me solution sir i m in very trouble.


[attachment deleted by admin]

[Yusuf]

Are you using version 3.3.8? If problem still persists, please try to use version 3.3.7.

Thank you.