Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0028948Openbravo ERP04. Warehouse managementpublic2015-02-16 10:362015-03-03 16:09
ReporterVictorVillar 
Assigned Toreinaldoguerra 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0PR15Q2Fixed in Version 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket33899
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0028948: Orders Awaiting Delivery report is not calculating correctly the Quantity in Stock
DescriptionOrders Awaiting Delivery report is not calculating correctly the Quantity in Stock when the product has instance attributes
Steps To ReproduceAs group Admin role,
 Go to Sales order window,
    create a new one for Product: Zumo de Naranja Bio 0,33L
    movemendate: Today
Complete it.

Go to Orders Awaiting Delivery Report:
   From date: today
   To Date: Today

Realise that the quantity in Stock is blank.
Proposed Solution-- AND COALESCE(OL.M_ATTRIBUTESETINSTANCE_ID,'0') =
++ COALESCE(SD.M_ATTRIBUTESETINSTANCE_ID,'0')
AND (CASE WHEN OL.M_ATTRIBUTESETINSTANCE_ID IS NOT NULL THEN OL.M_ATTRIBUTESETINSTANCE_ID =
SD.M_ATTRIBUTESETINSTANCE_ID ELSE 1=1 END)
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-02-16 10:36VictorVillarNew Issue
2015-02-16 10:36VictorVillarAssigned To => Sandrahuguet
2015-02-16 10:36VictorVillarOBNetwork customer => Yes
2015-02-16 10:36VictorVillarModules => Core
2015-02-16 10:36VictorVillarSupport ticket => 33899
2015-02-16 10:36VictorVillarResolution time => 1425250800
2015-02-16 10:36VictorVillarTriggers an Emergency Pack => No
2015-02-16 11:05VictorVillarProposed Solution updated
2015-02-24 15:17reinaldoguerraAssigned ToSandrahuguet => reinaldoguerra
2015-02-24 15:17reinaldoguerraStatusnew => scheduled
2015-02-25 14:11reinaldoguerraNote Added: 0074911
2015-03-02 13:31hgbotCheckin
2015-03-02 13:31hgbotNote Added: 0075081
2015-03-02 13:31hgbotStatusscheduled => resolved
2015-03-02 13:31hgbotResolutionopen => fixed
2015-03-02 13:31hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e6a5485a8001f8d165440a2c83495a58221ac505 [^]
2015-03-02 13:31aferrazReview Assigned To => aferraz
2015-03-02 13:31aferrazNote Added: 0075084
2015-03-02 13:31aferrazStatusresolved => closed
2015-03-03 16:09hudsonbotCheckin
2015-03-03 16:09hudsonbotNote Added: 0075121

Notes
(0074911)
reinaldoguerra   
2015-02-25 14:11   
Test plan used:
1- Login into Openbravo ERP
2- Go to Sales order window,
    create a new one for Product: Zumo de Naranja Bio 0,33L (this product has an attribute set defined)
    movemendate: Today
3- Book it.
4- Go to Orders Awaiting Delivery Report:
   From date: today
   To Date: Today
5- Realize that the quantity in Stock is now correctly shown.
(0075081)
hgbot   
2015-03-02 13:31   
Repository: erp/devel/pi
Changeset: e6a5485a8001f8d165440a2c83495a58221ac505
Author: Reinaldo Guerra <reinaldo.guerra <at> peoplewalking.com>
Date: Tue Feb 24 12:33:15 2015 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/e6a5485a8001f8d165440a2c83495a58221ac505 [^]

Fixed bug 28948: Orders Awaiting Delivery report do not show well the Stock Qtty

Orders Awaiting Delivery report's query, was not obtaining correctly the Quantity in Stock, due to a wrong comparison with the value of the attribute set of products in order's line, when it is seted as null.
To avoid this, the report's sql query was changed to compare the attribute set values of the storage detail between them, if the order's lines product has not an attribute set value defined. In other case, are compared the attribute set values of the order's line and the storage detail.
Now the product's stock quantity is correctly shown.

---
M modules/org.openbravo.reports.ordersawaitingdelivery/src/org/openbravo/reports/ordersawaitingdelivery/erpCommon/ad_reports/ReportOrderNotShipped_data.xsql
---
(0075084)
aferraz   
2015-03-02 13:31   
Code review + Testing OK
(0075121)
hudsonbot   
2015-03-03 16:09   
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/f4fc528722d4 [^]
Maturity status: Test