0015741: 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

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0015939

closed

adrianromero

Inactive process plans are used when running manufacturing plan

Notes
(0034250) hgbot (developer) 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 (manager) 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 (developer) 2011-02-28 11:11	Verified

Issue History
Date Modified	Username	Field	Change
2011-01-24 10:49	maite	New Issue
2011-01-24 10:49	maite	Assigned To	=> adrianromero
2011-01-24 10:49	maite	Modules	=> Core
2011-02-10 16:34	adrianromero	Status	new => scheduled
2011-02-10 16:34	adrianromero	fix_in_branch	=> pi
2011-02-10 16:34	adrianromero	Type	defect => backport
2011-02-10 16:34	adrianromero	fix_in_branch	pi =>
2011-02-10 16:34	adrianromero	Issue cloned	0015939
2011-02-10 16:34	adrianromero	Relationship added	blocks 0015939
2011-02-17 17:47	hgbot	Checkin
2011-02-17 17:47	hgbot	Note Added: 0034250
2011-02-17 17:47	hgbot	Status	scheduled => resolved
2011-02-17 17:47	hgbot	Resolution	open => fixed
2011-02-17 17:47	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/stable/2.50/rev/98d3b02cdc49175383d24a82041f565540d80ad3 [^]
2011-02-17 17:50	adrianromero	Note Added: 0034251
2011-02-28 11:11	maite	Note Added: 0034401
2011-02-28 11:11	maite	Status	resolved => closed
2011-02-28 11:11	maite	Fixed in Version	=> 2.50MP27