Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035416Openbravo ERP04. Warehouse managementpublic2017-03-02 17:532017-03-02 17:53
Reportervmromanos 
Assigned ToTriage Omni WMS 
PrioritynormalSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035416: Update ABC in Pareto Product Report should be refactor
DescriptionThis process is based on the M_UPDATE_PARETO_PRODUCT db function, which also calls the M_GET_PARETO_ABC function, both having very important performance issues.

This process should be refactored to avoid the usage of these functions to calculate (once again) & update the ABC.
The ABC already calculated in the report should be used directly to update the records.

Steps To ReproduceNA
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0032493 closed vmromanos Pareto Product Report takes too long in an environment with big amount of data 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-03-02 17:53vmromanosNew Issue
2017-03-02 17:53vmromanosAssigned To => Triage Finance
2017-03-02 17:53vmromanosOBNetwork customer => No
2017-03-02 17:53vmromanosModules => Core
2017-03-02 17:53vmromanosTriggers an Emergency Pack => No
2017-03-02 17:53vmromanosRelationship addedrelated to 0032493

There are no notes attached to this issue.