0015486: Work Requirement taken twice into account when processing Manufacturing Plan

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0015486

Openbravo ERP

06. Material requirement planning (MRP)

public

2010-12-20 12:45

2011-05-24 10:57

Reporter

maite

Assigned To

adrianromero

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

2.50MP24

Target Version

2.50MP26

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0015486: Work Requirement taken twice into account when processing Manufacturing Plan

Description

Work Requirement taken twice into account when processing Manufacturing Plan

Steps To Reproduce

1.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
         Purchase=N
         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 Solution

I 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 ....)"

Additional Information