Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026480Openbravo ERP05. Production managementpublic2014-05-06 18:312015-02-11 10:57
Reporterngarcia 
Assigned ToAtulOpenbravo 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR14Q3Fixed in Version 
Merge Request Status
Review Assigned Torafaroda
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0026480: Quantity should be rounded when creating a work effort from a work requirement operation set as create standards
DescriptionQuantity should be rounded when creating a work effort from a work requirement operation set as create standards
Steps To ReproduceChange the qtyEdition, qtyRelation and qtyExcel to show 4 decimals in Format.xml file
As group admin role:
   Create an Activity
   Create a Process Plan and Version
   When creating an Operation, select the previously created Activity and select the Create Standards checkbox
   Add a line in the I/O Products tab with Quantity 1866.9
   Create a Work Requirement for the previously created Process Plan with Quantity = 9.3095 and process it
   Create Work Effort and validate it
Check through database the movementqty on the M_PRODUCTIONLINE table has 5 decimals (17379.90555)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0022988 new Triage Omni OMS Qty proposed is not taking into account the Standard Precision of its Unit of Measure 
related to defect 0028914 closed AtulOpenbravo Should be an option to use the UOM Standard precision for production or not 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-05-06 18:31ngarciaNew Issue
2014-05-06 18:31ngarciaAssigned To => jonalegriaesarte
2014-05-06 18:31ngarciaModules => Core
2014-05-06 18:31ngarciaResolution time => 1402005600
2014-05-06 18:31ngarciaTriggers an Emergency Pack => No
2014-05-06 18:32ngarciaIssue Monitored: networkb
2014-05-07 21:14johnfandlIssue Monitored: johnfandl
2014-05-19 14:33jonalegriaesarteAssigned Tojonalegriaesarte => pramakrishnan
2014-06-05 13:42AtulOpenbravoAssigned Topramakrishnan => AtulOpenbravo
2014-06-05 13:46AtulOpenbravoStatusnew => scheduled
2014-06-05 13:46AtulOpenbravofix_in_branch => pi
2014-06-06 19:17AtulOpenbravoNote Added: 0067813
2014-06-10 08:26AtulOpenbravoReview Assigned To => rafaroda
2014-06-10 08:26AtulOpenbravofix_in_branchpi =>
2014-06-10 08:27hgbotCheckin
2014-06-10 08:27hgbotNote Added: 0067834
2014-06-10 08:27hgbotStatusscheduled => resolved
2014-06-10 08:27hgbotResolutionopen => fixed
2014-06-10 08:27hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6ec5a7961a6015619024062222846fc67fcbf45f [^]
2014-06-10 08:41rafarodaNote Added: 0067837
2014-06-10 08:41rafarodaStatusresolved => closed
2014-06-10 22:24hudsonbotCheckin
2014-06-10 22:24hudsonbotNote Added: 0067892
2015-02-11 10:57VictorVillarRelationship addedrelated to 0022988
2015-02-11 12:40VictorVillarRelationship addedrelated to 0028914

Notes
(0067813)
AtulOpenbravo   
2014-06-06 19:17   
Test Plan
- Change the qtyEdition, qtyRelation and qtyExcel to show 4 decimals in Format.xml file
- Login as Group Admin role:
- Create an Activity
- Create a Process Plan and Version.
- When creating an Operation, select the previously created Activity and selecting the Create Standards checkbox is optional.
- Add a line in the I/O Products tab with Quantity 1866.9
- Create a Work Requirement for the previously created Process Plan with Quantity = 9.3095 and process it.
- Create Work Effort from either Work Requirement or manually using Work Effort Window.
- If create standards button is checked then under Production Run >> Product tab checks records. If using manual Work Effort, select WR Phase and set completed quantity and click on Create Standards button and Production Run >> Product Tab records. Quantity will be displayed with the standard precision of uom used in the same line.
** It can be verified in the database M_ProductionLine Table.
(0067834)
hgbot   
2014-06-10 08:27   
Repository: erp/devel/pi
Changeset: 6ec5a7961a6015619024062222846fc67fcbf45f
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Fri Jun 06 22:49:47 2014 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/6ec5a7961a6015619024062222846fc67fcbf45f [^]

Fixes Issue 26480:Rounding of movementQty in WorkEffort-ProductionRun-Product
Rounding is done using StdPrecision of Production Line Uom.

---
M src-db/database/model/functions/MA_PRODUCTIONRUN_STANDARD.xml
---
(0067837)
rafaroda   
2014-06-10 08:41   
Product created in Work Effort from Work Requirement is now properly rounded with UOM standard precision: see images in https://drive.google.com/folderview?id=0B649lz4ZYJcHSmkyaHBUZWQ1OHM&usp=sharing [^]
(0067892)
hudsonbot   
2014-06-10 22:24   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/763f16c2ad2e [^]
Maturity status: Test