Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011248Openbravo ERP06. Material requirement planning (MRP)public2009-11-04 15:542011-03-01 12:16
Reportermensenjh 
Assigned Toadrianromero 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionrPath Linux
Product Version2.50MP5 
Target Version2.50MP25Fixed in Version2.50MP27 
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
Summary0011248: Work Requirement: Rounding issue for Quantity field for WR created by MRP
DescriptionSee other issue 0010612 that was closed for administration reasons.

Work requirements created through manufacturing plan are rounded op 1/1000. 62 pieces will be shown as 62.001. The rounding accuracy in the product master for the UoM is set to 0.
Steps To Reproduce1. Create two product masters for a finished product and a bought-in component. The finished product has a planning type that consists of all MRP elements and the Unit of Measure is of a type with a standard precision of 0.

2. Set up process plan for a finished product that contains at least 1 component.

3. Create a sales order or forecast for the finished product.

4. Run the manufacturing plan.

5. Create the work requirements from the manufacturing plan window.

6. Go to the window Production requirement in the Production menu and check the qty in the header of the newly created work requirement. The qty is round up 1/1000.

See atthached screenprint.

Proposed SolutionGet rid of the 1/1000 rounding. Make sure precision is in line with precision of UoM in product master.
Additional Information
TagsNo tags attached.
Relationships
related to defect 0004688 closed gorkaion Production MRP - Needed Product Quantity versus Work Requirement Quantity 
depends on defect 0015610 closed adrianromero Work Requirement: Rounding issue for Quantity field for WR created by MRP 
has duplicate defect 0010612 closed adrianromero Work Requirement: Rounding issue for Quantity field for WR created by MRP 
Attached Filespng Rounding_WR.PNG (47,691) 2009-11-04 15:54
https://issues.openbravo.com/file_download.php?file_id=1914&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2009-11-04 15:54mensenjhNew Issue
2009-11-04 15:54mensenjhAssigned To => rafaroda
2009-11-04 15:54mensenjhFile Added: Rounding_WR.PNG
2009-11-04 15:55mensenjhIssue Monitored: mensenjh
2010-02-11 18:13rafarodaAssigned Torafaroda => adrianromero
2010-03-13 13:33mensenjhNote Added: 0025439
2010-08-20 13:13RenateNieuwkoopNote Added: 0030184
2010-08-20 13:14RenateNieuwkoopIssue Monitored: RenateNieuwkoop
2010-11-05 11:51mensenjhNote Added: 0032408
2010-11-08 09:39jonalegriaesarteIssue Monitored: networkb
2010-11-08 13:16jonalegriaesarteTarget Version => 2.50MP25
2011-01-11 13:07adrianromeroStatusnew => scheduled
2011-01-11 13:07adrianromerofix_in_branch => pi
2011-01-11 13:07adrianromeroTypedefect => backport
2011-01-11 13:07adrianromerofix_in_branchpi =>
2011-01-11 13:07adrianromeroIssue cloned0015610
2011-01-11 13:07adrianromeroRelationship addeddepends on 0015610
2011-01-17 16:18adrianromeroRelationship addedrelated to 0010612
2011-01-17 16:19adrianromeroRelationship deletedrelated to 0010612
2011-01-17 16:19adrianromeroRelationship addedhas duplicate 0010612
2011-01-17 18:27hgbotCheckin
2011-01-17 18:27hgbotNote Added: 0033699
2011-01-17 18:27hgbotStatusscheduled => resolved
2011-01-17 18:27hgbotResolutionopen => fixed
2011-01-17 18:27hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/5280ca88645df6f05f6ac2636c0feace56141855 [^]
2011-01-17 18:35adrianromeroNote Added: 0033701
2011-01-18 16:15adrianromeroRelationship addedrelated to 0004688
2011-01-18 16:25hgbotCheckin
2011-01-18 16:25hgbotNote Added: 0033721
2011-01-18 16:25hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.50/rev/5280ca88645df6f05f6ac2636c0feace56141855 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.creditmanagement.dunning/rev/5ebd5e69b2361291d0abfbccf95dfa50c9f88bbc [^]
2011-01-18 16:29adrianromeroNote Deleted: 0033721
2011-01-18 16:29adrianromeroFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.creditmanagement.dunning/rev/5ebd5e69b2361291d0abfbccf95dfa50c9f88bbc [^] => http://code.openbravo.com/erp/stable/2.50/rev/5280ca88645df6f05f6ac2636c0feace56141855 [^]
2011-01-24 15:51hgbotCheckin
2011-01-24 15:51hgbotNote Added: 0033827
2011-01-24 15:51hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.50/rev/5280ca88645df6f05f6ac2636c0feace56141855 [^] => http://code.openbravo.com/erp/stable/2.50/rev/478bd99001cd6e8f26fb464bf2cbc3ef145a8861 [^]
2011-03-01 12:16maiteNote Added: 0034466
2011-03-01 12:16maiteStatusresolved => closed
2011-03-01 12:16maiteFixed in Version => 2.50MP27

Notes
(0025439)
mensenjh   
2010-03-13 13:33   
Yesterday a nice prospect of mine was testing the production module. He didn't communicate his findings yet but I already know he found the rounding issue. This issue seems so straightforward to solve and will make the production planing look a lot better. It's just tough to explain that a bug like this remains in the application for so long.
(0030184)
RenateNieuwkoop   
2010-08-20 13:13   
duplicate of 10612 reported by myself in September 2009

cheers
Renate
(0032408)
mensenjh   
2010-11-05 11:51   
Bug reported in issue 9864 for Prof Subscr. customer.
(0033699)
hgbot   
2011-01-17 18:27   
Repository: erp/stable/2.50
Changeset: 5280ca88645df6f05f6ac2636c0feace56141855
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Mon Jan 17 18:26:12 2011 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/5280ca88645df6f05f6ac2636c0feace56141855 [^]

Fixes issue 0011248: Work Requirement: Rounding issue for Quantity field for WR created by MRP
It has been removed the fixed rouding to 3 decimals and added as rounding parameter the standard precision of the product UOM

---
M src-db/database/model/functions/MRP_WORKREQUIREMENT.xml
---
(0033701)
adrianromero   
2011-01-17 18:35   
* Testing the issue

Following the example http://wiki.openbravo.com/wiki/How-to_MRP#MRP:_A_second_example [^] Verify that the quantity of the Work Requirement generated is 150 and not 150.001 (ie rounded to 0 decimals that is the standard precision for the Unit UOM)

* Other areas affected

No other areas affected. It has been modified only the process of generating work requirements in the Manufacturing plan window.
(0033827)
hgbot   
2011-01-24 15:51   
Repository: erp/stable/2.50
Changeset: 478bd99001cd6e8f26fb464bf2cbc3ef145a8861
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Thu Jan 20 13:18:39 2011 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/478bd99001cd6e8f26fb464bf2cbc3ef145a8861 [^]

Fixes issue 0011248: Work Requirement: Rounding issue for Quantity field for WR created by MRP
It has been fixed the way of calculating the planned quantity value to match the especifications of a work requirement. The planned quantity is an integer value that describes the minimum number of times required to build at least the number of products in the Manufacturing Plan

---
M src-db/database/model/functions/MRP_WORKREQUIREMENT.xml
---
(0034466)
maite   
2011-03-01 12:16   
verified