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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0018956
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 05. Production managementmajoralways2011-11-02 13:422011-11-15 18:13
ReportermaiteView Statuspublic 
Assigned Tojonalegriaesarte 
PriorityurgentResolutionfixedFixed in Version2.50MP36
StatusclosedFix in branchFixed in SCM revision94de727f4381
ProjectionnoneETAnoneTarget Version2.50MP36
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0018956: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00188503.0MP5 closedjonalegriaesarte Generate Standards process should not consider production lines with qty zero 

-  Notes
(0042831)
hgbot (developer)
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 (developer)
2011-11-15 18:13

 verified

- Issue History
Date Modified Username Field Change
2011-11-02 13:42 maite New Issue
2011-11-02 13:42 maite Assigned To => jonalegriaesarte
2011-11-02 13:42 maite Modules => Core
2011-11-02 13:43 maite Relationship added related to 0018850
2011-11-02 13:43 maite Issue Monitored: networkb
2011-11-15 12:56 hgbot Checkin
2011-11-15 12:56 hgbot Note Added: 0042831
2011-11-15 12:56 hgbot Status new => resolved
2011-11-15 12:56 hgbot Resolution open => fixed
2011-11-15 12:56 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/94de727f4381845c6c0fde928e1fbfedda63d709 [^]
2011-11-15 18:13 maite Note Added: 0042854
2011-11-15 18:13 maite Status resolved => closed
2011-11-15 18:13 maite Fixed in Version => 2.50MP36

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker