Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016173Openbravo ERP09. Financial managementpublic2011-03-08 18:182011-03-23 00:00
Reporteradrianromero 
Assigned Tojonalegriaesarte 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Versionpi 
Target VersionFixed in Version3.0RC6 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0016173: 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
Additional Information
TagsNo tags attached.
Relationships
blocks backport 00158502.50MP28 closed jonalegriaesarte the XLS generated in report trial balance is not correct 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-03-08 18:18adrianromeroNew Issue
2011-03-08 18:18adrianromeroAssigned To => jonalegriaesarte
2011-03-08 18:18adrianromeroModules => Core
2011-03-08 18:18adrianromeroOBNetwork customer => Yes
2011-03-08 18:18adrianromeroIssue generated from0015850
2011-03-08 18:18adrianromeroRelationship addedblocks 0015850
2011-03-08 18:18adrianromeroStatusnew => scheduled
2011-03-08 18:18adrianromerofix_in_branch => pi
2011-03-09 11:15hgbotCheckin
2011-03-09 11:15hgbotNote Added: 0034682
2011-03-09 11:15hgbotStatusscheduled => resolved
2011-03-09 11:15hgbotResolutionopen => fixed
2011-03-09 11:15hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/61f174927bf2357331b93bcc6b1f827a5ac29d71 [^]
2011-03-22 17:00malsasuaNote Added: 0035159
2011-03-22 17:00malsasuaStatusresolved => closed
2011-03-22 17:00malsasuaFixed in Version => 3.0RC6
2011-03-23 00:00anonymoussf_bug_id0 => 3235753

Notes
(0034682)
hgbot   
2011-03-09 11:15   
Repository: erp/devel/pi
Changeset: 61f174927bf2357331b93bcc6b1f827a5ac29d71
Author: Egoitz Castillo <egoitz.castillo <at> openbravo.com>
Date: Wed Mar 09 11:14:44 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/61f174927bf2357331b93bcc6b1f827a5ac29d71 [^]

Fixes issue 0016173: 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
---
(0035159)
malsasua   
2011-03-22 17:00   
it works fine