Fixed bug 17842
authorSalvador Zapata <salvador.zapata@openbravo.com>
Wed, 13 Jul 2011 16:49:45 +0200
changeset 13329 0ab8d290c95a
parent 13328 887a041f92a6
child 13330 fb50d884949b
Fixed bug 17842
src-db/database/model/triggers/C_CONVERSION_RATE_DOCUMENT_TRG.xml
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/model/triggers/C_CONVERSION_RATE_DOCUMENT_TRG.xml	Mon Jul 04 17:44:29 2011 +0200
+++ b/src-db/database/model/triggers/C_CONVERSION_RATE_DOCUMENT_TRG.xml	Wed Jul 13 16:49:45 2011 +0200
@@ -77,6 +77,9 @@
 		FROM aprm_finacc_transaction_v
 		WHERE aprm_finacc_transaction_v_id = :OLD.aprm_finacc_transaction_v_id;
 	END IF;
+	IF(v_Posted='Y')
+		THEN  RAISE_APPLICATION_ERROR(-20501, 'Document processed/posted');
+	END IF;
     END IF;
     IF DELETING THEN
 	IF :OLD.C_INVOICE_ID IS NOT NULL THEN
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Mon Jul 04 17:44:29 2011 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Wed Jul 13 16:49:45 2011 +0200
@@ -211114,7 +211114,7 @@
 <!--35AFE074271647AE830192953835C695-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
 <!--35AFE074271647AE830192953835C695-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--35AFE074271647AE830192953835C695-->  <ISPARENT><![CDATA[Y]]></ISPARENT>
-<!--35AFE074271647AE830192953835C695-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--35AFE074271647AE830192953835C695-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
 <!--35AFE074271647AE830192953835C695-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
 <!--35AFE074271647AE830192953835C695-->  <READONLYLOGIC><![CDATA[@HASREVERSEDINVOICESO@='Y' | @HASREVERSEDINVOICEPO@='Y']]></READONLYLOGIC>
 <!--35AFE074271647AE830192953835C695-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
@@ -260869,7 +260869,7 @@
 <!--E673EE5F3E0741FD97178D4C2994C445-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
 <!--E673EE5F3E0741FD97178D4C2994C445-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--E673EE5F3E0741FD97178D4C2994C445-->  <ISPARENT><![CDATA[Y]]></ISPARENT>
-<!--E673EE5F3E0741FD97178D4C2994C445-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--E673EE5F3E0741FD97178D4C2994C445-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
 <!--E673EE5F3E0741FD97178D4C2994C445-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
 <!--E673EE5F3E0741FD97178D4C2994C445-->  <READONLYLOGIC><![CDATA[@HASREVERSEDINVOICESO@='Y' | @HASREVERSEDINVOICEPO@='Y']]></READONLYLOGIC>
 <!--E673EE5F3E0741FD97178D4C2994C445-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
@@ -262010,7 +262010,7 @@
 <!--FCA27DEA87A04D738AAB1452C9FE14F7-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
 <!--FCA27DEA87A04D738AAB1452C9FE14F7-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--FCA27DEA87A04D738AAB1452C9FE14F7-->  <ISPARENT><![CDATA[Y]]></ISPARENT>
-<!--FCA27DEA87A04D738AAB1452C9FE14F7-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--FCA27DEA87A04D738AAB1452C9FE14F7-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
 <!--FCA27DEA87A04D738AAB1452C9FE14F7-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
 <!--FCA27DEA87A04D738AAB1452C9FE14F7-->  <READONLYLOGIC><![CDATA[@HASREVERSEDINVOICESO@='Y' | @HASREVERSEDINVOICEPO@='Y']]></READONLYLOGIC>
 <!--FCA27DEA87A04D738AAB1452C9FE14F7-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
--- a/src-db/database/sourcedata/AD_FIELD.xml	Mon Jul 04 17:44:29 2011 +0200
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Wed Jul 13 16:49:45 2011 +0200
@@ -192537,7 +192537,7 @@
 <!--F823B2CD61844A2EA3FDC4B64C63DA58-->  <AD_FIELD_ID><![CDATA[F823B2CD61844A2EA3FDC4B64C63DA58]]></AD_FIELD_ID>
 <!--F823B2CD61844A2EA3FDC4B64C63DA58-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--F823B2CD61844A2EA3FDC4B64C63DA58-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--F823B2CD61844A2EA3FDC4B64C63DA58-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--F823B2CD61844A2EA3FDC4B64C63DA58-->  <ISACTIVE><![CDATA[N]]></ISACTIVE>
 <!--F823B2CD61844A2EA3FDC4B64C63DA58-->  <NAME><![CDATA[Payment]]></NAME>
 <!--F823B2CD61844A2EA3FDC4B64C63DA58-->  <DESCRIPTION><![CDATA[Payment event]]></DESCRIPTION>
 <!--F823B2CD61844A2EA3FDC4B64C63DA58-->  <HELP><![CDATA[Payment event]]></HELP>