details:   https://code.openbravo.com/erp/devel/pi/rev/1ab098a07115
changeset: 29269:1ab098a07115
user:      Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
date:      Fri Apr 22 09:38:01 2016 +0200
summary:   Related to issue 32281: Wrong picking list quantity when no stock 
available

Send p_reservation_id as null when calling M_GET_STOCK_PARAM from 
M_RESERVE_STOCK_AUTO in order to check reserved quantity from any reservation.

diffstat:

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

diffs (12 lines):

diff -r c8a6c060de10 -r 1ab098a07115 
src-db/database/model/functions/M_RESERVE_STOCK_AUTO.xml
--- a/src-db/database/model/functions/M_RESERVE_STOCK_AUTO.xml  Fri Apr 22 
07:55:38 2016 +0200
+++ b/src-db/database/model/functions/M_RESERVE_STOCK_AUTO.xml  Fri Apr 22 
09:38:01 2016 +0200
@@ -77,7 +77,7 @@
       WHERE c_orderline_id = v_soline_id;
     END IF;
 
-    M_GET_STOCK_PARAM(v_pinstance_id, p_reservation_id, v_pendingtoreserveqty, 
v_product_id, v_locator_id, v_warehouse_id, v_prioritywarehouse_id, v_org_id, 
v_asi_id, p_User_ID, v_client_id, v_warehouse_rule_id, v_uom_id, null, null, 
null, null, '---', p_reservation_id, 'N', v_pinstance_result, v_pinstance_msg);
+    M_GET_STOCK_PARAM(v_pinstance_id, p_reservation_id, v_pendingtoreserveqty, 
v_product_id, v_locator_id, v_warehouse_id, v_prioritywarehouse_id, v_org_id, 
v_asi_id, p_User_ID, v_client_id, v_warehouse_rule_id, v_uom_id, null, null, 
null, null, '---', null, 'N', v_pinstance_result, v_pinstance_msg);
     -- Check result
     IF (v_pinstance_result = 0) THEN
       -- Error on m_get_stock

------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to