Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0031710Openbravo ERP09. Financial managementpublic2015-12-15 10:052017-09-21 16:49
caristu 
collazoandy4 
highminorN/A
closedfixed 
5
 
3.0PR17Q4 
aferraz
Core
No
0031710: Review XLS reports to apply cell type when required
Since [1] the XLS report content is exported as string in order to ensure that all the data can be seen when opening this kind of reports with Office.

In order to ensure a correct definition of our core XLS reports, they should be reviewed and for example make numeric fields be exported as numbers. This way they can be manipulated directly after opening them with any spreadsheet application.

Currently the General Ledger Report and the Trial Balance are properly configured as explained here[2] and numeric values are seen as numbers in spreadsheet. The rest of XLS reports should be configured in the same way.

Note: with fix [3], BigDecimal values are exported as numbers. The decimal and thousands separators used for that numbers will be those configured in the spreadsheet program (Excel).

[1] https://issues.openbravo.com/view.php?id=31676 [^]
[2] http://wiki.openbravo.com/wiki/How_to_create_a_Report#Configuring_Cell_Type_in_XLS_Reports [^]
[3] https://code.openbravo.com/erp/devel/pi/rev/bfee0e727006 [^]
In description
No tags attached.
related to defect 0031676 closed caristu Openbravo ERP Some values are not shown in XLS format after Jasper Library Upgrade using Microsoft Office 2007 
related to defect 0034973 closed collazoandy4 Localization Pack: Spain In Multidimensional Tax Report, after up gradation (version pr 16Q 2.4) nos(debit/credit) are coming as text instead of no 
has duplicate defect 0033832 closed Triage Omni OMS Openbravo ERP Numeric Values in Reports are Text not numeric in Excel 
related to defect 0032954 closed AtulOpenbravo Openbravo ERP Payment Report in Excel format is not setting "," (comma) as decimal separator, although it is defined in Format.xml file 
related to feature request 0033743 new Triage Platform Base Openbravo ERP Numeric Values in Reports are Text, not numeric in Excel 
related to defect 0035304 closed mcobas Openbravo ERP Sales and purchase dimensional reports : after up gradation (version pr 16Q 2.4) nos(debit/credit) are coming as text instead of 
related to defect 0036404 closed collazoandy4 Openbravo ERP Numbers in Receivables Aging Schedule and Payables Aging Schedule are exported to Excel as strings 
related to defect 0037626 closed collazoandy4 Openbravo ERP Numbers in Valued Stock Report are exported to Excel as strings 
Issue History
2015-12-15 10:05caristuNew Issue
2015-12-15 10:05caristuAssigned To => Triage Finance
2015-12-15 10:05caristuModules => Core
2015-12-15 10:05caristuTriggers an Emergency Pack => No
2015-12-15 10:06caristuRelationship addedrelated to 0031676
2016-05-25 09:56caristuDescription Updatedbug_revision_view_page.php?rev_id=12227#r12227
2016-05-25 10:28aferrazRelationship addedrelated to 0032954
2016-08-23 08:33caristuRelationship addedblocks 0033743
2016-08-24 08:17caristuRelationship deletedblocks 0033743
2016-08-24 08:17caristuRelationship addedrelated to 0033743
2016-08-29 12:54aferrazRelationship addedhas duplicate 0033832
2016-09-15 13:06egoitzResolution time => 1475272800
2017-01-17 07:32pradeepvarmaRelationship addedrelated to 0034973
2017-01-23 13:04pradeepvarmaIssue Monitored: pradeepvarma
2017-02-06 12:32maiteResolution time1475272800 =>
2017-02-20 10:04pradeepvarmaRelationship addedrelated to 0035304
2017-07-04 17:20ngarciaRelationship addedrelated to 0036404
2017-07-26 16:04collazoandy4Assigned ToTriage Finance => collazoandy4
2017-07-26 16:04collazoandy4Statusnew => scheduled
2017-07-26 23:23collazoandy4Note Added: 0098233
2017-08-01 16:46collazoandy4Note Edited: 0098233bug_revision_view_page.php?bugnote_id=0098233#r15567
2017-08-03 05:33collazoandy4Note Edited: 0098233bug_revision_view_page.php?bugnote_id=0098233#r15573
2017-08-04 10:09hgbotCheckin
2017-08-04 10:09hgbotNote Added: 0098387
2017-08-04 10:09hgbotStatusscheduled => resolved
2017-08-04 10:09hgbotResolutionopen => fixed
2017-08-04 10:09hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9b2210a5b6924fae9f8703601d6d99683fd9c2ff [^]
2017-08-08 15:07hgbotCheckin
2017-08-08 15:07hgbotNote Added: 0098434
2017-08-08 15:08aferrazReview Assigned To => aferraz
2017-08-08 15:08aferrazNote Added: 0098435
2017-08-08 15:08aferrazStatusresolved => closed
2017-08-08 15:08aferrazFixed in Version => 3.0PR17Q4
2017-09-21 16:49hudsonbotCheckin
2017-09-21 16:49hudsonbotNote Added: 0099298
2017-09-21 16:49hudsonbotCheckin
2017-09-21 16:49hudsonbotNote Added: 0099300
2018-01-12 11:11gorkaionRelationship addedrelated to 0037626

