Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Modules] Valued Stock Enhancedtrivialhave not tried2015-03-10 11:432015-10-16 09:04
ReporternaiaramartinezView Statuspublic 
Assigned Tojonalegriaesarte 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionb54f43479161
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned Todmiguelez
Regression introduced in release

0029215: 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
TagsNo tags attached.
Attached Filesdiff file icon 29215.diff [^] (129,512 bytes) 2015-03-10 12:28 [Show Content]
diff file icon ShowsWarehouseInParents.diff [^] (933 bytes) 2015-05-27 10:28 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
dmiguelez (developer)
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.
hgbot (developer)
2015-10-14 11:48

Repository: erp/pmods/org.openbravo.warehouse.reportvaluedstockenhanced
Changeset: b54f434791610e140b584ed43d13412b9f094ff1
Author: Gorka Ion Damián <gorkaion.damian <at>>
Date: Wed Oct 14 11:46:45 2015 +0200
URL: [^]

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/
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/
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
dmiguelez (developer)
2015-10-16 09:04

Code Review + Testing Ok

- Issue History
Date Modified Username Field Change
2015-03-10 11:43 naiaramartinez New Issue
2015-03-10 11:43 naiaramartinez Assigned To => jonalegriaesarte
2015-03-10 12:26 naiaramartinez Proposed Solution updated
2015-03-10 12:28 naiaramartinez File Added: 29215.diff
2015-05-27 10:28 dmiguelez File Added: ShowsWarehouseInParents.diff
2015-05-27 10:29 dmiguelez Note Added: 0077792
2015-10-14 11:48 hgbot Checkin
2015-10-14 11:48 hgbot Note Added: 0081002
2015-10-14 11:48 hgbot Status new => resolved
2015-10-14 11:48 hgbot Resolution open => fixed
2015-10-14 11:48 hgbot Fixed in SCM revision => [^]
2015-10-16 09:04 dmiguelez Review Assigned To => dmiguelez
2015-10-16 09:04 dmiguelez Note Added: 0081050
2015-10-16 09:04 dmiguelez Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker