0020026: Not possible to validate a work effort because an error

Description

If exists any register in global use tab in the work effor, and the standars has been created by the production run with a 'completed quantity' = 0, an error message: "division by zero" appears.
Because when the PL "ma_workeffort_validate" checks if there is a Global use with the function "ma_globaluse_distribute", and the error happens in the next statement:
wpp.MOVEMENTQTY*pp.PRODUCTIONQTY, 0) /v_Total

and v_Total is the SUM(wpp.MOVEMENTQTY*pp.PRODUCTIONQTY), if this sum is 0, then there is a division by zero

If the user has introduced the completed qty = 0 in the production run, the process does not know how many qty spreads to all the production runs executed.

Steps To Reproduce

Before the steps below create a sequence for a process plan checking off the Global use. Then planning a Work Requirment.
As group admin role,
Go to Work Effort window,
  - create a work effort
Go to Production run tab:
  - create a new one:
       - select the WR Phase created before
       - Completed qty: 0
Click in Create Standars button and Validate the work effort.
An error message appears: "Division by zero"

Proposed Solution

A correct message clarifying the situation explained in the Description.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0019792

3.0MP10

closed

jecharri

Not possible to validate a work effort because an error

Notes
(0046757) hgbot (developer) 2012-03-27 12:05	Repository: erp/stable/2.50 Changeset: 681cc0d238aab1961ba0157565a21f691a75bd4e Author: Javier Etxarri <javier.echarri <at> openbravo.com> Date: Wed Mar 14 18:48:08 2012 +0100 URL: http://code.openbravo.com/erp/stable/2.50/rev/681cc0d238aab1961ba0157565a21f691a75bd4e [^] Fixes issue 20026: Not possible to validate a work effort because an error --- M src-db/database/model/functions/MA_PRODUCTIONRUN_STANDARD.xml M src-db/database/sourcedata/AD_MESSAGE.xml ---

(0046874) VictorVillar (viewer) 2012-03-29 12:19	Verified

Issue History
Date Modified	Username	Field	Change
2012-03-14 18:00	jecharri	Type	defect => backport
2012-03-14 18:00	jecharri	fix_in_branch	=> 2.50
2012-03-14 18:10	jecharri	version	3.0MP7.1 => 2.50MP39
2012-03-14 18:10	jecharri	Target Version	3.0MP10 => 2.50MP41
2012-03-26 10:34	jecharri	Priority	urgent => high
2012-03-26 10:34	jecharri	Severity	major => minor
2012-03-27 12:05	hgbot	Checkin
2012-03-27 12:05	hgbot	Note Added: 0046757
2012-03-27 12:05	hgbot	Status	scheduled => resolved
2012-03-27 12:05	hgbot	Resolution	open => fixed
2012-03-27 12:05	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/stable/2.50/rev/681cc0d238aab1961ba0157565a21f691a75bd4e [^]
2012-03-29 12:19	VictorVillar	Note Added: 0046874
2012-03-29 12:19	VictorVillar	Status	resolved => closed