Fixes issue 12404: Complete and reactivate sales order - delete the lines - Now Total Net Amount and Total Gross Amount are same
authorHarikrishnan Raja <harikrishnan.raja@openbravo.com>
Thu, 01 Apr 2010 12:04:44 +0530
changeset 6884 fc18da8fb8f7
parent 6883 ac47c1cf8454
child 6885 39596de39bca
Fixes issue 12404: Complete and reactivate sales order - delete the lines - Now Total Net Amount and Total Gross Amount are same
src-db/database/model/triggers/C_ORDERLINE_TRG2.xml
--- a/src-db/database/model/triggers/C_ORDERLINE_TRG2.xml	Wed Mar 31 18:09:01 2010 +0200
+++ b/src-db/database/model/triggers/C_ORDERLINE_TRG2.xml	Thu Apr 01 12:04:44 2010 +0530
@@ -203,7 +203,7 @@
  v_newLineNetAmt:=0;
  IF(v_Processed='N') THEN
   -- Calculate taxes
-  IF(UPDATING) THEN
+  IF(UPDATING OR DELETING) THEN
   v_oldLine:= COALESCE(:old.LineNetAmt,0) + COALESCE(:old.FreightAmt,0) + COALESCE(:old.ChargeAmt,0);
   END IF;  
   IF (INSERTING OR UPDATING) THEN