Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0030509Openbravo ERP06. Material requirement planning (MRP)public2015-08-06 14:292015-11-23 21:16
VictorVillar 
AtulOpenbravo 
urgentmajoralways
closedfixed 
5
pi 
 
vmromanos
Core
No
0030509: The MRP only takes into account the process plan version valid when it is being processed
The MRP only takes into account the process plan version valid when it is being processed.

If there are more than one process plan valid versions in the same month, the manufacturing plan process should take into account the planned order date in order to calculate the correct version in each case.
The MRP only takes into account the process plan version valid when it is being processed.

If there are more than one process plan valid versions in the same month, the manufacturing plan process should take into account the planned order date in order to calculate the correct version in each case.

please follow the steps provided in the following document [1] in order to reproduce the problem.

[1] https://docs.google.com/a/openbravo.com/document/d/1nXctaPx9tAFxb2QP7Gj43T9vmOcFAYjUN-D_iNTwixk/edit?usp=sharing [^]
If there are more than one process plan valid versions in the same month, the manufacturing plan process should take into account the planned order date in order to calculate the correct version in each case.
No tags attached.
Issue History
2015-08-06 14:29VictorVillarNew Issue
2015-08-06 14:29VictorVillarAssigned To => Triage Finance
2015-08-06 14:29VictorVillarModules => Core
2015-08-06 14:29VictorVillarTriggers an Emergency Pack => No
2015-08-06 14:29VictorVillarIssue Monitored: networkb
2015-08-28 15:11VictorVillarNote Added: 0079800
2015-08-28 15:11VictorVillarTypedesign defect => defect
2015-08-28 15:31VictorVillarResolution time => 1443304800
2015-08-28 15:39VictorVillarNote Deleted: 0079800
2015-08-28 15:40VictorVillarResolution time1443304800 =>
2015-08-28 15:40VictorVillarTypedefect => design defect
2015-09-03 10:27VictorVillarResolution time => 1443823200
2015-09-03 10:27VictorVillarTypedesign defect => defect
2015-09-04 09:33VictorVillarSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=9343#r9343
2015-09-16 10:00AtulOpenbravoAssigned ToTriage Finance => AtulOpenbravo
2015-09-16 10:01AtulOpenbravoStatusnew => scheduled
2015-09-23 11:53AtulOpenbravoNote Added: 0080574
2015-09-29 14:00psanjuanNote Added: 0080704
2015-10-01 10:32psanjuanNote Edited: 0080704bug_revision_view_page.php?bugnote_id=0080704#r9549
2015-10-01 11:09psanjuanNote Edited: 0080704bug_revision_view_page.php?bugnote_id=0080704#r9550
2015-10-01 12:00psanjuanNote Edited: 0080704bug_revision_view_page.php?bugnote_id=0080704#r9553
2015-10-01 12:02psanjuanNote Edited: 0080704bug_revision_view_page.php?bugnote_id=0080704#r9554
2015-10-01 12:15psanjuanNote Edited: 0080704bug_revision_view_page.php?bugnote_id=0080704#r9555
2015-10-01 12:18psanjuanNote Edited: 0080704bug_revision_view_page.php?bugnote_id=0080704#r9556
2015-10-01 12:29psanjuanNote Edited: 0080704bug_revision_view_page.php?bugnote_id=0080704#r9557
2015-10-01 12:31psanjuanNote Edited: 0080704bug_revision_view_page.php?bugnote_id=0080704#r9559
2015-10-01 12:34psanjuanNote Edited: 0080704bug_revision_view_page.php?bugnote_id=0080704#r9560
2015-10-01 12:41psanjuanNote Edited: 0080704bug_revision_view_page.php?bugnote_id=0080704#r9561
2015-10-01 12:44psanjuanNote Edited: 0080704bug_revision_view_page.php?bugnote_id=0080704#r9562
2015-10-01 12:45psanjuanNote Edited: 0080704bug_revision_view_page.php?bugnote_id=0080704#r9563
2015-10-01 13:23psanjuanNote Edited: 0080704bug_revision_view_page.php?bugnote_id=0080704#r9564
2015-10-01 13:24psanjuanNote Edited: 0080704bug_revision_view_page.php?bugnote_id=0080704#r9565
2015-10-01 13:32psanjuanNote Edited: 0080704bug_revision_view_page.php?bugnote_id=0080704#r9566
2015-10-01 13:33psanjuanNote Added: 0080786
2015-10-02 08:31hgbotCheckin
2015-10-02 08:31hgbotNote Added: 0080797
2015-10-02 08:31hgbotStatusscheduled => resolved
2015-10-02 08:31hgbotResolutionopen => fixed
2015-10-02 08:31hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/29524c0b6c24f87b21861020d3026657b4145f3f [^]
2015-10-02 08:32vmromanosReview Assigned To => vmromanos
2015-10-02 08:32vmromanosNote Added: 0080798
2015-10-02 08:32vmromanosStatusresolved => closed
2015-11-23 21:16hudsonbotCheckin
2015-11-23 21:16hudsonbotNote Added: 0082106

Notes
(0080574)
AtulOpenbravo   
2015-09-23 11:53   
Test Plan

- Following steps given in http://wiki.openbravo.com/wiki/ERP_2.50:How-to_MRP [^]
MRP: A second example.

- Create two products Leg A and Leg B (Refer above link and create similar as Product Leg) to differentiate between Process Plan Versions.

- Create Process Plan Versions with date as
1. Date From 01-01-2015 Date To 01-06-2015 (Use product use (p-) as Leg A)
2. Date From 01-06-2015 Date To 31-12-2015 (Use product use (p-)as Leg B)

- Create two different Sales Order one each in above two date slots. Complete them.

- Create Manufacturing Plan for both sales order dates and run Process Manufacturing Plan button.

- Check that in manufacturing plan lines for first slot product Leg A is used and for second slot product leg B is used.
(0080704)
psanjuan   
2015-09-29 14:00   
(edited on: 2015-10-01 13:32)
Test Plan

Configuration steps:

The organization to be used is F&B España, for instance, so all master data below can be created for F&B España organization.

-Go to Planning Method window and create below Planning Method.
Planning Method Test.
-Select all transactions type in lines 10..50 (Material Requirement, Sales Forecast, Pending Purchase Order, Pending Sales Order and Pending Work Requirement). Weighting = 1 for each line.
-Do not enter any Days from/to, to make it simple.

-Go to Planner and create "Planner 1".

-Go to Product window and create below 3 products:

(1) Search Key = Name = 02317077-REV-X1. Set as "Purchase" = Yes, "Sale" = NO, "Production" = Yes
Go to price tab and select "Tarifa Bebidas Alegres" - Unit Price = List Price = 100.00
Go to Manufacturing tab and enter below data: "Planning Method Test", and "Planner 1".

(2) Search Key = Name = 02317079-REV-X1. Set as "Purchase" = No, "Sale" = Yes, "Production" = Yes.
Go to Manufacturing tab and enter below data: "Planning Method Test", "Planner 1" and a Storage bin.
Go to Price tab and select a sales price list "Tarifa de Ventas". Unit = List Price = 150.00

(3) Search Key = Name = 02317077-REV-X2. Set as "Purchase" = Yes, "Sale"= No, "Production" = Yes
Tarifa Bebidas Alegres - Unit Price = List Price = 90.00
Go to Manufacturing tab and enter below data: "Planning Method Test" and "Planner 1".
- Go to "Activity" window and create an activity/operation named "Build". Save.

- Go to "Process Plan" window and create a new one named "WP201-REV"
- Go to "Version" tab and create two versions one starting from/to 01-01-2015/05-08-2015; and the other one starting from/to 05-08-2015/31-12-9999
- Select version 1 and enter operation Build. Go to I/O Products and enter below P+, P-:
Product = 02317079-REV-X1 - as P+, Quantity = 1
Product = 02317077-REV-X1 - as P-, Quantity= 1
- Select verion 2 and enter operation Build. Go to I/O Products and enter below P+, P-:
Product = 02317079-REV-X1 - as P+, Quantity = 1
Product = 02317077-REV-X2 - as P-, Quantity= 1

