Odoo Help

Welcome!

This community 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.

0

How to Change Invoice date after validation?

By
Samer Semaan
on 9/27/16, 7:06 AM 424 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

1

zbik

--zbik--
5976
| 6 4 7
Lodz, Poland
--zbik--


zbik
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

zbik
on 9/27/16, 11:27 AM
0

Bejaoui Souheil

--Bejaoui Souheil--
808
| 2 1 4
Sousse, Tunisia
--Bejaoui Souheil--

Odoo developer,  functional and technical consultant

souheil_bejaoui@hotmail.fr

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

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.

which module do you recommend?

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

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.

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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

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