[OpenbravoERP-commits] devel/pi: Fixes issue 0024659: The Update Qty process does not w...

[hg]

details:   https://code.openbravo.com/erp/devel/pi/rev/b2884133c259
changeset: 21056:b2884133c259
user:      Jon Alegría <jon.alegria <at> openbravo.com>
date:      Mon Sep 02 13:23:55 2013 +0200
summary:   Fixes issue 0024659: The Update Qty process does not work properly 
under some circunstancies

diffstat:

 src-db/database/model/functions/M_INVENTORY_LISTUPDATE.xml |  26 +------------
 1 files changed, 3 insertions(+), 23 deletions(-)

diffs (50 lines):

diff -r 6e5c3a83e2b5 -r b2884133c259 
src-db/database/model/functions/M_INVENTORY_LISTUPDATE.xml
--- a/src-db/database/model/functions/M_INVENTORY_LISTUPDATE.xml        Mon Sep 
02 10:57:15 2013 +0200
+++ b/src-db/database/model/functions/M_INVENTORY_LISTUPDATE.xml        Mon Sep 
02 13:23:55 2013 +0200
@@ -106,27 +106,7 @@
       FROM M_Storage_Detail s
       WHERE s.M_Product_ID=M_InventoryLine.M_Product_ID
         AND s.M_Locator_ID=M_InventoryLine.M_Locator_ID
-        AND COALESCE(s.M_ATTRIBUTESETINSTANCE_ID, 
'-1')=COALESCE(M_InventoryLine.M_ATTRIBUTESETINSTANCE_ID, '-1')
-        AND s.C_UOM_ID=M_InventoryLine.C_UOM_ID
-        AND COALESCE(s.M_Product_UOM_ID, 
'-1')=COALESCE(M_InventoryLine.M_Product_UOM_ID, '-1')
-      )
-      ,
-      QtyCount=
-      (SELECT QtyOnHand
-      FROM M_Storage_Detail s
-      WHERE s.M_Product_ID=M_InventoryLine.M_Product_ID
-        AND s.M_Locator_ID=M_InventoryLine.M_Locator_ID
-        AND COALESCE(s.M_ATTRIBUTESETINSTANCE_ID, 
'-1')=COALESCE(M_InventoryLine.M_ATTRIBUTESETINSTANCE_ID, '-1')
-        AND s.C_UOM_ID=M_InventoryLine.C_UOM_ID
-        AND COALESCE(s.M_Product_UOM_ID, 
'-1')=COALESCE(M_InventoryLine.M_Product_UOM_ID, '-1')
-      )
-      ,
-      QuantityOrder=
-      (SELECT QtyOrderOnHand
-      FROM M_Storage_Detail s
-      WHERE s.M_Product_ID=M_InventoryLine.M_Product_ID
-        AND s.M_Locator_ID=M_InventoryLine.M_Locator_ID
-        AND COALESCE(s.M_ATTRIBUTESETINSTANCE_ID, 
'-1')=COALESCE(M_InventoryLine.M_ATTRIBUTESETINSTANCE_ID, '-1')
+        AND COALESCE(s.M_ATTRIBUTESETINSTANCE_ID, 
'0')=COALESCE(M_InventoryLine.M_ATTRIBUTESETINSTANCE_ID, '0')
         AND s.C_UOM_ID=M_InventoryLine.C_UOM_ID
         AND COALESCE(s.M_Product_UOM_ID, 
'-1')=COALESCE(M_InventoryLine.M_Product_UOM_ID, '-1')
       )
@@ -136,7 +116,7 @@
       FROM M_Storage_Detail s
       WHERE s.M_Product_ID=M_InventoryLine.M_Product_ID
         AND s.M_Locator_ID=M_InventoryLine.M_Locator_ID
-        AND COALESCE(s.M_ATTRIBUTESETINSTANCE_ID, 
'-1')=COALESCE(M_InventoryLine.M_ATTRIBUTESETINSTANCE_ID, '-1')
+        AND COALESCE(s.M_ATTRIBUTESETINSTANCE_ID, 
'0')=COALESCE(M_InventoryLine.M_ATTRIBUTESETINSTANCE_ID, '0')
         AND s.C_UOM_ID=M_InventoryLine.C_UOM_ID
         AND COALESCE(s.M_Product_UOM_ID, 
'-1')=COALESCE(M_InventoryLine.M_Product_UOM_ID, '-1')
       )
@@ -149,7 +129,7 @@
       FROM M_Storage_Detail s
       WHERE s.M_Product_ID=M_InventoryLine.M_Product_ID
         AND s.M_Locator_ID=M_InventoryLine.M_Locator_ID
-        AND COALESCE(s.M_ATTRIBUTESETINSTANCE_ID, 
'-1')=COALESCE(M_InventoryLine.M_ATTRIBUTESETINSTANCE_ID, '-1')
+        AND COALESCE(s.M_ATTRIBUTESETINSTANCE_ID, 
'0')=COALESCE(M_InventoryLine.M_ATTRIBUTESETINSTANCE_ID, '0')
         AND s.C_UOM_ID=M_InventoryLine.C_UOM_ID
         AND COALESCE(s.M_Product_UOM_ID, 
'-1')=COALESCE(M_InventoryLine.M_Product_UOM_ID, '-1')
       )

------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits