Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031628Openbravo ERP09. Financial managementpublic2015-11-26 10:302015-12-01 12:33
Reportermaite 
Assigned ToAtulOpenbravo 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q4.1Fixed in Version 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0031628: Debit and Credit values not shown when running General Ledger Report in XLS format using Microsoft Office 2007
DescriptionDebit and Credit values not shown when running General Ledger Report in XLS format using Microsoft Office 2007
Steps To Reproduce1. Run General Ledger Report in XLS format using Microsoft Office 2007 from a windows machine setting any filtering critera
2. Open xls file with Microsoft Excel and realize that Credit and Debit values are not shown

NOTE: difference is in format of Credit and Debit columns. If you open PR15Q2 file with Microsoft Office 2007 and check format of the column is "General". However file from PR15Q3 has format defined as "Personalize"
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0031593 closed AtulOpenbravo Debit and Credit values not shown when running General Ledger Report in XLS format using Microsoft Office 2007 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-12-01 12:30dmiguelezTypedefect => backport
2015-12-01 12:30dmiguelezTarget Version => 3.0PR15Q4.1
2015-12-01 12:32hgbotCheckin
2015-12-01 12:32hgbotNote Added: 0082485
2015-12-01 12:32hgbotStatusscheduled => resolved
2015-12-01 12:32hgbotResolutionopen => fixed
2015-12-01 12:32hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR15Q4.1/rev/f8452f44752ed15e329c861490d878ce3d311bd1 [^]
2015-12-01 12:33dmiguelezReview Assigned To => dmiguelez
2015-12-01 12:33dmiguelezNote Added: 0082486
2015-12-01 12:33dmiguelezStatusresolved => closed

Notes
(0082485)
hgbot   
2015-12-01 12:32   
Repository: erp/backports/3.0PR15Q4.1
Changeset: f8452f44752ed15e329c861490d878ce3d311bd1
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Mon Nov 30 14:24:17 2015 +0530
URL: http://code.openbravo.com/erp/backports/3.0PR15Q4.1/rev/f8452f44752ed15e329c861490d878ce3d311bd1 [^]

Fixes Issue 31628:Debit and Credit values not shown when running General
Ledger Report in XLS format using Microsoft Office 2007

Used Numberformat parameter to format the numeric fields

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerExcel.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceExcel.jrxml
---
(0082486)
dmiguelez   
2015-12-01 12:33   
Code Review + Testing Ok