[OpenbravoERP-commits] devel/pi: Fixes issue 0024620: Sales quotation is modifying qty

[hg]

details:   https://code.openbravo.com/erp/devel/pi/rev/9f1d2c0629be
changeset: 21226:9f1d2c0629be
user:      Jon Alegría <jon.alegria <at> openbravo.com>
date:      Tue Oct 01 18:55:13 2013 +0200
summary:   Fixes issue 0024620: Sales quotation is modifying qty
reserved in m_storage_pending table and it shouldn't

diffstat:

 src-db/database/model/functions/C_ORDER_POST1.xml |  4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diffs (21 lines):

diff -r 2bd8dc474ca4 -r 9f1d2c0629be 
src-db/database/model/functions/C_ORDER_POST1.xml
--- a/src-db/database/model/functions/C_ORDER_POST1.xml Tue Oct 01 17:03:37 
2013 +0200
+++ b/src-db/database/model/functions/C_ORDER_POST1.xml Tue Oct 01 18:55:13 
2013 +0200
@@ -462,7 +462,7 @@
               v_QtyPO:=0;
               v_QtyOrderPO:=NULL;
             END IF;
-            IF ((v_DocStatus<>'IP' OR v_DocAction<>'CO') AND 
v_DocSubTypeSO<>'OB') THEN
+            IF ((v_DocStatus<>'IP' OR v_DocAction<>'CO') AND 
COALESCE(v_DocSubTypeSO, '')<>'OB') THEN
               M_UPDATE_STORAGE_PENDING(v_Client_ID, v_Org_ID, v_UpdatedBy, 
Cur_ResLine.M_Product_ID, Cur_ResLine.M_Warehouse_ID, 
Cur_ResLine.M_AttributeSetInstance_ID, Cur_ResLine.C_UOM_ID, 
Cur_ResLine.M_PRODUCT_UOM_ID, v_QtySO, v_QtyOrderSO, v_QtyPO, v_QtyOrderPO) ;
             END IF;
           END LOOP;
@@ -1060,7 +1060,7 @@
                 v_QtyOrderPO := C_Uom_Convert(v_QtyPO, Cur_ResLine.C_UOM_ID, 
Cur_ResLine.M_Product_UOM_ID, 'Y');
               END IF;
             END IF;
-            IF ((v_DocStatus<>'IP' OR v_DocAction<>'CO') AND 
v_DocSubTypeSO<>'OB') THEN
+            IF ((v_DocStatus<>'IP' OR v_DocAction<>'CO') AND 
COALESCE(v_DocSubTypeSO, '')<>'OB') THEN
               M_UPDATE_STORAGE_PENDING(v_Client_ID, v_Org_ID, v_UpdatedBy, 
Cur_ResLine.M_Product_ID, Cur_ResLine.M_Warehouse_ID, 
Cur_ResLine.M_AttributeSetInstance_ID,
               Cur_ResLine.C_UOM_ID, Cur_ResLine.M_PRODUCT_UOM_ID, v_QtySO, 
v_QtyOrderSO, v_QtyPO, v_QtyOrderPO);
             END IF;

------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits