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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0026936
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] 03. Procurement managementminorN/A2014-06-25 08:362014-08-08 18:53
ReporterrafarodaView Statuspublic 
Assigned Torafaroda 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision063228ee428e
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Torafademiguel
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0026936: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to feature request 0026935 closedrafaroda Sales Invoice Dimensional Report exportable to excel 
has duplicate feature request 0018472 closedjonalegriaesarte Purchase Invoice Dimensional Report can't be imported to Excel 
related to defect 0027622 newrafaroda Small fixes on Sales and Purchase Invoice Dimensional Reports export to Excel 
related to feature request 0031733 scheduledmarkmm82 It would be fine if invoice's currency was added to the invoice dimensional reports when exporting to Excel 

-  Notes
(0068340)
hgbot (developer)
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 (developer)
2014-06-26 14:51

 Backed out and reopened https://code.openbravo.com/erp/devel/pi/rev/3e175c44e3f3 [^]
(0068390)
hudsonbot (developer)
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 (developer)
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 (developer)
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

- Issue History
Date Modified Username Field Change
2014-06-25 08:36 rafaroda New Issue
2014-06-25 08:36 rafaroda Assigned To => rafaroda
2014-06-25 08:36 rafaroda Modules => Core
2014-06-25 08:36 rafaroda Triggers an Emergency Pack => No
2014-06-25 08:36 rafaroda Relationship added related to 0026935
2014-06-26 12:50 hgbot Checkin
2014-06-26 12:50 hgbot Note Added: 0068340
2014-06-26 12:50 hgbot Status new => resolved
2014-06-26 12:50 hgbot Resolution open => fixed
2014-06-26 12:50 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4896738282ea114a53c3bf83843f9592e149de78 [^]
2014-06-26 14:49 rafaroda Status resolved => new
2014-06-26 14:49 rafaroda Resolution fixed => open
2014-06-26 14:51 rafaroda Note Added: 0068351
2014-06-27 04:06 hudsonbot Checkin
2014-06-27 04:06 hudsonbot Note Added: 0068390
2014-07-07 11:28 rafaroda Status new => scheduled
2014-07-07 11:28 rafaroda fix_in_branch => pi
2014-07-22 08:09 hgbot Checkin
2014-07-22 08:09 hgbot Note Added: 0068776
2014-07-22 08:09 hgbot Status scheduled => resolved
2014-07-22 08:09 hgbot Resolution open => fixed
2014-07-22 08:09 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/4896738282ea114a53c3bf83843f9592e149de78 [^] => http://code.openbravo.com/erp/devel/pi/rev/063228ee428e2da4cbe283b74a45960a7b9f71e0 [^]
2014-07-23 10:41 rafademiguel Review Assigned To => rafademiguel
2014-07-23 10:41 rafademiguel Status resolved => closed
2014-08-08 18:53 hudsonbot Checkin
2014-08-08 18:53 hudsonbot Note Added: 0069200
2014-09-17 09:26 rafaroda Relationship added related to 0027622
2015-12-16 13:18 ngarcia Relationship added has duplicate 0018472
2015-12-16 13:27 ngarcia Relationship added related to 0031733

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker