From ff5c2756e482a1b96e875bcd00502f93349611ec Mon Sep 17 00:00:00 2001 From: garyhgohoos Date: Tue, 16 Sep 2014 15:59:10 -0400 Subject: [PATCH] Issue #24584:create supply order with correct order number --- foundation-database/public/functions/convertquote.sql | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) diff --git a/foundation-database/public/functions/convertquote.sql b/foundation-database/public/functions/convertquote.sql index e26484e9c..c9d775989 100644 --- a/foundation-database/public/functions/convertquote.sql +++ b/foundation-database/public/functions/convertquote.sql @@ -252,8 +252,10 @@ BEGIN IF (_r.quitem_createorder) THEN IF (_r.item_type IN ('M')) THEN - SELECT createWo( CAST(_r.quhead_number AS INTEGER), supply.itemsite_id, 1, (_r.quitem_qtyord * _r.quitem_qty_invuomratio), - _r.itemsite_leadtime, _r.quitem_scheddate, _r.quitem_memo, 'S', _soitemid, _r.quhead_prj_id ) INTO _orderId + SELECT createWo( CAST(_soNum AS INTEGER), supply.itemsite_id, 1, + (_r.quitem_qtyord * _r.quitem_qty_invuomratio), + _r.itemsite_leadtime, _r.quitem_scheddate, _r.quitem_memo, + 'S', _soitemid, _r.quhead_prj_id ) INTO _orderId FROM itemsite sold, itemsite supply WHERE ((sold.itemsite_item_id=supply.itemsite_item_id) AND (supply.itemsite_warehous_id=_r.quitem_order_warehous_id) @@ -268,7 +270,8 @@ BEGIN AND (charass_target_id=_r.quitem_id)); ELSIF ( (_r.item_type IN ('P', 'O')) AND (_r.itemsite_createsopr) ) THEN - SELECT createPr( CAST(_r.quhead_number AS INTEGER), _r.quitem_itemsite_id, (_r.quitem_qtyord * _r.quitem_qty_invuomratio), + SELECT createPr( CAST(_soNum AS INTEGER), _r.quitem_itemsite_id, + (_r.quitem_qtyord * _r.quitem_qty_invuomratio), _r.quitem_scheddate, '', 'S', _soitemid ) INTO _orderId; _orderType := 'R'; UPDATE pr SET pr_prj_id=_r.quhead_prj_id WHERE pr_id=_orderId; -- 2.39.2