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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0015486
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 06. Material requirement planning (MRP)majoralways2010-12-20 12:452011-05-24 10:57
ReportermaiteView Statuspublic 
Assigned Toadrianromero 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionb5e03aab8f21
ProjectionnoneETAnoneTarget Version2.50MP26
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP24SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015486: 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 ....)"
TagsclosingMay2011
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on defect 0015607 closedadrianromero Work Requirement taken twice into account when processing Manufacturing Plan 

-  Notes
(0033613)
hgbot (developer)
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 (manager)
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.

- Issue History
Date Modified Username Field Change
2010-12-20 12:45 maite New Issue
2010-12-20 12:45 maite Assigned To => adrianromero
2010-12-20 12:45 maite Modules => Core
2010-12-20 12:46 maite Target Version => 2.50MP26
2010-12-20 12:59 maite Steps to Reproduce Updated View Revisions
2011-01-11 12:49 adrianromero Status new => scheduled
2011-01-11 12:49 adrianromero fix_in_branch => pi
2011-01-11 12:50 adrianromero Type defect => backport
2011-01-11 12:50 adrianromero fix_in_branch pi =>
2011-01-11 12:50 adrianromero Issue cloned 0015607
2011-01-11 12:50 adrianromero Relationship added depends on 0015607
2011-01-12 10:22 maite Steps to Reproduce Updated View Revisions
2011-01-13 10:02 hgbot Checkin
2011-01-13 10:02 hgbot Note Added: 0033613
2011-01-13 10:02 hgbot Status scheduled => resolved
2011-01-13 10:02 hgbot Resolution open => fixed
2011-01-13 10:02 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/b5e03aab8f21196ecfa426282e89ec2265256bbc [^]
2011-01-13 10:10 adrianromero Note Added: 0033615
2011-05-24 10:03 dalsasua Tag Attached: closingMay2011
2011-05-24 10:57 dalsasua Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker