Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027255Localization Pack: SpainMulti Dimensional Tax Reportpublic2014-08-01 12:552016-08-09 15:31
Reporterpsanjuan 
Assigned Tomarkmm82 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 8.04.1
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Toaferraz
Support ticket
OBNetwork customer
Regression introduced in release
Summary0027255: "Total Document Amt" column does not make sense in the section "Summary per Tax/Withholding %"
Description"Total Document Amt" column does not makes sense in the section "Summary per Tax/Withholding %" as summary section can include lines of the same invoice.

See image attached.

Both lines under 0,00%, 4.00%, 10.00% and 21.00% belongs to the same invoice, therefore the Total Document Amount is 11.189,98 and not 22.379,96
Steps To ReproduceCreate only a purchase invoice in a given period.
Enter 2 purchase lines both having the same tax 21%.
Use for instance below listed tax rates:

Adquisiciones 21%
Prestación servicios nacional 21%

Launch the Multidimensional Tax Report and realize that the total document amount column *2 the correct total document amount.

Proposed SolutionRemove the column "Total document amount" form the section "Summary per Tax/Withholding".
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0027256 new jonalegriaesarte  "Total Document Amt" column does not make sense in the section "Summary per Tax/Withholding %" 
related to design defect 0029015 new Triage Omni OMS Totals for Tax Base and Total Document Amt does not make sense in the summary sections 
Attached Filespng issue_27255.png (65,390) 2014-08-01 13:01
https://issues.openbravo.com/file_download.php?file_id=7115&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2014-08-01 12:55psanjuanNew Issue
2014-08-01 12:55psanjuanAssigned To => jonalegriaesarte
2014-08-01 12:56psanjuanIssue cloned0027256
2014-08-01 12:57psanjuanSummaryColumn "Totlal Document Amt" makes no sense in the section "Summary per Tax/Withholding %" => "Total Document Amt" column does not makes sense in the section "Summary per Tax/Withholding %"
2014-08-01 12:57psanjuanDescription Updatedbug_revision_view_page.php?rev_id=6226#r6226
2014-08-01 13:00psanjuanSummary"Total Document Amt" column does not makes sense in the section "Summary per Tax/Withholding %" => "Total Document Amt" column does not make sense in the section "Summary per Tax/Withholding %"
2014-08-01 13:00psanjuanProposed Solution updated
2014-08-01 13:01psanjuanFile Added: issue_27255.png
2014-08-01 13:01psanjuanRelationship addedrelated to 0027256
2015-02-20 15:01ngarciaRelationship addedrelated to 0029015
2016-03-31 10:40ngarciaAssigned Tojonalegriaesarte =>
2016-03-31 10:40ngarciaIssue Monitored: networkb
2016-04-13 11:20ngarciaResolution time => 1463090400
2016-04-13 11:20ngarciaTypedesign defect => defect
2016-04-13 11:25ngarciaAssigned To => Triage Finance
2016-04-25 14:47aferrazAssigned ToTriage Finance => markmm82
2016-04-30 03:47markmm82Statusnew => scheduled
2016-05-03 17:24markmm82Note Added: 0086159
2016-05-09 18:13hgbotCheckin
2016-05-09 18:13hgbotNote Added: 0086322
2016-05-09 18:13hgbotStatusscheduled => resolved
2016-05-09 18:13hgbotResolutionopen => fixed
2016-05-09 18:13hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30/rev/bfc9508498cebb37cdb711ee6f72d9361c350707 [^]
2016-05-09 18:13hgbotCheckin
2016-05-09 18:13hgbotNote Added: 0086323
2016-05-09 18:13hgbotCheckin
2016-05-09 18:13hgbotNote Added: 0086324
2016-05-09 18:19aferrazReview Assigned To => aferraz
2016-05-09 18:19aferrazNote Added: 0086325
2016-05-09 18:19aferrazStatusresolved => closed
2016-08-09 15:29hgbotCheckin
2016-08-09 15:29hgbotNote Added: 0088928
2016-08-09 15:29hgbotStatusclosed => resolved
2016-08-09 15:29hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30/rev/bfc9508498cebb37cdb711ee6f72d9361c350707 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30/rev/92f10f5d4da48f9ca4c0ed0e14ede1f1643cd0e4 [^]
2016-08-09 15:31shuehnerNote Added: 0088930
2016-08-09 15:31shuehnerStatusresolved => closed
2016-08-09 15:31shuehnerFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30/rev/92f10f5d4da48f9ca4c0ed0e14ede1f1643cd0e4 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30/rev/bfc9508498cebb37cdb711ee6f72d9361c350707 [^]

Notes
(0086159)
markmm82   
2016-05-03 17:24   
Test plan:
Create only a purchase invoice in a given period.
Enter 2 purchase lines both having the same tax 21%.
Use for instance below listed tax rates:
-Adquisiciones 21%
-Prestación servicios nacional 21%
Launch the Multidimensional Tax Report and realize that the total document amount column is not shown in the section "Summary per Tax/Withholding".
(0086322)
hgbot   
2016-05-09 18:13   
Repository: erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30
Changeset: bfc9508498cebb37cdb711ee6f72d9361c350707
Author: Mark <m.molina <at> nectus.com>
Date: Mon May 02 13:36:50 2016 -0400
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30/rev/bfc9508498cebb37cdb711ee6f72d9361c350707 [^]

Fixes issue 27255:Remove TotalDocumentAmt column in Summary per Tax/Withholding

Removed the column "Total document amount" from the section "Summary per Tax/Withholding" of the Multidimensional Tax report.

---
M src/org/openbravo/module/invoiceTaxReportEnhanced30/ad_reports/OBMTR30_InvoiceTaxReportSummaryByRate.jrxml
---
(0086323)
hgbot   
2016-05-09 18:13   
Repository: erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30
Changeset: 1ae5999d4bce5a7d107b2a1d95668ed6f5f5fab5
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Mon May 09 17:43:22 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30/rev/1ae5999d4bce5a7d107b2a1d95668ed6f5f5fab5 [^]

Related to issue 27255: Code review improvements

---
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src/org/openbravo/module/invoiceTaxReportEnhanced30/ad_reports/OBMTR30_InvoiceTaxReportSummaryByRate.jrxml
---
(0086324)
hgbot   
2016-05-09 18:13   
Repository: erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30
Changeset: 5b472fc7aca05a2a583cf8607b237e32e69f1d2a
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Mon May 09 18:06:00 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30/rev/5b472fc7aca05a2a583cf8607b237e32e69f1d2a [^]

Related to issue 27255: Update module version

---
M src-db/database/sourcedata/AD_MODULE.xml
---
(0086325)
aferraz   
2016-05-09 18:19   
Code review + Testing OK
(0088928)
hgbot   
2016-08-09 15:29   
Repository: erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30
Changeset: 92f10f5d4da48f9ca4c0ed0e14ede1f1643cd0e4
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Tue Aug 09 15:28:53 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30/rev/92f10f5d4da48f9ca4c0ed0e14ede1f1643cd0e4 [^]

Fixed 27255. Remove use of deprecated methods.

Call new ReportingUtils.getTranslatedJasperReport instead of the old method
in Utility.java

---
M src/org/openbravo/module/invoiceTaxReportEnhanced30/ad_reports/OBMTR30_InvoiceTaxReportJR.java
---
(0088930)
shuehner   
2016-08-09 15:31   
Re-close issue.
Last commit did not belong into here.