Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004801Openbravo ERP09. Financial managementpublic2008-09-03 16:002008-12-16 11:49
Reporternetworkb 
Assigned Tovmromanos 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS Version
Product Version2.35MP5 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0004801: 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
depends on backport 0004818 closed vmromanos Is not possible to change the alias in Account Combination window 
depends on backport 0004819 closed vmromanos Is not possible to change the alias in Account Combination window 
depends on backport 0005162 closed vmromanos Is not possible to change the alias in Account Combination window 
Attached Files? C_VALIDCOMBINATION_TRG.sql (7,728) 2008-09-03 16:00
https://issues.openbravo.com/file_download.php?file_id=242&type=bug
Issue History
Date ModifiedUsernameFieldChange
2008-09-03 16:00networkbNew Issue
2008-09-03 16:00networkbAssigned To => cromero
2008-09-03 16:00networkbsf_bug_id0 => 2091202
2008-09-03 16:00networkbFile Added: C_VALIDCOMBINATION_TRG.sql
2008-09-03 16:00networkbRegression testing => No
2008-09-04 17:28cromeroStatusnew => scheduled
2008-09-04 17:28cromeroAssigned Tocromero => vmromanos
2008-09-04 17:28cromerofix_in_branch => trunk
2008-09-05 13:33svnbotCheckin
2008-09-05 13:33svnbotNote Added: 0008893
2008-09-05 13:33svnbotStatusscheduled => resolved
2008-09-05 13:33svnbotResolutionopen => fixed
2008-09-05 13:33svnbotsvn_revision => 6885
2008-09-19 10:34svnbotCheckin
2008-09-19 10:34svnbotNote Added: 0009091
2008-09-19 10:34svnbotsvn_revision6885 => 7536
2008-09-22 18:01cromeroStatusresolved => new
2008-09-22 18:01cromeroResolutionfixed => open
2008-09-22 18:01cromeroStatusnew => scheduled
2008-09-22 18:01cromeroStatusscheduled => resolved
2008-09-22 18:01cromeroResolutionopen => fixed
2008-10-08 15:56psarobeStatusresolved => new
2008-10-08 15:56psarobeResolutionfixed => open
2008-10-08 15:56psarobeNote Added: 0009442
2008-10-08 15:57psarobeStatusnew => scheduled
2008-10-08 18:54svnbotCheckin
2008-10-08 18:54svnbotNote Added: 0009462
2008-10-08 18:54svnbotStatusscheduled => resolved
2008-10-08 18:54svnbotResolutionopen => fixed
2008-10-08 18:54svnbotsvn_revision7536 => 8418
2008-12-16 11:49psarobeStatusresolved => closed

Notes
(0008893)
svnbot   
2008-09-05 13:33   
Repository: openbravo
Revision: 6885
Author: vmromanos
Date: 2008-09-05 13:33:27 +0200 (Fri, 05 Sep 2008)

Fixed bug 0004801: Changed C_VALIDCOMBINATION_TRG trigger.

---
U trunk/src-db/database/model/triggers/C_VALIDCOMBINATION_TRG.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=6885&sc=1 [^]
(0009091)
svnbot   
2008-09-19 10:34   
Repository: openbravo
Revision: 7536
Author: cromeroherrero
Date: 2008-09-19 10:34:39 +0200 (Fri, 19 Sep 2008)

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

---
U trunk/src-db/database/model/triggers/C_VALIDCOMBINATION_TRG.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=7536&sc=1 [^]
(0009442)
psarobe   
2008-10-08 15:56   
The expected result is not the one the solution propose
(0009462)
svnbot   
2008-10-08 18:54   
Repository: openbravo
Revision: 8418
Author: vmromanos
Date: 2008-10-08 18:54:00 +0200 (Wed, 08 Oct 2008)

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

---
U trunk/src-db/database/model/triggers/C_VALIDCOMBINATION_TRG.xml
---

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