c2c-oerpscenario team mailing list archive

["Olivier Dony \(OpenERP\)" <789019@xxxxxxxxxxxxxxxxxx>]

Here are my votes:

- ir_model.name: yes
- res.company.name: yes
- res.currency - symbol: should be (name,company_id) as Marco corrected
- res.partner - name (+ reference): no, ref is not required and should not be, so it will be annoying (but perhaps an on_change warning on the name field instead, to cover the supplier/customer case?)
- res.partner.bank - account or iban: no, don't think this is something we should prevent
- account.period - name: can't be on name only, as the user creating them might not even be able to see the conflicting ones from other companies (totally confusing!). Could be on (name,company_id). I suppose that's not what you were looking for, but in case of multi-company, if users can see periods from several companies, then they should be named appropriately. And keep in mind that admin user must *not* be used for regular business transactions!
- account.tax - name: same logic as account.period
- product_template - name (+code): should be (name, code, company_id)

Further thoughts?

-- 
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):
  Confirmed

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