Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015741Openbravo ERP06. Material requirement planning (MRP)public2011-01-24 10:492011-02-28 11:11
Reportermaite 
Assigned Toadrianromero 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP25 
Target Version2.50MP27Fixed in Version2.50MP27 
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
Summary0015741: Inactive process plans are used when running manufacturing plan
DescriptionInactive process plans are used when running manufacturing plan. Process should filter and only use active process plans
Steps To Reproduce1. Material Requirement (MRP) || Setup || Planning Method || Header : define record
2. Material Requirement (MRP) || Setup || Planning Method || Header >> Lines : add line for each transaction type, all with weighting=1
3. Master Data Management || Product || Product : define products for Main org as follows
  - ProductA: stocked=Y, production=Y, purchase=N
  - ProductB: stocked=Y, production=Y, purchase=N
  - Product P1+ : stocked=Y, production=Y, purchase=N
  - Product P2+ : stocked=Y, production=Y, purchase=N
4. Master Data Management || Product || Product >> Org Specific : add record for each product for:
   Main org
   Planning method created
   Warehouse=ML1
   Capacity=10000
5. Production Management || Setup || Activity || Activity : create record
5. Production Management || Transactions || Process Plan || Process Plan : create 2 records:
   -ProcessPlan 1:
      * Org= Main
      * Version tab= from 01/01/2005 to 31/12/9999 + Org=Main
      * Operation tab= org=Main + activity=act + multiplier=1
      * IO Products tab= org=Main
         P- : productA + Decrease=1 + Quantity=1 + Rejected=1
         P- : productB + Decrease=1 + Quantity=1 + Rejected=1
         P+ : P1+ + Component Cost=1 + Decrease=1 + Quantity=1 + Rejected=1
   -ProcessPlan 2:
      * Org= Main
      * Version tab= from 01/01/2005 to 31/12/9999 + Org=Main
      * Operation tab= org=Main + activity=act + multiplier=1
      * IO Products tab= org=Main
         P- : productA + Decrease=1 + Quantity=1 + Rejected=1
         P- : productB + Decrease=1 + Quantity=1 + Rejected=1
         P+ : P2+ + Component Cost=1 + Decrease=1 + Quantity=1 + Rejected=1
Deactivate ProcessPlan2
6. Come back to definition of P1+ and set Process Plan= ProcesPlan1
7. Come back to definition of P2+ and set Process Plan= ProcesPlan2
8. Sales Management || Transactions || Sales Order || Header : create Sales Order for Main org and BP=mcgiver. Add line for Product= P1+ and qty=30. Process Order
9. Material Requirement (MRP) || Transactions || Manufacturing Plan || Header : create record for Main org , documentDate=01/01/2011, Timehorizon=60, product=P1+ and rest of filters empty.
Process Manufacturing Plan

Realize that P2+ appear in Lines generated for Manufacturing Plan. It should not be included as it belongs to a Process Plan deactivated
Proposed Solutionfilter by active process plan, version, operation and IOproducts in view MA_PROCESSPLAN_TOTALIZED
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0015939 closed adrianromero Inactive process plans are used when running manufacturing plan 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-01-24 10:49maiteNew Issue
2011-01-24 10:49maiteAssigned To => adrianromero
2011-01-24 10:49maiteModules => Core
2011-01-24 10:49maiteOBNetwork customer => Yes
2011-02-10 16:34adrianromeroStatusnew => scheduled
2011-02-10 16:34adrianromerofix_in_branch => pi
2011-02-10 16:34adrianromeroTypedefect => backport
2011-02-10 16:34adrianromerofix_in_branchpi =>
2011-02-10 16:34adrianromeroIssue cloned0015939
2011-02-10 16:34adrianromeroRelationship addedblocks 0015939
2011-02-17 17:47hgbotCheckin
2011-02-17 17:47hgbotNote Added: 0034250
2011-02-17 17:47hgbotStatusscheduled => resolved
2011-02-17 17:47hgbotResolutionopen => fixed
2011-02-17 17:47hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/98d3b02cdc49175383d24a82041f565540d80ad3 [^]
2011-02-17 17:50adrianromeroNote Added: 0034251
2011-02-28 11:11maiteNote Added: 0034401
2011-02-28 11:11maiteStatusresolved => closed
2011-02-28 11:11maiteFixed in Version => 2.50MP27

Notes
(0034250)
hgbot   
2011-02-17 17:47   
Repository: erp/stable/2.50
Changeset: 98d3b02cdc49175383d24a82041f565540d80ad3
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Thu Feb 17 17:46:38 2011 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/98d3b02cdc49175383d24a82041f565540d80ad3 [^]

Fixes issue 0015741: Inactive process plans are used when running manufacturing plan
It has been modified the view MA_PROCESSPLAN_TOTALIZED to take only into account active records

---
M src-db/database/model/views/MA_PROCESSPLAN_TOTALIZED.xml
---
(0034251)
adrianromero   
2011-02-17 17:50   
* Testing issue

Follow the steps to test and verify that now the Process Manufacturing Plan is not taking into account inactive process plans. Also it does not take into account inactive process plan versions, nor sequence, nor sequence products

* Other areas affected

Only the view MA_PROCESSPLAN_TOTALIZED has been affected and only removing inactive records. The logic of this view remains the same.
(0034401)
maite   
2011-02-28 11:11   
Verified