Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031456Openbravo ERP04. Warehouse managementpublic2015-11-12 18:402015-11-23 21:17
ReporterVictorVillar 
Assigned ToTriage Omni WMS 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0PR16Q1Fixed in Version 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket37884
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0031456: Wrong second uom quantiy in partial invoices
DescriptionWrong second uom quantiy in partial invoices
Steps To ReproduceIt is necessary to show the fields/tabs related with second uom. (conversion tab in UOM window, Uom tab in product window, orders, shipments/receipts, invoices)
As System role,
  Go to Unit of measure
      select Unit and change the standard precision to 2.

As group Admin role,
  Create a new conversion for Kilogram. Second unit of measure: Unit
 Multiply rate by: 3.6

Go to Product window,
  name: second UOM
  UOM: Unit
UOM tab: Kilogram

Go to Goods Shipment.
  Create a new one for SecondUOM product.
    order qty: 10
    movement qty: 36
Complete it

Go to Sales invoices
  Create a new one.
  Use create lines from the previous shipment and change the Order quantity to 5.
Complete it.

  Create a new one
   Use create lines from the previous shipment. Realise that the pending qty is 18, which is OK, but the Order quantity is 10 and this is wrong it should be 5.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-11-12 18:40VictorVillarNew Issue
2015-11-12 18:40VictorVillarAssigned To => Triage Finance
2015-11-12 18:40VictorVillarOBNetwork customer => Yes
2015-11-12 18:40VictorVillarModules => Core
2015-11-12 18:40VictorVillarSupport ticket => 37884
2015-11-12 18:40VictorVillarResolution time => 1449874800
2015-11-12 18:40VictorVillarTriggers an Emergency Pack => No
2015-11-12 18:40VictorVillarIssue Monitored: networkb
2015-11-23 11:42hgbotCheckin
2015-11-23 11:42hgbotNote Added: 0082064
2015-11-23 11:42hgbotStatusnew => resolved
2015-11-23 11:42hgbotResolutionopen => fixed
2015-11-23 11:42hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/afe94278340093cf287804d3007cf00aaab278e9 [^]
2015-11-23 11:42dmiguelezReview Assigned To => dmiguelez
2015-11-23 11:42dmiguelezNote Added: 0082065
2015-11-23 11:42dmiguelezStatusresolved => closed
2015-11-23 21:17hudsonbotCheckin
2015-11-23 21:17hudsonbotNote Added: 0082265

Notes
(0082064)
hgbot   
2015-11-23 11:42   
Repository: erp/devel/pi
Changeset: afe94278340093cf287804d3007cf00aaab278e9
Author: Mark <markmm82 <at> gmail.com>
Date: Fri Nov 20 09:09:18 2015 +0000
URL: http://code.openbravo.com/erp/devel/pi/rev/afe94278340093cf287804d3007cf00aaab278e9 [^]

Fixes issue 31456: Wrong quantityOrder calculation when exist more than one line inside a sales invoice.

Inside the SQL query was returned the original quantity order (with was created the Shipment Invoice), but the value must be decreased from the total quantity of existing lines.
Wright now the returned value is obtained like this:
(l.quantityOrder - sum(COALESCE(CASE WHEN i.docstatus = 'CO' THEN il.quantityorder ELSE 0 END, 0))) AS quantityOrder,

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
---
(0082065)
dmiguelez   
2015-11-23 11:42   
Code Review + Testing Ok
(0082265)
hudsonbot   
2015-11-23 21:17   
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/7b56bebaaa88 [^]
Maturity status: Test