Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0009719Openbravo ERP02. Master data managementpublic2009-06-30 13:072011-02-04 09:12
networkb 
rmorley 
highminoralways
acknowledgedopen 
20rPath Linux
2.40MP6 
2.50MP5 
Core
No
0009719: system allow create two lines equals in price list schema
in the same price list schema, you can create two lines with same organization, bussiness partner, and product category
Master Data Management || Pricing || Price List Schema || Header
. create new schema , discount type: price list

Master Data Management || Pricing || Price List Schema || Header >> lines
. create new line with product p1, org O1, bussiness partner null and product category null. press save button.
. create new line with product p1, org O1, bussiness partner null and product category null. press save button

system does not returns any error and line is saved.
No tags attached.
Issue History
2009-06-30 13:07networkbNew Issue
2009-06-30 13:07networkbAssigned To => rafaroda
2009-06-30 21:23psarobeNote Added: 0017698
2009-06-30 21:23psarobeStatusnew => feedback
2009-07-01 08:52networkbNote Added: 0017712
2009-07-10 10:21rafarodaStatusfeedback => new
2009-07-10 11:01pjuvaraPriorityimmediate => urgent
2009-07-13 06:34pjuvaraTarget Version => 2.50MP5
2009-07-20 23:19psarobeStatusnew => closed
2009-07-20 23:19psarobeNote Added: 0018440
2009-07-20 23:19psarobeResolutionopen => no change required
2009-07-21 00:00anonymoussf_bug_id0 => 2824528
2009-07-21 11:10networkbStatusclosed => new
2009-07-21 11:10networkbResolutionno change required => open
2009-07-21 11:10networkbNote Added: 0018468
2009-07-29 12:54psarobePriorityurgent => high
2009-07-29 12:54psarobeStatusnew => scheduled
2009-07-29 12:54psarobefix_in_branch => pi
2009-08-04 12:58rafarodaNote Added: 0018821
2009-08-04 12:58rafarodaAssigned Torafaroda => pjuvara
2009-08-04 12:58rafarodaStatusscheduled => acknowledged
2009-08-04 12:58rafarodaTypedefect => feature request
2009-08-04 12:58rafarodafix_in_branchpi =>
2011-02-04 09:12jpabloaeAssigned Topjuvara => rmorley

Notes
(0017698)
psarobe   
2009-06-30 21:23   
Why do you think is it a bug?
(0017712)
networkb   
2009-07-01 08:52   
because it could be confusing, you could have 100 lines in schema with product selected and bussiness partner and product category not selected, but only 99 lines in price list generated
(0018440)
psarobe   
2009-07-20 23:19   
This is not a bug. Please use alerts if you want the ERP give you a warning on this
(0018468)
networkb   
2009-07-21 11:10   
This problem can be solved with the following constraint:

alter table M_DISCOUNTSCHEMALINE add (constraint one_pricelistschema unique(
AD_ORG_ID,ISACTIVE,M_DISCOUNTSCHEMA_ID,M_PRODUCT_CATEGORY_ID,C_BPARTNER_ID,
M_PRODUCT_ID,CONVERSIONRATETYPE,CONVERSIONDATE,LIST_BASE,LIST_ADDAMT,
LIST_DISCOUNT,LIST_ROUNDING,LIST_MINAMT,LIST_MAXAMT,LIST_FIXED,STD_BASE,
STD_ADDAMT,STD_DISCOUNT,STD_ROUNDING,STD_MINAMT,STD_MAXAMT,STD_FIXED,
LIMIT_BASE,LIMIT_ADDAMT,LIMIT_DISCOUNT,LIMIT_ROUNDING,LIMIT_MINAMT,
LIMIT_MAXAMT,LIMIT_FIXED));
(0018821)
rafaroda   
2009-08-04 12:58   
Specific solution applied to the customer.

Issue set to feature request to study which unique constraint is functionally reasonable in this window.