details:   https://code.openbravo.com/erp/devel/pi/rev/8ffe44c21d8d
changeset: 20708:8ffe44c21d8d
user:      Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> 
openbravo.com>
date:      Thu Jul 04 17:38:00 2013 +0530
summary:   Fixes Issue 24270: Error is not raised when processing 2 identical 
inventory lines

diffstat:

 src/org/openbravo/materialmgmt/InventoryCountProcess.java |  4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diffs (14 lines):

diff -r a5b3324cad3b -r 8ffe44c21d8d 
src/org/openbravo/materialmgmt/InventoryCountProcess.java
--- a/src/org/openbravo/materialmgmt/InventoryCountProcess.java Thu Jul 04 
21:17:03 2013 +0200
+++ b/src/org/openbravo/materialmgmt/InventoryCountProcess.java Thu Jul 04 
17:38:00 2013 +0530
@@ -248,8 +248,8 @@
         + InventoryCountLine.PROPERTY_PRODUCT);
     where.append("         and coalesce(icl." + 
InventoryCountLine.PROPERTY_ATTRIBUTESETVALUE
         + ", '0') = coalesce(icl2." + 
InventoryCountLine.PROPERTY_ATTRIBUTESETVALUE + ", '0')");
-    where.append("         and icl." + InventoryCountLine.PROPERTY_ORDERUOM + 
" = icl2."
-        + InventoryCountLine.PROPERTY_ORDERUOM);
+    where.append("         and coalesce(icl." + 
InventoryCountLine.PROPERTY_ORDERUOM
+        + ", '0') = coalesce(icl2." + InventoryCountLine.PROPERTY_ORDERUOM + 
", '0')");
     where.append("         and icl." + InventoryCountLine.PROPERTY_STORAGEBIN 
+ " = icl2."
         + InventoryCountLine.PROPERTY_STORAGEBIN);
     where.append("         and icl." + InventoryCountLine.PROPERTY_LINENO + " 
<> icl2."

------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to