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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0020026
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 05. Production managementminoralways2012-02-16 13:182012-03-29 12:19
ReporterVictorVillarView Statuspublic 
Assigned Tojecharri 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branch2.50Fixed in SCM revision681cc0d238aa
ProjectionnoneETAnoneTarget Version2.50MP41
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP39SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

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

DescriptionIf 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 ReproduceBefore 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 SolutionA correct message clarifying the situation explained in the Description.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 00197923.0MP10 closedjecharri 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 (developer)
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


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker