Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0027133
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] 07. Sales managementminorN/A2014-07-21 10:252014-12-30 23:24
ReporterrafarodaView Statuspublic 
Assigned Torafademiguel 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revisionbc9bbb0e83d6
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned Togorkaion
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0027133: 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)
TagsNo tags attached.
Attached Filespng file icon FilterWindow.png [^] (24,094 bytes) 2014-07-21 10:25


pdf file icon ReportInvoiceCustomerDimensionalAnalysesComparativeJR.jrxml.pdf [^] (46,983 bytes) 2014-07-21 10:26
diff file icon SDRMultiComparativeExtended.diff [^] (1,047,908 bytes) 2014-09-17 09:18

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks feature request 0027567 newrafademiguel Sales Invoice Dimensional Report Comparative exportable to Excel 

-  Notes
(0069713)
hgbot (developer)
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 (viewer)
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 (developer)
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 (viewer)
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 (developer)
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 (viewer)
2014-11-18 12:59

 Code reviewed and tested
(0073073)
hudsonbot (viewer)
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

- Issue History
Date Modified Username Field Change
2014-07-21 10:25 rafaroda New Issue
2014-07-21 10:25 rafaroda Assigned To => dmiguelez
2014-07-21 10:25 rafaroda File Added: FilterWindow.png
2014-07-21 10:25 rafaroda OBNetwork customer => No
2014-07-21 10:25 rafaroda Modules => Core
2014-07-21 10:25 rafaroda Triggers an Emergency Pack => No
2014-07-21 10:25 rafaroda Assigned To dmiguelez => rafaroda
2014-07-21 10:26 rafaroda File Added: ReportInvoiceCustomerDimensionalAnalysesComparativeJR.jrxml.pdf
2014-07-21 10:26 rafaroda Status new => scheduled
2014-07-21 10:26 rafaroda fix_in_branch => pi
2014-08-25 15:12 hgbot Checkin
2014-08-25 15:12 hgbot Note Added: 0069713
2014-08-25 15:12 hgbot Status scheduled => resolved
2014-08-25 15:12 hgbot Resolution open => fixed
2014-08-25 15:12 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f2fc5701f0a74ec81519d588151c29bd4f69b893 [^]
2014-08-26 05:18 hudsonbot Checkin
2014-08-26 05:18 hudsonbot Note Added: 0069736
2014-09-16 19:09 hgbot Checkin
2014-09-16 19:09 hgbot Note Added: 0070159
2014-09-16 19:10 rafaroda Assigned To rafaroda => rafademiguel
2014-09-16 19:10 rafaroda Status resolved => new
2014-09-16 19:10 rafaroda Resolution fixed => open
2014-09-17 08:26 rafaroda Relationship added blocks 0027567
2014-09-17 09:18 rafaroda File Added: SDRMultiComparativeExtended.diff
2014-09-17 13:49 hudsonbot Checkin
2014-09-17 13:49 hudsonbot Note Added: 0070178
2014-09-18 17:41 rafaroda Issue Monitored: rafaroda
2014-11-18 11:00 hgbot Checkin
2014-11-18 11:01 hgbot Note Added: 0071748
2014-11-18 11:01 hgbot Status new => resolved
2014-11-18 11:01 hgbot Resolution open => fixed
2014-11-18 11:01 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/f2fc5701f0a74ec81519d588151c29bd4f69b893 [^] => http://code.openbravo.com/erp/devel/pi/rev/bc9bbb0e83d60d87e1f0869e4693a3d1e4aeae82 [^]
2014-11-18 12:59 gorkaion Review Assigned To => gorkaion
2014-11-18 12:59 gorkaion Note Added: 0071758
2014-11-18 12:59 gorkaion Status resolved => closed
2014-12-30 23:24 hudsonbot Checkin
2014-12-30 23:24 hudsonbot Note Added: 0073073

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker