Hi Joe, thanks for your quick response. i changed the value as advised but it dint work... :-/
27 09/24/2008 12:09:16 pm
Topic: Recieving Payment (11 replies, posted in Accounts Receivable)
I'm trying to receive payment from a customer but I'm getting the error below.
DATABASE ERROR : The debtor transaction record could not be inserted
error code : 1292
error message : Incorrect date value: '' for column 'due_date' at row 1
sql that failed was : INSERT INTO 0_debtor_trans ( trans_no, type, debtor_no, branch_code, tran_date, due_date, reference, tpe, order_, ov_amount, ov_discount, ov_gst, ov_freight, ov_freight_tax, rate, ship_via, alloc, trans_link ) VALUES (10, 12, '8', '10', '2008/09/24', '', '9', '0', 0, 6500000, '0', 0, '0', 0, 1, '', 0, '0')
What strikes me is that there's no due date in the payment form so I'm wondering why it's asking me that question.
Im using PHP 5.2.6, MYSQL 5.0.51, Apache 2.0.63 on Windows Vista