Zum Inhalt springen
Menü
Sie müssen registriert sein, um mit der Community zu interagieren.
Diese Frage wurde gekennzeichnet
4196 Ansichten

Hello everyone,

When trying to cancel Draft invoices, an exception is thrown. The error in the logs is 

ERROR:  duplicate key value violates unique constraint "account_invoice_number_uniq"
DETAIL: Key (number, company_id, journal_id, type)=(, 1, 2, out_invoice) already exists.
Query failed
PostgreSQL said: duplicate key value violates unique constraint "account_invoice_number_uniq"
Detail: Key (number, company_id, journal_id, type)=(, 1, 2, out_invoice) already exists.


According to postgresql, the query it is trying to run is 

UPDATE "account_invoice" SET "internal_number"='',"number"='',"write_uid"=5,"write_date"=(now() at time zone 'UTC') WHERE id IN (1873)


It looks like the value for number is not being passed.

Any suggestions ?

Avatar
Verwerfen
Verknüpfte Beiträge Antworten Ansichten Aktivität
1
Juli 21
7666
2
Sept. 21
3041
0
März 15
3804
2
März 15
5496
1
Juli 25
770