Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0032703
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementminoralways2016-04-19 10:242016-07-12 11:26
ReporteraferrazView Statuspublic 
Assigned Toaferraz 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision02dbd212f15b
ProjectionnoneETAnoneTarget Version3.0PR16Q3
OSLinux 64 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionProfessional ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0032703: 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/ [^]
TagsApproved
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 00325043.0PR16Q3 closedaferraz Huge performance problem in the costing background process and using the Negative stock correction too 

-  Notes
(0085803)
hgbot (developer)
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 (developer)
2016-04-21 10:07

 Code Review + Testing OK

- Issue History
Date Modified Username Field Change
2016-04-19 10:24 aferraz New Issue
2016-04-19 10:24 aferraz Assigned To => dmitry_mezentsev
2016-04-19 10:24 aferraz Modules => Core
2016-04-19 10:24 aferraz Triggers an Emergency Pack => No
2016-04-19 10:24 aferraz Relationship added blocks 0032504
2016-04-20 15:56 dmitry_mezentsev Tag Attached: Approved
2016-04-20 15:56 dmitry_mezentsev Assigned To dmitry_mezentsev => aferraz
2016-04-20 21:02 hgbot Checkin
2016-04-20 21:02 hgbot Note Added: 0085803
2016-04-20 21:02 hgbot Status new => resolved
2016-04-20 21:02 hgbot Resolution open => fixed
2016-04-20 21:02 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/api-checks/rev/02dbd212f15bfe1a84f0d0ba3fcf44ab956de789 [^]
2016-04-21 10:07 dmiguelez Review Assigned To => dmiguelez
2016-04-21 10:07 dmiguelez Note Added: 0085816
2016-04-21 10:07 dmiguelez Status resolved => closed
2016-07-12 11:25 Sanjota Relationship added blocks 0033460
2016-07-12 11:26 Sanjota Relationship deleted blocks 0033460

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker