This question has been flagged
6 Replies
12501 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.

THX

Avatar
Discard
Best Answer

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!)




Avatar
Discard
Author

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.

Answer updated - see step 1a

Best Answer

Hi,

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.

Avatar
Discard
Author

which module do you recommend?

Best Answer

Hello,

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)

Regards.

Avatar
Discard
Author

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

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.