Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0020026 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
backport | [Openbravo ERP] 05. Production management | minor | always | 2012-02-16 13:18 | 2012-03-29 12:19 | |||
Reporter | VictorVillar | View Status | public | |||||
Assigned To | jecharri | |||||||
Priority | high | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | 2.50 | Fixed in SCM revision | 681cc0d238aa | |||
Projection | none | ETA | none | Target Version | 2.50MP41 | |||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | 2.50MP39 | SCM revision | ||||||
Review Assigned To | ||||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 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 ] | ||||||||
|
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 |