Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0027102
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setupmajoralways2014-07-16 21:082014-12-30 23:23
ReporterjecharriView Statuspublic 
Assigned Tofsoto82 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision3547f6b6e776
ProjectionnoneETAnoneTarget Version3.0PR15Q1
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toeduardo_Argal
Web browserGoogle Chrome
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0027102: Create Variants method is not setting the correct organization in table m_product_ch_value

DescriptionCreate Variants method is not setting the correct organization in table m_product_ch_value
Steps To Reproduce-Go to ERP and create a "product characteristic" with check "Variant" checked.
-Go to window product and create a product with org '*'
-Set the product as generic and insert created "product characteristic"
-Change the user organization to "Vall blanca User"
-After that, select again the product and press in "Create variants"

You will see that created product has "Vall blanca User" organization in table "m_product_ch_value" instead of "*"

You can use the following query to check

select chv.ad_org_id,p.ad_org_id,c.ad_org_id,v.ad_org_id
from m_product_ch_value chv
  join m_product p on p.m_product_id = chv.m_product_id
  join m_characteristic c on c.m_characteristic_id = chv.m_characteristic_id
  join m_ch_value v on v.m_ch_value_id = chv.m_ch_value_id

It will be necessary to create a module script

When this issue is fixed, check also related issue 27117
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0027117 closedfsoto82 Modules Create Variants method is not setting the correct organization in table m_product_ch_value importing product with "IDL Variants" 
blocks defect 00272193.0PR15Q1 closedreinaldoguerra Openbravo ERP Product characteristics with numbers as variants are difficult to identify 

-  Notes
(0070826)
fsoto82 (developer)
2014-10-09 06:01

-Go to ERP and create a "product characteristic" with check "Variant" checked.
-Go to window product and create a product with org '*'
-Set the product as generic and insert created "product characteristic"
-Change the user organization to other than *
-After that, select again the product and press in "Create variants"
Check the "m_product_ch_value" organization (as described in the steps to reproduce), now is the same as the product organization
(0071182)
hgbot (developer)
2014-10-27 10:56

Repository: erp/devel/pi
Changeset: 3547f6b6e776cb27d8238786712f591b2adc269c
Author: Fernando Soto <fernando.soto <at> peoplewalking.com>
Date: Mon Oct 20 16:03:47 2014 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/3547f6b6e776cb27d8238786712f591b2adc269c [^]

Fixed bug 27102: Create Variants method is not setting the correct organization

Modified class VariantAutomaticGenerationProcess to set to the Product Characteristics Value the same organization of the product.
Also created UpdateProductChValueOrg modulescript to fix the previously entered data.

---
M src/org/openbravo/materialmgmt/VariantAutomaticGenerationProcess.java
A src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateProductChValueOrg.class
A src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateProductChValueOrgData.class
A src-util/modulescript/src/org/openbravo/modulescript/UpdateProductChValueOrg.java
A src-util/modulescript/src/org/openbravo/modulescript/UpdateProductChValueOrg_data.xsql
---
(0071224)
eduardo_Argal (developer)
2014-10-28 13:44

Code Reviewed and tested
(0072991)
hudsonbot (developer)
2014-12-30 23:23

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/6525fe229e06 [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2014-07-16 21:08 jecharri New Issue
2014-07-16 21:08 jecharri Assigned To => dmiguelez
2014-07-16 21:08 jecharri Web browser => Google Chrome
2014-07-16 21:08 jecharri Modules => Core
2014-07-16 21:08 jecharri Resolution time => 1408485600
2014-07-16 21:08 jecharri Triggers an Emergency Pack => No
2014-07-16 21:10 jecharri Web browser Google Chrome => Google Chrome
2014-07-16 21:10 jecharri Steps to Reproduce Updated View Revisions
2014-07-17 18:17 jecharri Relationship added related to 0027117
2014-07-17 18:18 jecharri Web browser Google Chrome => Google Chrome
2014-07-17 18:18 jecharri Steps to Reproduce Updated View Revisions
2014-07-28 20:55 jecharri Relationship added blocks 0027219
2014-09-22 16:36 jonalegriaesarte Target Version => 3.0PR15Q1
2014-09-22 16:37 jonalegriaesarte Target Version 3.0PR15Q1 => 3.0PR14Q4
2014-09-29 16:12 jonalegriaesarte Target Version 3.0PR14Q4 => 3.0PR15Q1
2014-10-07 16:30 fsoto82 Status new => scheduled
2014-10-07 16:30 fsoto82 Assigned To dmiguelez => fsoto82
2014-10-07 16:30 fsoto82 fix_in_branch => pi
2014-10-09 06:01 fsoto82 Note Added: 0070826
2014-10-27 10:56 hgbot Checkin
2014-10-27 10:56 hgbot Note Added: 0071182
2014-10-27 10:56 hgbot Status scheduled => resolved
2014-10-27 10:56 hgbot Resolution open => fixed
2014-10-27 10:56 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3547f6b6e776cb27d8238786712f591b2adc269c [^]
2014-10-28 13:44 eduardo_Argal Review Assigned To => eduardo_Argal
2014-10-28 13:44 eduardo_Argal Note Added: 0071224
2014-10-28 13:44 eduardo_Argal Status resolved => closed
2014-12-30 23:23 hudsonbot Checkin
2014-12-30 23:23 hudsonbot Note Added: 0072991


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker