details: https://code.openbravo.com/erp/devel/pi/rev/4e55d4ef021a
changeset: 24290:4e55d4ef021a
user: Atul Gaware <atul.gaware <at> openbravo.com>
date: Thu Aug 21 11:35:54 2014 +0530
summary: Fixes Issue 27381:Void Goods Receipt fails in oracle instance
diffstat:
src-db/database/model/functions/M_INOUT_POST.xml | 6 ++++++
1 files changed, 6 insertions(+), 0 deletions(-)
diffs (23 lines):
diff -r 12574ebf963a -r 4e55d4ef021a
src-db/database/model/functions/M_INOUT_POST.xml
--- a/src-db/database/model/functions/M_INOUT_POST.xml Thu Aug 21 12:14:32
2014 +0200
+++ b/src-db/database/model/functions/M_INOUT_POST.xml Thu Aug 21 11:35:54
2014 +0530
@@ -600,6 +600,7 @@
ELSIF (cur_inout.issotrx = 'N' AND
cur_inoutline.canceled_inoutline_id IS NOT NULL AND v_qty < 0) THEN
-- Revert to pre-reservations
+ BEGIN
select sum(iol.movementqty)
into v_qtysumorders
from m_inoutline iol
@@ -612,6 +613,11 @@
where c_orderline_id=cur_inoutline.c_orderline_id
and rs.m_locator_id=cur_inoutline.m_locator_id;
+ EXCEPTION
+ WHEN NO_DATA_FOUND THEN
+ v_qtysumorders:=0;
+ v_released:=0;
+ END;
v_penqty := -v_qty -
((v_qtysumorders+(-cur_inoutline.movementqty))-v_released);
DECLARE
------------------------------------------------------------------------------
Slashdot TV.
Video for Nerds. Stuff that matters.
http://tv.slashdot.org/
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
