0022584: When changing the organization for a price list, this change is not applied into their child lists

diff -r 555f4b2e7402 src-db/database/model/triggers/M_PRICELIST_TRG.xml --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src-db/database/model/triggers/M_PRICELIST_TRG.xml Thu Feb 07 23:49:55 2013 +0100 @@ -0,0 +1,43 @@ +<?xml version="1.0"?> + <database name="TRIGGER M_PRICELIST_TRG"> + <trigger name="M_PRICELIST_TRG" table="M_PRICELIST" fires="after" insert="false" update="true" delete="false" foreach="row"> + <body><![CDATA[ + +/************************************************************************* +* The contents of this file are subject to the Openbravo Public License +* Version 1.1 (the "License"), being the Mozilla Public License +* Version 1.1 with a permitted attribution clause; you may not use this +* file except in compliance with the License. You may obtain a copy of +* the License at http://www.openbravo.com/legal/license.html +* Software distributed under the License is distributed on an "AS IS" +* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the +* License for the specific language governing rights and limitations +* under the License. +* The Original Code is Openbravo ERP. +* The Initial Developer of the Original Code is Openbravo SLU +* All portions are Copyright (C) 2013 Openbravo SLU +* All Rights Reserved. +* Contributor(s): ______________________________________. +************************************************************************/ + + v_count NUMBER; + +BEGIN + + IF AD_isTriggerEnabled()='N' THEN RETURN; + END IF; + + SELECT count(*) + INTO v_count + FROM m_pricelist_version plv + WHERE plv.m_pricelist_id = :old.m_pricelist_id; + + IF (v_count > 0 and :old.ad_org_id <> :new.ad_org_id) THEN + UPDATE m_pricelist_version set ad_org_id=:new.ad_org_id + WHERE m_pricelist_id=:old.m_pricelist_id; + END IF; + + END M_PRICELIST_TRG +]]></body> + </trigger> + </database> diff -r 555f4b2e7402 src-db/database/model/triggers/M_PRICELIST_VERSION_TRG.xml --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src-db/database/model/triggers/M_PRICELIST_VERSION_TRG.xml Thu Feb 07 23:49:55 2013 +0100 @@ -0,0 +1,42 @@ +<?xml version="1.0"?> + <database name="TRIGGER M_PRICELIST_VERSION_TRG"> + <trigger name="M_PRICELIST_VERSION_TRG" table="M_PRICELIST_VERSION" fires="after" insert="false" update="true" delete="false" foreach="row"> + <body><![CDATA[ + +/************************************************************************* +* The contents of this file are subject to the Openbravo Public License +* Version 1.1 (the "License"), being the Mozilla Public License +* Version 1.1 with a permitted attribution clause; you may not use this +* file except in compliance with the License. You may obtain a copy of +* the License at http://www.openbravo.com/legal/license.html +* Software distributed under the License is distributed on an "AS IS" +* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the +* License for the specific language governing rights and limitations +* under the License. +* The Original Code is Openbravo ERP. +* The Initial Developer of the Original Code is Openbravo SLU +* All portions are Copyright (C) 2013 Openbravo SLU +* All Rights Reserved. +* Contributor(s): ______________________________________. +************************************************************************/ + v_count NUMBER; + +BEGIN + + IF AD_isTriggerEnabled()='N' THEN RETURN; + END IF; + + SELECT count(*) + INTO v_count + FROM m_productprice pp + WHERE pp.m_pricelist_version_id = :old.m_pricelist_version_id; + + IF (v_count > 0 and :old.ad_org_id <> :new.ad_org_id) THEN + UPDATE m_productprice set ad_org_id=:new.ad_org_id + WHERE m_pricelist_version_id=:old.m_pricelist_version_id; + END IF; + + END M_PRICELIST_VERSION_TRG +]]></body> + </trigger> + </database>

Issue History
Date Modified	Username	Field	Change
2012-12-14 13:17	caristu	New Issue
2012-12-14 13:17	caristu	Assigned To	=> dmiguelez
2012-12-14 13:17	caristu	Modules	=> Core
2012-12-14 13:17	caristu	Triggers an Emergency Pack	=> No
2012-12-17 09:57	caristu	Resolution time	=> 1361487600
2012-12-17 09:58	caristu	Target Version	=> 3.0MP20
2012-12-17 10:01	dmiguelez	Assigned To	dmiguelez => jonalegriaesarte
2013-01-24 11:12	jonalegriaesarte	Target Version	3.0MP20 => 3.0MP21
2013-02-05 14:45	txasu	Note Added: 0056168
2013-02-05 14:46	txasu	Note Edited: 0056168	View Revisions
2013-02-07 22:10	jecharri	Assigned To	jonalegriaesarte => jecharri
2013-02-07 23:22	jecharri	Status	new => scheduled
2013-02-07 23:22	jecharri	fix_in_branch	=> pi
2013-02-07 23:23	jecharri	Note Added: 0056277
2013-02-07 23:54	jecharri	File Added: issue_22584.diff
2013-02-11 12:43	hgbot	Checkin
2013-02-11 12:43	hgbot	Note Added: 0056325
2013-02-11 12:43	hgbot	Status	scheduled => resolved
2013-02-11 12:43	hgbot	Resolution	open => fixed
2013-02-11 12:43	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/2b1ed45e9a0af2d5ce896326e5633a89b3c01143 [^]
2013-02-11 12:44	jecharri	Note Added: 0056326
2013-02-15 15:36	caristu	Review Assigned To	=> caristu
2013-02-15 15:36	caristu	Note Added: 0056494
2013-02-15 15:36	caristu	Status	resolved => closed
2013-02-20 04:49	hudsonbot	Checkin
2013-02-20 04:49	hudsonbot	Note Added: 0056559
2014-02-05 13:31	ngarcia	Relationship added	related to 0022314

Notes
(0056168) txasu (reporter) 2013-02-05 14:45 edited on: 2013-02-05 14:46	Jon, FYI: Same happens when changing the org for a business partner: bank account and locations tabs are not updated. Regards.

(0056277) jecharri (developer) 2013-02-07 23:23	Issue resolved. Pending to unfreeze pi

(0056325) hgbot (developer) 2013-02-11 12:43	Repository: erp/devel/pi Changeset: 2b1ed45e9a0af2d5ce896326e5633a89b3c01143 Author: Javier Etxarri <javier.echarri <at> openbravo.com> Date: Mon Feb 11 12:43:15 2013 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/2b1ed45e9a0af2d5ce896326e5633a89b3c01143 [^] Fixes issue 22584: When changing the organization for a price list, this change is not applied into their child lists --- M src-db/database/sourcedata/AD_COLUMN.xml ---

(0056326) jecharri (developer) 2013-02-11 12:44	Finally we have decided to disactivate the posibility to change the price list organization or of the BP

(0056494) caristu (developer) 2013-02-15 15:36	Verified

(0056559) hudsonbot (developer) 2013-02-20 04:49	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/d828167a9e83 [^] Maturity status: Test