details: https://code.openbravo.com/erp/devel/pi/rev/237fe3795fb4 changeset: 26406:237fe3795fb4 user: Jorge Garcia <jorge.garcia <at> openbravo.com> date: Tue Apr 21 10:25:34 2015 +0200 summary: Fixed issue 29637: Account fields should not be shown in some cases in G/L Conf
"Account tree" and "Account element" fields should not be shown when setting User1 or User2 dimension in General Ledger Configuration window. The solution is to change the Display Logic for those fields, and delete the element types U1 and U2. Now, when User 1 / User 2 is selected, the Account Tree and the Account Element aren't displayed. details: https://code.openbravo.com/erp/devel/pi/rev/fa88cad0c966 changeset: 26407:fa88cad0c966 user: Sandra Huguet <sandra.huguet <at> openbravo.com> date: Mon May 04 18:12:27 2015 +0200 summary: Related to issue 29637 Added read only logic because in grid mode is possible to add "Account tree" and "Account element" to all dimensions. Added distinct in C_ELEMENTVALUE_TRG to avoid duplicates values in account combinations. diffstat: src-db/database/model/triggers/C_ELEMENTVALUE_TRG.xml | 6 +++--- src-db/database/sourcedata/AD_COLUMN.xml | 2 ++ src-db/database/sourcedata/AD_FIELD.xml | 4 ++-- 3 files changed, 7 insertions(+), 5 deletions(-) diffs (70 lines): diff -r f83615a66bb3 -r fa88cad0c966 src-db/database/model/triggers/C_ELEMENTVALUE_TRG.xml --- a/src-db/database/model/triggers/C_ELEMENTVALUE_TRG.xml Mon May 04 17:24:03 2015 +0200 +++ b/src-db/database/model/triggers/C_ELEMENTVALUE_TRG.xml Mon May 04 18:12:27 2015 +0200 @@ -14,7 +14,7 @@ * under the License. * The Original Code is Openbravo ERP. * The Initial Developer of the Original Code is Openbravo SLU -* All portions are Copyright (C) 2001-2013 Openbravo SLU +* All portions are Copyright (C) 2001-2015 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************/ @@ -57,7 +57,7 @@ -- Create Valid Combination IF(:new.elementlevel = 'S') THEN FOR cur_AcctSchema IN - (SELECT C_AcctSchema_ID + (SELECT distinct (C_AcctSchema_ID) FROM C_AcctSchema_Element WHERE C_AcctSchema_Element.C_Element_ID = :new.C_Element_ID ) @@ -185,7 +185,7 @@ END IF; ELSE FOR cur_AcctSchema IN - (SELECT C_AcctSchema_ID + (SELECT distinct (C_AcctSchema_ID) FROM C_AcctSchema_Element WHERE C_AcctSchema_Element.C_Element_ID = :new.C_Element_ID ) diff -r f83615a66bb3 -r fa88cad0c966 src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml Mon May 04 17:24:03 2015 +0200 +++ b/src-db/database/sourcedata/AD_COLUMN.xml Mon May 04 18:12:27 2015 +0200 @@ -39106,6 +39106,7 @@ <!--2666--> <ISPARENT><![CDATA[N]]></ISPARENT> <!--2666--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> <!--2666--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--2666--> <READONLYLOGIC><![CDATA[@ElementType@!'AC']]></READONLYLOGIC> <!--2666--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> <!--2666--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> <!--2666--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> @@ -39591,6 +39592,7 @@ <!--2701--> <ISPARENT><![CDATA[N]]></ISPARENT> <!--2701--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> <!--2701--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--2701--> <READONLYLOGIC><![CDATA[@ElementType@!'AC']]></READONLYLOGIC> <!--2701--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> <!--2701--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> <!--2701--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> diff -r f83615a66bb3 -r fa88cad0c966 src-db/database/sourcedata/AD_FIELD.xml --- a/src-db/database/sourcedata/AD_FIELD.xml Mon May 04 17:24:03 2015 +0200 +++ b/src-db/database/sourcedata/AD_FIELD.xml Mon May 04 18:12:27 2015 +0200 @@ -20850,7 +20850,7 @@ <!--1531--> <AD_COLUMN_ID><![CDATA[2666]]></AD_COLUMN_ID> <!--1531--> <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD> <!--1531--> <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED> -<!--1531--> <DISPLAYLOGIC><![CDATA[@ElementType@='AC' | @ElementType@='U1' | @ElementType@='U2']]></DISPLAYLOGIC> +<!--1531--> <DISPLAYLOGIC><![CDATA[@ElementType@='AC']]></DISPLAYLOGIC> <!--1531--> <DISPLAYLENGTH><![CDATA[44]]></DISPLAYLENGTH> <!--1531--> <ISREADONLY><![CDATA[N]]></ISREADONLY> <!--1531--> <SEQNO><![CDATA[60]]></SEQNO> @@ -21111,7 +21111,7 @@ <!--1541--> <AD_COLUMN_ID><![CDATA[2701]]></AD_COLUMN_ID> <!--1541--> <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD> <!--1541--> <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED> -<!--1541--> <DISPLAYLOGIC><![CDATA[@ElementType@='AC' | @ElementType@='U1' | @ElementType@='U2']]></DISPLAYLOGIC> +<!--1541--> <DISPLAYLOGIC><![CDATA[@ElementType@='AC']]></DISPLAYLOGIC> <!--1541--> <DISPLAYLENGTH><![CDATA[44]]></DISPLAYLENGTH> <!--1541--> <ISREADONLY><![CDATA[N]]></ISREADONLY> <!--1541--> <SEQNO><![CDATA[90]]></SEQNO> ------------------------------------------------------------------------------ One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
