Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0004818
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementminoralways2008-09-04 17:282008-12-09 08:19
ReporternetworkbView Statuspublic 
Assigned Tovmromanos 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branch2.40Fixed in SCM revision8455
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product Version2.35MP5SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0004818: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0004801 closedvmromanos Is not possible to change the alias in Account Combination window 

-  Notes
(0008892)
svnbot (reporter)
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 (reporter)
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 (manager)
2008-10-08 18:48

 The expected result is not the one the solution propose
(0009463)
svnbot (reporter)
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 (reporter)
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 [^]

- Issue History
Date Modified Username Field Change
2008-09-04 17:28 cromero New Issue
2008-09-04 17:28 cromero Assigned To => vmromanos
2008-09-04 17:28 cromero Status new => scheduled
2008-09-05 12:39 svnbot Checkin
2008-09-05 12:39 svnbot Note Added: 0008892
2008-09-05 12:39 svnbot Status scheduled => resolved
2008-09-05 12:39 svnbot Resolution open => fixed
2008-09-05 12:39 svnbot svn_revision => 6879
2008-09-19 10:35 cromero Status resolved => new
2008-09-19 10:35 cromero Resolution fixed => open
2008-09-19 10:35 cromero Status new => scheduled
2008-09-19 10:35 cromero fix_in_branch 2.40 => trunk
2008-09-19 10:47 cromero fix_in_branch trunk => 2.40
2008-09-19 10:47 cromero Proposed Solution updated
2008-09-19 10:52 svnbot Checkin
2008-09-19 10:52 svnbot Note Added: 0009093
2008-09-19 10:52 svnbot Status scheduled => resolved
2008-09-19 10:52 svnbot Resolution open => fixed
2008-09-19 10:52 svnbot svn_revision 6879 => 7542
2008-10-08 18:48 vmromanos Status resolved => new
2008-10-08 18:48 vmromanos Resolution fixed => open
2008-10-08 18:48 vmromanos Note Added: 0009461
2008-10-08 18:51 vmromanos Status new => scheduled
2008-10-08 18:51 vmromanos fix_in_branch 2.40 => trunk
2008-10-08 18:52 vmromanos fix_in_branch trunk => 2.40
2008-10-08 18:58 svnbot Checkin
2008-10-08 18:58 svnbot Note Added: 0009463
2008-10-08 18:58 svnbot Status scheduled => resolved
2008-10-08 18:58 svnbot Resolution open => fixed
2008-10-08 18:58 svnbot svn_revision 7542 => 8419
2008-10-09 11:22 svnbot Checkin
2008-10-09 11:22 svnbot Note Added: 0009482
2008-10-09 11:22 svnbot svn_revision 8419 => 8455
2008-12-09 08:19 krishna Regression testing => No
2008-12-09 08:19 krishna Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker