Community mailing list archives

community@mail.odoo.com

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

by
loic
- 11/02/2014 13:26:51
Hi Luca,

What do you to say with your address ?
For us it's important than Odoo create a patch to resolve this problem.
How to deploy in Company Odoo if there is a little modification like address and hight impact inside Odoo and administration Company.


------------------------
Cordialement,
loïc Richard

2014-11-02 12:42 GMT-05:00 Luca Carabelli <luca.carabelli@politecnici.com>:


Luca Carabelli

Politecnici S.r.l.
Via dell'Artigiano, 20
37010 Albaré di Costermano (VR)
Tel: +39 045 6201295 (r.a.)
Fax: +39 045 6201877
Email: luca.carabelli@politecnici.com
Web: www.politecnici.com
Blog: www.politecnici.blogspot.com
Da: Loïc Richard
Inviato: domenica 2 novembre 2014 00:12
A: Community
Rispondi a: OpenERP S.A. Community
Oggetto: Re: 8.00 - Bug on address customer in relation with invoice in Odoo

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.


------------------------
Cordialement,
loïc Richard

2014-11-01 2:07 GMT-04:00 Ferdinand Gassauer <ferdinand.gassauer@camptocamp.com>:
On 2014-11-01 00:47, Pedro Manuel Baeza Romero wrote:

  1. Agree, this works with Address
  2. Disagree
    1. especially critical (legaly required) processes must be enforced - (all possible errors will be made and the company/manager will be liable)
    2. 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.

<blockquote cite="mid:CACSANCBzuUmpzy4fq784XaPPY7xznvXyX2ZUcfvFPgt-mq2exw@mail.gmail.com" type="cite">
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.

Regards.

2014-11-01 0:37 GMT+01:00 Ferdinand Gassauer <ferdinand.gassauer@camptocamp.com>:
On 2014-10-31 19:18, Loïc Richard wrote:

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.

<blockquote cite="mid:CAKAiKMGd2gCfFgGU4gxQ_N0S8qq+yn89cpMNO7N06cgcH-+ghg@mail.gmail.com" type="cite">
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.



------------------------
Cordialement,
loïc Richard

2014-10-31 14:02 GMT-04:00 Ferdinand Gassauer <ferdinand.gassauer@camptocamp.com>:
On 2014-10-31 18:47, Raphaël Valyi wrote:

Hello
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
    and
  • unauthorized access
    Example HR - not everyone who can "read" hr employee data must be allowed to access personal data of employees stored as attachment.

<blockquote cite="mid:CAByrsx1rRna-a32j7E=sVvWvRj4A0UpKDSa=qJhYdATgxMG78A@mail.gmail.com" type="cite">
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 <loic.richard1@free.fr> wrote:

Hello,

Currently I write a webservice between my ecommerce platform and Odoo

Description
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.

Thanks



------------------------
Cordialement,
loïc Richard

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe




--
Raphaël Valyi
Founder and consultant
+55 21 3942-2434


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe