Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0015486 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
backport | [Openbravo ERP] 06. Material requirement planning (MRP) | major | always | 2010-12-20 12:45 | 2011-05-24 10:57 | |||
Reporter | maite | View Status | public | |||||
Assigned To | adrianromero | |||||||
Priority | urgent | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | b5e03aab8f21 | ||||
Projection | none | ETA | none | Target Version | 2.50MP26 | |||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | 2.50MP24 | SCM revision | ||||||
Merge Request Status | ||||||||
Review Assigned To | ||||||||
OBNetwork customer | OBPS | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Support ticket | ||||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
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 ....)" | |||||||
Tags | closingMay2011 | |||||||
Attached Files | ||||||||
![]() |
||||||||
|
![]() |
|
(0033613) hgbot (developer) 2011-01-13 10:02 |
Repository: erp/stable/2.50 Changeset: b5e03aab8f21196ecfa426282e89ec2265256bbc Author: Adrián Romero <adrianromero <at> openbravo.com> Date: Thu Jan 13 10:01:33 2011 +0100 URL: http://code.openbravo.com/erp/stable/2.50/rev/b5e03aab8f21196ecfa426282e89ec2265256bbc [^] Fixes issue 0015486: Work Requirement taken twice into account when processing Manufacturing Plan It has been added a new filter to not to include products that has been already processed --- M src-db/database/model/functions/MRP_RUN_INITIALIZE.xml --- |
(0033615) adrianromero (viewer) 2011-01-13 10:10 |
* Testing the issue Follow the steps to reproduce and verify that now the products are not added twice. Verify also that if the product plan has only one P+ product the manufacturing plan is working as before the fix was applied. This issue needs to be tested in both databases Oracle and Postgresql. * Other areas affected No other areas affected. Only the Manufacturing plan process has been modified. |
![]() |
|||
Date Modified | Username | Field | Change |
2010-12-20 12:45 | maite | New Issue | |
2010-12-20 12:45 | maite | Assigned To | => adrianromero |
2010-12-20 12:45 | maite | Modules | => Core |
2010-12-20 12:45 | maite | OBNetwork customer | => Yes |
2010-12-20 12:46 | maite | Target Version | => 2.50MP26 |
2010-12-20 12:59 | maite | Steps to Reproduce Updated | View Revisions |
2011-01-11 12:49 | adrianromero | Status | new => scheduled |
2011-01-11 12:49 | adrianromero | fix_in_branch | => pi |
2011-01-11 12:50 | adrianromero | Type | defect => backport |
2011-01-11 12:50 | adrianromero | fix_in_branch | pi => |
2011-01-11 12:50 | adrianromero | Issue cloned | 0015607 |
2011-01-11 12:50 | adrianromero | Relationship added | depends on 0015607 |
2011-01-12 10:22 | maite | Steps to Reproduce Updated | View Revisions |
2011-01-13 10:02 | hgbot | Checkin | |
2011-01-13 10:02 | hgbot | Note Added: 0033613 | |
2011-01-13 10:02 | hgbot | Status | scheduled => resolved |
2011-01-13 10:02 | hgbot | Resolution | open => fixed |
2011-01-13 10:02 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/stable/2.50/rev/b5e03aab8f21196ecfa426282e89ec2265256bbc [^] |
2011-01-13 10:10 | adrianromero | Note Added: 0033615 | |
2011-05-24 10:03 | dalsasua | Tag Attached: closingMay2011 | |
2011-05-24 10:57 | dalsasua | Status | resolved => closed |
Copyright © 2000 - 2009 MantisBT Group |