Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0035302Openbravo ERP02. Master data managementpublic2017-02-17 14:422017-03-15 20:21
nataliag 
luisrs8608 
normalmajoralways
closedfixed 
5
 
3.0PR17Q2 
markmm82
Core
No
0035302: When you change the organization of a product category, it is not changed from the node of the product category tree.
When you change the organization of a product category, it is not changed from the node of the product category tree.
1- Go to “SQL Query” window in backend using the System administrator role.
2- Execute this query:
select tn.ad_treenode_id
        from M_Product_Category pc, ad_treenode tn
        where pc.ad_org_id <> tn.ad_org_id
        and pc.M_Product_Category_ID = tn.node_id

3- Any result is shown, because all the organizations of the product categories are the same as the organization of the product category tree node.
4- Now, go to “Product Category” window using The White Valley Group Admin and select a record, for example “Camping”. Change its category and set it as “Posets Store” and save it.
5- Execute again the query of step 2. Now, a result is shown, because the organization of the product category has been changed but not the node’s category of its tree. As consequence, this inconsistent categories are not show in webPOS.
No tags attached.
Issue History
2017-02-17 14:42nataliagNew Issue
2017-02-17 14:42nataliagAssigned To => Triage Finance
2017-02-17 14:42nataliagModules => Core
2017-02-17 14:42nataliagTriggers an Emergency Pack => No
2017-02-20 18:33markmm82Assigned ToTriage Finance => collazoandy4
2017-03-06 18:02markmm82Note Added: 0094772
2017-03-06 18:02markmm82Statusnew => scheduled
2017-03-07 17:13markmm82Note Edited: 0094772bug_revision_view_page.php?bugnote_id=0094772#r14742
2017-03-07 17:46hgbotCheckin
2017-03-07 17:46hgbotNote Added: 0094807
2017-03-07 17:46hgbotStatusscheduled => resolved
2017-03-07 17:46hgbotResolutionopen => fixed
2017-03-07 17:46hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/43a3e127a0440605a36591138fa18a10cf0e1f28 [^]
2017-03-07 17:49markmm82Review Assigned To => markmm82
2017-03-07 17:49markmm82Note Added: 0094808
2017-03-07 17:49markmm82Statusresolved => closed
2017-03-07 17:49markmm82Fixed in Version => 3.0PR17Q2
2017-03-12 16:30markmm82Assigned Tocollazoandy4 => luisrs8608
2017-03-15 20:21hudsonbotCheckin
2017-03-15 20:21hudsonbotNote Added: 0095275

Notes
(0094772)
markmm82   
2017-03-06 18:02   
(edited on: 2017-03-07 17:13)
Test plan

1- Go to “SQL Query” window in backend using the System administrator role.
2- Execute this query:
select tn.ad_treenode_id
        from M_Product_Category pc, ad_treenode tn
        where pc.ad_org_id <> tn.ad_org_id
        and pc.M_Product_Category_ID = tn.node_id

3- Any result is shown, because all the organizations of the product categories are the same as the organization of the product category tree node.
4- Now, go to “Product Category” window using The White Valley Group Admin and select a record, for example “Camping”. Change its organization and set it as “Posets Store” and save it.
5- Execute again the query of step 2 and notice that any result is shown, because all the organizations of the product categories has been updated and are the same as the new organization of the product category tree node.

(0094807)
hgbot   
2017-03-07 17:46   
Repository: erp/devel/pi
Changeset: 43a3e127a0440605a36591138fa18a10cf0e1f28
Author: Luis <luisrs8608 <at> gmail.com>
Date: Mon Mar 06 09:51:37 2017 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/43a3e127a0440605a36591138fa18a10cf0e1f28 [^]

Fixes issue 35302: Updated the node's organization of the product category tree.

When you change the organization of a product category, it is not changed from
the node of the product category tree. As consequence, categories are not shown
in webPOS.

To solve this, when the product category's organization is changed, the node's organization of the
product category tree is updated too.

---
M src-db/database/model/triggers/M_PRODUCT_CATEGORY_TRG.xml
---
(0094808)
markmm82   
2017-03-07 17:49   
Code review + Testing OK
(0095275)
hudsonbot   
2017-03-15 20:21   
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/54e102bef53e [^]
Maturity status: Test