Community mailing list archives
Re: 8.00 - Bug on address customer in relation with invoice in Odooby
Via dell'Artigiano, 20
37010 Albaré di Costermano (VR)
Tel: +39 045 6201295 (r.a.)
Fax: +39 045 6201877
Hi,Why do not include inside the database a new field : lock_invoice => 1/0 and create a base with the adress.Web the invoice is creted and validated else the lock_invoice becone 1 and the customer address is copy inside the base.It could be simple to resolve this problem.Maybe, the workflowcould be created.No, or it's very complicateed to insert this inside Odoo.------------------------
loïc Richard2014-11-01 2:07 GMT-04:00 Ferdinand Gassauer <email@example.com>:On 2014-11-01 00:47, Pedro Manuel Baeza Romero wrote:<blockquote cite="mid:CACSANCBzuUmpzy4fq784XaPPY7xznvXyX2ZUcfvFPgtfirstname.lastname@example.org" type="cite">
- Agree, this works with Address
- especially critical (legaly required) processes must be enforced - (all possible errors will be made and the company/manager will be liable)
- does not work with all master data
Example - Company changes (part of) the name but keeps VAT/TIN - hence it is the same (juridical) partner, you don't want to loose partners history either creating a new partner.
I don't think this is an issue. It's only a question of procedure. If you change any customer address, you shouldn't overwrite current record, but add another one with the new address, and deactivate the old one (or keep it if it is the main one, but not using it). You can mark any "contact" (this is not the best word indeed) as invoice address, and there it is. Anyway, if you don't do that, you always keep a copy in PDF of the original printed invoice, so legal part is also covered.
2014-11-01 0:37 GMT+01:00 Ferdinand Gassauer <email@example.com>:
On 2014-10-31 19:18, Loïc Richard wrote:<blockquote cite="mid:CAKAiKMGd2gCfFgGU4gxQ_N0S8qq+yn89cpMNO7N06cgcHfirstname.lastname@example.org" type="cite">
well the other issue is one for partners, these implement systems which are not designed to be revision proof, the day will come that they will be hold liable not telling the client these facts beforehand.
I ferdinand, I am agree with you. It was my next question, if I don't generate my pdf invoice, what is the result if the address is change !! it has the new address.
I think this problem must be a priority because it's very important.The inspector can tell me :Hey Loic, you realise false invoice, it's money laundering :)
Seriuoly, this rpobelm has also a big impact also on the customers.
2014-10-31 14:02 GMT-04:00 Ferdinand Gassauer <email@example.com>:
On 2014-10-31 18:47, Raphaël Valyi wrote:<blockquote cite="mid:CAByrsx1rRna-a32j7E=sVvWvRj4A0UpKDSa=qJhYdATgxMG78A@mail.gmail.com" type="cite">
I just want to add, that this method is not revision proof.
any user with access to invoices can delete and recreate the pds - with the new master data - hence it will not be the "original" any more.
IMO Odoo needs a mechanism to "protect" attachments
- from unauthorized deletion
Example: see above
- unauthorized access
Example HR - not everyone who can "read" hr employee data must be allowed to access personal data of employees stored as attachment.
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 <firstname.lastname@example.org> 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.