Community mailing list archives

Re: 8.00 - Bug on address customer in relation with invoice in Odoo

Ferdinand Gassauer
- 10/31/2014 14:15:09
On 2014-10-31 19:03, Loïc Richard wrote:

until v.8 there was an audittrail module, which did a poor job, hence it was abandoned.
IIRC it recorded only top level changes.

I suggested once to use database triggers to trace any changes in master data without much performance influence
  • master data do not change often
  • if done in the DB, the ERP is not affected
  • Odoo people do not like DB triggers. (copy old record in Pre-delete, pre-update triggers  m2o,o2m,m2m must be handled correctly - complex task )
  • we have been using this technique for many years without problems
  • someone is trying to create a new audit trail module, but this would require


<blockquote cite="" type="cite">
Thank you Raphaël,

But with the law, do you have a discussion, because it's a problem, you see something on your erp and you have another something in your pdf.

I don't know but if I am an inspector, I will don't agree with this case and I will taxed the company fo non respect.

Do you have another experience like SAP, Oracle concerning this point.
For example, at the moment, in SAP, if you change the product tax , all your invoice will be impacted. 

Concerning the portal customer, is it also the same problem ?

loïc Richard

2014-10-31 13:47 GMT-04:00 Raphaël Valyi <>:
Helo Loïc,

What you describe was a hot topic back in 2007/2008... And this isn't just with the addresses but any data linked in invoices that are not in the account_invoice table.

At that time it was chosen that a "temporal" data model could be implemented to fix this but that it would have been complex.

A workaround that has been agreed as acceptable at that time is the current system we have where invoice pdf's are stored as attachments and never changed once they have been generated once in a validated state. This doesn't help with queries in the database but ensures that your printed versions of invoices will not changed when data change.

Hope this help.

On Fri, Oct 31, 2014 at 2:07 PM, Loïc Richard <> wrote:


Currently I write a webservice between my ecommerce platform and Odoo

When I change a payment address during the payment process (new payment address) on my ecommerce platform, the payment address is write in hard inside database and the old address is not updated.

But in Odoo, this not the same thing, if during the process payment, the customer change this payment address, all the invoice (new and old) has the new address.

I think there is a big bug in odoo because the address has an impact on invoice.

I tried to change just in Odoo, a customer address, all the invoice has impacted, new and old invoice include the validate invoice.

This is a problem, in my opinion, with the law. All invoicemust be had an invoice, and the invoice validated should not be exchange

is the samething if I change a taxe rate. In this case, it can become horrible.

What the solution to resolve this problem, because it's important.


loïc Richard

Post to:

Raphaël Valyi
Founder and consultant

Post to:

Post to: