Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035133Localization Pack: SpainMulti Dimensional Tax Report Cash VATpublic2017-02-02 09:252017-02-13 13:28
Reportervmromanos 
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
Summary0035133: 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 0034973 closed collazoandy4 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-02-02 09:25vmromanosNew Issue
2017-02-02 09:25vmromanosAssigned To => Triage Finance
2017-02-02 09:25vmromanosResolution time => 1487026800
2017-02-02 09:25vmromanosIssue generated from0034973
2017-02-02 09:25vmromanosRelationship addedrelated to 0034973
2017-02-02 15:53markmm82Assigned ToTriage Finance => collazoandy4
2017-02-07 22:47collazoandy4Statusnew => scheduled
2017-02-07 22:47collazoandy4Note Added: 0094135
2017-02-10 21:05hgbotCheckin
2017-02-10 21:05hgbotNote Added: 0094225
2017-02-10 21:05hgbotStatusscheduled => resolved
2017-02-10 21:05hgbotResolutionopen => fixed
2017-02-10 21:05hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30.cashvat/rev/c9ed290f04f9082b160651c604bf3147b19f1575 [^]
2017-02-10 21:05hgbotCheckin
2017-02-10 21:05hgbotNote Added: 0094226
2017-02-13 13:28vmromanosReview Assigned To => vmromanos
2017-02-13 13:28vmromanosNote Added: 0094268
2017-02-13 13:28vmromanosStatusresolved => closed

Notes
(0094135)
collazoandy4   
2017-02-07 22:47   
Test Plan
  Go to the windows Multidimensional Tax Report Cash Vat
    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
(0094225)
hgbot   
2017-02-10 21:05   
Repository: erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30.cashvat
Changeset: c9ed290f04f9082b160651c604bf3147b19f1575
Author: Armaignac <collazoandy4 <at> gmail.com>
Date: Fri Feb 10 11:20:36 2017 -0500
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30.cashvat/rev/c9ed290f04f9082b160651c604bf3147b19f1575 [^]

Fixes issue 35133: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.

---
M src/org/openbravo/module/invoiceTaxReportEnhanced30/cashvat/ad_reports/OBMTRCV_InvoiceTaxReport.jrxml
M src/org/openbravo/module/invoiceTaxReportEnhanced30/cashvat/ad_reports/OBMTRCV_InvoiceTaxReportDetail.jrxml
M src/org/openbravo/module/invoiceTaxReportEnhanced30/cashvat/ad_reports/OBMTRCV_InvoiceTaxReportSummary.jrxml
M src/org/openbravo/module/invoiceTaxReportEnhanced30/cashvat/ad_reports/OBMTRCV_InvoiceTaxReportSummaryByRate.jrxml
---
(0094226)
hgbot   
2017-02-10 21:05   
Repository: erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30.cashvat
Changeset: 8812bcce9dd7c6802916cfd1b9f05d221e896880
Author: Mark <markmm82 <at> gmail.com>
Date: Fri Feb 10 14:33:20 2017 -0500
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30.cashvat/rev/8812bcce9dd7c6802916cfd1b9f05d221e896880 [^]

Related to issue 35133: Update module version

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

Fixed in module Multidimensional Tax Report Cash VAT 1.0.300