This question has been flagged
2 Replies
3483 Views

Hello,

Before changing the invoice number sequence, I have created a quotation and test the invoice, now when I valid this invoice the number is not the new sequence but the old. How I can changed the number Manually or by SQL ?

I have tried to cancel the invoice but I can't recreate a new invoice by the delivries order, I can just make the invoice in draft, but when I valided the invoice is still the old sequence.

Thanks In advance.

Avatar
Discard
Best Answer

By SQL you clear field internal_number in account_invoice. If this field is not empty old number is set.

Avatar
Discard

I use the module Clean Cancelled Invoice Number By ADHOC SA. It works great.

Best Answer

There is a module change_invoice_number available in https://github.com/Vauxoo/addons-vauxoo.git repository to change invoice number. 

Cheers!

Avatar
Discard