details: https://code.openbravo.com/erp/devel/pi/rev/bf2bb9e85e41 changeset: 19146:bf2bb9e85e41 user: Mikel Irurita <mikel.irurita <at> openbravo.com> date: Wed Jan 02 18:30:33 2013 +0100 summary: Fixes issue 22718: pending goods receipt, generate m_matchpo entry
details: https://code.openbravo.com/erp/devel/pi/rev/e673ef0ebd97 changeset: 19147:e673ef0ebd97 user: Mikel Irurita <mikel.irurita <at> openbravo.com> date: Wed Jan 02 18:34:15 2013 +0100 summary: Related to issue 22718: improve indentantion, use spaces diffstat: src-db/database/model/functions/M_INOUT_POST.xml | 74 ++++++++++++------------ 1 files changed, 37 insertions(+), 37 deletions(-) diffs (88 lines): diff -r 42f163d092a5 -r e673ef0ebd97 src-db/database/model/functions/M_INOUT_POST.xml --- a/src-db/database/model/functions/M_INOUT_POST.xml Wed Jan 02 16:29:40 2013 +0100 +++ b/src-db/database/model/functions/M_INOUT_POST.xml Wed Jan 02 18:34:15 2013 +0100 @@ -532,47 +532,47 @@ LOOP SELECT count(*) INTO v_count - FROM M_MATCHPO - WHERE C_ORDERLINE_ID = Cur_SLines.C_OrderLine_ID - AND M_INOUTLINE_ID = Cur_SLines.M_InOutLine_ID; + FROM M_MATCHPO + WHERE C_ORDERLINE_ID = Cur_SLines.C_OrderLine_ID + AND M_INOUTLINE_ID = Cur_SLines.M_InOutLine_ID; - v_Qty:=Cur_SLines.MovementQty; - --IF (ABS(Cur_SLines.MovementQty) > ABS(Cur_SLines.QtyOrdered)) THEN - -- v_Qty := Cur_SLines.QtyOrdered; - --END IF; + v_Qty:=Cur_SLines.MovementQty; + --IF (ABS(Cur_SLines.MovementQty) > ABS(Cur_SLines.QtyOrdered)) THEN + -- v_Qty := Cur_SLines.QtyOrdered; + --END IF; - IF (v_count <> 0) THEN - SELECT max(M_MATCHPO_ID) - INTO v_MatchPO_ID + IF (v_count = 0) THEN + Ad_Sequence_Next('M_MatchPO', Cur_SLines.AD_Org_ID, v_MatchPO_ID) ; + -- The min qty. Modified by Ismael Ciordia + v_ResultStr:='InsertMatchPO ' || v_MatchPO_ID; + INSERT + INTO M_MATCHPO + ( + M_MatchPO_ID, AD_Client_ID, AD_Org_ID, IsActive, + Created, CreatedBy, Updated, UpdatedBy, + M_InOutLine_ID, C_OrderLine_ID, M_Product_ID, DateTrx, + Qty, Processing, Processed, Posted + ) + VALUES + ( + v_MatchPO_ID, Cur_SLines.AD_Client_ID, Cur_SLines.AD_Org_ID, 'Y', + now(), v_User, now(), v_User, + Cur_SLines.M_InOutLine_ID, Cur_SLines.C_OrderLine_ID, Cur_SLines.M_Product_ID, now(), + v_Qty, 'N', 'Y', 'N' + ) + ; + ELSE + SELECT max(M_MATCHPO_ID) + INTO v_MatchPO_ID FROM M_MATCHPO - WHERE C_ORDERLINE_ID = Cur_SLines.C_OrderLine_ID - AND M_INOUTLINE_ID = Cur_SLines.M_InOutLine_ID; + WHERE C_ORDERLINE_ID = Cur_SLines.C_OrderLine_ID + AND M_INOUTLINE_ID = Cur_SLines.M_InOutLine_ID; - Ad_Sequence_Next('M_MatchPO', Cur_SLines.AD_Org_ID, v_MatchPO_ID) ; - -- The min qty. Modified by Ismael Ciordia - v_ResultStr:='InsertMatchPO ' || v_MatchPO_ID; - INSERT - INTO M_MATCHPO - ( - M_MatchPO_ID, AD_Client_ID, AD_Org_ID, IsActive, - Created, CreatedBy, Updated, UpdatedBy, - M_InOutLine_ID, C_OrderLine_ID, M_Product_ID, DateTrx, - Qty, Processing, Processed, Posted - ) - VALUES - ( - v_MatchPO_ID, Cur_SLines.AD_Client_ID, Cur_SLines.AD_Org_ID, 'Y', - now(), v_User, now(), v_User, - Cur_SLines.M_InOutLine_ID, Cur_SLines.C_OrderLine_ID, Cur_SLines.M_Product_ID, now(), - v_Qty, 'N', 'Y', 'N' - ) - ; - ELSE - v_ResultStr:='UpdateMatchPO ' || v_MatchPO_ID; - UPDATE M_MATCHPO - SET DateTrx = now(), Qty =v_Qty, Processing = 'N', Processed = 'Y', Posted='N' - WHERE M_MATCHPO_ID = v_MatchPO_ID; - END IF; + v_ResultStr:='UpdateMatchPO ' || v_MatchPO_ID; + UPDATE M_MATCHPO + SET DateTrx = now(), Qty =v_Qty, Processing = 'N', Processed = 'Y', Posted='N' + WHERE M_MATCHPO_ID = v_MatchPO_ID; + END IF; END LOOP; v_ResultStr:='MatchInv'; FOR Cur_ILines IN ------------------------------------------------------------------------------ Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery and much more. Keep your Java skills current with LearnJavaNow - 200+ hours of step-by-step video tutorials by Java experts. SALE $49.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122612 _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
