Got this complaint from a user:
When attempting to void a transaction, I get the following error:
'
UPDATE ar set
invnumber = ?,
ordnumber = ?,
quonumber = ?,
description = ?,
transdate = ?,
entity_credit_account = ?,
amount = ?,
netamount = ?,
paid = ?,
datepaid = ?,
duedate = ?,
invoice = '1',
shippingpoint = ?,
shipvia = ?,
terms = ?,
notes = ?,
intnotes = ?,
taxincluded = ?,
curr = ?,
person_id = ?,
till = ?,
language_code = ?,
ponumber = ?,
approved = ?,
crdate = ?,
reverse = ?,
is_return = ?,
setting_sequence = ?
WHERE id = ?
ERROR: duplicate key value violates unique constraint "ar_invnumber_key"
DETAIL: Key (invnumber)=(4639-VOID) already exists. at LedgerSMB/IS.pm line 1494
'
I've looked in the database ar.invnumber column, and this key does not currently exist.
Testing this with a sales invoice (as indicated by the subject), on 1.4.12, this works for me. Closing as such. Thanks for reporting though!
Regards,
Erik.