← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 789019] Re: unique keys missing

 

well the multi-company issue is one thing and must depend on the multi
company rules.

nevertheless the general rule must be that the user is able to clearly identify ONE (correct) resource especially in o2m and m2m selections. this is ONLY possible if he/she SEES all columns making up the "uniqueness".
 
so it's probably a good idea to display the company_id  for "multi-company" groups/users.

duplicate partner names:
I still believe that if the res_partner.name field is not unique - which is very possible - there must be another visible criteria to allow the user to choose the correct partner. for this reason I suggested to use the not mandatory field reference and create a unique key on name,reference (not sure that works) or to create a python check.

partners and the customer/supplier problem:

I suggest to display the customer/supplier check-box in the list view,
this might trigger the awareness that only one kind of partners is
displayed - IMHO the pressed /released state of  CUSTOMER/SUPPLIER
buttons are NOT visible enough - especially in bright conditions.

day to day works shows that users have problems here.

-- 
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
Status in OpenERP Server:
  Fix Committed

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


References