Topic: Purchases - Database Error
I am currently utilising version 2.3.11
When creating a direct invoice under purchases, I get the following error message if the supplier has the same currency as my company. Each set up with ZAR as currency
DATABASE ERROR : Cannot insert a supplier transaction record
error code : 1265
error message : Data truncated for column 'ov_discount' at row 1
sql that failed was : INSERT INTO 0_supp_trans (trans_no, type, supplier_id, tran_date, due_date, reference, supp_reference, ov_amount, ov_gst, rate, ov_discount, tax_included) VALUES ('9', '20', '4', '2011-12-31', '2011-12-31', '3', '3', '25', '1.25', '1', '', '0')
Set-up error or bug?