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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0015850
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementminoralways2011-02-03 10:052011-03-22 16:51
ReportermalsasuaView Statuspublic 
Assigned Tojonalegriaesarte 
PriorityhighResolutionfixedFixed in Version2.50MP28
StatusclosedFix in branchFixed in SCM revisiond276a24c4ada
ProjectionnoneETAnoneTarget Version2.50MP28
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product Version2.50MP27SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015850: the XLS generated in report trial balance is not correct

Descriptionin html, the amounts are distinct that xls format
Steps To Reproducein smallbazar, to run the report with the filters:
from date:01/01/2007
to date: 31/12/2007
org: main
account level: subaccount
run html:
 account 40000 : initial balance -701.30
run XLS:
 account 40000 : initial balance 4201.30
Proposed Solution. to calculate the initial balance in sql, the label union should be replace by union all
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00140742.50MP21 closedsathiyan Error with Opening entry in Trial Balance report 
depends on defect 0016173 closedjonalegriaesarte the XLS generated in report trial balance is not correct 

-  Notes
(0034678)
hgbot (developer)
2011-03-09 10:42

 Repository: erp/stable/2.50
Changeset: d276a24c4ada11393fcbcdb52cb7b9f5c56b0c95
Author: Egoitz Castillo <egoitz.castillo <at> openbravo.com>
Date: Wed Mar 09 10:41:27 2011 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/d276a24c4ada11393fcbcdb52cb7b9f5c56b0c95 [^]

Fixes issue 0015850: the XLS generated in report trial balance is not correct
Added an union all in the sql that shows the results in XLS.

---
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql
---
(0035155)
malsasua (developer)
2011-03-22 16:51

 it works fine.

- Issue History
Date Modified Username Field Change
2011-02-03 10:05 malsasua New Issue
2011-02-03 10:05 malsasua Assigned To => dalsasua
2011-02-03 10:05 malsasua Modules => Core
2011-02-03 10:07 malsasua Issue Monitored: networkb
2011-02-03 10:07 malsasua Note Added: 0034019
2011-02-17 10:53 dalsasua Note Deleted: 0034019
2011-02-17 10:56 dalsasua Severity major => minor
2011-03-08 18:17 adrianromero Assigned To dalsasua => jonalegriaesarte
2011-03-08 18:17 adrianromero Status new => scheduled
2011-03-08 18:17 adrianromero fix_in_branch => pi
2011-03-08 18:17 adrianromero Type defect => backport
2011-03-08 18:17 adrianromero version => 2.50MP27
2011-03-08 18:17 adrianromero fix_in_branch pi =>
2011-03-08 18:18 adrianromero Issue cloned 0016173
2011-03-08 18:18 adrianromero Relationship added depends on 0016173
2011-03-09 09:50 dalsasua Relationship added related to 0014074
2011-03-09 10:42 hgbot Checkin
2011-03-09 10:42 hgbot Note Added: 0034678
2011-03-09 10:42 hgbot Status scheduled => resolved
2011-03-09 10:42 hgbot Resolution open => fixed
2011-03-09 10:42 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/d276a24c4ada11393fcbcdb52cb7b9f5c56b0c95 [^]
2011-03-22 16:51 malsasua Note Added: 0035155
2011-03-22 16:51 malsasua Status resolved => closed
2011-03-22 16:51 malsasua Fixed in Version => 2.50MP28

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker