Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015850Openbravo ERP09. Financial managementpublic2011-02-03 10:052011-03-22 16:51
Reportermalsasua 
Assigned Tojonalegriaesarte 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version2.50MP27 
Target Version2.50MP28Fixed in Version2.50MP28 
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
Summary0015850: 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
related to defect 00140742.50MP21 closed sathiyan Error with Opening entry in Trial Balance report 
depends on defect 0016173 closed jonalegriaesarte the XLS generated in report trial balance is not correct 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-02-03 10:05malsasuaNew Issue
2011-02-03 10:05malsasuaAssigned To => dalsasua
2011-02-03 10:05malsasuaModules => Core
2011-02-03 10:05malsasuaOBNetwork customer => Yes
2011-02-03 10:07malsasuaIssue Monitored: networkb
2011-02-03 10:07malsasuaNote Added: 0034019
2011-02-17 10:53dalsasuaNote Deleted: 0034019
2011-02-17 10:56dalsasuaSeveritymajor => minor
2011-03-08 18:17adrianromeroAssigned Todalsasua => jonalegriaesarte
2011-03-08 18:17adrianromeroStatusnew => scheduled
2011-03-08 18:17adrianromerofix_in_branch => pi
2011-03-08 18:17adrianromeroTypedefect => backport
2011-03-08 18:17adrianromeroversion => 2.50MP27
2011-03-08 18:17adrianromerofix_in_branchpi =>
2011-03-08 18:18adrianromeroIssue cloned0016173
2011-03-08 18:18adrianromeroRelationship addeddepends on 0016173
2011-03-09 09:50dalsasuaRelationship addedrelated to 0014074
2011-03-09 10:42hgbotCheckin
2011-03-09 10:42hgbotNote Added: 0034678
2011-03-09 10:42hgbotStatusscheduled => resolved
2011-03-09 10:42hgbotResolutionopen => fixed
2011-03-09 10:42hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/d276a24c4ada11393fcbcdb52cb7b9f5c56b0c95 [^]
2011-03-22 16:51malsasuaNote Added: 0035155
2011-03-22 16:51malsasuaStatusresolved => closed
2011-03-22 16:51malsasuaFixed in Version => 2.50MP28

Notes
(0034678)
hgbot   
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   
2011-03-22 16:51   
it works fine.