details: https://code.openbravo.com/erp/devel/pi/rev/847b236b4c75 changeset: 21732:847b236b4c75 user: Atul Gaware <atul.gaware <at> openbravo.com> date: Mon Dec 30 18:16:41 2013 +0530 summary: 0024881: Swiss franc is duplicated. Only CHF has to exist
details: https://code.openbravo.com/erp/devel/pi/rev/17847a1ed46d changeset: 21733:17847a1ed46d user: Atul Gaware <atul.gaware <at> openbravo.com> date: Mon Dec 30 14:55:36 2013 +0530 summary: Fixes Issue 0025106:Asset set as not fully depreciated when there is a previously depreciated amount diffstat: src-db/database/model/functions/A_AMORTIZATION_PROCESS.xml | 4 +- src-db/database/sourcedata/referencedData/C_CURRENCY.xml | 18 -------------- 2 files changed, 2 insertions(+), 20 deletions(-) diffs (49 lines): diff -r 987357c24f95 -r 17847a1ed46d src-db/database/model/functions/A_AMORTIZATION_PROCESS.xml --- a/src-db/database/model/functions/A_AMORTIZATION_PROCESS.xml Mon Dec 30 19:17:05 2013 +0530 +++ b/src-db/database/model/functions/A_AMORTIZATION_PROCESS.xml Mon Dec 30 14:55:36 2013 +0530 @@ -16,7 +16,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-2009 Openbravo SLU +* All portions are Copyright (C) 2001-2013 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************/ @@ -149,7 +149,7 @@ AND am.A_Amortization_ID=V_Record_ID); UPDATE a_asset SET IsFullyDepreciated='Y',Updated=now(),UpdatedBy=v_AD_User_ID - WHERE COALESCE(AmortizationValueAmt, -1)=COALESCE(DepreciatedValue, -2) ; + WHERE COALESCE(DepreciatedPlan, -1)=COALESCE(DepreciatedValue, -2) ; END IF; --<<FINISH_PROCESS>> IF(p_PInstance_ID IS NOT NULL) THEN diff -r 987357c24f95 -r 17847a1ed46d src-db/database/sourcedata/referencedData/C_CURRENCY.xml --- a/src-db/database/sourcedata/referencedData/C_CURRENCY.xml Mon Dec 30 19:17:05 2013 +0530 +++ b/src-db/database/sourcedata/referencedData/C_CURRENCY.xml Mon Dec 30 14:55:36 2013 +0530 @@ -252,24 +252,6 @@ <!--114--> <ISSYMBOLRIGHTSIDE><![CDATA[N]]></ISSYMBOLRIGHTSIDE> <!--114--></C_CURRENCY> -<!--115--><C_CURRENCY> -<!--115--> <C_CURRENCY_ID><![CDATA[115]]></C_CURRENCY_ID> -<!--115--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> -<!--115--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> -<!--115--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> -<!--115--> <CREATED><![CDATA[2011-02-22 17:06:39.0]]></CREATED> -<!--115--> <CREATEDBY><![CDATA[0]]></CREATEDBY> -<!--115--> <UPDATED><![CDATA[2011-02-22 17:06:39.0]]></UPDATED> -<!--115--> <UPDATEDBY><![CDATA[0]]></UPDATEDBY> -<!--115--> <ISO_CODE><![CDATA[SFR]]></ISO_CODE> -<!--115--> <CURSYMBOL><![CDATA[SFr]]></CURSYMBOL> -<!--115--> <DESCRIPTION><![CDATA[Swiss Franc]]></DESCRIPTION> -<!--115--> <STDPRECISION><![CDATA[2]]></STDPRECISION> -<!--115--> <COSTINGPRECISION><![CDATA[2]]></COSTINGPRECISION> -<!--115--> <PRICEPRECISION><![CDATA[2]]></PRICEPRECISION> -<!--115--> <ISSYMBOLRIGHTSIDE><![CDATA[N]]></ISSYMBOLRIGHTSIDE> -<!--115--></C_CURRENCY> - <!--116--><C_CURRENCY> <!--116--> <C_CURRENCY_ID><![CDATA[116]]></C_CURRENCY_ID> <!--116--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> ------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits