Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032703Openbravo ERP04. Warehouse managementpublic2016-04-19 10:242016-07-12 11:26
Reporteraferraz 
Assigned Toaferraz 
PriorityimmediateSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionProfessional Appliance
Product Version 
Target Version3.0PR16Q3Fixed in Version 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0032703: API Change Request: Change cumqty column name in M_Costing table
DescriptionRelated to issue 32504: cumqty column from M_Costing table needs to be renamed to cumstock in order to delete data from this column (update it to null).

Cumqty column was developed in order to save the accumulative quantity (stock) at the point of each costing record but it was never used.
Starting from 32504 and in order to improve performance, this column (renamed to cumstock) will be used to calculate the stock at any point, instead of adding the movementqty of all M_Transaction records until this point.

We want to delete the data from this column to make sure it will be correctly calculated starting from now and this approach performs much more better than updating this column with a modulescript (M_Costing table will not be recreated: http://wiki.openbravo.com/wiki/Projects:Table_Recreation_Prevention [^]).

The risk is minor, because cumqty column was never used.
Steps To Reproducehttps://ci.openbravo.com//job/try-api/3345/ [^]
Proposed Solution
Additional Information
TagsApproved
Relationships
blocks defect 00325043.0PR16Q3 closed aferraz Huge performance problem in the costing background process and using the Negative stock correction too 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-04-19 10:24aferrazNew Issue
2016-04-19 10:24aferrazAssigned To => dmitry_mezentsev
2016-04-19 10:24aferrazModules => Core
2016-04-19 10:24aferrazTriggers an Emergency Pack => No
2016-04-19 10:24aferrazRelationship addedblocks 0032504
2016-04-20 15:56dmitry_mezentsevTag Attached: Approved
2016-04-20 15:56dmitry_mezentsevAssigned Todmitry_mezentsev => aferraz
2016-04-20 21:02hgbotCheckin
2016-04-20 21:02hgbotNote Added: 0085803
2016-04-20 21:02hgbotStatusnew => resolved
2016-04-20 21:02hgbotResolutionopen => fixed
2016-04-20 21:02hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/api-checks/rev/02dbd212f15bfe1a84f0d0ba3fcf44ab956de789 [^]
2016-04-21 10:07dmiguelezReview Assigned To => dmiguelez
2016-04-21 10:07dmiguelezNote Added: 0085816
2016-04-21 10:07dmiguelezStatusresolved => closed
2016-07-12 11:25SanjotaRelationship addedblocks 0033460
2016-07-12 11:26SanjotaRelationship deletedblocks 0033460

Notes
(0085803)
hgbot   
2016-04-20 21:02   
Repository: erp/devel/api-checks
Changeset: 02dbd212f15bfe1a84f0d0ba3fcf44ab956de789
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Wed Apr 20 21:00:35 2016 +0200
URL: http://code.openbravo.com/erp/devel/api-checks/rev/02dbd212f15bfe1a84f0d0ba3fcf44ab956de789 [^]

Fixes issue 32703: API change for issue 32504

---
M model/src-db/database/model/tables/M_COSTING.xml
M model/src-db/database/sourcedata/AD_COLUMN.xml
M model/src-db/database/sourcedata/AD_ELEMENT.xml
M model/src-db/database/sourcedata/AD_FIELD.xml
A java.japi.gz
---
(0085816)
dmiguelez   
2016-04-21 10:07   
Code Review + Testing OK