Fixes Issue 25462: Products movement report is not filtering correcly by lot
authorAtul Gaware <atul.gaware@openbravo.com>
Mon, 10 Feb 2014 18:40:25 +0530
changeset 22009 b6dad5dc6d68
parent 22008 2b4515770947
child 22010 303f6522150c
child 22094 dddf8acd15d0
Fixes Issue 25462: Products movement report is not filtering correcly by lot
src/org/openbravo/erpCommon/ad_reports/ReportProductMovement.java
src/org/openbravo/erpCommon/ad_reports/ReportProductMovement_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportProductMovement.java	Thu Feb 06 12:47:30 2014 +0530
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportProductMovement.java	Mon Feb 10 18:40:25 2014 +0530
@@ -11,7 +11,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) 2001-2012 Openbravo SLU 
+ * All portions are Copyright (C) 2001-2014 Openbravo SLU 
  * All Rights Reserved.
  * Contributor(s):  ______________________________________.
  ************************************************************************
@@ -175,7 +175,7 @@
             Utility.getContext(this, vars, "#User_Client", "ReportProductMovement"),
             Utility.getContext(this, vars, "#AccessibleOrgTree", "ReportProductMovement"),
             strDateFrom, DateTimeData.nDaysAfter(this, strDateTo, "1"), strcBpartnerId,
-            strmProductId);
+            strmProductId, strmAttributesetinstanceId);
         if (data1 == null || data1.length == 0) {
           discard[1] = "selEliminar2";
           data1 = ReportProductMovementData.set();
--- a/src/org/openbravo/erpCommon/ad_reports/ReportProductMovement_data.xsql	Thu Feb 06 12:47:30 2014 +0530
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportProductMovement_data.xsql	Mon Feb 10 18:40:25 2014 +0530
@@ -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) 2001-2012 Openbravo SLU 
+ * All portions are Copyright (C) 2001-2014 Openbravo SLU 
  * All Rights Reserved. 
  * Contributor(s):  ______________________________________.
  ************************************************************************
@@ -104,6 +104,7 @@
     <Parameter name="parDateTo" optional="true" after="AND 1=1"><![CDATA[ AND M_TRANSACTION.MOVEMENTDATE < to_date(?)]]></Parameter>
     <Parameter name="cBpartner" optional="true" after="AND 1=1"><![CDATA[ AND C_BPARTNER.C_BPARTNER_ID = ?]]></Parameter>
     <Parameter name="mProductId" optional="true" after="AND 1=1"><![CDATA[ AND M_PRODUCT.M_PRODUCT_ID = ?]]></Parameter>
+    <Parameter name="mAttributeSetInstanceId" optional="true" after="AND 1=1"><![CDATA[AND M_TRANSACTION.M_ATTRIBUTESETINSTANCE_ID = ?]]></Parameter>
   </SqlMethod>
 
   <SqlMethod name="selectMovement" type="preparedStatement" return="multiple">