public static BigDecimal base(BigDecimal p_Amount,int p_C_CurrencyFrom_ID,Timestamp p_ConversionDate,int p_AD_Client_ID,int p_AD_Org_ID) throws SQLException {
  if (p_Amount == null || p_C_CurrencyFrom_ID == 0)   return null;
  if (p_Amount.signum() == 0)   return p_Amount;
  String sql="SELECT ac.C_Currency_ID " + "FROM AD_ClientInfo ci" + " INNER JOIN C_AcctSchema ac ON (ci.C_AcctSchema1_ID=ac.C_AcctSchema_ID) "+ "WHERE ci.AD_Client_ID=?";
  int C_CurrencyTo_ID=Adempiere.getSQLValue(sql,p_AD_Client_ID);
  if (p_C_CurrencyFrom_ID == C_CurrencyTo_ID)   return p_Amount;
  return convert(p_Amount,p_C_CurrencyFrom_ID,C_CurrencyTo_ID,p_ConversionDate,0,p_AD_Client_ID,p_AD_Org_ID);
}

public static BigDecimal base ( BigDecimal p_Amount , int p_C_CurrencyFrom_ID , Timestamp p_ConversionDate , int p_AD_Client_ID , int p_AD_Org_ID ) throws SQLException { if ( p_Amount == null || p_C_CurrencyFrom_ID == 0 ) return null ; if ( p_Amount . signum ( ) == 0 ) return p_Amount ; String sql = "SELECT ac.C_Currency_ID " + "FROM AD_ClientInfo ci" + " INNER JOIN C_AcctSchema ac ON (ci.C_AcctSchema1_ID=ac.C_AcctSchema_ID) " + "WHERE ci.AD_Client_ID=?" ; int C_CurrencyTo_ID = Adempiere . getSQLValue ( sql , p_AD_Client_ID ) ; if ( p_C_CurrencyFrom_ID == C_CurrencyTo_ID ) return p_Amount ; return convert ( p_Amount , p_C_CurrencyFrom_ID , C_CurrencyTo_ID , p_ConversionDate , 0 , p_AD_Client_ID , p_AD_Org_ID ) ; }
convert amount to base currency . ( default conversion type ) previously : c_base_convert - now : currencybase
