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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0031456
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2015-11-12 18:402015-11-23 21:17
ReporterVictorVillarView Statuspublic 
Assigned ToTriage Omni WMS 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionafe942783400
ProjectionnoneETAnoneTarget Version3.0PR16Q1
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned Todmiguelez
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0031456: 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0082064)
hgbot (developer)
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 (developer)
2015-11-23 11:42

Code Review + Testing Ok
(0082265)
hudsonbot (developer)
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

- Issue History
Date Modified Username Field Change
2015-11-12 18:40 VictorVillar New Issue
2015-11-12 18:40 VictorVillar Assigned To => Triage Finance
2015-11-12 18:40 VictorVillar Modules => Core
2015-11-12 18:40 VictorVillar Resolution time => 1449874800
2015-11-12 18:40 VictorVillar Triggers an Emergency Pack => No
2015-11-12 18:40 VictorVillar Issue Monitored: networkb
2015-11-23 11:42 hgbot Checkin
2015-11-23 11:42 hgbot Note Added: 0082064
2015-11-23 11:42 hgbot Status new => resolved
2015-11-23 11:42 hgbot Resolution open => fixed
2015-11-23 11:42 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/afe94278340093cf287804d3007cf00aaab278e9 [^]
2015-11-23 11:42 dmiguelez Review Assigned To => dmiguelez
2015-11-23 11:42 dmiguelez Note Added: 0082065
2015-11-23 11:42 dmiguelez Status resolved => closed
2015-11-23 21:17 hudsonbot Checkin
2015-11-23 21:17 hudsonbot Note Added: 0082265


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker