Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0015939Openbravo ERP06. Material requirement planning (MRP)public2011-02-10 16:342011-05-24 10:55
adrianromero 
adrianromero 
urgentmajoralways
closedfixed 
5
pi 
 
Core
No
0015939: Inactive process plans are used when running manufacturing plan
Inactive process plans are used when running manufacturing plan. Process should filter and only use active process plans
1. 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
filter by active process plan, version, operation and IOproducts in view MA_PROCESSPLAN_TOTALIZED
closingMay2011
depends on backport 00157412.50MP27 closed adrianromero Inactive process plans are used when running manufacturing plan 
Issue History
2011-02-10 16:34adrianromeroNew Issue
2011-02-10 16:34adrianromeroAssigned To => adrianromero
2011-02-10 16:34adrianromeroModules => Core
2011-02-10 16:34adrianromeroIssue generated from0015741
2011-02-10 16:34adrianromeroRelationship addeddepends on 0015741
2011-02-10 16:34adrianromeroStatusnew => scheduled
2011-02-10 16:34adrianromerofix_in_branch => pi
2011-02-21 18:01hgbotCheckin
2011-02-21 18:01hgbotNote Added: 0034292
2011-02-21 18:01hgbotStatusscheduled => resolved
2011-02-21 18:01hgbotResolutionopen => fixed
2011-02-21 18:01hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7265d977ebe52a1b4e7fb52f55b2affa1b0e15dc [^]
2011-02-21 18:02adrianromeroNote Added: 0034293
2011-05-24 10:11dalsasuaTag Attached: closingMay2011
2011-05-24 10:55dalsasuaStatusresolved => closed

Notes
(0034292)
hgbot   
2011-02-21 18:01   
Repository: erp/devel/pi
Changeset: 7265d977ebe52a1b4e7fb52f55b2affa1b0e15dc
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Mon Feb 21 17:58:56 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/7265d977ebe52a1b4e7fb52f55b2affa1b0e15dc [^]

Fixes issue 0015939: 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
---
(0034293)
adrianromero   
2011-02-21 18:02   
* 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.