Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0022089Openbravo ERP09. Financial managementpublic2012-10-24 12:532012-11-30 14:08
Reporterngarcia 
Assigned Tocaristu 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP18Fixed in Version3.0MP18 
Merge Request Status
Review Assigned Tongarcia
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket17551
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0022089: Modulescript needed to correct the fact_acct records with acctdescription different from the associated element value name
DescriptionModulescript needed to correct the fact_acct records with acctdescription different from the associated element value name
Steps To ReproduceAs group admin role:
   Generate the General Ledger Report
   From Date: 31-12-2011
   To Date: today's date
   Accounting schema: F&B International Group US/A/US Dollar
   From Account: Income Summary
   To Account: Income Summary
   Notice that in the title the description of the 8990 element value is shown instead of its name
   The same happens if you navigate to associated journal entries
Proposed SolutionThe query could be:

update fact_acct
set acctdescription = (select name from c_elementvalue where c_elementvalue_id = account_id)
where fact_acct_id in
(select fact_acct_id
from fact_acct fa left join c_elementvalue ev on fa.account_id = ev.c_elementvalue_id
where (fa.acctdescription is null
or (fa.acctdescription is not null and fa.acctdescription <> ev.name)))
Additional Information
TagsNo tags attached.
Relationships
related to defect 0021661 closed eduardo_Argal Account Tree: update to the Name not shown in the account tree 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-10-24 12:53ngarciaNew Issue
2012-10-24 12:53ngarciaAssigned To => dmiguelez
2012-10-24 12:53ngarciaModules => Core
2012-10-24 12:53ngarciaOBNetwork customer => Yes
2012-10-24 12:53ngarciaSupport ticket => 17551
2012-10-24 12:53ngarciaRelationship addedrelated to 0021661
2012-10-24 12:53ngarciaIssue Monitored: networkb
2012-10-24 12:56dmiguelezAssigned Todmiguelez => jonalegriaesarte
2012-10-30 12:45jonalegriaesarteNote Added: 0053810
2012-10-30 12:45jonalegriaesarteTypedefect => feature request
2012-10-30 12:48jonalegriaesarteAssigned Tojonalegriaesarte => caristu
2012-10-30 12:48jonalegriaesarteTarget Version3.0MP17 => 3.0MP18
2012-11-27 08:50hgbotCheckin
2012-11-27 08:50hgbotNote Added: 0054508
2012-11-27 08:50hgbotStatusnew => resolved
2012-11-27 08:50hgbotResolutionopen => fixed
2012-11-27 08:50hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f7c14ec8bc1aec631890655a8c30a0da9ae25973 [^]
2012-11-27 09:03hgbotCheckin
2012-11-27 09:03hgbotNote Added: 0054509
2012-11-27 19:39hudsonbotCheckin
2012-11-27 19:39hudsonbotNote Added: 0054608
2012-11-27 19:39hudsonbotCheckin
2012-11-27 19:39hudsonbotNote Added: 0054609
2012-11-28 19:17ngarciaReview Assigned To => ngarcia
2012-11-28 19:17ngarciaNote Added: 0054646
2012-11-28 19:17ngarciaStatusresolved => closed
2012-11-28 19:17ngarciaFixed in Version => 3.0MP18
2012-11-30 14:08ngarciaNote Added: 0054674

Notes
(0053810)
jonalegriaesarte   
2012-10-30 12:45   
This is a feature request that will be developed during November and it will be included in MP18
(0054508)
hgbot   
2012-11-27 08:50   
Repository: erp/devel/pi
Changeset: f7c14ec8bc1aec631890655a8c30a0da9ae25973
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Mon Nov 26 11:32:51 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/f7c14ec8bc1aec631890655a8c30a0da9ae25973 [^]

fixes issue 22089: Modulescript needed to correct the fact_acct records
with acctdescription different from the associated element value name

---
A src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateFactAcctDescription.class
A src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateFactAcctDescriptionData.class
A src-util/modulescript/src/org/openbravo/modulescript/UpdateFactAcctDescription.java
A src-util/modulescript/src/org/openbravo/modulescript/UpdateFactAcctDescription_data.xsql
---
(0054509)
hgbot   
2012-11-27 09:03   
Repository: erp/devel/pi
Changeset: 1734e920ff4c1c079c34d937f084a92cc480434a
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Tue Nov 27 09:01:57 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/1734e920ff4c1c079c34d937f084a92cc480434a [^]

related to issue 22089: corrects license year

---
M src-util/modulescript/src/org/openbravo/modulescript/UpdateFactAcctDescription_data.xsql
---
(0054608)
hudsonbot   
2012-11-27 19:39   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/eaf1a8bdbf4e [^]

Maturity status: Test
(0054609)
hudsonbot   
2012-11-27 19:39   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/eaf1a8bdbf4e [^]

Maturity status: Test
(0054646)
ngarcia   
2012-11-28 19:17   
verified
(0054674)
ngarcia   
2012-11-30 14:08   
There is another commit related with this issue in the following bug:

https://issues.openbravo.com/view.php?id=22435 [^]