Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0011248
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 06. Material requirement planning (MRP)minoralways2009-11-04 15:542011-03-01 12:16
ReportermensenjhView Statuspublic 
Assigned Toadrianromero 
PrioritynormalResolutionfixedFixed in Version2.50MP27
StatusclosedFix in branchFixed in SCM revision478bd99001cd
ProjectionnoneETAnoneTarget Version2.50MP25
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_11
OS VersionrPath LinuxDatabase version8.3.5Ant version1.7.1
Product Version2.50MP5SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0011248: 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.
TagsNo tags attached.
Attached Filespng file icon Rounding_WR.PNG [^] (47,691 bytes) 2009-11-04 15:54

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0004688 closedgorkaion Production MRP - Needed Product Quantity versus Work Requirement Quantity 
depends on defect 0015610 closedadrianromero Work Requirement: Rounding issue for Quantity field for WR created by MRP 
has duplicate defect 0010612 closedadrianromero Work Requirement: Rounding issue for Quantity field for WR created by MRP 

-  Notes
(0025439)
mensenjh (reporter)
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 (reporter)
2010-08-20 13:13

 duplicate of 10612 reported by myself in September 2009

cheers
Renate
(0032408)
mensenjh (reporter)
2010-11-05 11:51

 Bug reported in issue 9864 for Prof Subscr. customer.
(0033699)
hgbot (developer)
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 (manager)
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 (developer)
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 (developer)
2011-03-01 12:16

 verified

- Issue History
Date Modified Username Field Change
2009-11-04 15:54 mensenjh New Issue
2009-11-04 15:54 mensenjh Assigned To => rafaroda
2009-11-04 15:54 mensenjh File Added: Rounding_WR.PNG
2009-11-04 15:55 mensenjh Issue Monitored: mensenjh
2010-02-11 18:13 rafaroda Assigned To rafaroda => adrianromero
2010-03-13 13:33 mensenjh Note Added: 0025439
2010-08-20 13:13 RenateNieuwkoop Note Added: 0030184
2010-08-20 13:14 RenateNieuwkoop Issue Monitored: RenateNieuwkoop
2010-11-05 11:51 mensenjh Note Added: 0032408
2010-11-08 09:39 jonalegriaesarte Issue Monitored: networkb
2010-11-08 13:16 jonalegriaesarte Target Version => 2.50MP25
2011-01-11 13:07 adrianromero Status new => scheduled
2011-01-11 13:07 adrianromero fix_in_branch => pi
2011-01-11 13:07 adrianromero Type defect => backport
2011-01-11 13:07 adrianromero fix_in_branch pi =>
2011-01-11 13:07 adrianromero Issue cloned 0015610
2011-01-11 13:07 adrianromero Relationship added depends on 0015610
2011-01-17 16:18 adrianromero Relationship added related to 0010612
2011-01-17 16:19 adrianromero Relationship deleted related to 0010612
2011-01-17 16:19 adrianromero Relationship added has duplicate 0010612
2011-01-17 18:27 hgbot Checkin
2011-01-17 18:27 hgbot Note Added: 0033699
2011-01-17 18:27 hgbot Status scheduled => resolved
2011-01-17 18:27 hgbot Resolution open => fixed
2011-01-17 18:27 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/5280ca88645df6f05f6ac2636c0feace56141855 [^]
2011-01-17 18:35 adrianromero Note Added: 0033701
2011-01-18 16:15 adrianromero Relationship added related to 0004688
2011-01-18 16:25 hgbot Checkin
2011-01-18 16:25 hgbot Note Added: 0033721
2011-01-18 16:25 hgbot Fixed in SCM revision http://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:29 adrianromero Note Deleted: 0033721
2011-01-18 16:29 adrianromero Fixed in SCM revision http://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:51 hgbot Checkin
2011-01-24 15:51 hgbot Note Added: 0033827
2011-01-24 15:51 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.50/rev/5280ca88645df6f05f6ac2636c0feace56141855 [^] => http://code.openbravo.com/erp/stable/2.50/rev/478bd99001cd6e8f26fb464bf2cbc3ef145a8861 [^]
2011-03-01 12:16 maite Note Added: 0034466
2011-03-01 12:16 maite Status resolved => closed
2011-03-01 12:16 maite Fixed in Version => 2.50MP27

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker