Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||
| ID | |||||||||||
| 0009719 | |||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||||
| feature request | [Openbravo ERP] 02. Master data management | minor | always | 2009-06-30 13:07 | 2011-02-04 09:12 | ||||||
| Reporter | networkb | View Status | public | ||||||||
| Assigned To | rmorley | ||||||||||
| Priority | high | Resolution | open | Fixed in Version | |||||||
| Status | acknowledged | Fix in branch | Fixed in SCM revision | ||||||||
| Projection | none | ETA | none | Target Version | 2.50MP5 | ||||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_11 | ||||||
| OS Version | rPath Linux | Database version | 8.3.5 | Ant version | 1.7.1 | ||||||
| Product Version | 2.40MP6 | SCM revision | |||||||||
| Review Assigned To | |||||||||||
| Web browser | |||||||||||
| Modules | Core | ||||||||||
| Regression level | |||||||||||
| Regression date | |||||||||||
| Regression introduced in release | |||||||||||
| Regression introduced by commit | |||||||||||
| Triggers an Emergency Pack | No | ||||||||||
| Summary | 0009719: system allow create two lines equals in price list schema | ||||||||||
| Description | in the same price list schema, you can create two lines with same organization, bussiness partner, and product category | ||||||||||
| Steps To Reproduce | 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. | ||||||||||
| Tags | No tags attached. | ||||||||||
| Attached Files | |||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0017698) psarobe (manager) 2009-06-30 21:23 |
Why do you think is it a bug? |
|
(0017712) networkb (developer) 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 (manager) 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 (developer) 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 (developer) 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. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-06-30 13:07 | networkb | New Issue | |
| 2009-06-30 13:07 | networkb | Assigned To | => rafaroda |
| 2009-06-30 21:23 | psarobe | Note Added: 0017698 | |
| 2009-06-30 21:23 | psarobe | Status | new => feedback |
| 2009-07-01 08:52 | networkb | Note Added: 0017712 | |
| 2009-07-10 10:21 | rafaroda | Status | feedback => new |
| 2009-07-10 11:01 | pjuvara | Priority | immediate => urgent |
| 2009-07-13 06:34 | pjuvara | Target Version | => 2.50MP5 |
| 2009-07-20 23:19 | psarobe | Status | new => closed |
| 2009-07-20 23:19 | psarobe | Note Added: 0018440 | |
| 2009-07-20 23:19 | psarobe | Resolution | open => no change required |
| 2009-07-21 00:00 | anonymous | sf_bug_id | 0 => 2824528 |
| 2009-07-21 11:10 | networkb | Status | closed => new |
| 2009-07-21 11:10 | networkb | Resolution | no change required => open |
| 2009-07-21 11:10 | networkb | Note Added: 0018468 | |
| 2009-07-29 12:54 | psarobe | Priority | urgent => high |
| 2009-07-29 12:54 | psarobe | Status | new => scheduled |
| 2009-07-29 12:54 | psarobe | fix_in_branch | => pi |
| 2009-08-04 12:58 | rafaroda | Note Added: 0018821 | |
| 2009-08-04 12:58 | rafaroda | Assigned To | rafaroda => pjuvara |
| 2009-08-04 12:58 | rafaroda | Status | scheduled => acknowledged |
| 2009-08-04 12:58 | rafaroda | Type | defect => feature request |
| 2009-08-04 12:58 | rafaroda | fix_in_branch | pi => |
| 2011-02-04 09:12 | jpabloae | Assigned To | pjuvara => rmorley |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |