Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004819Openbravo ERP09. Financial managementpublic2008-09-04 17:282008-10-24 18:25
Reporternetworkb 
Assigned Tovmromanos 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS Version
Product Version2.35MP5 
Target VersionFixed in Version2.35MP9 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0004819: Is not possible to change the alias in Account Combination window
DescriptionIt is currently not possible to modify the alias in window: Account Combination, as the alias in Valid Combination is overwritten by the value of the Element Value via a trigger.

Steps To ReproduceFinancial Management>Accounting>Setup>Account Combination

Change the Alias and save
Proposed SolutionModify the C_VALIDCOMBINATION_TRG so that whenever the alias in Account
Combination is empty, the value from Element Value is used. Whenever the alias is filled, it will not update from elementvalue anymore.

Modify

IF (Cur_AC%NOTFOUND) THEN -- mandatory
v_IsFullyQualified := 'N';
ELSE
:new.Alias := v_TempValue; --Alias is the account no
END IF;

to:

IF (Cur_AC%NOTFOUND) THEN -- mandatory
v_IsFullyQualified := 'N';
ELSE
IF (:old.Alias is null) THEN
:new.Alias := v_TempValue; --Alias is the account no
END IF;
END IF;

Attached you fill find the modified C_VALIDCOMBINATION_TRG
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0004801 closed vmromanos Is not possible to change the alias in Account Combination window 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-04 17:28cromeroNew Issue
2008-09-04 17:28cromeroAssigned To => vmromanos
2008-09-04 17:28cromeroStatusnew => scheduled
2008-09-05 12:20svnbotCheckin
2008-09-05 12:20svnbotNote Added: 0008891
2008-09-05 12:20svnbotStatusscheduled => resolved
2008-09-05 12:20svnbotResolutionopen => fixed
2008-09-05 12:20svnbotsvn_revision => 6873
2008-09-19 10:35cromeroStatusresolved => new
2008-09-19 10:35cromeroResolutionfixed => open
2008-09-19 10:35cromeroStatusnew => scheduled
2008-09-19 10:35cromerofix_in_branch2.3x => trunk
2008-09-19 10:47cromeroOBNetwork customer => No
2008-09-19 10:47cromerofix_in_branchtrunk => 2.3x
2008-09-19 10:47cromeroProposed Solution updated
2008-09-19 10:48svnbotCheckin
2008-09-19 10:48svnbotNote Added: 0009092
2008-09-19 10:48svnbotStatusscheduled => resolved
2008-09-19 10:48svnbotResolutionopen => fixed
2008-09-19 10:48svnbotsvn_revision6873 => 7541
2008-10-08 15:54psarobeStatusresolved => new
2008-10-08 15:54psarobeResolutionfixed => open
2008-10-08 15:54psarobeNote Added: 0009441
2008-10-08 15:54psarobeFixed in Version2.35MP9 =>
2008-10-08 15:57psarobeStatusnew => scheduled
2008-10-08 15:57psarobefix_in_branch2.3x => trunk
2008-10-08 18:45vmromanosfix_in_branchtrunk => 2.3x
2008-10-08 19:14svnbotCheckin
2008-10-08 19:14svnbotNote Added: 0009466
2008-10-08 19:14svnbotStatusscheduled => resolved
2008-10-08 19:14svnbotResolutionopen => fixed
2008-10-08 19:14svnbotsvn_revision7541 => 8421
2008-10-24 18:25plujanRegression testing => No
2008-10-24 18:25plujanStatusresolved => closed
2008-10-24 18:25plujanFixed in Version => 2.35MP9

Notes
(0008891)
svnbot   
2008-09-05 12:20   
Repository: openbravo
Revision: 6873
Author: vmromanos
Date: 2008-09-05 12:20:41 +0200 (Fri, 05 Sep 2008)

Fixed bug 0004819: Changed the C_VALIDCOMBINATION_TRG trigger

---
U branches/r2.3x/database/model/triggers/C_VALIDCOMBINATION_TRG.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=6873&sc=1 [^]
(0009092)
svnbot   
2008-09-19 10:48   
Repository: openbravo
Revision: 7541
Author: cromeroherrero
Date: 2008-09-19 10:48:53 +0200 (Fri, 19 Sep 2008)

Fixed bug 4819: Is not possible to change the alias in Account Combination window

---
U branches/r2.3x/database/model/triggers/C_VALIDCOMBINATION_TRG.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=7541&sc=1 [^]
(0009441)
psarobe   
2008-10-08 15:54   
The solution is not correct
(0009466)
svnbot   
2008-10-08 19:14   
Repository: openbravo
Revision: 8421
Author: vmromanos
Date: 2008-10-08 19:14:01 +0200 (Wed, 08 Oct 2008)

Fixed bug 0004819: Is not possible to change the alias in Account Combination window.

---
U branches/r2.3x/database/model/triggers/C_VALIDCOMBINATION_TRG.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=8421&sc=1 [^]