c2c-oerpscenario team mailing list archive

["Amit Parik \(OpenERP\)" <amp@xxxxxxxxxxx>]

Hello DR Ferdinand,

Thanks for your reply and good explanation!

I am agree with your comment#5, that more then one company have a same prefix.
So I would like to suggest following suggestion for changing the constraint.

    _sql_constraints = [
        ('name_uniq', 'unique(name,company_id)', 'Order Reference must be unique per Company!'),
    ]

Thanks again!

** Changed in: openobject-addons
   Importance: Undecided => Low

** Changed in: openobject-addons
       Status: Opinion => Confirmed

** Changed in: openobject-addons
     Assignee: (unassigned) => OpenERP R&D Addons Team 3 (openerp-dev-addons3)

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

Title:
  Sale: Constraint Error-Order Reference must be unique per company

Status in OpenERP Addons (modules):
  Confirmed

Bug description:
  1.Create a new db and install the multi-company module.
  2.Change the user company to Shop1.
  3.Create a Sale order and Save the record.

  It gives the following error:-
  IntegrityError: duplicate key value violates unique constraint "sale_order_name_uniq"

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