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