Odoo Help


How to Change Invoice date after validation?

Samer Semaan
on 9/27/16, 7:06 AM 2,503 views

how to change invoice date after validation, we don't want to refund the invoice just to change its date, after validation odoo9 doesnt allow to change its date.




| 6 5 7
Lodz, Poland

On 9/27/16, 10:29 AM

This is not a recommended method, but ... :)

1)  You install module account_cancel
1a) After install, select journal "Sale journal" and check field Allow Cancelling Entries

2) Unreconcile invoice if payment is registered

3) Cancel invoice and in next step Reset to Draft

4) Change date

5) Validate invoice again (and reconcile payment if exist)

PS. Warning! Invoice number remains the same but order by date changed (possible inconsistency!)

i am getting this when i try to cancel the invoice:

You cannot modify a posted entry of this journal.

First you should set the journal to allow cancelling entries.

Samer Semaan
on 9/27/16, 11:16 AM

Answer updated - see step 1a

on 9/27/16, 11:27 AM

Bejaoui Souheil

--Bejaoui Souheil--
--Bejaoui Souheil--

Odoo developer,  functional and technical consultant


Bejaoui Souheil
On 9/27/16, 9:32 AM


The Bill date field defined as readonly field in the python side.

So, with a custom module you can change it to be editable even after the validation of an invoice.

Or you must change it directly from the database.

Best regards.

which module do you recommend?

Samer Semaan
on 9/27/16, 10:51 AM


Well why this is not allowed out-of-the-box is mainly your all accounting transactions considers the Invoice Date, so

once you validate your Invoice, Journal Entries are posted based on invoice date and currency rate is also taken based on that.

If you did mistake, you can go for cancelling process by creating Refund(click Refund Invoice and choose option for cancel), and have a new copy of your invoice which you can modify. (or Cancel Invoice option is also fine)


The Problem Here, we are not allowed the break the sequence of the invoice by the local regulations, and we are not to issue an invoice with a date in advance

what happened now is like this

invoice 2 date 1 October (by mistake)

invoice 3 date 28 september

we just want to fix the date to avoid penalties from the ministry of finance

Samer Semaan
on 9/28/16, 5:00 AM

In that case answer from zbik is correct. You need to install cancel invoice application, that would allow you cancel, reset invoice without changing it's sequence number. Also note that, if sometimes this invoice is already paid then you need to unreconcile your payment done for the invoice. For 9.0, you can remove payment from invoice itself, and for 8.0, you can open Journal Items, and Unreconcile the entries choosing top More option.

Rifakat Haradwala (rha)
on 9/28/16, 5:07 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 9/27/16, 7:06 AM
Seen: 2503 times
Last updated: 9/28/16, 4:41 AM