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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0015607
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 06. Material requirement planning (MRP)majoralways2011-01-11 12:502011-05-24 10:57
ReporteradrianromeroView Statuspublic 
Assigned Toadrianromero 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision7e8867befb64
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version3.0RC3SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015607: 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
         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 ]
blocks backport 00154862.50MP26 closedadrianromero Work Requirement taken twice into account when processing Manufacturing Plan 

-  Notes
(0033614)
hgbot (developer)
2011-01-13 10:07

Repository: erp/devel/pi
Changeset: 7e8867befb641a2ac7ad3b533841cb10abc0ee37
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Thu Jan 13 10:05:56 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/7e8867befb641a2ac7ad3b533841cb10abc0ee37 [^]

Fixes issue 0015607: 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
---
(0033616)
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
2011-01-11 12:50 adrianromero New Issue
2011-01-11 12:50 adrianromero Assigned To => adrianromero
2011-01-11 12:50 adrianromero Modules => Core
2011-01-11 12:50 adrianromero Issue generated from 0015486
2011-01-11 12:50 adrianromero Relationship added blocks 0015486
2011-01-11 13:18 adrianromero Status new => scheduled
2011-01-11 13:18 adrianromero fix_in_branch => pi
2011-01-13 10:07 hgbot Checkin
2011-01-13 10:07 hgbot Note Added: 0033614
2011-01-13 10:07 hgbot Status scheduled => resolved
2011-01-13 10:07 hgbot Resolution open => fixed
2011-01-13 10:07 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7e8867befb641a2ac7ad3b533841cb10abc0ee37 [^]
2011-01-13 10:10 adrianromero Note Added: 0033616
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