- Go to Product window and enter above created "Process Plan" "WP201-REV" for each of these three products.

- Create a goods receipt for product 02317077-REV-X1 for 15 units dated on 01-01-2015. Complete it.

Execution steps:

A.

- Go to "MRP Forecast" window and create a new one with below setup: Document Date 02-08-2015,BP = Alimentos y Supermercados.
- Go to lines tab and enter below data:
Planned date = 03-08-2015
Product = 02317079-REV-X1

- Go to Manufacturing Plan window create a new one dated on 02-08-2015. Time Horizon = 30 days, Select product 02317079-REV-X1
- Process Manufacturing Plan.
- Realize that "Suggested Material requirement" uses Process Plan version 1, that is the one that uses product = 02317077-REV-X1 with a planned order date = 03-08-2015
- Delete Manufacturing Plan lines by deleting on following listed Transaction Type order:
Stock, Minimum Stock, Suggested Material Requirement, Suggested Work Effort and Sales Forecast.


B.

- Go to "MRP Forecast" window, select the one created above and change Planned date to 10-08-2015
- Go to Manufacturing Plan window and Process it once again.
- Realize that "Suggested Material requirement" uses Process Plan version 2, that is the one that uses product = 02317077-REV-X2, with a planned order date = 10-08-2015
- Delete Manufacturing Plan lines by deleting on following listed Transaction Type order:
Stock, Minimum Stock, Suggested Material Requirement, Suggested Work Effort and Sales Forecast.

C.

- Go to MRP Forecast window and delete the record.
- Go to Sales Order window and create a new order for BP = Alimentos y Supermercados, order date = 02-08-2015, scheduled delivery date = 03-08-2015, for 1 unit of product 02317079-REV-X1. Complete the order.
- Go to Manufacturing Plan and process the manufacturing plan created.
- Realize that "Suggested Material requirement" uses Process Plan version 1, that is the one that uses product = 02317077-REV-X1 with a planned order date = 03-08-2015
- Delete Manufacturing Plan lines by deleting on following listed Transaction Type order:
Stock, Minimum Stock, Suggested Material Requirement, Suggested Work Effort and Sales Forecast.
- Go to Sales order window and Reactivate the order. Change Scheduled Deliver Date to 10-08-2015. Save and Book the order.
- Go to Manufacturing Plan and process the manufacturing plan created.
- Realize that "Suggested Material requirement" uses Process Plan version 2, that is the one that uses product = 02317077-REV-X2 with a planned order date = 10-08-2015

(0080786)
psanjuan   
2015-10-01 13:33   
Test Plan above verified.
Issue can be closed after tech review.
(0080797)
hgbot   
2015-10-02 08:31   
Repository: erp/devel/pi
Changeset: 29524c0b6c24f87b21861020d3026657b4145f3f
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Thu Oct 01 14:31:43 2015 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/29524c0b6c24f87b21861020d3026657b4145f3f [^]

Fixes Issue 30509:The MRP only takes into account the process plan version
valid when it is being processed

- MA_ProcessPlan_Totalized view is changed to not only to consider processplan
versions in the current date now(). Also Column added showing Date From and
Date To for Process Plan versions.
- Latest version is selected for MRP_Run_Lines's Produced product based on
Planned Order Date from MA_ProcessPlan_Totalized available versions.

---
M src-db/database/model/functions/MRP_RUN_EXPLODE.xml
M src-db/database/model/views/MA_PROCESSPLAN_TOTALIZED.xml
---
(0080798)
vmromanos   
2015-10-02 08:32   
Code review OK
(0082106)
hudsonbot   
2015-11-23 21:16   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/7b56bebaaa88 [^]
Maturity status: Test