Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0004801 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | minor | always | 2008-09-03 16:00 | 2008-12-16 11:49 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | vmromanos | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 8418 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | Oracle | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.35MP5 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0004801: Is not possible to change the alias in Account Combination window | |||||||
| Description | It 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 Reproduce | Financial Management>Accounting>Setup>Account Combination Change the Alias and save | |||||||
| Proposed Solution | Modify 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 | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  C_VALIDCOMBINATION_TRG.sql [^] (7,728 bytes) 2008-09-03 16:00 | |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||||||||||||||||
|
||||||||||||||||||||||
 Relationships |
|
Notes |
|
|
(0008893) svnbot (reporter) 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 (reporter) 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 (manager) 2008-10-08 15:56 |
The expected result is not the one the solution propose |
|
(0009462) svnbot (reporter) 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 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-09-03 16:00 | networkb | New Issue | |
| 2008-09-03 16:00 | networkb | Assigned To | => cromero |
| 2008-09-03 16:00 | networkb | sf_bug_id | 0 => 2091202 |
| 2008-09-03 16:00 | networkb | File Added: C_VALIDCOMBINATION_TRG.sql | |
| 2008-09-03 16:00 | networkb | Regression testing | => No |
| 2008-09-04 17:28 | cromero | Status | new => scheduled |
| 2008-09-04 17:28 | cromero | Assigned To | cromero => vmromanos |
| 2008-09-04 17:28 | cromero | fix_in_branch | => trunk |
| 2008-09-05 13:33 | svnbot | Checkin | |
| 2008-09-05 13:33 | svnbot | Note Added: 0008893 | |
| 2008-09-05 13:33 | svnbot | Status | scheduled => resolved |
| 2008-09-05 13:33 | svnbot | Resolution | open => fixed |
| 2008-09-05 13:33 | svnbot | svn_revision | => 6885 |
| 2008-09-19 10:34 | svnbot | Checkin | |
| 2008-09-19 10:34 | svnbot | Note Added: 0009091 | |
| 2008-09-19 10:34 | svnbot | svn_revision | 6885 => 7536 |
| 2008-09-22 18:01 | cromero | Status | resolved => new |
| 2008-09-22 18:01 | cromero | Resolution | fixed => open |
| 2008-09-22 18:01 | cromero | Status | new => scheduled |
| 2008-09-22 18:01 | cromero | Status | scheduled => resolved |
| 2008-09-22 18:01 | cromero | Resolution | open => fixed |
| 2008-10-08 15:56 | psarobe | Status | resolved => new |
| 2008-10-08 15:56 | psarobe | Resolution | fixed => open |
| 2008-10-08 15:56 | psarobe | Note Added: 0009442 | |
| 2008-10-08 15:57 | psarobe | Status | new => scheduled |
| 2008-10-08 18:54 | svnbot | Checkin | |
| 2008-10-08 18:54 | svnbot | Note Added: 0009462 | |
| 2008-10-08 18:54 | svnbot | Status | scheduled => resolved |
| 2008-10-08 18:54 | svnbot | Resolution | open => fixed |
| 2008-10-08 18:54 | svnbot | svn_revision | 7536 => 8418 |
| 2008-12-16 11:49 | psarobe | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |