Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031629Openbravo ERP09. Financial managementpublic2015-11-26 10:302015-12-01 12:33
Reportermaite 
Assigned ToAtulOpenbravo 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q3.4Fixed 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
Summary0031629: 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.0PR15Q3.4
2015-12-01 12:32hgbotCheckin
2015-12-01 12:32hgbotNote Added: 0082483
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.0PR15Q3.4/rev/6abe3000db92a8e84f1ecfac110496db027f4c9e [^]
2015-12-01 12:33dmiguelezReview Assigned To => dmiguelez
2015-12-01 12:33dmiguelezNote Added: 0082487
2015-12-01 12:33dmiguelezStatusresolved => closed

Notes
(0082483)
hgbot   
2015-12-01 12:32   
Repository: erp/backports/3.0PR15Q3.4
Changeset: 6abe3000db92a8e84f1ecfac110496db027f4c9e
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.0PR15Q3.4/rev/6abe3000db92a8e84f1ecfac110496db027f4c9e [^]

Fixes Issue 31629: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
---
(0082487)
dmiguelez   
2015-12-01 12:33   
Code Review + Testing Ok