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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0022089
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] 09. Financial managementmajoralways2012-10-24 12:532012-11-30 14:08
ReporterngarciaView Statuspublic 
Assigned Tocaristu 
PriorityurgentResolutionfixedFixed in Version3.0MP18
StatusclosedFix in branchFixed in SCM revisionf7c14ec8bc1a
ProjectionnoneETAnoneTarget Version3.0MP18
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tongarcia
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

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

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0021661 closededuardo_Argal Account Tree: update to the Name not shown in the account tree 

-  Notes
(0053810)
jonalegriaesarte (reporter)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
2012-11-28 19:17

verified
(0054674)
ngarcia (developer)
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 [^]

- Issue History
Date Modified Username Field Change
2012-10-24 12:53 ngarcia New Issue
2012-10-24 12:53 ngarcia Assigned To => dmiguelez
2012-10-24 12:53 ngarcia Modules => Core
2012-10-24 12:53 ngarcia Relationship added related to 0021661
2012-10-24 12:53 ngarcia Issue Monitored: networkb
2012-10-24 12:56 dmiguelez Assigned To dmiguelez => jonalegriaesarte
2012-10-30 12:45 jonalegriaesarte Note Added: 0053810
2012-10-30 12:45 jonalegriaesarte Type defect => feature request
2012-10-30 12:48 jonalegriaesarte Assigned To jonalegriaesarte => caristu
2012-10-30 12:48 jonalegriaesarte Target Version 3.0MP17 => 3.0MP18
2012-11-27 08:50 hgbot Checkin
2012-11-27 08:50 hgbot Note Added: 0054508
2012-11-27 08:50 hgbot Status new => resolved
2012-11-27 08:50 hgbot Resolution open => fixed
2012-11-27 08:50 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f7c14ec8bc1aec631890655a8c30a0da9ae25973 [^]
2012-11-27 09:03 hgbot Checkin
2012-11-27 09:03 hgbot Note Added: 0054509
2012-11-27 19:39 hudsonbot Checkin
2012-11-27 19:39 hudsonbot Note Added: 0054608
2012-11-27 19:39 hudsonbot Checkin
2012-11-27 19:39 hudsonbot Note Added: 0054609
2012-11-28 19:17 ngarcia Review Assigned To => ngarcia
2012-11-28 19:17 ngarcia Note Added: 0054646
2012-11-28 19:17 ngarcia Status resolved => closed
2012-11-28 19:17 ngarcia Fixed in Version => 3.0MP18
2012-11-30 14:08 ngarcia Note Added: 0054674


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker