0015939: Inactive process plans are used when running manufacturing plan

Description

Inactive process plans are used when running manufacturing plan. Process should filter and only use active process plans

Steps To Reproduce

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

Proposed Solution

filter by active process plan, version, operation and IOproducts in view MA_PROCESSPLAN_TOTALIZED

Tags

closingMay2011

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

depends on

backport

0015741

2.50MP27

closed

adrianromero

Inactive process plans are used when running manufacturing plan

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

Issue History
Date Modified	Username	Field	Change
2011-02-10 16:34	adrianromero	New Issue
2011-02-10 16:34	adrianromero	Assigned To	=> adrianromero
2011-02-10 16:34	adrianromero	Modules	=> Core
2011-02-10 16:34	adrianromero	Issue generated from	0015741
2011-02-10 16:34	adrianromero	Relationship added	depends on 0015741
2011-02-10 16:34	adrianromero	Status	new => scheduled
2011-02-10 16:34	adrianromero	fix_in_branch	=> pi
2011-02-21 18:01	hgbot	Checkin
2011-02-21 18:01	hgbot	Note Added: 0034292
2011-02-21 18:01	hgbot	Status	scheduled => resolved
2011-02-21 18:01	hgbot	Resolution	open => fixed
2011-02-21 18:01	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/7265d977ebe52a1b4e7fb52f55b2affa1b0e15dc [^]
2011-02-21 18:02	adrianromero	Note Added: 0034293
2011-05-24 10:11	dalsasua	Tag Attached: closingMay2011
2011-05-24 10:55	dalsasua	Status	resolved => closed