Notes
(0098233)
collazoandy4   
2017-07-26 23:23   
(edited on: 2017-08-03 05:33)
Test Plan I Journal Entries Report
  As F&B International Group Admin role
    Go to Journal Entries Report and launch the Excel format and check the number fields are exported as number

Test Plan II Shipments Dimensional Report
  As F&B International Group Admin role
    Go to Shipments Dimensional Report and set From Date: 26-07-2015, To Date: Today, Dimensions: Product
      Launch the Excel format and check the number fields are exported as number
      Add al dimensions to the filter and launch (once more) the Excel format and check the number fields are exported as number

Test Plan III Stock Report
  As F&B International Group Admin role
    Go to Stock Report and launch the Excel format and check the number fields are exported as number


Test Plan IV Purchase Invoice Dimensional Report
  As F&B International Group Admin role
    Go to Purchase Invoice Dimensional Report window and fill information as follow:
      From Date: 01-08-2015
      To Date: Today
      Dimmensions: Product
      Launch the Excel format and check the number fields are exported as number

Test Plan V Sales Invoice Dimensional Report
  As F&B International Group Admin role
    Go to Sales Invoice Dimensional Report window and fill information as follow:
      From Date: 01-08-2015
      To Date: Today
      Organization: F&B EspaƱa, S.A
      Dimmensions: Product
      Launch the Excel format and check the number fields are exported as number

Test Plan VI Customer Statement Report
  As F&B International Group Admin role
    Go to Customer Statement Report window and fill information as follow:
      Business Partner: Alimentos y Supermercados, S.A
      Launch the Excel format and check the number fields are exported as number

(0098387)
hgbot   
2017-08-04 10:09   
Repository: erp/devel/pi
Changeset: 9b2210a5b6924fae9f8703601d6d99683fd9c2ff
Author: Armaignac <collazoandy4 <at> gmail.com>
Date: Wed Jul 26 17:24:11 2017 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/9b2210a5b6924fae9f8703601d6d99683fd9c2ff [^]

Fixes issue 31710: Review XLS reports to apply cell type when required

The Journal Entries, Shipments Dimensional, Stock, Purchase Invoice Dimensional,
Sales Invoice Dimensional, and Customer Statement Reports was modified in order
to ensure that all numeric fields can be exported as numeric

The fields defined in jasper report contains a format method call causing the
cell value be of string type

All the format calls was removed and the field now specified the cell value type
and the output format by the jasper patternExpression specification.

---
M src/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournalExcel.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesXLS.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesXLS.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportWarehousePartnerJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/WeightDimensionalComparative.jrxml
M src/org/openbravo/erpCommon/ad_reports/WeightDimensionalNoComparative.jrxml
---
(0098434)
hgbot   
2017-08-08 15:07   
Repository: erp/devel/pi
Changeset: a686f7a45fa5eda3c023a08000b8fb74acc0ee5b
Author: Armaignac <collazoandy4 <at> gmail.com>
Date: Fri Aug 04 11:34:16 2017 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/a686f7a45fa5eda3c023a08000b8fb74acc0ee5b [^]

Related to issue 31710: Fix Sales Invoice Dimensional & Shipment Dimensional reports

The Sales Invoice Dimensional Report document type total was exported as String. A int conversion was added to doctypecount.

The Shipments Dimensional Report totals missed the patternExpression. It was added to properly format the amount.

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalyses_srpt_doctypecount.jrxml
M src/org/openbravo/erpCommon/ad_reports/WeightDimensionalNoComparative.jrxml
---
(0098435)
aferraz   
2017-08-08 15:08   
Code review + Testing OK
(0099298)
hudsonbot   
2017-09-21 16:49   
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/9750b78d3e5c [^]
Maturity status: Test
(0099300)
hudsonbot   
2017-09-21 16:49   
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/9750b78d3e5c [^]
Maturity status: Test