details: https://code.openbravo.com/erp/devel/pi/rev/d06684d8f8db
changeset: 14955:d06684d8f8db
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Fri Dec 23 08:25:29 2011 +0100
summary: Fixes issue 19354: Problems in SL_Order_Amt callout
diffstat:
src/org/openbravo/erpCommon/ad_callouts/SL_Order_Stock_data.xsql | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diffs (21 lines):
diff -r 57cc2b93df7a -r d06684d8f8db
src/org/openbravo/erpCommon/ad_callouts/SL_Order_Stock_data.xsql
--- a/src/org/openbravo/erpCommon/ad_callouts/SL_Order_Stock_data.xsql Thu Dec
22 11:46:30 2011 +0100
+++ b/src/org/openbravo/erpCommon/ad_callouts/SL_Order_Stock_data.xsql Fri Dec
23 08:25:29 2011 +0100
@@ -35,7 +35,7 @@
<SqlMethod name="totalStockNoAttribute" type="preparedStatement"
return="string" default="0">
<SqlMethodComment></SqlMethodComment>
<Sql>
- SELECT SUM (QTYONHAND) AS QTY FROM M_STORAGE_DETAIL
+ SELECT COALESCE(SUM (QTYONHAND),0) AS QTY FROM M_STORAGE_DETAIL
WHERE M_PRODUCT_ID = ?
AND C_UOM_ID = ?
</Sql>
@@ -45,7 +45,7 @@
<SqlMethod name="totalStockAttribute" type="preparedStatement"
return="string" default="0">
<SqlMethodComment></SqlMethodComment>
<Sql>
- SELECT SUM (QTYONHAND) AS QTY FROM M_STORAGE_DETAIL
+ SELECT COALESCE(SUM (QTYONHAND),0) AS QTY FROM M_STORAGE_DETAIL
WHERE M_PRODUCT_ID = ?
AND C_UOM_ID = ?
AND M_ATTRIBUTESETINSTANCE_ID = ?
------------------------------------------------------------------------------
Write once. Port to many.
Get the SDK and tools to simplify cross-platform app development. Create
new or port existing apps to sell to consumers worldwide. Explore the
Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join
http://p.sf.net/sfu/intel-appdev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
