Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0028948 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 04. Warehouse management | major | always | 2015-02-16 10:36 | 2015-03-03 16:09 | |||
Reporter | VictorVillar | View Status | public | |||||
Assigned To | reinaldoguerra | |||||||
Priority | urgent | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | e6a5485a8001 | ||||
Projection | none | ETA | none | Target Version | 3.0PR15Q2 | |||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | pi | SCM revision | ||||||
Review Assigned To | aferraz | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0028948: Orders Awaiting Delivery report is not calculating correctly the Quantity in Stock | |||||||
Description | Orders Awaiting Delivery report is not calculating correctly the Quantity in Stock when the product has instance attributes | |||||||
Steps To Reproduce | As 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) | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0074911) reinaldoguerra (developer) 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 (developer) 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 (manager) 2015-03-02 13:31 |
Code review + Testing OK |
(0075121) hudsonbot (developer) 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 |
Issue History | |||
Date Modified | Username | Field | Change |
2015-02-16 10:36 | VictorVillar | New Issue | |
2015-02-16 10:36 | VictorVillar | Assigned To | => Sandrahuguet |
2015-02-16 10:36 | VictorVillar | Modules | => Core |
2015-02-16 10:36 | VictorVillar | Resolution time | => 1425250800 |
2015-02-16 10:36 | VictorVillar | Triggers an Emergency Pack | => No |
2015-02-16 11:05 | VictorVillar | Proposed Solution updated | |
2015-02-24 15:17 | reinaldoguerra | Assigned To | Sandrahuguet => reinaldoguerra |
2015-02-24 15:17 | reinaldoguerra | Status | new => scheduled |
2015-02-25 14:11 | reinaldoguerra | Note Added: 0074911 | |
2015-03-02 13:31 | hgbot | Checkin | |
2015-03-02 13:31 | hgbot | Note Added: 0075081 | |
2015-03-02 13:31 | hgbot | Status | scheduled => resolved |
2015-03-02 13:31 | hgbot | Resolution | open => fixed |
2015-03-02 13:31 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/e6a5485a8001f8d165440a2c83495a58221ac505 [^] |
2015-03-02 13:31 | aferraz | Review Assigned To | => aferraz |
2015-03-02 13:31 | aferraz | Note Added: 0075084 | |
2015-03-02 13:31 | aferraz | Status | resolved => closed |
2015-03-03 16:09 | hudsonbot | Checkin | |
2015-03-03 16:09 | hudsonbot | Note Added: 0075121 |
Copyright © 2000 - 2009 MantisBT Group |