Menu

#1303 Cannot void a sales invoice

1.4
closed-works-for-me
nobody
None
1.4
5
2015-06-23
2014-12-17
John Locke
No

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.

Discussion

  • Anonymous

    Anonymous - 2015-06-23

    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.

     
  • Anonymous

    Anonymous - 2015-06-23
    • status: open --> closed-works-for-me
    • Version: --> 1.4
     
MongoDB Logo MongoDB