Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027397Openbravo ERP05. Production managementpublic2014-08-21 06:592014-12-30 23:24
ReporterVictorVillar 
Assigned Tofsoto82 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q1Fixed in Version3.0PR15Q1 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket29937
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027397: The ending date of the work requirement is not calculated properly
DescriptionThe ending date of the work requirement is not calculated properly
Steps To ReproduceAs group admin role,
Go to Process Plan
  create a new header for * Org.
  create a new Version: Estimated time 2
  create a new operation: estimated time 2
  define the consumed products and the produced products
Go to Work Requirement window
  select the process plan created before.
  Quantity: 5000
  Start date: today
  Ending date: realise that is populated autmatically as today
Process it
As you can read [1] The calculation of the Estimated time is: estimated time taken from the process plan x process quantity on the work requirement.
So the result is 10000 hours.
And that information is populated in the operation too.

But the Ending date of the header and the ending date of each Operation does not change, and this is a wrong information, taking into account the Estimated time.


[1] http://wiki.openbravo.com/wiki/Work_Requirement [^]

Please check the ma_workrequirement_process function.
    
Proposed SolutionThe Header/operation Ending date should be calculated depending on the Estimated time calculated when the user process the work requirement
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-08-21 06:59VictorVillarNew Issue
2014-08-21 06:59VictorVillarAssigned To => jonalegriaesarte
2014-08-21 06:59VictorVillarOBNetwork customer => Yes
2014-08-21 06:59VictorVillarModules => Core
2014-08-21 06:59VictorVillarSupport ticket => 29937
2014-08-21 06:59VictorVillarResolution time => 1412200800
2014-08-21 06:59VictorVillarTriggers an Emergency Pack => No
2014-08-21 06:59VictorVillarIssue Monitored: networkb
2014-09-01 16:34jonalegriaesarteAssigned Tojonalegriaesarte => AtulOpenbravo
2014-09-22 16:36jonalegriaesarteTarget Version3.0PR14Q4 => 3.0PR15Q1
2014-10-29 03:51fsoto82Statusnew => scheduled
2014-10-29 03:51fsoto82Assigned ToAtulOpenbravo => fsoto82
2014-10-29 03:51fsoto82fix_in_branch => pi
2014-10-29 23:50fsoto82Note Added: 0071259
2014-11-05 17:34hgbotCheckin
2014-11-05 17:34hgbotNote Added: 0071437
2014-11-05 17:34hgbotStatusscheduled => resolved
2014-11-05 17:34hgbotResolutionopen => fixed
2014-11-05 17:34hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9e11efa4229f852c575624616b8d38048ac9a3c1 [^]
2014-11-05 17:35SandrahuguetReview Assigned To => Sandrahuguet
2014-11-05 17:35SandrahuguetNote Added: 0071438
2014-11-05 17:35SandrahuguetStatusresolved => closed
2014-11-05 17:35SandrahuguetFixed in Version => 3.0PR15Q1
2014-12-30 23:24hudsonbotCheckin
2014-12-30 23:24hudsonbotNote Added: 0073020

Notes
(0071259)
fsoto82   
2014-10-29 23:50   
As group admin role,
Go to Process Plan
  create a new header for * Org.
  create a new Version: Estimated time 2
  create a new operation: estimated time 2
  define the consumed products and the produced products
Go to Work Requirement window
  select the process plan created before.
  Quantity: 5000
  Start date: today
  Ending date: realise that is populated autmatically as today
Process it
Check the work requirement ending date is calculated correctly.

The work requirement ending date also is calculated if manually adds, update or delete the Work requirement Operations
(0071437)
hgbot   
2014-11-05 17:34   
Repository: erp/devel/pi
Changeset: 9e11efa4229f852c575624616b8d38048ac9a3c1
Author: Fernando Soto <fernando.soto <at> peoplewalking.com>
Date: Wed Oct 29 16:55:56 2014 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/9e11efa4229f852c575624616b8d38048ac9a3c1 [^]

Fixed bug 27397: Ending date of the work requirement is not calculated properly

Modified stored procedure MA_WORKREQUIREMENT_PROCESS to calculate the ending date of each Operation (MA_WRPHASE).
Modified the trigger MA_WRPHASE_TRG that was calculating the estimated time but not the endind date.

---
M src-db/database/model/functions/MA_WORKREQUIREMENT_PROCESS.xml
M src-db/database/model/triggers/MA_WRPHASE_TRG.xml
---
(0071438)
Sandrahuguet   
2014-11-05 17:35   
Code review + testing OK
(0073020)
hudsonbot   
2014-12-30 23:24   
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/6525fe229e06 [^]
Maturity status: Test