/// <summary>
/// Calculate/Set Tax Amt from Order Lines
/// </summary>
/// <returns>true if aclculated</returns>
public bool CalculateTaxFromLines()
{
Decimal taxBaseAmt = Env.ZERO;
Decimal taxAmt = Env.ZERO;
//
bool documentLevel = GetTax().IsDocumentLevel();
MTax tax = GetTax();
// Calculate Tax on TaxAble Amount
String sql = "SELECT TaxAbleAmt FROM C_OrderLine WHERE C_Order_ID=" + GetC_Order_ID() + " AND C_Tax_ID=" + GetC_Tax_ID();
IDataReader idr = null;
try
{
idr = DataBase.DB.ExecuteReader(sql, null, Get_TrxName());
while (idr.Read())
{
Decimal baseAmt = Utility.Util.GetValueOfDecimal(idr[0]);
taxBaseAmt = Decimal.Add(taxBaseAmt, baseAmt);
//
if (!documentLevel) // calculate line tax
{
taxAmt = Decimal.Add(taxAmt, tax.CalculateTax(baseAmt, false, GetPrecision()));
}
}
idr.Close();
}
catch (Exception e)
{
if (idr != null)
{
idr.Close();
}
log.Log(Level.SEVERE, "CalculateTaxFromLines", e);
log.Log(Level.SEVERE, sql, e);
taxBaseAmt = Utility.Util.GetValueOfDecimal(null);
}
// Calculate Tax
if (documentLevel) // document level
{
taxAmt = tax.CalculateTax(taxBaseAmt, false, GetPrecision());
}
SetTaxAmt(taxAmt);
// Set Base
//if (IsTaxIncluded())
// SetTaxBaseAmt(Decimal.Subtract(taxBaseAmt, taxAmt));
//else
SetTaxBaseAmt(taxBaseAmt);
//log.fine(toString());
return(true);
}
/// <summary>
/// Set Amount (Callout)
/// </summary>
/// <param name="windowNo">window</param>
/// <param name="columnName">changed column</param>
private void SetAmt(int windowNo, String columnName)
{
// get values
Decimal qtyEntered = GetQtyEntered();
Decimal priceEntered = GetPriceEntered();
log.Fine("QtyEntered=" + qtyEntered + ", PriceEntered=" + priceEntered);
//if (qtyEntered == null)
//{
// qtyEntered = Env.ZERO;
//}
//if (priceEntered == null)
//{
// priceEntered = Env.ZERO;
//}
// Line Net Amt
Decimal lineNetAmt = Decimal.Multiply(qtyEntered, priceEntered);
int stdPrecision = GetCtx().GetStdPrecision();
if (Env.Scale(lineNetAmt) > stdPrecision)
{
lineNetAmt = Decimal.Round(lineNetAmt, stdPrecision, MidpointRounding.AwayFromZero);
}
// Calculate Tax Amount
Boolean isTaxIncluded = IsTaxIncluded();
Decimal?taxAmt = null;
if (columnName.Equals("TaxAmt"))
{
taxAmt = GetTaxAmt();
}
else
{
int C_Tax_ID = GetC_Tax_ID();
if (C_Tax_ID != 0)
{
MTax tax = new MTax(GetCtx(), C_Tax_ID, null);
taxAmt = tax.CalculateTax(lineNetAmt, isTaxIncluded, stdPrecision);
SetTaxAmt(Convert.ToDecimal(taxAmt));
}
}
if (isTaxIncluded)
{
SetLineTotalAmt(lineNetAmt);
SetLineNetAmt(Decimal.Subtract(lineNetAmt, Convert.ToDecimal(taxAmt)));
}
else
{
SetLineNetAmt(lineNetAmt);
SetLineTotalAmt(Decimal.Subtract(lineNetAmt, Convert.ToDecimal(taxAmt)));
}
}
/**************************************************************************
* Calculate/Set Tax Base Amt from Invoice Lines
* @return true if tax calculated
*/
public bool CalculateTaxFromLines()
{
Decimal?taxBaseAmt = Env.ZERO;
Decimal taxAmt = Env.ZERO;
//
bool documentLevel = GetTax().IsDocumentLevel();
MTax tax = GetTax();
//
String sql = "SELECT il.LineNetAmt, COALESCE(il.TaxAmt,0), i.IsSOTrx "
+ "FROM C_InvoiceLine il"
+ " INNER JOIN C_Invoice i ON (il.C_Invoice_ID=i.C_Invoice_ID) "
+ "WHERE il.C_Invoice_ID=" + GetC_Invoice_ID() + " AND il.C_Tax_ID=" + GetC_Tax_ID();
IDataReader idr = null;
try
{
idr = DataBase.DB.ExecuteReader(sql, null, Get_TrxName());
while (idr.Read())
{
// BaseAmt
Decimal baseAmt = Utility.Util.GetValueOfDecimal(idr[0]);
taxBaseAmt = Decimal.Add((Decimal)taxBaseAmt, baseAmt);
// TaxAmt
Decimal amt = Utility.Util.GetValueOfDecimal(idr[1]);
//if (amt == null)
// amt = Env.ZERO;
bool isSOTrx = "Y".Equals(idr[2].ToString());
//
if (documentLevel || Env.Signum(baseAmt) == 0)
{
amt = Env.ZERO;
}
else if (Env.Signum(amt) != 0 && !isSOTrx) // manually entered
{
;
}
else // calculate line tax
{
amt = tax.CalculateTax(baseAmt, IsTaxIncluded(), GetPrecision());
}
//
taxAmt = Decimal.Add(taxAmt, amt);
}
idr.Close();
}
catch (Exception e)
{
if (idr != null)
{
idr.Close();
}
log.Log(Level.SEVERE, "setTaxBaseAmt", e);
taxBaseAmt = null;
}
if (taxBaseAmt == null)
{
return(false);
}
// Calculate Tax
if (documentLevel || Env.Signum(taxAmt) == 0)
{
taxAmt = tax.CalculateTax((Decimal)taxBaseAmt, IsTaxIncluded(), GetPrecision());
}
SetTaxAmt(taxAmt);
// Set Base
if (IsTaxIncluded())
{
SetTaxBaseAmt(Decimal.Subtract((Decimal)taxBaseAmt, taxAmt));
}
else
{
SetTaxBaseAmt((Decimal)taxBaseAmt);
}
return(true);
}
/// <summary>
/// Calculate/Set Surcharge Tax Amt from Invoice Lines
/// </summary>
/// <returns>true if calculated</returns>
public bool CalculateSurchargeFromLines()
{
Decimal taxBaseAmt = Env.ZERO;
Decimal surTaxAmt = Env.ZERO;
//
MTax surTax = new MTax(GetCtx(), GetC_Tax_ID(), Get_TrxName());
bool documentLevel = surTax.IsDocumentLevel();
//
String sql = "SELECT il.TaxBaseAmt, COALESCE(il.TaxAmt,0), i.IsSOTrx , i.C_Currency_ID , i.DateAcct , i.C_ConversionType_ID, tax.SurchargeType "
+ "FROM C_InvoiceLine il"
+ " INNER JOIN C_Invoice i ON (il.C_Invoice_ID=i.C_Invoice_ID) "
+ " INNER JOIN C_Tax tax ON il.C_Tax_ID=tax.C_Tax_ID "
+ "WHERE il.C_Invoice_ID=" + GetC_Invoice_ID() + " AND tax.Surcharge_Tax_ID=" + GetC_Tax_ID();
IDataReader idr = null;
int c_Currency_ID = 0;
DateTime? dateAcct = null;
int c_ConversionType_ID = 0;
try
{
idr = DataBase.DB.ExecuteReader(sql, null, Get_TrxName());
while (idr.Read())
{
//Get References from invoiice header
c_Currency_ID = Utility.Util.GetValueOfInt(idr[3]);
dateAcct = Utility.Util.GetValueOfDateTime(idr[4]);
c_ConversionType_ID = Utility.Util.GetValueOfInt(idr[5]);
// BaseAmt
Decimal baseAmt = Utility.Util.GetValueOfDecimal(idr[0]);
// TaxAmt
Decimal taxAmt = Utility.Util.GetValueOfDecimal(idr[1]);
string surchargeType = Util.GetValueOfString(idr[6]);
// for Surcharge Calculation type - Line Amount + Tax Amount
if (surchargeType.Equals(MTax.SURCHARGETYPE_LineAmountPlusTax))
{
baseAmt = Decimal.Add(baseAmt, taxAmt);
taxBaseAmt = Decimal.Add(taxBaseAmt, baseAmt);
}
// for Surcharge Calculation type - Line Amount
else if (surchargeType.Equals(MTax.SURCHARGETYPE_LineAmount))
{
taxBaseAmt = Decimal.Add(taxBaseAmt, baseAmt);
}
// for Surcharge Calculation type - Tax Amount
else
{
baseAmt = taxAmt;
taxBaseAmt = Decimal.Add(taxBaseAmt, baseAmt);
}
taxAmt = Env.ZERO;
bool isSOTrx = "Y".Equals(idr[2].ToString());
//
if (documentLevel || Env.Signum(baseAmt) == 0)
{
}
else if (Env.Signum(taxAmt) != 0 && !isSOTrx) // manually entered
{
;
}
else // calculate line tax
{
taxAmt = surTax.CalculateTax(baseAmt, false, GetPrecision());
}
//
surTaxAmt = Decimal.Add(surTaxAmt, taxAmt);
}
idr.Close();
}
catch (Exception e)
{
if (idr != null)
{
idr.Close();
}
log.Log(Level.SEVERE, "setTaxBaseAmt", e);
taxBaseAmt = Util.GetValueOfDecimal(null);
}
// Calculate Tax
if (documentLevel || Env.Signum(surTaxAmt) == 0)
{
surTaxAmt = surTax.CalculateTax(taxBaseAmt, false, GetPrecision());
}
SetTaxAmt(surTaxAmt);
// set Tax Amount in base currency
if (Get_ColumnIndex("TaxBaseCurrencyAmt") >= 0)
{
decimal taxAmtBaseCurrency = GetTaxAmt();
int primaryAcctSchemaCurrency = GetCtx().GetContextAsInt("$C_Currency_ID");
if (c_Currency_ID != primaryAcctSchemaCurrency)
{
taxAmtBaseCurrency = MConversionRate.Convert(GetCtx(), GetTaxAmt(), primaryAcctSchemaCurrency, c_Currency_ID,
dateAcct, c_ConversionType_ID, GetAD_Client_ID(), GetAD_Org_ID());
}
SetTaxBaseCurrencyAmt(taxAmtBaseCurrency);
}
// Set Base
SetTaxBaseAmt(taxBaseAmt);
return(true);
}
/**************************************************************************
* Calculate/Set Tax Base Amt from Invoice Lines
* @return true if tax calculated
*/
public bool CalculateTaxFromLines()
{
Decimal?taxBaseAmt = Env.ZERO;
Decimal taxAmt = Env.ZERO;
//
bool documentLevel = GetTax().IsDocumentLevel();
MTax tax = GetTax();
// Calculate Tax on TaxAble Amount
String sql = "SELECT il.TaxBaseAmt, COALESCE(il.TaxAmt,0), i.IsSOTrx , i.C_Currency_ID , i.DateAcct , i.C_ConversionType_ID "
+ "FROM C_InvoiceLine il"
+ " INNER JOIN C_Invoice i ON (il.C_Invoice_ID=i.C_Invoice_ID) "
+ "WHERE il.C_Invoice_ID=" + GetC_Invoice_ID() + " AND il.C_Tax_ID=" + GetC_Tax_ID();
IDataReader idr = null;
int c_Currency_ID = 0;
DateTime? dateAcct = null;
int c_ConversionType_ID = 0;
try
{
idr = DataBase.DB.ExecuteReader(sql, null, Get_TrxName());
while (idr.Read())
{
//Get References from invoiice header
c_Currency_ID = Utility.Util.GetValueOfInt(idr[3]);
dateAcct = Utility.Util.GetValueOfDateTime(idr[4]);
c_ConversionType_ID = Utility.Util.GetValueOfInt(idr[5]);
// BaseAmt
Decimal baseAmt = Utility.Util.GetValueOfDecimal(idr[0]);
taxBaseAmt = Decimal.Add((Decimal)taxBaseAmt, baseAmt);
// TaxAmt
Decimal amt = Utility.Util.GetValueOfDecimal(idr[1]);
//if (amt == null)
// amt = Env.ZERO;
bool isSOTrx = "Y".Equals(idr[2].ToString());
//
if (documentLevel || Env.Signum(baseAmt) == 0)
{
amt = Env.ZERO;
}
else if (Env.Signum(amt) != 0 && !isSOTrx) // manually entered
{
;
}
else // calculate line tax
{
amt = tax.CalculateTax(baseAmt, false, GetPrecision());
}
//
taxAmt = Decimal.Add(taxAmt, amt);
}
idr.Close();
}
catch (Exception e)
{
if (idr != null)
{
idr.Close();
}
log.Log(Level.SEVERE, "setTaxBaseAmt", e);
log.Log(Level.SEVERE, sql, e);
taxBaseAmt = null;
}
if (taxBaseAmt == null)
{
return(false);
}
// Calculate Tax
if (documentLevel || Env.Signum(taxAmt) == 0)
{
taxAmt = tax.CalculateTax((Decimal)taxBaseAmt, false, GetPrecision());
}
SetTaxAmt(taxAmt);
// set Tax Amount in base currency
if (Get_ColumnIndex("TaxBaseCurrencyAmt") >= 0)
{
decimal taxAmtBaseCurrency = GetTaxAmt();
int primaryAcctSchemaCurrency = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT C_Currency_ID FROM C_AcctSchema WHERE C_AcctSchema_ID =
(SELECT c_acctschema1_id FROM ad_clientinfo WHERE ad_client_id = " + GetAD_Client_ID() + ")", null, Get_Trx()));
if (c_Currency_ID != primaryAcctSchemaCurrency)
{
taxAmtBaseCurrency = MConversionRate.Convert(GetCtx(), GetTaxAmt(), primaryAcctSchemaCurrency, c_Currency_ID,
dateAcct, c_ConversionType_ID, GetAD_Client_ID(), GetAD_Org_ID());
}
SetTaxBaseCurrencyAmt(taxAmtBaseCurrency);
}
// Set Base
//if (IsTaxIncluded())
// SetTaxBaseAmt(Decimal.Subtract((Decimal)taxBaseAmt, taxAmt));
//else
SetTaxBaseAmt((Decimal)taxBaseAmt);
return(true);
}
/// <summary>
/// Calculate Tax and Surcharge
/// </summary>
/// <param name="amount"></param>
/// <param name="taxIncluded">if true tax is calculated from gross otherwise from net </param>
/// <param name="scale"></param>
/// <returns>tax amount</returns>
public Decimal CalculateSurcharge(Decimal amount, Boolean taxIncluded, int scale, out Decimal SurchargeAmt)
{
// Null Tax
SurchargeAmt = Env.ZERO;
Decimal TaxAmt = Env.ZERO;
if (IsZeroTax())
{
return(Env.ZERO);
}
Decimal multiplier = Env.ZERO;
Decimal taxBase = amount;
Decimal taxRate = GetRate();
MTax surTax = MTax.Get(GetCtx(), GetSurcharge_Tax_ID());
Decimal surRate = surTax.GetRate();
// for Surcharge Calculation type - Line Amount + Tax Amount
if (GetSurchargeType() == MTax.SURCHARGETYPE_LineAmountPlusTax)
{
if (!taxIncluded) // $100 * 6 / 100 == $6 == $100 * 0.06
{
// Calculate Tax Amount on Line Amount
multiplier = Decimal.Round(Decimal.Divide(taxRate, 100), 12, MidpointRounding.AwayFromZero);
TaxAmt = Decimal.Multiply(amount, multiplier);
// Calculate Surcharge Tax Amount on Line Amount + Tax Amount
amount = amount + TaxAmt;
multiplier = Decimal.Round(Decimal.Divide(surRate, 100), 12, MidpointRounding.AwayFromZero);
SurchargeAmt = Decimal.Multiply(amount, multiplier);
TaxAmt = Decimal.Round(TaxAmt, scale, MidpointRounding.AwayFromZero);
SurchargeAmt = Decimal.Round(SurchargeAmt, scale, MidpointRounding.AwayFromZero);
}
else // $106 - ($106 / (100+6)/100) == $6 == $106 - ($106/1.06)
{
multiplier = Decimal.Round(Decimal.Divide(surRate, 100), 12, MidpointRounding.AwayFromZero);
multiplier = Decimal.Add(multiplier, Env.ONE);
taxBase = Decimal.Divide(amount, multiplier);
taxBase = Decimal.Round(taxBase, 12, MidpointRounding.AwayFromZero);
amount = taxBase;
multiplier = Decimal.Round(Decimal.Divide(taxRate, 100), 12, MidpointRounding.AwayFromZero);
multiplier = Decimal.Add(multiplier, Env.ONE);
taxBase = Decimal.Divide(amount, multiplier);
TaxAmt = CalculateTax(taxBase, false, scale);
SurchargeAmt = surTax.CalculateTax(Decimal.Add(taxBase, TaxAmt), false, scale);
}
}
// for Surcharge Calculation type - Line Amount
else if (GetSurchargeType() == MTax.SURCHARGETYPE_LineAmount)
{
if (!taxIncluded) // $100 * 6 / 100 == $6 == $100 * 0.06
{
// Calculate Tax Amount on Line Amount
multiplier = Decimal.Round(Decimal.Divide(taxRate, 100), 12, MidpointRounding.AwayFromZero);
TaxAmt = Decimal.Multiply(amount, multiplier);
TaxAmt = Decimal.Round(TaxAmt, scale, MidpointRounding.AwayFromZero);
// Calculate Surcharge Tax Amount on Line Amount
multiplier = Decimal.Round(Decimal.Divide(surRate, 100), 12, MidpointRounding.AwayFromZero);
SurchargeAmt = Decimal.Multiply(amount, multiplier);
SurchargeAmt = Decimal.Round(SurchargeAmt, scale, MidpointRounding.AwayFromZero);
}
else // $106 - ($106 / (100+6)/100) == $6 == $106 - ($106/1.06)
{
multiplier = Decimal.Round(Decimal.Divide(Decimal.Add(taxRate, surRate), 100), 12, MidpointRounding.AwayFromZero);
multiplier = Decimal.Add(multiplier, Env.ONE);
taxBase = Decimal.Divide(amount, multiplier);
taxBase = Decimal.Round(taxBase, 12, MidpointRounding.AwayFromZero);
TaxAmt = CalculateTax(taxBase, false, scale);
SurchargeAmt = surTax.CalculateTax(taxBase, false, scale);
}
}
// for Surcharge Calculation type - Tax Amount
else
{
if (!taxIncluded) // $100 * 6 / 100 == $6 == $100 * 0.06
{
// Calculate Tax Amount on Line Amount
multiplier = Decimal.Round(Decimal.Divide(taxRate, 100), 12, MidpointRounding.AwayFromZero);
TaxAmt = Decimal.Multiply(amount, multiplier);
// Calculate Surcharge Tax Amount on Line Amount + Tax Amount
multiplier = Decimal.Round(Decimal.Divide(surRate, 100), 12, MidpointRounding.AwayFromZero);
SurchargeAmt = Decimal.Multiply(TaxAmt, multiplier);
TaxAmt = Decimal.Round(TaxAmt, scale, MidpointRounding.AwayFromZero);
SurchargeAmt = Decimal.Round(SurchargeAmt, scale, MidpointRounding.AwayFromZero);
}
else // $106 - ($106 / (100+6)/100) == $6 == $106 - ($106/1.06)
{
multiplier = Decimal.Round(Decimal.Divide(surRate, 100), 12, MidpointRounding.AwayFromZero);
multiplier = Decimal.Multiply(taxRate, multiplier);
multiplier = Decimal.Add(taxRate, multiplier);
multiplier = Decimal.Round(Decimal.Divide(multiplier, 100), 12, MidpointRounding.AwayFromZero);
multiplier = Decimal.Add(multiplier, Env.ONE);
taxBase = Decimal.Divide(amount, multiplier);
taxBase = Decimal.Round(taxBase, 12, MidpointRounding.AwayFromZero);
TaxAmt = CalculateTax(taxBase, false, scale);
SurchargeAmt = surTax.CalculateTax(TaxAmt, false, scale);
}
}
return(TaxAmt);
}
/// <summary>
/// Calculate/Set Surcharge Tax Amt from Order Lines
/// </summary>
/// <returns>true if calculated</returns>
public bool CalculateSurchargeFromLines()
{
Decimal taxBaseAmt = Env.ZERO;
Decimal surTaxAmt = Env.ZERO;
//
MTax surTax = new MTax(GetCtx(), GetC_Tax_ID(), Get_TrxName());
bool documentLevel = surTax.IsDocumentLevel();
//
String sql = "SELECT ol.TaxAbleAmt, ol.TaxAmt, tax.SurchargeType FROM C_OrderLine ol"
+ " INNER JOIN C_Tax tax ON ol.C_Tax_ID=tax.C_Tax_ID WHERE ol.C_Order_ID=" + GetC_Order_ID()
+ " AND tax.Surcharge_Tax_ID=" + GetC_Tax_ID();
IDataReader idr = null;
try
{
idr = DataBase.DB.ExecuteReader(sql, null, Get_TrxName());
while (idr.Read())
{
Decimal baseAmt = Util.GetValueOfDecimal(idr[0]);
Decimal taxAmt = Util.GetValueOfDecimal(idr[1]);
string surchargeType = Util.GetValueOfString(idr[2]);
// for Surcharge Calculation type - Line Amount + Tax Amount
if (surchargeType.Equals(MTax.SURCHARGETYPE_LineAmountPlusTax))
{
baseAmt = Decimal.Add(baseAmt, taxAmt);
taxBaseAmt = Decimal.Add(taxBaseAmt, baseAmt);
}
// for Surcharge Calculation type - Line Amount
else if (surchargeType.Equals(MTax.SURCHARGETYPE_LineAmount))
{
taxBaseAmt = Decimal.Add(taxBaseAmt, baseAmt);
}
// for Surcharge Calculation type - Tax Amount
else
{
baseAmt = taxAmt;
taxBaseAmt = Decimal.Add(taxBaseAmt, baseAmt);
}
//
if (!documentLevel) // calculate Surcharge tax
{
surTaxAmt = Decimal.Add(surTaxAmt, surTax.CalculateTax(baseAmt, false, GetPrecision()));
}
}
idr.Close();
}
catch (Exception e)
{
if (idr != null)
{
idr.Close();
}
log.Log(Level.SEVERE, "CalculateSurchargeFromLines", e);
taxBaseAmt = Utility.Util.GetValueOfDecimal(null);
}
// Calculate Tax
if (documentLevel) // document level
{
surTaxAmt = surTax.CalculateTax(taxBaseAmt, false, GetPrecision());
}
SetTaxAmt(surTaxAmt);
SetTaxBaseAmt(taxBaseAmt);
return(true);
}
