Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026936Openbravo ERP03. Procurement managementpublic2014-06-25 08:362014-08-08 18:53
Reporterrafaroda 
Assigned Torafaroda 
PrioritynormalSeverityminorReproducibilityN/A
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Torafademiguel
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0026936: Purchase Invoice Dimensional Report exportable to Excel
DescriptionA new button to export the report to excel will be added in the Purchase Invoice Dimensional Report.

The Excel layout will include the following columns (in the same order that are listed):
1) Organization
2) Business Partner Group
3) Business Partner
4) Document No
5) Invoice Date
6) Product Group
7) Product
8) Amount
9) Quantity

With the level of detail shown in the excel layout, the users will be able to group by any of the report dimensions. In addition, a column with the Invoice Date will be included in the excel layout, therefore, the user will be able to do an extra analysis using this column what is not shown in the html and pdf results.

Once the result has been exported to the excel, the user will be able to delete those columns that he doesn't need for the analysis or modify the columns order before grouping in the excel.

Some considerations about the excel result are:
* The excel result takes into account the Primary filters ‘From/To Date’ and ‘Amount Greater/Less Than’ but doesn’t consider the option ‘Comparative Report’ neither the related filters ‘From/To Reference Date’.
* The excel result takes into account all the Secondary Filters.
* The excel result ignores the section ‘Dimension’, it always show all possible columns and the highest level of detail for that the user can use the excel grouping features.
* The excel result ignores the section ‘Sort’. The default order in the excel will be the following: Organization, Document No and Invoice Date. The user will be able to modify the order easily using the excel ordering features.
* The excel result considers the filter ‘Currency’.
Steps To ReproduceGo to Procurement Management > Analysis Tools > Purchase Invoice Dimensional Report
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0026935 closed rafaroda Sales Invoice Dimensional Report exportable to excel 
has duplicate feature request 0018472 closed jonalegriaesarte Purchase Invoice Dimensional Report can't be imported to Excel 
related to defect 0027622 new rafaroda Small fixes on Sales and Purchase Invoice Dimensional Reports export to Excel 
related to feature request 0031733 scheduled markmm82 It would be fine if invoice's currency was added to the invoice dimensional reports when exporting to Excel 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-06-25 08:36rafarodaNew Issue
2014-06-25 08:36rafarodaAssigned To => rafaroda
2014-06-25 08:36rafarodaModules => Core
2014-06-25 08:36rafarodaTriggers an Emergency Pack => No
2014-06-25 08:36rafarodaRelationship addedrelated to 0026935
2014-06-26 12:50hgbotCheckin
2014-06-26 12:50hgbotNote Added: 0068340
2014-06-26 12:50hgbotStatusnew => resolved
2014-06-26 12:50hgbotResolutionopen => fixed
2014-06-26 12:50hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4896738282ea114a53c3bf83843f9592e149de78 [^]
2014-06-26 14:49rafarodaStatusresolved => new
2014-06-26 14:49rafarodaResolutionfixed => open
2014-06-26 14:51rafarodaNote Added: 0068351
2014-06-27 04:06hudsonbotCheckin
2014-06-27 04:06hudsonbotNote Added: 0068390
2014-07-07 11:28rafarodaStatusnew => scheduled
2014-07-07 11:28rafarodafix_in_branch => pi
2014-07-22 08:09hgbotCheckin
2014-07-22 08:09hgbotNote Added: 0068776
2014-07-22 08:09hgbotStatusscheduled => resolved
2014-07-22 08:09hgbotResolutionopen => fixed
2014-07-22 08:09hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/4896738282ea114a53c3bf83843f9592e149de78 [^] => http://code.openbravo.com/erp/devel/pi/rev/063228ee428e2da4cbe283b74a45960a7b9f71e0 [^]
2014-07-23 10:41rafademiguelReview Assigned To => rafademiguel
2014-07-23 10:41rafademiguelStatusresolved => closed
2014-08-08 18:53hudsonbotCheckin
2014-08-08 18:53hudsonbotNote Added: 0069200
2014-09-17 09:26rafarodaRelationship addedrelated to 0027622
2015-12-16 13:18ngarciaRelationship addedhas duplicate 0018472
2015-12-16 13:27ngarciaRelationship addedrelated to 0031733

Notes
(0068340)
hgbot   
2014-06-26 12:50   
Repository: erp/devel/pi
Changeset: 4896738282ea114a53c3bf83843f9592e149de78
Author: Rafa Roda Palacios <rafa.roda <at> ubiquads.com>
Date: Wed Jun 25 18:00:57 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/4896738282ea114a53c3bf83843f9592e149de78 [^]

Fixes issue 26936 Feature request to make Purchase Invoice Dimensional Report exportable to excel

---
M src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesFilterJR.html
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesJR_data.xsql
A src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesXLS.html
A src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesXLS.xml
---
(0068351)
rafaroda   
2014-06-26 14:51   
Backed out and reopened https://code.openbravo.com/erp/devel/pi/rev/3e175c44e3f3 [^]
(0068390)
hudsonbot   
2014-06-27 04:06   
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/c5640d5a10d4 [^]
Maturity status: Test
(0068776)
hgbot   
2014-07-22 08:09   
Repository: erp/devel/pi
Changeset: 063228ee428e2da4cbe283b74a45960a7b9f71e0
Author: Rafa Roda Palacios <rafa.roda <at> ubiquads.com>
Date: Tue Jul 22 08:09:03 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/063228ee428e2da4cbe283b74a45960a7b9f71e0 [^]

Fixes issue 26936 Feature request to make Purchase Invoice Dimensional Report exportable to excel

---
M src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesFilterJR.html
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesJR_data.xsql
A src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesXLS.jrxml
---
(0069200)
hudsonbot   
2014-08-08 18:53   
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/4450016dee64 [^]
Maturity status: Test