Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0034099Openbravo ERP04. Warehouse managementpublic2016-09-27 13:552016-12-29 15:56
Reporterngarcia 
Assigned ToAtulOpenbravo 
PriorityhighSeverityminorReproducibilityalways
StatusscheduledResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket43068
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0034099: Different precision in database than in UI for Unit Cost field of Product - Unit Cost tab
DescriptionDifferent precision in database than in UI for Unit Cost field of Product - Unit Cost tab
Steps To ReproduceCheck the generalQty format is configured to show 6 decimals and euroInform is configured to show 2 in Format.xml file
As system admin role:
   Set Cost Precision of the currency to 6
As group admin role:
   Set the following preference as Y:
      Allow to persist Unit Cost
   Create a new product
   Create a physical inventory and add the previously created product:
      Quantity count: 5
      Cost: 0.125
   Launch the Costing Background Process
   Check the Unit Cost is shown as 0.13 in Product - Unit Cost tab
   Check through database the unit_price column of the m_stock_valuation table is 0.125
Proposed SolutionCheck if unit_price should be rounded to two or if its reference should be Number (Product - Costing - Cost) instead of Amount (Product - Transactions - Transaction Cost)
Additional Information
TagsNo tags attached.
Relationships
related to defect 0034056 closed markmm82 Wrong stock in Unit Cost tab of Product window 
related to defect 0034055 closed markmm82 Wrong cost adjustment is made when stock reaches 0 but stock valuation is not 0 due to rounding issues 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-09-27 13:55ngarciaNew Issue
2016-09-27 13:55ngarciaAssigned To => Triage Finance
2016-09-27 13:55ngarciaOBNetwork customer => Yes
2016-09-27 13:55ngarciaModules => Core
2016-09-27 13:55ngarciaSupport ticket => 43068
2016-09-27 13:55ngarciaTriggers an Emergency Pack => No
2016-09-27 13:56ngarciaIssue Monitored: networkb
2016-09-27 13:57ngarciaProposed Solution updated
2016-09-27 13:57ngarciaRelationship addedrelated to 0034056
2016-09-27 17:55eugeniIssue Monitored: eugeni
2016-10-10 18:55aferrazRelationship addedrelated to 0034055
2016-10-25 09:55psanjuanNote Added: 0090848
2016-12-27 19:08markmm82Assigned ToTriage Finance => AtulOpenbravo
2016-12-29 10:22AtulOpenbravoStatusnew => scheduled
2016-12-29 15:52AtulOpenbravoSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=14133#r14133
2016-12-29 15:56AtulOpenbravoNote Added: 0093058
2016-12-29 15:56AtulOpenbravoSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=14134#r14134

Notes
(0090848)
psanjuan   
2016-10-25 09:55   
Issue verified.
(0093058)
AtulOpenbravo   
2016-12-29 15:56   
Test Plan
- Check the generalQty format is configured to show 6 decimals and euroInform is configured to show 2 in Format.xml file
- Login as System Admin role:
   Set Cost Precision of the currency EUR and USD to 6 instead of 2.
- Login as F&B International Group Admin role:
   Set the following preference as Y:
      Allow to persist Unit Cost
- Create a new product "Product A" in F&B US Inc organization.
- Create a physical inventory and add line as below:
      Product: Product A
      Quantity Count= 5
      Cost= 0.125
      Storage Bin= EC-0-0-0
      Process Inventory document.
- Launch the Costing Background Process
- Check the Unit Cost is shown as 0.125 in Product - Unit Cost tab
- Check through database, the unit_price column of the m_stock_valuation table is 0.125