c2c-oerpscenario team mailing list archive
-
c2c-oerpscenario team
-
Mailing list archive
-
Message #29374
[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