Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031874ModulesValued Stock Enhancedpublic2016-01-13 16:592016-12-28 10:54
Reporterdmiguelez 
Assigned ToTriage Omni OMS 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionduplicate 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Toaferraz
Support ticket
OBNetwork customer
Regression introduced in release
Summary0031874: Performance problems in Valued Stock Report Enhanced
DescriptionPerformance problems in Valued Stock Report Enhanced with large volumes of data.
Steps To ReproducePerformance problems in Valued Stock Report Enhanced with large volumes of data.
Proposed SolutionCreate an aggregated table to store the information per accounting Period to the time it takes to run calculations needed in order to show the report.
Additional Information
TagsNo tags attached.
Relationships
duplicate of feature request 0034482 closed Triage Omni OMS Openbravo ERP Improve performance in Enhanced Valued Stock Report 
related to defect 0030197 closed psarobe Modules Enhanced valued stock report's performance is bad when no warehouse is filtered. 
related to design defect 0032493 closed vmromanos Openbravo ERP Pareto Product Report takes too long in an environment with big amount of data 
causes defect 0035415 closed dmiguelez Openbravo ERP Generate Aggregated Data Background doesn't work in Oracle 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-01-13 16:59dmiguelezNew Issue
2016-01-13 16:59dmiguelezAssigned To => Triage Finance
2016-01-13 16:59dmiguelezRelationship addedrelated to 0030197
2016-01-13 17:04dmiguelezNote Added: 0083256
2016-04-19 14:45aferrazRelationship addedrelated to 0032493
2016-04-22 14:41ngarciaIssue Monitored: ngarcia
2016-12-28 10:54aferrazReview Assigned To => aferraz
2016-12-28 10:54aferrazRelationship addedduplicate of 0034482
2016-12-28 10:54aferrazStatusnew => closed
2016-12-28 10:54aferrazResolutionopen => duplicate
2017-03-02 17:40vmromanosRelationship addedcauses 0035415

Notes
(0083256)
dmiguelez   
2016-01-13 17:04   
The proposal is:

1. Create an aggregated Table to store aggregated information for Stock and Valuation of the Stock.
  - This information should be grouped for each Product and Locator
  - This information needs to be created for each closed Accounting Period. The reason to do it is because the Valued Stock Report can be run as of Date, so it is needed to have aggregated information for different dates.
  - The information will be only stored for Closed and Permanently Closed Periods.

2. Create a Process to insert the information into the Table for each Closed Period. This Process will be scheduled as a background Process.

3. When a Period is Closed or Permanently Closed, the background Process will take it into account and will create the needed data when the process is run.

4. When a Period is Opened, if there is data for that Period (or for the next ones), it will be automatically deleted at that moment.