c2c-oerpscenario team mailing list archive

["Ferdinand @ Camptocamp" <789019@xxxxxxxxxxxxxxxxxx>]

well as I said it must not be allowed to create companies, products,
parteners, accounts..... with the same "name"

currently it is possible - see attachments

BTW we are working on a generic module which allows to merge duplicates, which are created 
* due to the lack of uniqueness checks (unique indices , which can be avoided creating a uinque index)
* due to organizational issues like partner changes name, but remains the same legal entity , user makes an error in creating a new  partner instead of renaming the old one - same for products etc

** Attachment added: "duplicates.png"
   https://bugs.launchpad.net/openobject-addons/+bug/789019/+attachment/2162444/+files/duplicates.png

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/789019

Title:
  unique keys missing

Status in OpenERP Modules (addons):
  Incomplete

Bug description:
  IMHO many tables should have uniquenes enforced using a column which
  is "visible" for the user, because in production envirenment the user
  has to identify and choose the correct resource "reading" the name or
  similar.

  Caveat: trailing blanks names with trailing "look" identical, but are not identical for check of uniqueness
  IMHO it does not make sense to store trailing blanks. (in general)
  (ASCII-Code 32, UnicodeU+0020.)

  I recognize that there might be resources like partners having the
  same "official" name and might be distinguish only by address or
  similar. In this case name + reference/code must be used.

  res.company - name
  res.currency - symbol
  res.partner - name (+ reference)
  res.partner.bank - account or iban
  account.period - name
  account.tax - name
  product_template - name (+code)
  ....

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/789019/+subscriptions