Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018850Openbravo ERP05. Production managementpublic2011-10-24 15:542011-11-04 13:57
Reportermaite 
Assigned Tojonalegriaesarte 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP5Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0018850: Generate Standards process should not consider production lines with qty zero
DescriptionIn the same way that process is not considering storage entries with QtyOnHand zero, it should not consider production lines with movementqty zero.
As actually they are considered, error "division by zero" is raised under some conditions
Steps To ReproduceHaving a look at Cur_Stock select, you can see that Qty field is only filtering by > 0 in first select and it should also filter in second part of union clause
Proposed SolutionAdd clause
M_PRODUCTIONLINE.movementqty > 0 in second part of select Cur_Stock (line 88)
(coalesce is not required as it is mandatory field)
Additional Information
TagsNo tags attached.
Relationships
related to backport 00189562.50MP36 closed jonalegriaesarte Generate Standards process should not consider production lines with qty zero 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-10-24 15:54maiteNew Issue
2011-10-24 15:54maiteAssigned To => jonalegriaesarte
2011-10-24 15:54maiteModules => Core
2011-10-24 17:01maiteIssue Monitored: networkb
2011-10-27 10:35hgbotCheckin
2011-10-27 10:35hgbotNote Added: 0042136
2011-10-27 10:35hgbotStatusnew => resolved
2011-10-27 10:35hgbotResolutionopen => fixed
2011-10-27 10:35hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4c7f25fd6942f8a4861fc2c678704a1597f6df3b [^]
2011-11-02 13:39maiteNote Added: 0042449
2011-11-02 13:39maiteStatusresolved => closed
2011-11-02 13:43maiteRelationship addedrelated to 0018956
2011-11-04 13:57hudsonbotCheckin
2011-11-04 13:57hudsonbotNote Added: 0042577

Notes
(0042136)
hgbot   
2011-10-27 10:35   
Repository: erp/devel/pi
Changeset: 4c7f25fd6942f8a4861fc2c678704a1597f6df3b
Author: Jon Alegría <jon.alegria <at> openbravo.com>
Date: Thu Oct 27 10:34:03 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/4c7f25fd6942f8a4861fc2c678704a1597f6df3b [^]

Fixes issue 0018850: Generate Standards process should not consider production
lines with qty zero.

---
M src-db/database/model/functions/MA_PRODUCTIONRUN_STANDARD.xml
---
(0042449)
maite   
2011-11-02 13:39   
verified
(0042577)
hudsonbot   
2011-11-04 13:57   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/d10da320df2a [^]

Maturity status: Test