Fixes issue 0016168: Error in the Stock Report when you move a Storage Bin
authorEgoitz Castillo <egoitz.castillo@openbravo.com>
Tue, 08 Mar 2011 12:51:09 +0100
changeset 11085 475327b2ce2d
parent 11084 25740f5d26f9
child 11086 e713c25dd054
Fixes issue 0016168: Error in the Stock Report when you move a Storage Bin
Added having clause not to show the quantities 0
src/org/openbravo/erpCommon/ad_reports/ReportWarehousePartner_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportWarehousePartner_data.xsql	Tue Mar 08 12:48:37 2011 +0100
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportWarehousePartner_data.xsql	Tue Mar 08 12:51:09 2011 +0100
@@ -45,6 +45,7 @@
       AND M_TRANSACTION.AD_ORG_ID IN ('1')
       AND 1=1
       GROUP BY M_PRODUCT_CATEGORY.NAME,M_PRODUCT.VALUE, M_PRODUCT.NAME, M_ATTRIBUTESETINSTANCE.M_ATTRIBUTESETINSTANCE_ID, M_ATTRIBUTESETINSTANCE.DESCRIPTION, M_LOCATOR.M_LOCATOR_ID, M_LOCATOR.X, M_LOCATOR.Y, M_LOCATOR.Z, C1.NAME, M_PRODUCT.WEIGHT, C1.C_UOM_ID, M_TRANSACTION.M_PRODUCT_UOM_ID, C2.NAME, M_LOCATOR.M_WAREHOUSE_ID
+      HAVING SUM(MOVEMENTQTY) <> 0
       ORDER BY  M_PRODUCT_CATEGORY.NAME,M_PRODUCT.VALUE, M_PRODUCT.NAME, M_ATTRIBUTESETINSTANCE.DESCRIPTION,M_LOCATOR.X, M_LOCATOR.Y, M_LOCATOR.Z
      ]]></Sql>
     <Parameter name="language"/>