Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029215ModulesValued Stock Enhancedpublic2015-03-10 11:432015-10-16 09:04
Reporternaiaramartinez 
Assigned Tojonalegriaesarte 
PrioritynormalSeveritytrivialReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Todmiguelez
Support ticket
OBNetwork customerNo
Regression introduced in release
Summary0029215: Be able to consolidate the information for all the warehouses
DescriptionNew check on the filter option: 'Warehouse consolidation'.

When checked, the report will show the information summing all the single records for all the warehouses, not taken into account if the warehouse selector is informed or not.The new logic should be done in pdf and excel too.
Steps To ReproduceOpen the report. Check that the filter exits and that it works for pdf and excel
Proposed SolutionFind attached file with the proposed solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filesdiff 29215.diff (129,512) 2015-03-10 12:28
https://issues.openbravo.com/file_download.php?file_id=7874&type=bug
diff ShowsWarehouseInParents.diff (933) 2015-05-27 10:28
https://issues.openbravo.com/file_download.php?file_id=8127&type=bug
Issue History
Date ModifiedUsernameFieldChange
2015-03-10 11:43naiaramartinezNew Issue
2015-03-10 11:43naiaramartinezAssigned To => jonalegriaesarte
2015-03-10 11:43naiaramartinezOBNetwork customer => No
2015-03-10 12:26naiaramartinezProposed Solution updated
2015-03-10 12:28naiaramartinezFile Added: 29215.diff
2015-05-27 10:28dmiguelezFile Added: ShowsWarehouseInParents.diff
2015-05-27 10:29dmiguelezNote Added: 0077792
2015-10-14 11:48hgbotCheckin
2015-10-14 11:48hgbotNote Added: 0081002
2015-10-14 11:48hgbotStatusnew => resolved
2015-10-14 11:48hgbotResolutionopen => fixed
2015-10-14 11:48hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.reportvaluedstockenhanced/rev/b54f434791610e140b584ed43d13412b9f094ff1 [^]
2015-10-16 09:04dmiguelezReview Assigned To => dmiguelez
2015-10-16 09:04dmiguelezNote Added: 0081050
2015-10-16 09:04dmiguelezStatusresolved => closed

Notes
(0077792)
dmiguelez   
2015-05-27 10:29   
Attached a file to fix this problem:
When selecting an Organization, it does not show the Warehouse from it's child Organizations, for example, by selecting US Organization, Warehouses from East Coast and West Coast should be displayed in the filter.
(0081002)
hgbot   
2015-10-14 11:48   
Repository: erp/pmods/org.openbravo.warehouse.reportvaluedstockenhanced
Changeset: b54f434791610e140b584ed43d13412b9f094ff1
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Wed Oct 14 11:46:45 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.reportvaluedstockenhanced/rev/b54f434791610e140b584ed43d13412b9f094ff1 [^]

Fixed issue 29215.Several improvements added to the report.

- Added option to export results to PDF or Excel.
- Added mandatory filter by Organization
- Warehouse filter now optional.
- Added consolidated flag to show results by warehouse or not when no
  warehouse is selected in the filter.
- Several fixes in the queries
-- getting the date to convert the cost amounts.
-- performance improvements by using new core columns with precomputed data.

---
M src-db/database/sourcedata/AD_MENU.xml
M src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml
M src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
M src-db/database/sourcedata/AD_PROCESS.xml
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src/org/openbravo/warehouse/reportvaluedstockenhanced/ReportValuedStockEnhanced.html
M src/org/openbravo/warehouse/reportvaluedstockenhanced/ReportValuedStockEnhanced.java
M src/org/openbravo/warehouse/reportvaluedstockenhanced/ReportValuedStockEnhanced.xml
M src/org/openbravo/warehouse/reportvaluedstockenhanced/ReportValuedStockEnhanced2.html
M src/org/openbravo/warehouse/reportvaluedstockenhanced/ReportValuedStockEnhanced2.xml
M src/org/openbravo/warehouse/reportvaluedstockenhanced/ReportValuedStockEnhanced_data.xsql
A src-db/database/sourcedata/AD_MESSAGE.xml
A src-db/database/sourcedata/AD_MODULE_DBPREFIX.xml
A src/org/openbravo/warehouse/reportvaluedstockenhanced/SummaryProductCategory.java
A src/org/openbravo/warehouse/reportvaluedstockenhanced/ad_reports/ReportValuedStockEnhancedExcel.jrxml
A src/org/openbravo/warehouse/reportvaluedstockenhanced/ad_reports/ReportValuedStockEnhancedPDF.jrxml
A src/org/openbravo/warehouse/reportvaluedstockenhanced/ad_reports/SumaryProductCategory.jrxml
---
(0081050)
dmiguelez   
2015-10-16 09:04   
Code Review + Testing Ok