0042267: M_Product has a wrong constraint - Openbravo Issue Tracking System

Openbravo Issue Tracking System - Openbravo ERP
View Issue Details

ID	Project	Category	View Status	Date Submitted	Last Update
0042267	Openbravo ERP	02. Master data management	public	2019-11-13 11:31	2020-01-02 16:28

Reporter	guillermogil
Assigned To	inigo_lerga
Priority	normal	Severity	major	Reproducibility	always
Status	closed	Resolution	fixed
Platform		OS	5	OS Version
Product Version
Target Version		Fixed in Version	3.0PR20Q1
Merge Request Status
Review Assigned To	aferraz
OBNetwork customer
Web browser
Modules	Core
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency Pack	No

Summary	0042267: M_Product has a wrong constraint
Description	m_product_value should be changed by a trigger that checks that the value is not duplicated on the same legal entity. It will be needed to review also if some index is needed as the unique will be removed.
Steps To Reproduce	N/A
Proposed Solution
Additional Information
Tags	No tags attached.
Relationships
Attached Files

Issue History
Date Modified	Username	Field	Change
2019-11-13 11:31	guillermogil	New Issue
2019-11-13 11:31	guillermogil	Assigned To	=> Triage Finance
2019-11-13 11:31	guillermogil	Modules	=> Core
2019-11-13 11:31	guillermogil	Resolution time	=> 1575586800
2019-11-13 11:31	guillermogil	Triggers an Emergency Pack	=> No
2019-11-13 11:33	guillermogil	Description Updated	bug_revision_view_page.php?rev_id=19678#r19678
2019-11-13 12:38	vmromanos	Note Added: 0115573
2019-11-13 12:38	vmromanos	Status	new => acknowledged
2019-11-13 12:45	vmromanos	Note Edited: 0115573	bug_revision_view_page.php?bugnote_id=0115573#r19682
2019-11-21 10:57	vmromanos	Note Added: 0115743
2019-11-21 10:58	vmromanos	Assigned To	Triage Finance => inigo_lerga
2019-11-21 10:58	vmromanos	Status	acknowledged => scheduled
2019-11-21 10:58	vmromanos	Type	defect => feature request
2019-11-27 08:20	inigo_lerga	Note Added: 0115861
2019-11-28 15:13	inigo_lerga	Note Added: 0115945
2019-12-17 17:07	hgbot	Checkin
2019-12-17 17:07	hgbot	Note Added: 0116382
2019-12-19 12:59	hgbot	Checkin
2019-12-19 12:59	hgbot	Note Added: 0116429
2019-12-19 18:27	hudsonbot	Checkin
2019-12-19 18:27	hudsonbot	Note Added: 0116440
2019-12-27 12:43	hgbot	Checkin
2019-12-27 12:43	hgbot	Note Added: 0116556
2019-12-27 12:43	hgbot	Status	scheduled => resolved
2019-12-27 12:43	hgbot	Resolution	open => fixed
2019-12-27 12:43	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/09d12ac7b19abe656c145d7b1806f7ae2b80663e [^]
2019-12-27 12:45	aferraz	Review Assigned To	=> aferraz
2019-12-27 12:45	aferraz	Note Added: 0116557
2019-12-27 12:45	aferraz	Status	resolved => closed
2019-12-27 12:45	aferraz	Fixed in Version	=> 3.0PR20Q1
2019-12-27 14:08	hgbot	Checkin
2019-12-27 14:08	hgbot	Note Added: 0116560
2019-12-27 14:33	hgbot	Checkin
2019-12-27 14:33	hgbot	Note Added: 0116562
2019-12-27 14:56	hgbot	Checkin
2019-12-27 14:56	hgbot	Note Added: 0116563
2020-01-02 16:28	inigo_lerga	Note Added: 0116610

Notes

Test Plan for Product:
As the F&B International Group Admin role:
    - Go to the Product Window.
    - Create a new record inserting "1" as SearchKey,
      "F&B España - Región Sur" as Organization and
      any name you prefer. Save the record.
    - Create another record inserting "1" as SearchKey,
      "F&B España - Región Norte" as Organization and
      any name you prefer. Save the record.
      #Apreciate that an error message is thrown as the
      two Organizations used have the same Legal Entity
      above them#
    - Change the SearchKey to a different value such as "2".
      #Apreciate that this time no error is shown and
      the record has been succesfully saved#
    - Modify the SearchKey of this same record to "1" again
      and save the record.
      #Apreciate that the same error as before is shown when
      modifying a record with the same SearchKey as another
      pre-existing one#

Test Plan for Product Category:
As the F&B International Group Admin role:
    - Go to the Product Category Window.
    - Create a new record inserting "1" as SearchKey,
      "F&B España - Región Sur" as Organization and
      any name you prefer. Save the record.
    - Create another record inserting "1" as SearchKey,
      "F&B España - Región Norte" as Organization and
      any name you prefer. Save the record.
      #Apreciate that an error message is thrown as the
      two Organizations used have the same Legal Entity
      above them#
    - Change the SearchKey to a different value such as "2".
      #Apreciate that this time no error is shown and
      the record has been succesfully saved#
    - Modify the SearchKey of this same record to "1" again
      and save the record.
      #Apreciate that the same error as before is shown when
      modifying a record with the same SearchKey as another
      pre-existing one#

Test Plan for Business Partner:
As the F&B International Group Admin role:
    - Go to the Business Partner Window.
    - Create a new record inserting "1" as SearchKey,
      "F&B España - Región Sur" as Organization and
      any commercial name and business partner category
      you prefer. Save the record.
    - Create another record inserting "1" as SearchKey,
      "F&B España - Región Norte" as Organization and
      any commercial name and business partner category
      you prefer. Save the record.
      #Apreciate that an error message is thrown as the
      two Organizations used have the same Legal Entity
      above them#
    - Change the SearchKey to a different value such as "2".
      #Apreciate that this time no error is shown and
      the record has been succesfully saved#
    - Modify the SearchKey of this same record to "1" again
      and save the record.
      #Apreciate that the same error as before is shown when
      modifying a record with the same SearchKey as another
      pre-existing one#

Test Plan for Business Partner Category:
As the F&B International Group Admin role:
    - Go to the Business Partner Category Window.
    - Create a new record inserting "1" as SearchKey,
      "F&B España - Región Sur" as Organization and
      any name you prefer. Save the record.
    - Create another record inserting "1" as SearchKey,
      "F&B España - Región Norte" as Organization and
      any name you prefer. Save the record.
      #Apreciate that an error message is thrown as the
      two Organizations used have the same Legal Entity
      above them#
    - Change the SearchKey to a different value such as "2".
      #Apreciate that this time no error is shown and
      the record has been succesfully saved#
    - Modify the SearchKey of this same record to "1" again
      and save the record.
      #Apreciate that the same error as before is shown when
      modifying a record with the same SearchKey as another
      pre-existing one#

Test Plan for Price List:
As the F&B International Group Admin role:
    - Go to the Price List Window.
    - Create a new record inserting "1" as Name,
      "F&B España - Región Sur" as Organization and
      any currency you prefer. Save the record.
    - Create another record inserting "1" as Name,
      "F&B España - Región Norte" as Organization and
      any currency you prefer. Save the record.
      #Apreciate that an error message is thrown as the
      two Organizations used have the same Legal Entity
      above them#
    - Change the Name to a different value such as "2".
      #Apreciate that this time no error is shown and
      the record has been succesfully saved#
    - Modify the Name of this same record to "1" again
      and save the record.
      #Apreciate that the same error as before is shown when
      modifying a record with the same Name as another
      pre-existing one#