Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035304Openbravo ERP09. Financial managementpublic2017-02-20 08:452017-03-15 20:20
Reporterpradeepvarma 
Assigned Tomcobas 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR17Q2 
Merge Request Status
Review Assigned Tomarkmm82
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035304: Sales and purchase dimensional reports : after up gradation (version pr 16Q 2.4) nos(debit/credit) are coming as text instead of
DescriptionIn sales invoice dimensional report and purchase invoice dimensional report, after up gradation (version pr16Q2.4) nos are coming as text in this report,
For eg: say qty and unit price columns should be 150 and 100.00, instead of it is appearing as '150 and '100.00.
Steps To Reproduce1. Log into any CS version in livebuilds as F&B International group admin
2. Open the sales invoice dimensional report/purchase invoice dimensional report.
3. select the data range from 1st Feb 2014 till today.
4. Click on export XLS option.
5. Open the downloaded excel sheet and notice that the qty column, unit price columns or any numeric column has "'" in front of the value.

PS Note : refer to the attached excel sheets
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0031710 closed collazoandy4 Review XLS reports to apply cell type when required 
Attached Filesgz issue_45594.tar.gz (49,234) 2017-02-20 08:45
https://issues.openbravo.com/file_download.php?file_id=10464&type=bug
Issue History
Date ModifiedUsernameFieldChange
2017-02-20 08:45pradeepvarmaNew Issue
2017-02-20 08:45pradeepvarmaAssigned To => Triage Finance
2017-02-20 08:45pradeepvarmaFile Added: issue_45594.tar.gz
2017-02-20 08:45pradeepvarmaModules => Core
2017-02-20 08:45pradeepvarmaResolution time => 1489359600
2017-02-20 08:45pradeepvarmaTriggers an Emergency Pack => No
2017-02-20 10:04pradeepvarmaRelationship addedrelated to 0031710
2017-02-20 18:33markmm82Assigned ToTriage Finance => collazoandy4
2017-03-01 22:02hgbotCheckin
2017-03-01 22:02hgbotNote Added: 0094672
2017-03-01 22:02hgbotStatusnew => resolved
2017-03-01 22:02hgbotResolutionopen => fixed
2017-03-01 22:02hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/954decf4ec445646f4d514046c1697ab28b9fd03 [^]
2017-03-01 22:04markmm82Assigned Tocollazoandy4 => mcobas
2017-03-01 22:05markmm82Review Assigned To => markmm82
2017-03-01 22:05markmm82Note Added: 0094673
2017-03-01 22:05markmm82Statusresolved => closed
2017-03-01 22:05markmm82Fixed in Version => 3.0PR17Q2
2017-03-15 20:20hudsonbotCheckin
2017-03-15 20:20hudsonbotNote Added: 0095245

Notes
(0094672)
hgbot   
2017-03-01 22:02   
Repository: erp/devel/pi
Changeset: 954decf4ec445646f4d514046c1697ab28b9fd03
Author: Miguel <martencobasmiguel <at> gmail.com>
Date: Wed Mar 01 10:27:42 2017 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/954decf4ec445646f4d514046c1697ab28b9fd03 [^]

Fixes issue 35304: Sales and purchase invoice dimensional reports after up gradation
(version pr 16Q 2.4) the number columns are exported as text.

Sales Invoice and Purchase Invoice dimensional reports were not designed considering the
type of the original text field expressions when exported it to xls format.

The net.sf.jasperreports.export.xls.detect.cell.type property was added to
autodetect the cell types and also the pattern "#,##0.00;-#,##0.00" was
included to the fields of number type to rightly format them.

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesXLS.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesXLS.jrxml
---
(0094673)
markmm82   
2017-03-01 22:05   
Code review + Testing OK
(0095245)
hudsonbot   
2017-03-15 20:20   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/54e102bef53e [^]
Maturity status: Test