Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004818Openbravo ERP09. Financial managementpublic2008-09-04 17:282008-12-09 08:19
Reporternetworkb 
Assigned Tovmromanos 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS Version
Product Version2.35MP5 
Target VersionFixed in Version 
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
Summary0004818: 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:39svnbotCheckin
2008-09-05 12:39svnbotNote Added: 0008892
2008-09-05 12:39svnbotStatusscheduled => resolved
2008-09-05 12:39svnbotResolutionopen => fixed
2008-09-05 12:39svnbotsvn_revision => 6879
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.40 => trunk
2008-09-19 10:47cromeroOBNetwork customer => No
2008-09-19 10:47cromerofix_in_branchtrunk => 2.40
2008-09-19 10:47cromeroProposed Solution updated
2008-09-19 10:52svnbotCheckin
2008-09-19 10:52svnbotNote Added: 0009093
2008-09-19 10:52svnbotStatusscheduled => resolved
2008-09-19 10:52svnbotResolutionopen => fixed
2008-09-19 10:52svnbotsvn_revision6879 => 7542
2008-10-08 18:48vmromanosStatusresolved => new
2008-10-08 18:48vmromanosResolutionfixed => open
2008-10-08 18:48vmromanosNote Added: 0009461
2008-10-08 18:51vmromanosStatusnew => scheduled
2008-10-08 18:51vmromanosfix_in_branch2.40 => trunk
2008-10-08 18:52vmromanosfix_in_branchtrunk => 2.40
2008-10-08 18:58svnbotCheckin
2008-10-08 18:58svnbotNote Added: 0009463
2008-10-08 18:58svnbotStatusscheduled => resolved
2008-10-08 18:58svnbotResolutionopen => fixed
2008-10-08 18:58svnbotsvn_revision7542 => 8419
2008-10-09 11:22svnbotCheckin
2008-10-09 11:22svnbotNote Added: 0009482
2008-10-09 11:22svnbotsvn_revision8419 => 8455
2008-12-09 08:19krishnaRegression testing => No
2008-12-09 08:19krishnaStatusresolved => closed

Notes
(0008892)
svnbot   
2008-09-05 12:39   
Repository: openbravo
Revision: 6879
Author: vmromanos
Date: 2008-09-05 12:39:41 +0200 (Fri, 05 Sep 2008)

Fixed bug 0004818: Changed C_VALIDCOMBINATION_TRG trigger

---
U branches/r2.40/src-db/database/model/triggers/C_VALIDCOMBINATION_TRG.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=6879&sc=1 [^]
(0009093)
svnbot   
2008-09-19 10:52   
Repository: openbravo
Revision: 7542
Author: cromeroherrero
Date: 2008-09-19 10:52:35 +0200 (Fri, 19 Sep 2008)

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

---
U branches/r2.40/src-db/database/model/triggers/C_VALIDCOMBINATION_TRG.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=7542&sc=1 [^]
(0009461)
vmromanos   
2008-10-08 18:48   
The expected result is not the one the solution propose
(0009463)
svnbot   
2008-10-08 18:58   
Repository: openbravo
Revision: 8419
Author: vmromanos
Date: 2008-10-08 18:58:52 +0200 (Wed, 08 Oct 2008)

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

---
U branches/r2.40/src-db/database/model/triggers/C_VALIDCOMBINATION_TRG.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=8419&sc=1 [^]
(0009482)
svnbot   
2008-10-09 11:22   
Repository: openbravo
Revision: 8455
Author: villind
Date: 2008-10-09 11:22:05 +0200 (Thu, 09 Oct 2008)

Merged in change 8419. Fixed bug 0004818: Is not possible to change the alias in Account Combination window.

---
_U branches/bonware/r2.40/
_U branches/bonware/r2.40/config/setup-tool/
_U branches/bonware/r2.40/eclipse.install.source.launch
_U branches/bonware/r2.40/export.database.launch
_U branches/bonware/r2.40/src-core/src/org/openbravo/database/OpenbravoDriverManagerConnectionFactory.java
U branches/bonware/r2.40/src-db/database/model/triggers/C_VALIDCOMBINATION_TRG.xml
_U branches/bonware/r2.40/update.database.launch
---

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