details: https://code.openbravo.com/erp/stable/2.50/rev/907e44abf20e
changeset: 9735:907e44abf20e
user: Mikel Irurita <mikel.irurita <at> openbravo.com>
date: Wed Nov 09 18:36:03 2011 +0100
summary: Fixes issue 18759: [trigger] invoice line without product and
without glitem but with line amt <>0
diffstat:
src-db/database/model/triggers/C_INVLINE_CHK_RESTRICTIONS_TRG.xml | 5 ++++
src-db/database/sourcedata/AD_MESSAGE.xml | 11
++++++++++
2 files changed, 16 insertions(+), 0 deletions(-)
diffs (36 lines):
diff -r 83ac2b6b7d2e -r 907e44abf20e
src-db/database/model/triggers/C_INVLINE_CHK_RESTRICTIONS_TRG.xml
--- a/src-db/database/model/triggers/C_INVLINE_CHK_RESTRICTIONS_TRG.xml Tue Nov
08 10:15:53 2011 +0100
+++ b/src-db/database/model/triggers/C_INVLINE_CHK_RESTRICTIONS_TRG.xml Wed Nov
09 18:36:03 2011 +0100
@@ -87,6 +87,11 @@
IF (:NEW.ISEDITLINENETAMT='Y' AND ROUND(TO_NUMBER(:NEW.QTYINVOICED) *
TO_NUMBER(:NEW.PRICEACTUAL),v_Prec)!=TO_NUMBER(:NEW.LINENETAMT)) THEN
RAISE_APPLICATION_ERROR(-20000, '@LineAmountNotCorrect@') ;
END IF;
+
+ IF (:NEW.account_id is null AND :NEW.m_product_id is null AND
:NEW.linenetamt <> 0) THEN
+ RAISE_APPLICATION_ERROR(-20000, '@InvoiceLineAmountMustBeZero@') ;
+ END IF;
+
END IF;
END C_INVLINE_CHK_RESTRICTIONS_TRG
]]></body>
diff -r 83ac2b6b7d2e -r 907e44abf20e src-db/database/sourcedata/AD_MESSAGE.xml
--- a/src-db/database/sourcedata/AD_MESSAGE.xml Tue Nov 08 10:15:53 2011 +0100
+++ b/src-db/database/sourcedata/AD_MESSAGE.xml Wed Nov 09 18:36:03 2011 +0100
@@ -32979,6 +32979,17 @@
<!--A6688A1ACA9F47D0B86C54890D41C2E2-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--A6688A1ACA9F47D0B86C54890D41C2E2--></AD_MESSAGE>
+<!--A68484EF93CE4EA5BC44B3A871F88691--><AD_MESSAGE>
+<!--A68484EF93CE4EA5BC44B3A871F88691-->
<AD_MESSAGE_ID><![CDATA[A68484EF93CE4EA5BC44B3A871F88691]]></AD_MESSAGE_ID>
+<!--A68484EF93CE4EA5BC44B3A871F88691-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--A68484EF93CE4EA5BC44B3A871F88691--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--A68484EF93CE4EA5BC44B3A871F88691--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--A68484EF93CE4EA5BC44B3A871F88691-->
<VALUE><![CDATA[InvoiceLineAmountMustBeZero]]></VALUE>
+<!--A68484EF93CE4EA5BC44B3A871F88691--> <MSGTEXT><![CDATA[Line amount must be
zero when no product nor G/L Item is selected.]]></MSGTEXT>
+<!--A68484EF93CE4EA5BC44B3A871F88691--> <MSGTYPE><![CDATA[E]]></MSGTYPE>
+<!--A68484EF93CE4EA5BC44B3A871F88691-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--A68484EF93CE4EA5BC44B3A871F88691--></AD_MESSAGE>
+
<!--A68C3053E180449ABF364A71CBAC9CF0--><AD_MESSAGE>
<!--A68C3053E180449ABF364A71CBAC9CF0-->
<AD_MESSAGE_ID><![CDATA[A68C3053E180449ABF364A71CBAC9CF0]]></AD_MESSAGE_ID>
<!--A68C3053E180449ABF364A71CBAC9CF0-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
------------------------------------------------------------------------------
RSA(R) Conference 2012
Save $700 by Nov 18
Register now
http://p.sf.net/sfu/rsa-sfdev2dev1
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
