Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0034973Localization Pack: SpainMulti Dimensional Tax Reportpublic2017-01-17 07:302017-02-13 13:14
Reporterpradeepvarma 
Assigned Tocollazoandy4 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Tovmromanos
Support ticket
OBNetwork customer
Regression introduced in release
Summary0034973: In Multidimensional Tax Report, after up gradation (version pr 16Q 2.4) nos(debit/credit) are coming as text instead of no
DescriptionThis is on Multidimensional Tax Report. After up gradation (version pr 16Q 2.4) nos are coming as text in this report, but previously
(version pr 16Q 3.8) this report was getting generated correctly. Now our customer wants the report in previous version where the nos
were not in text but in number. As an example, let's say debit should be 350,000.00, instead of it is appearing as '350,000.00
Steps To ReproduceThis is on Multidimensional Tax Report. After up gradation (version pr 16Q 2.4) nos are coming as text in this report, but previously
(version pr 16Q 3.8) this report was getting generated correctly. Now our customer wants the report in previous version where the nos
were not in text but in number. As an example, let's say debit should be 350,000.00, instead of it is appearing as '350,000.00
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0031710 closed collazoandy4 Openbravo ERP Review XLS reports to apply cell type when required 
related to defect 0035133 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 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-01-17 07:30pradeepvarmaNew Issue
2017-01-17 07:30pradeepvarmaAssigned To => Triage Finance
2017-01-17 07:30pradeepvarmaModules => Core
2017-01-17 07:30pradeepvarmaTriggers an Emergency Pack => No
2017-01-17 07:32pradeepvarmaRelationship addedrelated to 0031710
2017-01-24 13:05pradeepvarmaResolution time => 1487026800
2017-01-30 08:56malsasuaSeverityminor => major
2017-02-02 09:25vmromanosProjectOpenbravo ERP => Localization Pack: Spain
2017-02-02 09:25vmromanosCategoryZ. Others => Multi Dimensional Tax Report
2017-02-02 09:25vmromanosIssue cloned0035133
2017-02-02 09:25vmromanosRelationship addedrelated to 0035133
2017-02-03 19:13collazoandy4Assigned ToTriage Finance => collazoandy4
2017-02-03 19:14collazoandy4Statusnew => scheduled
2017-02-03 19:14collazoandy4Note Added: 0094047
2017-02-13 13:13hgbotCheckin
2017-02-13 13:13hgbotNote Added: 0094265
2017-02-13 13:13hgbotStatusscheduled => resolved
2017-02-13 13:13hgbotResolutionopen => fixed
2017-02-13 13:13hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30/rev/448727d8f50da480ff2400dea327200a37b0f1b3 [^]
2017-02-13 13:13hgbotCheckin
2017-02-13 13:13hgbotNote Added: 0094266
2017-02-13 13:14vmromanosReview Assigned To => vmromanos
2017-02-13 13:14vmromanosNote Added: 0094267
2017-02-13 13:14vmromanosStatusresolved => closed

Notes
(0094047)
collazoandy4   
2017-02-03 19:14   
Test Plan
  Go to the windows Multidimensional Tax Report
    From date: 03-02-2015
    To date: today
    Organization: F&B España S.A
    Export the report to Excel
  Verify that the numeric cells have a number format
(0094265)
hgbot   
2017-02-13 13:13   
Repository: erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30
Changeset: 448727d8f50da480ff2400dea327200a37b0f1b3
Author: Armaignac <collazoandy4 <at> gmail.com>
Date: Fri Feb 10 13:57:57 2017 -0500
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30/rev/448727d8f50da480ff2400dea327200a37b0f1b3 [^]

Fixes issue 34973:Number columns of Multidimensional Tax Report exported as text

The number columns of Multidimensional Tax Report was exporting to text in xls
format.
The net.sf.jasperreports.export.xls.detect.cell.type property was added to the report
with a true value. Also the pattern "#,##0.00;-#,##0.00" was included to the fields.
The function OBMTR30_GETCOUNTRYNAME was modified to get the country name when no
exist a language translation for the business partner location

---
M src-db/database/model/functions/OBMTR30_GETCOUNTRYNAME.xml
M src/org/openbravo/module/invoiceTaxReportEnhanced30/ad_reports/OBMTR30_InvoiceTaxReport.jrxml
M src/org/openbravo/module/invoiceTaxReportEnhanced30/ad_reports/OBMTR30_InvoiceTaxReportDetail.jrxml
M src/org/openbravo/module/invoiceTaxReportEnhanced30/ad_reports/OBMTR30_InvoiceTaxReportSummary.jrxml
M src/org/openbravo/module/invoiceTaxReportEnhanced30/ad_reports/OBMTR30_InvoiceTaxReportSummaryByRate.jrxml
---
(0094266)
hgbot   
2017-02-13 13:13   
Repository: erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30
Changeset: 10c58d24f5e9076a3290a49356f26d0ca70e201f
Author: Mark <markmm82 <at> gmail.com>
Date: Fri Feb 10 15:25:11 2017 -0500
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30/rev/10c58d24f5e9076a3290a49356f26d0ca70e201f [^]

Related to issue 34973: Update module version

---
M src-db/database/sourcedata/AD_MODULE.xml
---
(0094267)
vmromanos   
2017-02-13 13:14   
Code review + testing OK

Fixed in module Multidimensional Tax Report 3.0.400 or above