Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015610Openbravo ERP06. Material requirement planning (MRP)public2011-01-11 13:072011-05-24 10:57
Reporteradrianromero 
Assigned Toadrianromero 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionrPath Linux
Product Version3.0RC3 
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
Summary0015610: 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
TagsclosingMay2011
Relationships
blocks backport 00112482.50MP25 closed adrianromero Work Requirement: Rounding issue for Quantity field for WR created by MRP 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-01-11 13:07adrianromeroNew Issue
2011-01-11 13:07adrianromeroAssigned To => adrianromero
2011-01-11 13:07adrianromeroModules => Core
2011-01-11 13:07adrianromeroIssue generated from0011248
2011-01-11 13:07adrianromeroRelationship addedblocks 0011248
2011-01-11 13:07adrianromeroStatusnew => scheduled
2011-01-11 13:07adrianromerofix_in_branch => pi
2011-01-17 18:30hgbotCheckin
2011-01-17 18:30hgbotNote Added: 0033700
2011-01-17 18:30hgbotStatusscheduled => resolved
2011-01-17 18:30hgbotResolutionopen => fixed
2011-01-17 18:30hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a26534e5699c2568f983f71cb6c4a1a1cadf3322 [^]
2011-01-17 18:36adrianromeroNote Added: 0033702
2011-01-21 12:15hgbotCheckin
2011-01-21 12:15hgbotNote Added: 0033807
2011-01-21 12:15hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/a26534e5699c2568f983f71cb6c4a1a1cadf3322 [^] => http://code.openbravo.com/erp/devel/pi/rev/6ecc5c12a66b9eb2a5bada7bdd3047875a101140 [^]
2011-05-24 10:03dalsasuaTag Attached: closingMay2011
2011-05-24 10:57dalsasuaStatusresolved => closed

Notes
(0033700)
hgbot   
2011-01-17 18:30   
Repository: erp/devel/pi
Changeset: a26534e5699c2568f983f71cb6c4a1a1cadf3322
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Mon Jan 17 18:29:44 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/a26534e5699c2568f983f71cb6c4a1a1cadf3322 [^]

Fixes issue 0015610: 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
---
(0033702)
adrianromero   
2011-01-17 18:36   
* 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.
(0033807)
hgbot   
2011-01-21 12:15   
Repository: erp/devel/pi
Changeset: 6ecc5c12a66b9eb2a5bada7bdd3047875a101140
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Fri Jan 21 12:14:09 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/6ecc5c12a66b9eb2a5bada7bdd3047875a101140 [^]

Fixes issue 15610: 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
---