Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018956Openbravo ERP05. Production managementpublic2011-11-02 13:422011-11-15 18:13
Reportermaite 
Assigned Tojonalegriaesarte 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version2.50MP36Fixed in Version2.50MP36 
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
Summary0018956: 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) in function MA_PRODUCTIONRUN_STANDARD.xml
Additional Information
TagsNo tags attached.
Relationships
related to defect 00188503.0MP5 closed jonalegriaesarte Generate Standards process should not consider production lines with qty zero 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-11-02 13:42maiteNew Issue
2011-11-02 13:42maiteAssigned To => jonalegriaesarte
2011-11-02 13:42maiteModules => Core
2011-11-02 13:43maiteRelationship addedrelated to 0018850
2011-11-02 13:43maiteIssue Monitored: networkb
2011-11-15 12:56hgbotCheckin
2011-11-15 12:56hgbotNote Added: 0042831
2011-11-15 12:56hgbotStatusnew => resolved
2011-11-15 12:56hgbotResolutionopen => fixed
2011-11-15 12:56hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/94de727f4381845c6c0fde928e1fbfedda63d709 [^]
2011-11-15 18:13maiteNote Added: 0042854
2011-11-15 18:13maiteStatusresolved => closed
2011-11-15 18:13maiteFixed in Version => 2.50MP36

Notes
(0042831)
hgbot   
2011-11-15 12:56   
Repository: erp/stable/2.50
Changeset: 94de727f4381845c6c0fde928e1fbfedda63d709
Author: Jon Alegría <jon.alegria <at> openbravo.com>
Date: Tue Nov 15 12:55:20 2011 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/94de727f4381845c6c0fde928e1fbfedda63d709 [^]

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

---
M src-db/database/model/functions/MA_PRODUCTIONRUN_STANDARD.xml
---
(0042854)
maite   
2011-11-15 18:13   
verified