fixes issue 20846: The application does not order GL Items in financial invoice properly
authorCarlos Aristu <carlos.aristu@openbravo.com>
Mon, 30 Jul 2012 12:54:07 +0200
changeset 17578 f2a6e4598a05
parent 17577 0747bbf46a5e
child 17579 47c683261c3a
fixes issue 20846: The application does not order GL Items in financial invoice properly
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_REFERENCE.xml
src-db/database/sourcedata/AD_REF_TABLE.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Mon Jul 30 11:54:08 2012 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Mon Jul 30 12:54:07 2012 +0200
@@ -294110,7 +294110,7 @@
 <!--FD3A0DB0549845F29EDCA4FC514B52AD-->  <COLUMNNAME><![CDATA[Account_ID]]></COLUMNNAME>
 <!--FD3A0DB0549845F29EDCA4FC514B52AD-->  <AD_TABLE_ID><![CDATA[333]]></AD_TABLE_ID>
 <!--FD3A0DB0549845F29EDCA4FC514B52AD-->  <AD_REFERENCE_ID><![CDATA[18]]></AD_REFERENCE_ID>
-<!--FD3A0DB0549845F29EDCA4FC514B52AD-->  <AD_REFERENCE_VALUE_ID><![CDATA[66E310A87A844A51B8BAD2884E996CD6]]></AD_REFERENCE_VALUE_ID>
+<!--FD3A0DB0549845F29EDCA4FC514B52AD-->  <AD_REFERENCE_VALUE_ID><![CDATA[2F57E5B5EBF44E0A9D45492DECBD3CC1]]></AD_REFERENCE_VALUE_ID>
 <!--FD3A0DB0549845F29EDCA4FC514B52AD-->  <AD_VAL_RULE_ID><![CDATA[58401EEE65CC4551BEC649A16FA16479]]></AD_VAL_RULE_ID>
 <!--FD3A0DB0549845F29EDCA4FC514B52AD-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
 <!--FD3A0DB0549845F29EDCA4FC514B52AD-->  <ISKEY><![CDATA[N]]></ISKEY>
--- a/src-db/database/sourcedata/AD_REFERENCE.xml	Mon Jul 30 11:54:08 2012 +0200
+++ b/src-db/database/sourcedata/AD_REFERENCE.xml	Mon Jul 30 12:54:07 2012 +0200
@@ -4329,6 +4329,20 @@
 <!--2969F07308CB43ECBCDAE151C12F03E0-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
 <!--2969F07308CB43ECBCDAE151C12F03E0--></AD_REFERENCE>
 
+<!--2F57E5B5EBF44E0A9D45492DECBD3CC1--><AD_REFERENCE>
+<!--2F57E5B5EBF44E0A9D45492DECBD3CC1-->  <AD_REFERENCE_ID><![CDATA[2F57E5B5EBF44E0A9D45492DECBD3CC1]]></AD_REFERENCE_ID>
+<!--2F57E5B5EBF44E0A9D45492DECBD3CC1-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--2F57E5B5EBF44E0A9D45492DECBD3CC1-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--2F57E5B5EBF44E0A9D45492DECBD3CC1-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--2F57E5B5EBF44E0A9D45492DECBD3CC1-->  <NAME><![CDATA[C_GLItem Ordered by Organization]]></NAME>
+<!--2F57E5B5EBF44E0A9D45492DECBD3CC1-->  <DESCRIPTION><![CDATA[It is a general ledger item.]]></DESCRIPTION>
+<!--2F57E5B5EBF44E0A9D45492DECBD3CC1-->  <HELP><![CDATA[It is a general ledger item.]]></HELP>
+<!--2F57E5B5EBF44E0A9D45492DECBD3CC1-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--2F57E5B5EBF44E0A9D45492DECBD3CC1-->  <ISBASEREFERENCE><![CDATA[N]]></ISBASEREFERENCE>
+<!--2F57E5B5EBF44E0A9D45492DECBD3CC1-->  <PARENTREFERENCE_ID><![CDATA[18]]></PARENTREFERENCE_ID>
+<!--2F57E5B5EBF44E0A9D45492DECBD3CC1-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--2F57E5B5EBF44E0A9D45492DECBD3CC1--></AD_REFERENCE>
+
 <!--368E5F32B443454093D14D4E0AD44E13--><AD_REFERENCE>
 <!--368E5F32B443454093D14D4E0AD44E13-->  <AD_REFERENCE_ID><![CDATA[368E5F32B443454093D14D4E0AD44E13]]></AD_REFERENCE_ID>
 <!--368E5F32B443454093D14D4E0AD44E13-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_REF_TABLE.xml	Mon Jul 30 11:54:08 2012 +0200
+++ b/src-db/database/sourcedata/AD_REF_TABLE.xml	Mon Jul 30 12:54:07 2012 +0200
@@ -1142,6 +1142,18 @@
 <!--22F546D49D3A48E1B2B4F50446A8DE58-->  <ORDERBYCLAUSE><![CDATA[C_DocType.isdefault DESC, C_DocType.Name]]></ORDERBYCLAUSE>
 <!--22F546D49D3A48E1B2B4F50446A8DE58--></AD_REF_TABLE>
 
+<!--2F57E5B5EBF44E0A9D45492DECBD3CC1--><AD_REF_TABLE>
+<!--2F57E5B5EBF44E0A9D45492DECBD3CC1-->  <AD_REFERENCE_ID><![CDATA[2F57E5B5EBF44E0A9D45492DECBD3CC1]]></AD_REFERENCE_ID>
+<!--2F57E5B5EBF44E0A9D45492DECBD3CC1-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--2F57E5B5EBF44E0A9D45492DECBD3CC1-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--2F57E5B5EBF44E0A9D45492DECBD3CC1-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--2F57E5B5EBF44E0A9D45492DECBD3CC1-->  <AD_TABLE_ID><![CDATA[800022]]></AD_TABLE_ID>
+<!--2F57E5B5EBF44E0A9D45492DECBD3CC1-->  <AD_KEY><![CDATA[800437]]></AD_KEY>
+<!--2F57E5B5EBF44E0A9D45492DECBD3CC1-->  <AD_DISPLAY><![CDATA[800445]]></AD_DISPLAY>
+<!--2F57E5B5EBF44E0A9D45492DECBD3CC1-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--2F57E5B5EBF44E0A9D45492DECBD3CC1-->  <ORDERBYCLAUSE><![CDATA[AD_Org_ID = @AD_Org_ID@ DESC]]></ORDERBYCLAUSE>
+<!--2F57E5B5EBF44E0A9D45492DECBD3CC1--></AD_REF_TABLE>
+
 <!--54AC2749F26440F3AEA33378858569E4--><AD_REF_TABLE>
 <!--54AC2749F26440F3AEA33378858569E4-->  <AD_REFERENCE_ID><![CDATA[54AC2749F26440F3AEA33378858569E4]]></AD_REFERENCE_ID>
 <!--54AC2749F26440F3AEA33378858569E4-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>