Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015486Openbravo ERP06. Material requirement planning (MRP)public2010-12-20 12:452011-05-24 10:57
Reportermaite 
Assigned Toadrianromero 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP24 
Target Version2.50MP26Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0015486: Work Requirement taken twice into account when processing Manufacturing Plan
Description Work Requirement taken twice into account when processing Manufacturing Plan
Steps To Reproduce1.Production Management || Setup || Activity || Activity : create record choosing CostCenter=Assembly
2. Material Requirement (MRP) || Setup || Planning Method || Header: create record and add line to Transaction Type=Work Requirement
3. Production Management || Transactions || Process Plan || Process Plan : create record
4. Production Management || Transactions || Process Plan || Process Plan >> Version : create version from 01-01-2000 to 01-01-9999
5. Production Management || Transactions || Process Plan || Process Plan >> Version >> Operation : define operation for Activity already created and Cost Center Use Time=1 and Multiplier=1
6. Master Data Management || Product || Product : define products
  * P+A: Stocked=Y
         Production=Y
         Purchase=N
         Storage bin=ML1
         Assign created Process Plan
   Go to "Org Specific"tab and set Planing Method and Capacity=10000
  * Same for product P+ B
  * Same for product P- A
7. Production Management || Transactions || Process Plan || Process Plan >> Version >> Operation >> I/O Products : define 3 Product -->
  * two P+ with Component Cost= Rejected=Decrease=Quantity=1
  * one P- with Component Cost= Rejected=Decrease=Quantity=1
8. Production Management || Transactions || Work Requirement || Header : create WR for created Process Plan and Quantity=1700 and WR Creation Date=20/12/2010 and Starting Date=Ending date=31/12/2010.
Process Work requirement
9. Material Requirement (MRP) || Transactions || Manufacturing Plan || Header : create record with Document Date=20/12/2010 and Time Horizon=120.
Process Manufacturing Plan

Realize that WR has been taken into account two times
  
Proposed SolutionI is necessary to modify "Cur_Phase" to check if a work requirement has already been taken into account:

Something like: "and not exists (select 1 from mrp_run_production_line ....)"
Additional Information
TagsclosingMay2011
Relationships
depends on defect 0015607 closed adrianromero Work Requirement taken twice into account when processing Manufacturing Plan 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-12-20 12:45maiteNew Issue
2010-12-20 12:45maiteAssigned To => adrianromero
2010-12-20 12:45maiteModules => Core
2010-12-20 12:45maiteOBNetwork customer => Yes
2010-12-20 12:46maiteTarget Version => 2.50MP26
2010-12-20 12:59maiteSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=1367#r1367
2011-01-11 12:49adrianromeroStatusnew => scheduled
2011-01-11 12:49adrianromerofix_in_branch => pi
2011-01-11 12:50adrianromeroTypedefect => backport
2011-01-11 12:50adrianromerofix_in_branchpi =>
2011-01-11 12:50adrianromeroIssue cloned0015607
2011-01-11 12:50adrianromeroRelationship addeddepends on 0015607
2011-01-12 10:22maiteSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=1416#r1416
2011-01-13 10:02hgbotCheckin
2011-01-13 10:02hgbotNote Added: 0033613
2011-01-13 10:02hgbotStatusscheduled => resolved
2011-01-13 10:02hgbotResolutionopen => fixed
2011-01-13 10:02hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/b5e03aab8f21196ecfa426282e89ec2265256bbc [^]
2011-01-13 10:10adrianromeroNote Added: 0033615
2011-05-24 10:03dalsasuaTag Attached: closingMay2011
2011-05-24 10:57dalsasuaStatusresolved => closed

Notes
(0033613)
hgbot   
2011-01-13 10:02   
Repository: erp/stable/2.50
Changeset: b5e03aab8f21196ecfa426282e89ec2265256bbc
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Thu Jan 13 10:01:33 2011 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/b5e03aab8f21196ecfa426282e89ec2265256bbc [^]

Fixes issue 0015486: Work Requirement taken twice into account when processing Manufacturing Plan
It has been added a new filter to not to include products that has been already processed

---
M src-db/database/model/functions/MRP_RUN_INITIALIZE.xml
---
(0033615)
adrianromero   
2011-01-13 10:10   
* Testing the issue

Follow the steps to reproduce and verify that now the products are not added twice. Verify also that if the product plan has only one P+ product the manufacturing plan is working as before the fix was applied.

This issue needs to be tested in both databases Oracle and Postgresql.

* Other areas affected

No other areas affected. Only the Manufacturing plan process has been modified.