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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0028948
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2015-02-16 10:362015-03-03 16:09
ReporterVictorVillarView Statuspublic 
Assigned Toreinaldoguerra 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisione6a5485a8001
ProjectionnoneETAnoneTarget Version3.0PR15Q2
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned Toaferraz
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0028948: 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)
TagsNo 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
Powered by Mantis Bugtracker