Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006170Openbravo ERP06. Material requirement planning (MRP)public2008-11-24 11:472015-02-12 14:41
ReporterRenateNieuwkoop 
Assigned Tomirurita 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionout of date 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0006170: Work Requirement generated by MRP mfg plan does not reflect conversion rate
DescriptionMaterial Requirement Planning (MRP) || Transactions || Manufacturing Plan || Header
Material Requirement Planning (MRP) || Transactions || Manufacturing Plan || Header

When Work Requirements get generated from the Manufacturing Plan (MRP), it does not reflect the conversion rate and process quantity (snapshot 02)
If you enter a Work Requirement manually (see snapshot 03) it will do that, based on the process plan (see snapshot 01).

The system generated work requirement is using the same process plan, so the conversion rate should be picked up from that and the process quantity should be filled out also.
Steps To Reproduce
Proposed Solution
Additional Information
Tagscomsup_sprint3
Relationships
blocks defect 0006082 closed AinhoaPagola Work Requirement generated by MRP mfg plan does not reflect conversion rate 
Attached Filesjpg 090409outputMRPinwrongquantityfield.jpg (167,948) 2009-04-09 18:19
https://issues.openbravo.com/file_download.php?file_id=1165&type=bug
jpg

jpg 090409outputMRPinwrongquantityfield2.jpg (160,886) 2009-04-09 18:27
https://issues.openbravo.com/file_download.php?file_id=1166&type=bug
jpg
Issue History
Date ModifiedUsernameFieldChange
2008-11-24 11:47rafarodaNew Issue
2008-11-24 11:47rafarodaAssigned To => gorkaion
2008-11-24 11:47rafarodaStatusnew => scheduled
2008-12-09 12:22gorkaionAssigned Togorkaion => AinhoaPagola
2008-12-17 16:12svnbotCheckin
2008-12-17 16:12svnbotNote Added: 0011484
2008-12-17 16:12svnbotStatusscheduled => resolved
2008-12-17 16:12svnbotResolutionopen => fixed
2008-12-17 16:12svnbotsvn_revision => 11312
2008-12-17 16:27AinhoaPagolaTag Attached: comsup_sprint3
2009-03-03 17:16psarobeStatusresolved => closed
2009-04-09 18:18RenateNieuwkoopStatusclosed => new
2009-04-09 18:18RenateNieuwkoopResolutionfixed => open
2009-04-09 18:18RenateNieuwkoopNote Added: 0015313
2009-04-09 18:19RenateNieuwkoopFile Added: 090409outputMRPinwrongquantityfield.jpg
2009-04-09 18:19RenateNieuwkoopNote Added: 0015314
2009-04-09 18:25RenateNieuwkoopNote Added: 0015316
2009-04-09 18:27RenateNieuwkoopFile Added: 090409outputMRPinwrongquantityfield2.jpg
2009-04-09 18:28RenateNieuwkoopNote Added: 0015317
2009-04-24 16:56rafarodaversion => pi
2009-04-24 17:30AinhoaPagolaStatusnew => scheduled
2009-04-24 17:30AinhoaPagolafix_in_branch2.40 => pi
2009-04-24 17:30AinhoaPagolafix_in_branchpi => 2.40
2009-05-24 10:35RenateNieuwkoopNote Added: 0016596
2011-10-03 10:48jonalegriaesarteAssigned ToAinhoaPagola => jonalegriaesarte
2012-04-03 12:20jonalegriaesarteAssigned Tojonalegriaesarte => vmromanos
2012-05-10 12:12gorka_gilAssigned Tovmromanos => mirurita
2015-02-12 14:41plujanNote Added: 0074422
2015-02-12 14:41plujanStatusscheduled => closed
2015-02-12 14:41plujanResolutionopen => out of date

Notes
(0011484)
svnbot   
2008-12-17 16:12   
Repository: openbravo
Revision: 11312
Author: AinhoaPagola
Date: 2008-12-17 16:12:52 +0100 (Wed, 17 Dec 2008)

Fixes bug 0006170. Work requirement generated by MRP reflects conversion rate

---
U branches/r2.40/src-db/database/model/functions/MRP_WORKREQUIREMENT.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=11312&sc=1 [^]
(0015313)
RenateNieuwkoop   
2009-04-09 18:18   
hi

The conversion rate is there now, but it was fixed incorrect. The quantities generated by MRP should appear in the 'quantity' field, not in the 'process quantity' field. I'll attach a snapshot, where you can see that the output of MRP was to produce 600 pieces. This appeared in the 'process quantity' and the batch size is 8, so the produce quantity will be 75.001!!
(0015314)
RenateNieuwkoop   
2009-04-09 18:19   
This was retested in 2.50 beta postgreSQL and reopened as a result
(0015316)
RenateNieuwkoop   
2009-04-09 18:25   
Now I see what the problem is: the quantity 600 is appearing correct, but the 75 should be just 75, not 75.001 (due to the US setup I guess, it looks like 75 thousand and 1 instead of 75). However, there it's incorrect that it's coming up with 75.001 instead of 75.000.

So it's correct that 600 is in the process quantity and the 75 is in the quantity field. Sorry for the confusion!
(0015317)
RenateNieuwkoop   
2009-04-09 18:28   
Another example (snapshot 2) of the incorrect calculation of the Quantity field as a result from MRP: 206.251 units to be produced! The system should round up to the nearest whole quantity and based on that change the process quantity.
(0016596)
RenateNieuwkoop   
2009-05-24 10:35   
Still happening in 2.50 MP1
(0074422)
plujan   
2015-02-12 14:41   
Backports to 2.40 branch are no longer supported