Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027133Openbravo ERP07. Sales managementpublic2014-07-21 10:252014-12-30 23:24
Reporterrafaroda 
Assigned Torafademiguel 
PrioritynormalSeverityminorReproducibilityN/A
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Togorkaion
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027133: Sales Invoice Dimensional Report Multicomparative
DescriptionAdd more comparative periods (3, the one existing plus 2 new periods).

Right now you can only filter by two periods. Ability to compare by two more periods.
Steps To ReproduceGo to Sales Management > Analysis Tools > Sales Invoice Dimensional Report
Proposed Solution* Add 2 more lines of non-mandatory fields: From Reference Date - To Reference Date (see FilterWindow.png)
* If both From Reference Date - To Reference Date are filled for one line and complies with To Reference Date > From Reference Date, add it to the comparative report.
* A new Jasper JRXML template will be used for handling this extra data (attached current comparative report in PDF)
Additional Information
TagsNo tags attached.
Relationships
blocks feature request 0027567 new rafademiguel Sales Invoice Dimensional Report Comparative exportable to Excel 
Attached Filespng FilterWindow.png (24,094) 2014-07-21 10:25
https://issues.openbravo.com/file_download.php?file_id=7068&type=bug
png

pdf ReportInvoiceCustomerDimensionalAnalysesComparativeJR.jrxml.pdf (46,983) 2014-07-21 10:26
https://issues.openbravo.com/file_download.php?file_id=7069&type=bug
diff SDRMultiComparativeExtended.diff (1,047,908) 2014-09-17 09:18
https://issues.openbravo.com/file_download.php?file_id=7251&type=bug
Issue History
Date ModifiedUsernameFieldChange
2014-07-21 10:25rafarodaNew Issue
2014-07-21 10:25rafarodaAssigned To => dmiguelez
2014-07-21 10:25rafarodaFile Added: FilterWindow.png
2014-07-21 10:25rafarodaModules => Core
2014-07-21 10:25rafarodaTriggers an Emergency Pack => No
2014-07-21 10:25rafarodaAssigned Todmiguelez => rafaroda
2014-07-21 10:26rafarodaFile Added: ReportInvoiceCustomerDimensionalAnalysesComparativeJR.jrxml.pdf
2014-07-21 10:26rafarodaStatusnew => scheduled
2014-07-21 10:26rafarodafix_in_branch => pi
2014-08-25 15:12hgbotCheckin
2014-08-25 15:12hgbotNote Added: 0069713
2014-08-25 15:12hgbotStatusscheduled => resolved
2014-08-25 15:12hgbotResolutionopen => fixed
2014-08-25 15:12hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f2fc5701f0a74ec81519d588151c29bd4f69b893 [^]
2014-08-26 05:18hudsonbotCheckin
2014-08-26 05:18hudsonbotNote Added: 0069736
2014-09-16 19:09hgbotCheckin
2014-09-16 19:09hgbotNote Added: 0070159
2014-09-16 19:10rafarodaAssigned Torafaroda => rafademiguel
2014-09-16 19:10rafarodaStatusresolved => new
2014-09-16 19:10rafarodaResolutionfixed => open
2014-09-17 08:26rafarodaRelationship addedblocks 0027567
2014-09-17 09:18rafarodaFile Added: SDRMultiComparativeExtended.diff
2014-09-17 13:49hudsonbotCheckin
2014-09-17 13:49hudsonbotNote Added: 0070178
2014-09-18 17:41rafarodaIssue Monitored: rafaroda
2014-11-18 11:00hgbotCheckin
2014-11-18 11:01hgbotNote Added: 0071748
2014-11-18 11:01hgbotStatusnew => resolved
2014-11-18 11:01hgbotResolutionopen => fixed
2014-11-18 11:01hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/f2fc5701f0a74ec81519d588151c29bd4f69b893 [^] => http://code.openbravo.com/erp/devel/pi/rev/bc9bbb0e83d60d87e1f0869e4693a3d1e4aeae82 [^]
2014-11-18 12:59gorkaionReview Assigned To => gorkaion
2014-11-18 12:59gorkaionNote Added: 0071758
2014-11-18 12:59gorkaionStatusresolved => closed
2014-12-30 23:24hudsonbotCheckin
2014-12-30 23:24hudsonbotNote Added: 0073073

Notes
(0069713)
hgbot   
2014-08-25 15:12   
Repository: erp/devel/pi
Changeset: f2fc5701f0a74ec81519d588151c29bd4f69b893
Author: Rafa Roda Palacios <rafa.roda <at> ubiquads.com>
Date: Mon Aug 25 15:11:06 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f2fc5701f0a74ec81519d588151c29bd4f69b893 [^]

Fixes issue 27133 Feature request to add more comparative periods to the Sales Invoice Dimensional Report

---
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJRFilter.html
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJRFilter.xml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
A src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesMultiComparativeExtendedJR.jrxml
A src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesMultiComparativeJR.jrxml
---
(0069736)
hudsonbot   
2014-08-26 05:18   
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/de09123fc129 [^]
Maturity status: Test
(0070159)
hgbot   
2014-09-16 19:09   
Repository: erp/devel/pi
Changeset: d5192458aa11b434daf78df01a3bceb4a64bbed9
Author: Rafa Roda Palacios <rafa.roda <at> ubiquads.com>
Date: Tue Sep 16 19:08:39 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d5192458aa11b434daf78df01a3bceb4a64bbed9 [^]

Related to issue 27133 Backed out feature request Sales Invoice Dimensional Report Multicomparative

---
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJRFilter.html
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJRFilter.xml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
R src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesMultiComparativeExtendedJR.jrxml
R src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesMultiComparativeJR.jrxml
---
(0070178)
hudsonbot   
2014-09-17 13: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/c8fa8d228056 [^]
Maturity status: Test
(0071748)
hgbot   
2014-11-18 11:00   
Repository: erp/devel/pi
Changeset: bc9bbb0e83d60d87e1f0869e4693a3d1e4aeae82
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Tue Nov 18 10:58:56 2014 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/bc9bbb0e83d60d87e1f0869e4693a3d1e4aeae82 [^]

Fixed issue 27133. Added extra periods to compare in report.

Added multicomparative and multicomparative extended templates to be able to
compare the reference period against 2 or 3 different periods.

Fixed the margin diff variable definition expression.

---
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJRFilter.html
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJRFilter.xml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
A src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesMultiComparativeExtendedJR.jrxml
A src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesMultiComparativeJR.jrxml
---
(0071758)
gorkaion   
2014-11-18 12:59   
Code reviewed and tested
(0073073)
hudsonbot   
2014-12-30 23:24   
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/6525fe229e06 [^]
Maturity status: Test