details:   https://code.openbravo.com/erp/devel/pi/rev/096aefa3ffde
changeset: 15925:096aefa3ffde
user:      Unai Martirena <unai.martirena <at> openbravo.com>
date:      Tue Mar 27 10:12:09 2012 +0200
summary:   Fixes Bug 20066: In Balance sheet non active accounting report can 
be selected

details:   https://code.openbravo.com/erp/devel/pi/rev/920639f13d49
changeset: 15926:920639f13d49
user:      Unai Martirena <unai.martirena <at> openbravo.com>
date:      Tue Mar 27 13:52:47 2012 +0200
summary:   Fixes Issue 0020106: The Locator Selector has wrong filter by default

diffstat:

 src-db/database/sourcedata/AD_AUXILIARINPUT.xml                           |  
11 ++++++++++
 src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports_data.xsql |   
1 +
 2 files changed, 12 insertions(+), 0 deletions(-)

diffs (32 lines):

diff -r 0fc0c86395e6 -r 920639f13d49 
src-db/database/sourcedata/AD_AUXILIARINPUT.xml
--- a/src-db/database/sourcedata/AD_AUXILIARINPUT.xml   Wed Mar 28 11:44:25 
2012 +0200
+++ b/src-db/database/sourcedata/AD_AUXILIARINPUT.xml   Tue Mar 27 13:52:47 
2012 +0200
@@ -705,6 +705,17 @@
 <!--07F4F6379C2F4FFFB18F3FCB00257C87-->  
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--07F4F6379C2F4FFFB18F3FCB00257C87--></AD_AUXILIARINPUT>
 
+<!--09ACDC893CC845AFB7E29E1F2B66C23F--><AD_AUXILIARINPUT>
+<!--09ACDC893CC845AFB7E29E1F2B66C23F-->  
<AD_AUXILIARINPUT_ID><![CDATA[09ACDC893CC845AFB7E29E1F2B66C23F]]></AD_AUXILIARINPUT_ID>
+<!--09ACDC893CC845AFB7E29E1F2B66C23F-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--09ACDC893CC845AFB7E29E1F2B66C23F-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--09ACDC893CC845AFB7E29E1F2B66C23F-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--09ACDC893CC845AFB7E29E1F2B66C23F-->  <AD_TAB_ID><![CDATA[180]]></AD_TAB_ID>
+<!--09ACDC893CC845AFB7E29E1F2B66C23F-->  
<NAME><![CDATA[M_WAREHOUSE_ID]]></NAME>
+<!--09ACDC893CC845AFB7E29E1F2B66C23F-->  <CODE><![CDATA['']]></CODE>
+<!--09ACDC893CC845AFB7E29E1F2B66C23F-->  
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--09ACDC893CC845AFB7E29E1F2B66C23F--></AD_AUXILIARINPUT>
+
 <!--0A07CF6956004B47AA61B23C80D582DF--><AD_AUXILIARINPUT>
 <!--0A07CF6956004B47AA61B23C80D582DF-->  
<AD_AUXILIARINPUT_ID><![CDATA[0A07CF6956004B47AA61B23C80D582DF]]></AD_AUXILIARINPUT_ID>
 <!--0A07CF6956004B47AA61B23C80D582DF-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff -r 0fc0c86395e6 -r 920639f13d49 
src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports_data.xsql 
Wed Mar 28 11:44:25 2012 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports_data.xsql 
Tue Mar 27 13:52:47 2012 +0200
@@ -49,6 +49,7 @@
       <Sql>
                SELECT C_ACCT_RPT.C_ACCTSCHEMA_ID AS PADRE, 
COALESCE(REPORTTYPE,'N') || C_ACCT_RPT.C_ACCT_RPT_ID AS ID, C_ACCT_RPT.NAME AS 
NAME 
                FROM C_ACCT_RPT
+               WHERE C_ACCT_RPT.ISACTIVE = 'Y'
                ORDER BY NAME
       </Sql>
    </SqlMethod>

------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here 
http://p.sf.net/sfu/sfd2d-msazure
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to