details: https://code.openbravo.com/erp/devel/pi/rev/e6a5485a8001
changeset: 26103:e6a5485a8001
user: Reinaldo Guerra <reinaldo.guerra <at> peoplewalking.com>
date: Tue Feb 24 12:33:15 2015 -0500
summary: 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.
diffstat:
modules/org.openbravo.reports.ordersawaitingdelivery/src/org/openbravo/reports/ordersawaitingdelivery/erpCommon/ad_reports/ReportOrderNotShipped_data.xsql
| 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diffs (21 lines):
diff -r 03b252d94692 -r e6a5485a8001
modules/org.openbravo.reports.ordersawaitingdelivery/src/org/openbravo/reports/ordersawaitingdelivery/erpCommon/ad_reports/ReportOrderNotShipped_data.xsql
---
a/modules/org.openbravo.reports.ordersawaitingdelivery/src/org/openbravo/reports/ordersawaitingdelivery/erpCommon/ad_reports/ReportOrderNotShipped_data.xsql
Mon Mar 02 12:22:20 2015 +0100
+++
b/modules/org.openbravo.reports.ordersawaitingdelivery/src/org/openbravo/reports/ordersawaitingdelivery/erpCommon/ad_reports/ReportOrderNotShipped_data.xsql
Tue Feb 24 12:33:15 2015 -0500
@@ -12,7 +12,7 @@
* under the License.
* The Original Code is Openbravo ERP.
* The Initial Developer of the Original Code is Openbravo SLU
- * All portions are Copyright (C) 2009-2011 Openbravo SLU
+ * All portions are Copyright (C) 2009-2015 Openbravo SLU
* All Rights Reserved.
* Contributor(s): ______________________________________.
************************************************************************
@@ -43,7 +43,7 @@
LEFT JOIN M_STORAGE_DETAIL SD
ON OL.M_PRODUCT_ID = SD.M_PRODUCT_ID
AND OL.C_UOM_ID = SD.C_UOM_ID
- AND COALESCE(OL.M_ATTRIBUTESETINSTANCE_ID,'0') =
COALESCE(SD.M_ATTRIBUTESETINSTANCE_ID,'0')
+ AND COALESCE(OL.M_ATTRIBUTESETINSTANCE_ID, SD.M_ATTRIBUTESETINSTANCE_ID,
'0') = COALESCE(SD.M_ATTRIBUTESETINSTANCE_ID, '0')
AND COALESCE(OL.M_PRODUCT_UOM_ID, '-1') =
COALESCE(SD.M_PRODUCT_UOM_ID,'-1')
AND SD.M_LOCATOR_ID IN (SELECT LOC.M_LOCATOR_ID
FROM M_LOCATOR LOC
------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
