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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0018850
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 05. Production managementmajoralways2011-10-24 15:542011-11-04 13:57
ReportermaiteView Statuspublic 
Assigned Tojonalegriaesarte 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision4c7f25fd6942
ProjectionnoneETAnoneTarget Version3.0MP5
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

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

- Relationships Relation Graph ] Dependency Graph ]
related to backport 00189562.50MP36 closedjonalegriaesarte Generate Standards process should not consider production lines with qty zero 

-  Notes
(0042136)
hgbot (developer)
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 (developer)
2011-11-02 13:39

verified
(0042577)
hudsonbot (developer)
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

- Issue History
Date Modified Username Field Change
2011-10-24 15:54 maite New Issue
2011-10-24 15:54 maite Assigned To => jonalegriaesarte
2011-10-24 15:54 maite Modules => Core
2011-10-24 17:01 maite Issue Monitored: networkb
2011-10-27 10:35 hgbot Checkin
2011-10-27 10:35 hgbot Note Added: 0042136
2011-10-27 10:35 hgbot Status new => resolved
2011-10-27 10:35 hgbot Resolution open => fixed
2011-10-27 10:35 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4c7f25fd6942f8a4861fc2c678704a1597f6df3b [^]
2011-11-02 13:39 maite Note Added: 0042449
2011-11-02 13:39 maite Status resolved => closed
2011-11-02 13:43 maite Relationship added related to 0018956
2011-11-04 13:57 hudsonbot Checkin
2011-11-04 13:57 hudsonbot Note Added: 0042577


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker