details:   https://code.openbravo.com/erp/devel/pi/rev/7fd2202f4245
changeset: 21380:7fd2202f4245
user:      Javier Etxarri <javier.echarri <at> openbravo.com>
date:      Thu Oct 24 13:46:14 2013 +0200
summary:   Fixes issue 23535: User can select accounts
that belongs to an inactive general ledger

diffstat:

 src-db/database/sourcedata/AD_COLUMN.xml        |   3 ++-
 src-db/database/sourcedata/AD_REFERENCE.xml     |  13 +++++++++++++
 src-db/database/sourcedata/OBUISEL_SELECTOR.xml |  17 +++++++++++++++++
 3 files changed, 32 insertions(+), 1 deletions(-)

diffs (61 lines):

diff -r 491a3b333503 -r 7fd2202f4245 src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml  Thu Oct 24 14:27:52 2013 +0530
+++ b/src-db/database/sourcedata/AD_COLUMN.xml  Thu Oct 24 13:46:14 2013 +0200
@@ -39584,7 +39584,8 @@
 <!--2701-->  <HELP><![CDATA[Account Elements can be natural accounts or user 
defined values.]]></HELP>
 <!--2701-->  <COLUMNNAME><![CDATA[C_ElementValue_ID]]></COLUMNNAME>
 <!--2701-->  <AD_TABLE_ID><![CDATA[279]]></AD_TABLE_ID>
-<!--2701-->  <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--2701-->  
<AD_REFERENCE_ID><![CDATA[95E2A8B50A254B2AAE6774B8C2F28120]]></AD_REFERENCE_ID>
+<!--2701-->  
<AD_REFERENCE_VALUE_ID><![CDATA[5921E65E7BFA4134B98CCDA388CC0559]]></AD_REFERENCE_VALUE_ID>
 <!--2701-->  <FIELDLENGTH><![CDATA[22]]></FIELDLENGTH>
 <!--2701-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--2701-->  <ISPARENT><![CDATA[N]]></ISPARENT>
diff -r 491a3b333503 -r 7fd2202f4245 src-db/database/sourcedata/AD_REFERENCE.xml
--- a/src-db/database/sourcedata/AD_REFERENCE.xml       Thu Oct 24 14:27:52 
2013 +0530
+++ b/src-db/database/sourcedata/AD_REFERENCE.xml       Thu Oct 24 13:46:14 
2013 +0200
@@ -4960,6 +4960,19 @@
 <!--575BCB88A4694C27BC013DE9C73E6FE7-->  
<ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
 <!--575BCB88A4694C27BC013DE9C73E6FE7--></AD_REFERENCE>
 
+<!--5921E65E7BFA4134B98CCDA388CC0559--><AD_REFERENCE>
+<!--5921E65E7BFA4134B98CCDA388CC0559-->  
<AD_REFERENCE_ID><![CDATA[5921E65E7BFA4134B98CCDA388CC0559]]></AD_REFERENCE_ID>
+<!--5921E65E7BFA4134B98CCDA388CC0559-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--5921E65E7BFA4134B98CCDA388CC0559-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--5921E65E7BFA4134B98CCDA388CC0559-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--5921E65E7BFA4134B98CCDA388CC0559-->  <NAME><![CDATA[OBUISEL Account 
Element Value ]]></NAME>
+<!--5921E65E7BFA4134B98CCDA388CC0559-->  <DESCRIPTION><![CDATA[Account Element 
Value]]></DESCRIPTION>
+<!--5921E65E7BFA4134B98CCDA388CC0559-->  
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--5921E65E7BFA4134B98CCDA388CC0559-->  
<ISBASEREFERENCE><![CDATA[N]]></ISBASEREFERENCE>
+<!--5921E65E7BFA4134B98CCDA388CC0559-->  
<PARENTREFERENCE_ID><![CDATA[95E2A8B50A254B2AAE6774B8C2F28120]]></PARENTREFERENCE_ID>
+<!--5921E65E7BFA4134B98CCDA388CC0559-->  
<ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--5921E65E7BFA4134B98CCDA388CC0559--></AD_REFERENCE>
+
 <!--595E4FB3F743477BA5A670452556C3DF--><AD_REFERENCE>
 <!--595E4FB3F743477BA5A670452556C3DF-->  
<AD_REFERENCE_ID><![CDATA[595E4FB3F743477BA5A670452556C3DF]]></AD_REFERENCE_ID>
 <!--595E4FB3F743477BA5A670452556C3DF-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff -r 491a3b333503 -r 7fd2202f4245 
src-db/database/sourcedata/OBUISEL_SELECTOR.xml
--- a/src-db/database/sourcedata/OBUISEL_SELECTOR.xml   Thu Oct 24 14:27:52 
2013 +0530
+++ b/src-db/database/sourcedata/OBUISEL_SELECTOR.xml   Thu Oct 24 13:46:14 
2013 +0200
@@ -716,4 +716,21 @@
 <!--F42A1DD1B941461EB3B9AD07A534D91E-->  
<CUSTOM_QUERY><![CDATA[Y]]></CUSTOM_QUERY>
 <!--F42A1DD1B941461EB3B9AD07A534D91E--></OBUISEL_SELECTOR>
 
+<!--FA5BC3AD909645C3BCF9384AE635009A--><OBUISEL_SELECTOR>
+<!--FA5BC3AD909645C3BCF9384AE635009A-->  
<OBUISEL_SELECTOR_ID><![CDATA[FA5BC3AD909645C3BCF9384AE635009A]]></OBUISEL_SELECTOR_ID>
+<!--FA5BC3AD909645C3BCF9384AE635009A-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FA5BC3AD909645C3BCF9384AE635009A-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FA5BC3AD909645C3BCF9384AE635009A-->  
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--FA5BC3AD909645C3BCF9384AE635009A-->  <NAME><![CDATA[Account Element 
Value]]></NAME>
+<!--FA5BC3AD909645C3BCF9384AE635009A-->  
<AD_REFERENCE_ID><![CDATA[5921E65E7BFA4134B98CCDA388CC0559]]></AD_REFERENCE_ID>
+<!--FA5BC3AD909645C3BCF9384AE635009A-->  
<AD_TABLE_ID><![CDATA[188]]></AD_TABLE_ID>
+<!--FA5BC3AD909645C3BCF9384AE635009A-->  
<AD_COLUMN_ID><![CDATA[1125]]></AD_COLUMN_ID>
+<!--FA5BC3AD909645C3BCF9384AE635009A-->  <WHERECLAUSE><![CDATA[e.active = true 
and e.accountingElement.id=@inpcElementId@]]></WHERECLAUSE>
+<!--FA5BC3AD909645C3BCF9384AE635009A-->  
<OBCLKER_TEMPLATE_ID><![CDATA[9314DE8599AD44E7BFC4CC50699042AB]]></OBCLKER_TEMPLATE_ID>
+<!--FA5BC3AD909645C3BCF9384AE635009A-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FA5BC3AD909645C3BCF9384AE635009A-->  
<SUGGESTIONTEXTMATCHSTYLE><![CDATA[substring]]></SUGGESTIONTEXTMATCHSTYLE>
+<!--FA5BC3AD909645C3BCF9384AE635009A-->  
<POPUPTEXTMATCHSTYLE><![CDATA[substring]]></POPUPTEXTMATCHSTYLE>
+<!--FA5BC3AD909645C3BCF9384AE635009A-->  
<CUSTOM_QUERY><![CDATA[N]]></CUSTOM_QUERY>
+<!--FA5BC3AD909645C3BCF9384AE635009A--></OBUISEL_SELECTOR>
+
 </data>

------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to