Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0023815

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

defect

[Openbravo ERP] 09. Financial management

major

have not tried

2013-05-14 12:43

2013-06-03 12:58

Reporter

jonalegriaesarte

View Status

public

Assigned To

ioritzCia

Priority

normal

Resolution

fixed

Fixed in Version

3.0MP24

Status

closed

Fix in branch

pi

Fixed in SCM revision

Projection

none

ETA

none

Target Version

3.0MP24

OS

Any

Database

Any

Java version

OS Version

Database version

Ant version

Product Version

pi

SCM revision

Merge Request Status

Review Assigned To

jonalegriaesarte

OBNetwork customer

OBPS

Web browser

Modules

Core

Support ticket

21125

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0023815: When updating a subaccount the system is activating all the valid combinations associated

Description

When updating a subaccount the system is activating all the valid combinations associated

Steps To Reproduce

- With valid combinations inactive, update an account. All the valid combinations are activated due to this trigger:

C_ELEMENTVALUE_TRG:

     IF(:new.elementlevel = 'S') THEN
        SELECT COUNT(*)
        INTO v_Count
        FROM C_VALIDCOMBINATION
        WHERE Account_ID=:new.C_ElementValue_ID;
                                if(v_Count>0) THEN
                            UPDATE C_ValidCombination
                              SET Updated=now(), isactive = 'Y'
                              WHERE Account_ID=:new.C_ElementValue_ID;
                          ELSE
                            FOR cur_AcctSchema IN
                                (SELECT C_AcctSchema_ID
                                FROM C_AcctSchema_Element
                                WHERE C_AcctSchema_Element.C_Element_ID = :new.C_Element_ID
                                )
                              LOOP
                                                  INSERT INTO C_VALIDCOMBINATION
                                                          (C_VALIDCOMBINATION_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
                                                           UPDATED, UPDATEDBY, ALIAS, COMBINATION, DESCRIPTION, ISFULLYQUALIFIED,
                                                           C_ACCTSCHEMA_ID, ACCOUNT_ID, M_PRODUCT_ID, C_BPARTNER_ID, AD_ORGTRX_ID, C_LOCFROM_ID,
                                                           C_LOCTO_ID, C_SALESREGION_ID, C_PROJECT_ID, C_CAMPAIGN_ID, C_ACTIVITY_ID, USER1_ID,
                                                           USER2_ID)
                                                        VALUES (
                                                           GET_UUID(), :new.AD_Client_ID, :new.AD_Org_ID, :new.IsActive, :new.Created, :new.CreatedBy,
                                                           :new.Updated, :new.UpdatedBy, :new.value, :new.value, '', 'Y',
                                                           cur_AcctSchema.C_AcctSchema_ID, :new.C_ElementValue_ID, null, null, null, null,
                                                           null, null, null, null, null, null,
                                                           null);
                                                END LOOP;
                    END IF;
     END IF;

Tags

No tags attached.

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0058898) hgbot (developer) 2013-05-23 12:04	Repository: erp/devel/pi Changeset: 291741e7259e5223c83374283af6051a67916894 Author: Ioritz Cia <ioritz.cia <at> openbravo.com> Date: Wed May 22 17:22:04 2013 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/291741e7259e5223c83374283af6051a67916894 [^] Fixes issue 23815: When updating a subaccount the system is activating all the valid combinations associated. --- M src-db/database/model/triggers/C_ELEMENTVALUE_TRG.xml ---

(0058920) hudsonbot (viewer) 2013-05-24 01:19	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/758b27652865 [^] Maturity status: Test

(0059127) jonalegriaesarte (viewer) 2013-06-03 12:58	Verified, now the account combinations of the inactive accounting schemas are not updated.

Issue History
Date Modified	Username	Field	Change
2013-05-14 12:43	jonalegriaesarte	New Issue
2013-05-14 12:43	jonalegriaesarte	Assigned To	=> jonalegriaesarte
2013-05-14 12:43	jonalegriaesarte	Modules	=> Core
2013-05-14 12:43	jonalegriaesarte	OBNetwork customer	=> Yes
2013-05-14 12:43	jonalegriaesarte	Support ticket	=> 21125
2013-05-14 12:43	jonalegriaesarte	Triggers an Emergency Pack	=> No
2013-05-20 16:33	jonalegriaesarte	Assigned To	jonalegriaesarte => ioritzCia
2013-05-22 17:25	ioritzCia	Status	new => scheduled
2013-05-22 17:25	ioritzCia	fix_in_branch	=> pi
2013-05-23 12:04	hgbot	Checkin
2013-05-23 12:04	hgbot	Note Added: 0058898
2013-05-23 12:04	hgbot	Status	scheduled => resolved
2013-05-23 12:04	hgbot	Resolution	open => fixed
2013-05-23 12:04	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/291741e7259e5223c83374283af6051a67916894 [^]
2013-05-24 01:19	hudsonbot	Checkin
2013-05-24 01:19	hudsonbot	Note Added: 0058920
2013-06-03 12:58	jonalegriaesarte	Review Assigned To	=> jonalegriaesarte
2013-06-03 12:58	jonalegriaesarte	Note Added: 0059127
2013-06-03 12:58	jonalegriaesarte	Status	resolved => closed
2013-06-03 12:58	jonalegriaesarte	Fixed in Version	=> 3.0MP24

Copyright © 2000 - 2009 MantisBT Group