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

Description

In 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 Reproduce

Having 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 Solution

Add clause
M_PRODUCTIONLINE.movementqty > 0 in second part of select Cur_Stock (line 88)
(coalesce is not required as it is mandatory field)

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

backport

0018956

2.50MP36

closed

jonalegriaesarte

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 (viewer) 2011-11-02 13:39	verified

(0042577) hudsonbot (viewer) 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 15:54	maite	OBNetwork customer	=> Yes
2011-10-24 15:54	maite	Support ticket	=> 13002
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