} // afterSave
/// <summary>
/// This function is used to set Values on Recognition Plan
/// </summary>
/// <param name="invoiceLine">invoice line object </param>
/// <param name="invoice">invoice object</param>
/// <param name="C_RevenueRecognition_ID">Recognition ID</param>
/// <param name="ToCurrency">Currency</param>
public void SetRecognitionPlan(MInvoiceLine invoiceLine, MInvoice invoice, int C_RevenueRecognition_ID, int ToCurrency)
{
SetAD_Client_ID(invoice.GetAD_Client_ID());
SetAD_Org_ID(invoice.GetAD_Org_ID());
SetC_Currency_ID(ToCurrency);
SetC_InvoiceLine_ID(invoiceLine.GetC_InvoiceLine_ID());
SetC_RevenueRecognition_ID(C_RevenueRecognition_ID);
// when tax include into price list, then reduce tax from Line Net Amount
bool isTaxIncide = (new MPriceList(invoice.GetCtx(), invoice.GetM_PriceList_ID(), invoice.Get_Trx())).IsTaxIncluded();
Decimal Amount = invoiceLine.GetLineNetAmt() - (isTaxIncide ? (invoiceLine.GetTaxAmt() + invoiceLine.GetSurchargeAmt()) : 0);
if (invoice.GetC_Currency_ID() != ToCurrency)
{
Amount = MConversionRate.Convert(GetCtx(), Amount, invoice.GetC_Currency_ID(), ToCurrency, invoice.GetDateInvoiced(), invoice.GetC_ConversionType_ID(), invoice.GetAD_Client_ID(), invoice.GetAD_Org_ID());
}
SetTotalAmt(Amount);
SetRecognizedAmt(Env.ZERO);
}
/// <summary>
/// After Save
/// </summary>
/// <param name="newRecord"></param>
/// <param name="success"></param>
/// <returns>Success</returns>
///
public void SetRecognitionPlan(MInvoiceLine invoiceLine, MInvoice invoice, int C_RevenueRecognition_ID)
{
try
{
SetAD_Client_ID(invoice.GetAD_Client_ID());
SetAD_Org_ID(invoice.GetAD_Org_ID());
SetC_Currency_ID(invoice.GetC_Currency_ID());
SetC_InvoiceLine_ID(invoiceLine.GetC_InvoiceLine_ID());
SetC_RevenueRecognition_ID(C_RevenueRecognition_ID);
SetP_Revenue_Acct(0);
SetUnEarnedRevenue_Acct(0);
SetTotalAmt(invoiceLine.GetLineNetAmt());
SetRecognizedAmt(Env.ZERO);
}
catch (Exception ex)
{
// MessageBox.Show("MInvoiceLine--SetInvoice");
}
}
public static bool InsertForeignCostMatchInvoice(Ctx ctx, MInvoiceLine invoiceLine, decimal matchQty, int ASI, Trx trx)
{
int acctSchema_ID = 0;
int M_CostElement_ID = 0;
int AD_Org_ID = 0;
int M_ASI_ID = 0;
MProduct product = null;
MAcctSchema acctSchema = null;
MCostForeignCurrency foreignCost = null;
dynamic pc = null;
String cl = null;
MInvoice invoice = null;
try
{
// if cost is calculated then not to calculate again
if (invoiceLine.IsFutureCostCalculated())
{
return(true);
}
invoice = new MInvoice(ctx, invoiceLine.GetC_Invoice_ID(), trx);
if (!invoice.IsSOTrx() && !invoice.IsReturnTrx())
{
acctSchema_ID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT asch.c_acctschema_id FROM c_acctschema asch INNER JOIN ad_clientinfo ci
ON ci.c_acctschema1_id = asch.c_acctschema_id WHERE ci.ad_client_id = " + invoice.GetAD_Client_ID()));
acctSchema = new MAcctSchema(ctx, acctSchema_ID, trx);
if (acctSchema.GetC_Currency_ID() != invoice.GetC_Currency_ID())
{
// Get Costing Element of Av. Invoice
M_CostElement_ID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT M_CostElement_ID FROM M_CostElement WHERE AD_Client_ID = "
+ invoice.GetAD_Client_ID() + " AND IsActive = 'Y' AND CostingMethod = 'I'"));
product = new MProduct(ctx, invoiceLine.GetM_Product_ID(), trx);
if (product != null && product.GetProductType() == "I" && product.GetM_Product_ID() > 0) // for Item Type product
{
pc = MProductCategory.Get(product.GetCtx(), product.GetM_Product_Category_ID());
// Get Costing Level
if (pc != null)
{
cl = pc.GetCostingLevel();
}
if (cl == null)
{
cl = acctSchema.GetCostingLevel();
}
if (cl == "C" || cl == "B")
{
AD_Org_ID = 0;
}
else
{
AD_Org_ID = invoice.GetAD_Org_ID();
}
if (cl != "B")
{
M_ASI_ID = 0;
}
else
{
M_ASI_ID = ASI;
}
foreignCost = MCostForeignCurrency.Get(product, M_ASI_ID, AD_Org_ID, M_CostElement_ID, invoice.GetC_BPartner_ID(), invoice.GetC_Currency_ID());
foreignCost.SetC_Invoice_ID(invoice.GetC_Invoice_ID());
foreignCost.SetCumulatedQty(Decimal.Add(foreignCost.GetCumulatedQty(), matchQty));
foreignCost.SetCumulatedAmt(Decimal.Add(foreignCost.GetCumulatedAmt(), Decimal.Multiply(invoiceLine.GetPriceActual(), matchQty)));
if (foreignCost.GetCumulatedQty() != 0)
{
foreignCost.SetCostPerUnit(Decimal.Round(Decimal.Divide(foreignCost.GetCumulatedAmt(), foreignCost.GetCumulatedQty()), acctSchema.GetCostingPrecision()));
}
else
{
foreignCost.SetCostPerUnit(0);
}
if (!foreignCost.Save(trx))
{
ValueNamePair pp = VLogger.RetrieveError();
_log.Severe("Error occured during updating M_Cost_ForeignCurrency. Error name : " + pp.GetName() +
" AND Error Value : " + pp.GetValue() + " , For Invoice line : " + invoiceLine.GetC_InvoiceLine_ID() +
" , AND Ad_Client_ID : " + invoiceLine.GetAD_Client_ID());
return(false);
}
}
}
}
}
catch (Exception ex)
{
_log.Log(Level.SEVERE, "", ex);
return(false);
}
return(true);
}
public bool SetProductQty(int recordID, string keyColName, List <string> product, List <string> attribute, List <string> qty, List <string> qtybook, List <string> oline_ID, int ordID, List <string> locID, int lineID, VAdvantage.Utility.Ctx ctx)
{
if (keyColName.ToUpper().Trim() == "C_ORDER_ID")
{
MOrder ord = new MOrder(ctx, recordID, null);
for (int i = 0; i < product.Count; i++)
{
MOrderLine oline = new MOrderLine(ctx, lineID, null);
oline.SetAD_Client_ID(ord.GetAD_Client_ID());
oline.SetAD_Org_ID(ord.GetAD_Org_ID());
oline.SetM_Product_ID(Util.GetValueOfInt(product[i]));
oline.SetQty(Util.GetValueOfDecimal(qty[i]));
oline.SetC_Order_ID(recordID);
if (Util.GetValueOfInt(attribute[i]) != 0)
{
oline.SetM_AttributeSetInstance_ID(Util.GetValueOfInt(attribute[i]));
}
if (!ord.IsSOTrx())
{
MProduct pro = new MProduct(ctx, oline.GetM_Product_ID(), null);
String qryUom = "SELECT vdr.C_UOM_ID FROM M_Product p LEFT JOIN M_Product_Po vdr ON p.M_Product_ID= vdr.M_Product_ID WHERE p.M_Product_ID=" + oline.GetM_Product_ID() + " AND vdr.C_BPartner_ID = " + ord.GetC_BPartner_ID();
int uom = Util.GetValueOfInt(DB.ExecuteScalar(qryUom));
if (pro.GetC_UOM_ID() != 0)
{
if (pro.GetC_UOM_ID() != uom && uom != 0)
{
decimal?Res = Util.GetValueOfDecimal(DB.ExecuteScalar("SELECT trunc(multiplyrate,4) FROM C_UOM_Conversion WHERE C_UOM_ID = " + pro.GetC_UOM_ID() + " AND C_UOM_To_ID = " + uom + " AND M_Product_ID= " + oline.GetM_Product_ID() + " AND IsActive='Y'"));
if (Res > 0)
{
oline.SetQtyEntered(oline.GetQtyEntered() * Res);
//OrdQty = MUOMConversion.ConvertProductTo(GetCtx(), _M_Product_ID, UOM, OrdQty);
}
else
{
decimal?res = Util.GetValueOfDecimal(DB.ExecuteScalar("SELECT trunc(multiplyrate,4) FROM C_UOM_Conversion WHERE C_UOM_ID = " + pro.GetC_UOM_ID() + " AND C_UOM_To_ID = " + uom + " AND IsActive='Y'"));
if (res > 0)
{
oline.SetQtyEntered(oline.GetQtyEntered() * res);
//OrdQty = MUOMConversion.Convert(GetCtx(), prdUOM, UOM, OrdQty);
}
}
oline.SetC_UOM_ID(uom);
}
else
{
oline.SetC_UOM_ID(pro.GetC_UOM_ID());
}
}
}
if (!oline.Save())
{
}
}
}
else if (keyColName.ToUpper().Trim() == "C_INVOICE_ID")
{
MInvoice inv = new MInvoice(ctx, recordID, null);
for (int i = 0; i < product.Count; i++)
{
MInvoiceLine invline = new MInvoiceLine(ctx, lineID, null);
invline.SetAD_Client_ID(inv.GetAD_Client_ID());
invline.SetAD_Org_ID(inv.GetAD_Org_ID());
invline.SetM_Product_ID(Util.GetValueOfInt(product[i]));
invline.SetQty(Util.GetValueOfDecimal(qty[i]));
invline.SetC_Invoice_ID(recordID);
if (Util.GetValueOfInt(attribute[i]) != 0)
{
invline.SetM_AttributeSetInstance_ID(Util.GetValueOfInt(attribute[i]));
}
if (!inv.IsSOTrx())
{
MProduct pro = new MProduct(ctx, invline.GetM_Product_ID(), null);
String qryUom = "SELECT vdr.C_UOM_ID FROM M_Product p LEFT JOIN M_Product_Po vdr ON p.M_Product_ID= vdr.M_Product_ID WHERE p.M_Product_ID=" + invline.GetM_Product_ID() + " AND vdr.C_BPartner_ID = " + inv.GetC_BPartner_ID();
int uom = Util.GetValueOfInt(DB.ExecuteScalar(qryUom));
if (pro.GetC_UOM_ID() != 0)
{
if (pro.GetC_UOM_ID() != uom && uom != 0)
{
decimal?Res = Util.GetValueOfDecimal(DB.ExecuteScalar("SELECT trunc(multiplyrate,4) FROM C_UOM_Conversion WHERE C_UOM_ID = " + pro.GetC_UOM_ID() + " AND C_UOM_To_ID = " + uom + " AND M_Product_ID= " + invline.GetM_Product_ID() + " AND IsActive='Y'"));
if (Res > 0)
{
invline.SetQtyEntered(invline.GetQtyEntered() * Res);
//OrdQty = MUOMConversion.ConvertProductTo(GetCtx(), _M_Product_ID, UOM, OrdQty);
}
else
{
decimal?res = Util.GetValueOfDecimal(DB.ExecuteScalar("SELECT trunc(multiplyrate,4) FROM C_UOM_Conversion WHERE C_UOM_ID = " + pro.GetC_UOM_ID() + " AND C_UOM_To_ID = " + uom + " AND IsActive='Y'"));
if (res > 0)
{
invline.SetQtyEntered(invline.GetQtyEntered() * res);
//OrdQty = MUOMConversion.Convert(GetCtx(), prdUOM, UOM, OrdQty);
}
}
invline.SetC_UOM_ID(uom);
}
else
{
invline.SetC_UOM_ID(pro.GetC_UOM_ID());
}
}
}
if (!invline.Save())
{
}
}
}
else if (keyColName.ToUpper().Trim() == "M_INOUT_ID")
{
MInOut inv = new MInOut(ctx, recordID, null);
if (ordID > 0)
{
inv.SetC_Order_ID(ordID);
}
if (inv.Save())
{
for (int i = 0; i < product.Count; i++)
{
MInOutLine ioline = new MInOutLine(ctx, lineID, null);
ioline.SetAD_Client_ID(inv.GetAD_Client_ID());
ioline.SetAD_Org_ID(inv.GetAD_Org_ID());
ioline.SetM_Product_ID(Util.GetValueOfInt(product[i]));
ioline.SetQty(Util.GetValueOfDecimal(qty[i]));
ioline.SetM_InOut_ID(recordID);
ioline.SetC_OrderLine_ID(Util.GetValueOfInt(oline_ID[i]));
ioline.SetM_Locator_ID(Util.GetValueOfInt(locID[i]));
if (Util.GetValueOfInt(attribute[i]) != 0)
{
ioline.SetM_AttributeSetInstance_ID(Util.GetValueOfInt(attribute[i]));
}
if (!inv.IsSOTrx())
{
MProduct pro = new MProduct(ctx, ioline.GetM_Product_ID(), null);
String qryUom = "SELECT vdr.C_UOM_ID FROM M_Product p LEFT JOIN M_Product_Po vdr ON p.M_Product_ID= vdr.M_Product_ID WHERE p.M_Product_ID=" + ioline.GetM_Product_ID() + " AND vdr.C_BPartner_ID = " + inv.GetC_BPartner_ID();
int uom = Util.GetValueOfInt(DB.ExecuteScalar(qryUom));
if (pro.GetC_UOM_ID() != 0)
{
if (pro.GetC_UOM_ID() != uom && uom != 0)
{
decimal?Res = Util.GetValueOfDecimal(DB.ExecuteScalar("SELECT trunc(multiplyrate,4) FROM C_UOM_Conversion WHERE C_UOM_ID = " + pro.GetC_UOM_ID() + " AND C_UOM_To_ID = " + uom + " AND M_Product_ID= " + ioline.GetM_Product_ID() + " AND IsActive='Y'"));
if (Res > 0)
{
ioline.SetQtyEntered(ioline.GetQtyEntered() * Res);
//OrdQty = MUOMConversion.ConvertProductTo(GetCtx(), _M_Product_ID, UOM, OrdQty);
}
else
{
decimal?res = Util.GetValueOfDecimal(DB.ExecuteScalar("SELECT trunc(multiplyrate,4) FROM C_UOM_Conversion WHERE C_UOM_ID = " + pro.GetC_UOM_ID() + " AND C_UOM_To_ID = " + uom + " AND IsActive='Y'"));
if (res > 0)
{
ioline.SetQtyEntered(ioline.GetQtyEntered() * res);
//OrdQty = MUOMConversion.Convert(GetCtx(), prdUOM, UOM, OrdQty);
}
}
ioline.SetC_UOM_ID(uom);
}
else
{
ioline.SetC_UOM_ID(pro.GetC_UOM_ID());
}
}
}
if (!ioline.Save())
{
}
}
}
}
else if (keyColName.ToUpper().Trim() == "M_PACKAGE_ID")
{
MPackage pkg = new MPackage(ctx, recordID, null);
for (int i = 0; i < product.Count; i++)
{
MPackageLine mline = new MPackageLine(ctx, lineID, null);
mline.SetAD_Client_ID(pkg.GetAD_Client_ID());
mline.SetAD_Org_ID(pkg.GetAD_Org_ID());
mline.SetM_Product_ID(Util.GetValueOfInt(product[i]));
mline.SetQty(Util.GetValueOfDecimal(qty[i]));
if (Util.GetValueOfInt(oline_ID[i]) > 0)
{
mline.SetM_MovementLine_ID(Util.GetValueOfInt(oline_ID[i]));
MMovementLine mov = new MMovementLine(ctx, Util.GetValueOfInt(oline_ID[i]), null);
mline.SetDTD001_TotalQty(mov.GetMovementQty());
}
if (Util.GetValueOfInt(attribute[i]) != 0)
{
mline.SetM_AttributeSetInstance_ID(Util.GetValueOfInt(attribute[i]));
}
mline.SetM_Package_ID(recordID);
if (!mline.Save())
{
}
}
}
else if (keyColName.ToUpper().Trim() == "M_INVENTORY_ID")
{
MInventory inv = new MInventory(ctx, recordID, null);
for (int i = 0; i < product.Count; i++)
{
MInventoryLine invline = new MInventoryLine(ctx, lineID, null);
invline.SetAD_Client_ID(inv.GetAD_Client_ID());
invline.SetAD_Org_ID(inv.GetAD_Org_ID());
invline.SetM_Locator_ID(Util.GetValueOfInt(locID[i]));
invline.SetM_Product_ID(Util.GetValueOfInt(product[i]));
invline.SetQtyCount(Util.GetValueOfDecimal(qty[i]));
invline.SetQtyBook(Util.GetValueOfDecimal(qtybook[i]));
invline.SetAsOnDateCount(Util.GetValueOfDecimal(qty[i]));
invline.SetOpeningStock(Util.GetValueOfDecimal(qtybook[i]));
invline.SetM_Inventory_ID(recordID);
if (Util.GetValueOfInt(attribute[i]) != 0)
{
invline.SetM_AttributeSetInstance_ID(Util.GetValueOfInt(attribute[i]));
}
else
{
invline.SetM_AttributeSetInstance_ID(0);
}
if (!invline.Save())
{
}
}
}
return(true);
}
/**
* Apply Payment Term with schedule to Invoice
* @param invoice invoice
* @return true if payment schedule is valid
*/
private bool ApplySchedule(MInvoice invoice)
{
DeleteInvoicePaySchedule(invoice.GetC_Invoice_ID(), invoice.Get_TrxName());
// Create Schedule
MInvoicePaySchedule ips = null;
Decimal remainder = invoice.GetGrandTotal();
for (int i = 0; i < _schedule.Length; i++)
{
ips = new MInvoicePaySchedule(invoice, _schedule[i]);
//int _CountVA009 = Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(AD_MODULEINFO_ID) FROM AD_MODULEINFO WHERE PREFIX='VA009_' AND IsActive = 'Y'"));
//if (_CountVA009 > 0)
//{
// ips.SetVA009_ExecutionStatus("A");
// ips.SetC_DocType_ID(invoice.GetC_DocType_ID());
//}
int _CountVA009 = Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(AD_MODULEINFO_ID) FROM AD_MODULEINFO WHERE PREFIX='VA009_' AND IsActive = 'Y'"));
if (_CountVA009 > 0)
{
ips.SetVA009_ExecutionStatus("A");
ips.SetC_DocType_ID(invoice.GetC_DocType_ID());
MOrder _Order = new MOrder(GetCtx(), invoice.GetC_Order_ID(), Get_TrxName());
ips.SetVA009_PaymentMethod_ID(invoice.GetVA009_PaymentMethod_ID());
ips.SetC_PaymentTerm_ID(invoice.GetC_PaymentTerm_ID());
ips.SetVA009_GrandTotal(invoice.GetGrandTotal());
MPaymentTerm payterm = new MPaymentTerm(GetCtx(), invoice.GetC_PaymentTerm_ID(), Get_TrxName());
int _graceDay = payterm.GetGraceDays();
//DateTime? _followUpDay = GetDueDate(invoice);
ips.SetVA009_FollowupDate(ips.GetDueDate().Value.AddDays(_graceDay));
//ips.SetVA009_PlannedDueDate(GetDueDate(invoice));
ips.SetVA009_PlannedDueDate(ips.GetDueDate());
//ips.SetDueDate(GetDueDate(invoice));
//change by amit 25-11-2015
StringBuilder _sql = new StringBuilder();
_sql.Clear();
_sql.Append(@"SELECT UNIQUE asch.C_Currency_ID FROM c_acctschema asch INNER JOIN ad_clientinfo ci ON ci.c_acctschema1_id = asch.c_acctschema_id
INNER JOIN ad_client c ON c.ad_client_id = ci.ad_client_id INNER JOIN c_invoice i ON c.ad_client_id = i.ad_client_id
WHERE i.ad_client_id = " + invoice.GetAD_Client_ID());
int BaseCurrency = Util.GetValueOfInt(DB.ExecuteScalar(_sql.ToString(), null, null));
if (BaseCurrency != invoice.GetC_Currency_ID())
{
_sql.Clear();
_sql.Append(@"SELECT multiplyrate FROM c_conversion_rate WHERE AD_Client_ID = " + invoice.GetAD_Client_ID() + " AND c_currency_id = " + invoice.GetC_Currency_ID() +
" AND c_currency_to_id = " + BaseCurrency + " AND " + GlobalVariable.TO_DATE(invoice.GetDateAcct(), true) + " BETWEEN ValidFrom AND ValidTo");
decimal multiplyRate = Util.GetValueOfDecimal(DB.ExecuteScalar(_sql.ToString(), null, null));
if (multiplyRate == 0)
{
_sql.Clear();
_sql.Append(@"SELECT dividerate FROM c_conversion_rate WHERE AD_Client_ID = " + invoice.GetAD_Client_ID() + " AND c_currency_id = " + BaseCurrency +
" AND c_currency_to_id = " + invoice.GetC_Currency_ID() + " AND " + GlobalVariable.TO_DATE(invoice.GetDateAcct(), true) + " BETWEEN ValidFrom AND ValidTo");
multiplyRate = Util.GetValueOfDecimal(DB.ExecuteScalar(_sql.ToString(), null, null));
}
ips.SetVA009_OpenAmnt(ips.GetDueAmt() * multiplyRate);
}
else
{
ips.SetVA009_OpenAmnt(ips.GetDueAmt());
}
ips.SetC_Currency_ID(invoice.GetC_Currency_ID());
ips.SetVA009_BseCurrncy(BaseCurrency);
ips.SetVA009_OpnAmntInvce(ips.GetDueAmt());
ips.SetC_BPartner_ID(invoice.GetC_BPartner_ID());
//end
string sql = "Select va009_paymentmode, va009_paymenttype, va009_paymenttrigger From va009_paymentmethod where va009_paymentmethod_ID=" + invoice.GetVA009_PaymentMethod_ID() + " AND IsActive = 'Y' AND AD_Client_ID = " + invoice.GetAD_Client_ID();
DataSet ds = new DataSet();
ds = DB.ExecuteDataset(sql);
if (ds.Tables != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
{
ips.SetVA009_PaymentMode(Util.GetValueOfString(ds.Tables[0].Rows[j]["va009_paymentmode"]));
ips.SetVA009_PaymentType(Util.GetValueOfString(ds.Tables[0].Rows[j]["va009_paymenttype"]));
ips.SetVA009_PaymentTrigger(Util.GetValueOfString(ds.Tables[0].Rows[j]["va009_paymenttrigger"]));
ips.SetVA009_ExecutionStatus("A");
}
}
}
ips.Save(invoice.Get_TrxName());
log.Fine(ips.ToString());
remainder = Decimal.Subtract(remainder, ips.GetDueAmt());
} // for all schedules
// Remainder - update last
if (remainder.CompareTo(Env.ZERO) != 0 && ips != null)
{
ips.SetDueAmt(Decimal.Add(ips.GetDueAmt(), remainder));
ips.Save(invoice.Get_TrxName());
log.Fine("Remainder=" + remainder + " - " + ips);
}
// updateInvoice
if (invoice.GetC_PaymentTerm_ID() != GetC_PaymentTerm_ID())
{
invoice.SetC_PaymentTerm_ID(GetC_PaymentTerm_ID());
}
return(invoice.ValidatePaySchedule());
}
/**
* Apply Payment Term without schedule to Invoice
* @param invoice invoice
* @return false as no payment schedule
*/
private bool ApplyNoSchedule(MInvoice invoice)
{
DeleteInvoicePaySchedule(invoice.GetC_Invoice_ID(), invoice.Get_TrxName());
// updateInvoice
if (invoice.GetC_PaymentTerm_ID() != GetC_PaymentTerm_ID())
{
invoice.SetC_PaymentTerm_ID(GetC_PaymentTerm_ID());
}
if (invoice.IsPayScheduleValid())
{
invoice.SetIsPayScheduleValid(false);
}
//----------------Anuj------11/09/2015------------------------
int _CountVA009 = Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(AD_MODULEINFO_ID) FROM AD_MODULEINFO WHERE PREFIX='VA009_' AND IsActive = 'Y'"));
if (_CountVA009 > 0)
{
StringBuilder _sql = new StringBuilder();
MInvoicePaySchedule schedule = new MInvoicePaySchedule(GetCtx(), 0, Get_TrxName());
MPaymentTerm payterm = new MPaymentTerm(GetCtx(), invoice.GetC_PaymentTerm_ID(), Get_TrxName());
schedule.SetAD_Client_ID(invoice.GetAD_Client_ID());
schedule.SetAD_Org_ID(invoice.GetAD_Org_ID());
schedule.SetC_Invoice_ID(invoice.GetC_Invoice_ID());
schedule.SetC_DocType_ID(invoice.GetC_DocType_ID());
schedule.SetC_PaymentTerm_ID(invoice.GetC_PaymentTerm_ID());
schedule.SetVA009_GrandTotal(invoice.GetGrandTotal());
schedule.SetVA009_PaymentMethod_ID(invoice.GetVA009_PaymentMethod_ID());
schedule.SetDueDate(GetDueDate(invoice));
schedule.SetDueAmt(invoice.GetGrandTotal());
schedule.SetDiscountDate(invoice.GetDateInvoiced().Value.AddDays(Util.GetValueOfInt(payterm.GetDiscountDays())));
schedule.SetDiscountAmt((Util.GetValueOfDecimal((invoice.GetGrandTotal() * payterm.GetDiscount()) / 100)));
schedule.SetDiscountDays2(invoice.GetDateInvoiced().Value.AddDays(Util.GetValueOfInt(payterm.GetDiscountDays2())));
schedule.SetDiscount2((Util.GetValueOfDecimal((invoice.GetGrandTotal() * payterm.GetDiscount2()) / 100)));
schedule.SetVA009_PlannedDueDate(GetDueDate(invoice));
_sql.Clear();
_sql.Append(@"SELECT UNIQUE asch.C_Currency_ID FROM c_acctschema asch INNER JOIN ad_clientinfo ci ON ci.c_acctschema1_id = asch.c_acctschema_id
INNER JOIN ad_client c ON c.ad_client_id = ci.ad_client_id INNER JOIN c_invoice i ON c.ad_client_id = i.ad_client_id
WHERE i.ad_client_id = " + invoice.GetAD_Client_ID());
int BaseCurrency = Util.GetValueOfInt(DB.ExecuteScalar(_sql.ToString(), null, null));
if (BaseCurrency != invoice.GetC_Currency_ID())
{
// change by amit
_sql.Clear();
_sql.Append(@"SELECT multiplyrate FROM c_conversion_rate WHERE AD_Client_ID = " + GetCtx().GetAD_Client_ID() + " AND c_currency_id = " + invoice.GetC_Currency_ID() +
" AND c_currency_to_id = " + BaseCurrency + " AND " + GlobalVariable.TO_DATE(invoice.GetDateAcct(), true) + " BETWEEN ValidFrom AND ValidTo");
decimal multiplyRate = Util.GetValueOfDecimal(DB.ExecuteScalar(_sql.ToString(), null, null));
if (multiplyRate == 0)
{
_sql.Clear();
_sql.Append(@"SELECT dividerate FROM c_conversion_rate WHERE AD_Client_ID = " + GetCtx().GetAD_Client_ID() + " AND c_currency_id = " + BaseCurrency +
" AND c_currency_to_id = " + invoice.GetC_Currency_ID() + " AND " + GlobalVariable.TO_DATE(invoice.GetDateAcct(), true) + " BETWEEN ValidFrom AND ValidTo");
multiplyRate = Util.GetValueOfDecimal(DB.ExecuteScalar(_sql.ToString(), null, null));
}
schedule.SetVA009_OpenAmnt(invoice.GetGrandTotal() * multiplyRate);
}
else
{
schedule.SetVA009_OpenAmnt(invoice.GetGrandTotal());
}
schedule.SetC_Currency_ID(invoice.GetC_Currency_ID());
schedule.SetVA009_BseCurrncy(BaseCurrency);
schedule.SetVA009_OpnAmntInvce(invoice.GetGrandTotal());
schedule.SetC_BPartner_ID(invoice.GetC_BPartner_ID());
MOrder _Order = new MOrder(GetCtx(), invoice.GetC_Order_ID(), Get_TrxName());
//schedule.SetVA009_PaymentMethod_ID(_Order.GetVA009_PaymentMethod_ID());
//schedule.SetC_PaymentTerm_ID(_Order.GetC_PaymentTerm_ID());
int _graceDay = payterm.GetGraceDays();
DateTime?_followUpDay = GetDueDate(invoice);
schedule.SetVA009_FollowupDate(_followUpDay.Value.AddDays(_graceDay));
_sql.Clear();
_sql.Append("Select va009_paymentmode, va009_paymenttype, va009_paymenttrigger From va009_paymentmethod where va009_paymentmethod_ID=" + invoice.GetVA009_PaymentMethod_ID() + " AND IsActive = 'Y' AND AD_Client_ID = " + invoice.GetAD_Client_ID());
DataSet ds = new DataSet();
ds = DB.ExecuteDataset(_sql.ToString());
if (ds.Tables != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
schedule.SetVA009_PaymentMode(Util.GetValueOfString(ds.Tables[0].Rows[i]["va009_paymentmode"]));
schedule.SetVA009_PaymentType(Util.GetValueOfString(ds.Tables[0].Rows[i]["va009_paymenttype"]));
schedule.SetVA009_PaymentTrigger(Util.GetValueOfString(ds.Tables[0].Rows[i]["va009_paymenttrigger"]));
schedule.SetVA009_ExecutionStatus("A");
}
}
if (!schedule.Save())
{
return(false);
}
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// Create Facts (the accounting logic) for
/// MXI.
/// (single line)
/// <pre>
/// NotInvoicedReceipts DR (Receipt Org)
/// InventoryClearing CR
/// InvoicePV DR CR (difference)
/// Commitment
/// Expense CR
/// Offset DR
/// </pre>
/// </summary>
/// <param name="as1"></param>
/// <returns></returns>
public override List <Fact> CreateFacts(MAcctSchema as1)
{
List <Fact> facts = new List <Fact>();
// Nothing to do
if (GetM_Product_ID() == 0 || // no Product
Env.Signum(GetQty().Value) == 0 ||
Env.Signum(_receiptLine.GetMovementQty()) == 0) // Qty = 0
{
log.Fine("No Product/Qty - M_Product_ID=" + GetM_Product_ID()
+ ",Qty=" + GetQty() + ",InOutQty=" + _receiptLine.GetMovementQty());
return(facts);
}
MMatchInv matchInv = (MMatchInv)GetPO();
// create Fact Header
Fact fact = new Fact(this, as1, Fact.POST_Actual);
SetC_Currency_ID(as1.GetC_Currency_ID());
/** Needs to be handeled in PO Matching as1 no Receipt info
* if (_pc.isService())
* {
* log.Fine("Service - skipped");
* return fact;
* }
**/
// NotInvoicedReceipt DR
// From Receipt
Decimal multiplier = Math.Abs(Decimal.Round(Decimal.Divide(GetQty().Value, _receiptLine.GetMovementQty()), 12, MidpointRounding.AwayFromZero));
FactLine dr = fact.CreateLine(null,
GetAccount(Doc.ACCTTYPE_NotInvoicedReceipts, as1),
as1.GetC_Currency_ID(), Env.ONE, null); // updated below
if (dr == null)
{
_error = "No Product Costs";
return(null);
}
dr.SetQty(GetQty());
// dr.setM_Locator_ID(_receiptLine.getM_Locator_ID());
// MInOut receipt = _receiptLine.getParent();
// dr.setLocationFromBPartner(receipt.getC_BPartner_Location_ID(), true); // from Loc
// dr.setLocationFromLocator(_receiptLine.getM_Locator_ID(), false); // to Loc
Decimal temp = dr.GetAcctBalance();
// Set AmtAcctCr/Dr from Receipt (sets also Project)
if (!dr.UpdateReverseLine(MInOut.Table_ID, // Amt updated
_receiptLine.GetM_InOut_ID(), _receiptLine.GetM_InOutLine_ID(),
multiplier))
{
_error = "Mat.Receipt not posted yet";
return(null);
}
log.Fine("CR - Amt(" + temp + "->" + dr.GetAcctBalance()
+ ") - " + dr.ToString());
// InventoryClearing CR
// From Invoice
MAccount expense = _pc.GetAccount(ProductCost.ACCTTYPE_P_InventoryClearing, as1);
if (_pc.IsService())
{
expense = _pc.GetAccount(ProductCost.ACCTTYPE_P_Expense, as1);
}
Decimal LineNetAmt = _invoiceLine.GetLineNetAmt();
multiplier = Math.Abs(Decimal.Round(Decimal.Divide(GetQty().Value, _invoiceLine.GetQtyInvoiced()), 12, MidpointRounding.AwayFromZero));
if (multiplier.CompareTo(Env.ONE) != 0)
{
LineNetAmt = Decimal.Multiply(LineNetAmt, multiplier);
}
if (_pc.IsService())
{
LineNetAmt = dr.GetAcctBalance(); // book out exact receipt amt
}
FactLine cr = null;
if (as1.IsAccrual())
{
cr = fact.CreateLine(null, expense,
as1.GetC_Currency_ID(), null, LineNetAmt); // updated below
if (cr == null)
{
log.Fine("Line Net Amt=0 - M_Product_ID=" + GetM_Product_ID()
+ ",Qty=" + GetQty() + ",InOutQty=" + _receiptLine.GetMovementQty());
facts.Add(fact);
return(facts);
}
cr.SetQty(Decimal.Negate(GetQty().Value));
temp = cr.GetAcctBalance();
// Set AmtAcctCr/Dr from Invoice (sets also Project)
if (as1.IsAccrual() && !cr.UpdateReverseLine(MInvoice.Table_ID, // Amt updated
_invoiceLine.GetC_Invoice_ID(), _invoiceLine.GetC_InvoiceLine_ID(), multiplier))
{
_error = "Invoice not posted yet";
return(null);
}
log.Fine("DR - Amt(" + temp + "->" + cr.GetAcctBalance()
+ ") - " + cr.ToString());
}
else // Cash Acct
{
MInvoice invoice = _invoiceLine.GetParent();
if (as1.GetC_Currency_ID() == invoice.GetC_Currency_ID())
{
LineNetAmt = MConversionRate.Convert(GetCtx(), LineNetAmt,
invoice.GetC_Currency_ID(), as1.GetC_Currency_ID(),
invoice.GetDateAcct(), invoice.GetC_ConversionType_ID(),
invoice.GetAD_Client_ID(), invoice.GetAD_Org_ID());
}
cr = fact.CreateLine(null, expense,
as1.GetC_Currency_ID(), null, LineNetAmt);
cr.SetQty(Decimal.Negate(Decimal.Multiply(GetQty().Value, multiplier)));
}
cr.SetC_Activity_ID(_invoiceLine.GetC_Activity_ID());
cr.SetC_Campaign_ID(_invoiceLine.GetC_Campaign_ID());
cr.SetC_Project_ID(_invoiceLine.GetC_Project_ID());
cr.SetC_UOM_ID(_invoiceLine.GetC_UOM_ID());
cr.SetUser1_ID(_invoiceLine.GetUser1_ID());
cr.SetUser2_ID(_invoiceLine.GetUser2_ID());
// Invoice Price Variance difference
Decimal ipv = Decimal.Negate(Decimal.Add(cr.GetAcctBalance(), dr.GetAcctBalance()));
if (Env.Signum(ipv) != 0)
{
FactLine pv = fact.CreateLine(null,
_pc.GetAccount(ProductCost.ACCTTYPE_P_IPV, as1),
as1.GetC_Currency_ID(), ipv);
pv.SetC_Activity_ID(_invoiceLine.GetC_Activity_ID());
pv.SetC_Campaign_ID(_invoiceLine.GetC_Campaign_ID());
pv.SetC_Project_ID(_invoiceLine.GetC_Project_ID());
pv.SetC_UOM_ID(_invoiceLine.GetC_UOM_ID());
pv.SetUser1_ID(_invoiceLine.GetUser1_ID());
pv.SetUser2_ID(_invoiceLine.GetUser2_ID());
}
log.Fine("IPV=" + ipv + "; Balance=" + fact.GetSourceBalance());
MInOut inOut = _receiptLine.GetParent();
bool isReturnTrx = inOut.IsReturnTrx();
if (!IsPosted())
{
// Cost Detail Record - data from Expense/IncClearing (CR) record
MCostDetail.CreateInvoice(as1, GetAD_Org_ID(),
GetM_Product_ID(), matchInv.GetM_AttributeSetInstance_ID(),
_invoiceLine.GetC_InvoiceLine_ID(), 0, // No cost element
Decimal.Negate(cr.GetAcctBalance()), isReturnTrx ? Decimal.Negate(Utility.Util.GetValueOfDecimal(GetQty())) : Utility.Util.GetValueOfDecimal(GetQty()), // correcting
GetDescription(), GetTrx(), GetRectifyingProcess());
// Update Costing
UpdateProductInfo(as1.GetC_AcctSchema_ID(),
MAcctSchema.COSTINGMETHOD_StandardCosting.Equals(as1.GetCostingMethod()));
}
//
facts.Add(fact);
/** Commitment release ****/
if (as1.IsAccrual() && as1.IsCreateCommitment())
{
fact = Doc_Order.GetCommitmentRelease(as1, this,
Utility.Util.GetValueOfDecimal(GetQty()), _invoiceLine.GetC_InvoiceLine_ID(), Env.ONE);
if (fact == null)
{
return(null);
}
facts.Add(fact);
} // Commitment
return(facts);
}
/// <summary>
/// Create Invoice Line from Shipment
/// </summary>
/// <param name="order">order</param>
/// <param name="ship">shipment header</param>
/// <param name="sLine">shipment line</param>
private void CreateLine(MOrder order, MInOut ship, MInOutLine sLine)
{
if (_invoice == null)
{
_invoice = new MInvoice(order, 0, _DateInvoiced);
int _CountVA009 = Env.IsModuleInstalled("VA009_") ? 1 : 0;
if (_CountVA009 > 0)
{
int _PaymentMethod_ID = order.GetVA009_PaymentMethod_ID();
// during consolidation, payment method need to set that is defined on selected business partner.
// If not defined on BP then it will set from order
// during sale cycle -- VA009_PaymentMethod_ID
// during purchase cycle -- VA009_PO_PaymentMethod_ID
int bpPamentMethod_ID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT " + (order.IsSOTrx() ? " VA009_PaymentMethod_ID " : " VA009_PO_PaymentMethod_ID ") +
@" FROM C_BPartner WHERE C_BPartner_ID = " + order.GetC_BPartner_ID(), null, Get_Trx()));
if (_ConsolidateDocument && bpPamentMethod_ID != 0)
{
_PaymentMethod_ID = bpPamentMethod_ID;
}
if (_PaymentMethod_ID > 0)
{
_invoice.SetVA009_PaymentMethod_ID(_PaymentMethod_ID);
}
}
int _CountVA026 = Env.IsModuleInstalled("VA026_") ? 1 : 0;
if (_CountVA026 > 0)
{
_invoice.SetVA026_LCDetail_ID(order.GetVA026_LCDetail_ID());
}
// Added by Bharat on 29 Jan 2018 to set Inco Term from Order
if (_invoice.Get_ColumnIndex("C_IncoTerm_ID") > 0)
{
_invoice.SetC_IncoTerm_ID(order.GetC_IncoTerm_ID());
}
if (Env.IsModuleInstalled("VA077_"))
{
//.setva077
_invoice.Set_Value("VA077_AdditionalAnnualCharge", order.Get_Value("VA077_AdditionalAnnualCharge"));
_invoice.Set_Value("VA077_ChangeStartDate", order.Get_Value("VA077_ChangeStartDate"));
_invoice.Set_Value("VA077_ContractCPEndDate", order.Get_Value("VA077_ContractCPEndDate"));
_invoice.Set_Value("VA077_ContractCPStartDate", order.Get_Value("VA077_ContractCPStartDate"));
_invoice.Set_Value("VA077_HistoricContractDate", order.Get_Value("VA077_HistoricContractDate"));
_invoice.Set_Value("VA077_IsLegalEntity", order.Get_Value("VA077_IsLegalEntity"));
_invoice.Set_Value("VA077_MarginPercent", order.Get_Value("VA077_MarginPercent"));
_invoice.Set_Value("VA077_NewAnnualContractTotal", order.Get_Value("VA077_NewAnnualContractTotal"));
_invoice.Set_Value("VA077_OldAnnualContractTotal", order.Get_Value("VA077_OldAnnualContractTotal"));
_invoice.Set_Value("VA077_PartialAmtCatchUp", order.Get_Value("VA077_PartialAmtCatchUp"));
_invoice.Set_Value("VA077_SalesCoWorker", order.Get_Value("VA077_SalesCoWorker"));
_invoice.Set_Value("VA077_SalesCoWorkerPer", order.Get_Value("VA077_SalesCoWorkerPer"));
_invoice.Set_Value("VA077_TotalMarginAmt", order.Get_Value("VA077_TotalMarginAmt"));
_invoice.Set_Value("VA077_TotalPurchaseAmt", order.Get_Value("VA077_TotalPurchaseAmt"));
_invoice.Set_Value("VA077_TotalSalesAmt", order.Get_Value("VA077_TotalSalesAmt"));
}
if (!_invoice.Save())
{
ValueNamePair pp = VAdvantage.Logging.VLogger.RetrieveError();
if (pp != null)
{
throw new ArgumentException("Could not create Invoice (s). " + pp.GetName());
}
throw new Exception("Could not create Invoice (s)");
}
}
#region Comment Create Shipment Comment Line
// Create Shipment Comment Line
//if (_ship == null
// || _ship.GetM_InOut_ID() != ship.GetM_InOut_ID())
//{
// MDocType dt = MDocType.Get(GetCtx(), ship.GetC_DocType_ID());
// if (_bp == null || _bp.GetC_BPartner_ID() != ship.GetC_BPartner_ID())
// {
// _bp = new MBPartner(GetCtx(), ship.GetC_BPartner_ID(), Get_TrxName());
// }
// // Reference: Delivery: 12345 - 12.12.12
// MClient client = MClient.Get(GetCtx(), order.GetAD_Client_ID());
// String AD_Language = client.GetAD_Language();
// if (client.IsMultiLingualDocument() && _bp.GetAD_Language() != null)
// {
// AD_Language = _bp.GetAD_Language();
// }
// if (AD_Language == null)
// {
// // MessageBox.Show("Set base Language");
// //AD_Language = Language.getBaseAD_Language();
// }
// //java.text.SimpleDateFormat format = DisplayType.getDateFormat
// // (DisplayType.Date, Language.getLanguage(AD_Language));
// //String reference = dt.GetPrintName(_bp.GetAD_Language())
// // + ": " + ship.GetDocumentNo()
// // + " - " + format.format(ship.GetMovementDate());
// String reference = dt.GetPrintName(_bp.GetAD_Language())
// + ": " + ship.GetDocumentNo()
// + " - " + ship.GetMovementDate();
// _ship = ship;
// //
// MInvoiceLine line = new MInvoiceLine(_invoice);
// line.SetIsDescription(true);
// line.SetDescription(reference);
// line.SetLine(_line + sLine.GetLine() - 2);
// if (!line.Save())
// {
// throw new Exception("Could not create Invoice Comment Line (sh)");
// }
// // Optional Ship Address if not Bill Address
// if (order.GetBill_Location_ID() != ship.GetC_BPartner_Location_ID())
// {
// MLocation addr = MLocation.GetBPLocation(GetCtx(), ship.GetC_BPartner_Location_ID(), null);
// line = new MInvoiceLine(_invoice);
// line.SetIsDescription(true);
// line.SetDescription(addr.ToString());
// line.SetLine(_line + sLine.GetLine() - 1);
// if (!line.Save())
// {
// throw new Exception("Could not create Invoice Comment Line 2 (sh)");
// }
// }
//}
#endregion
//
MInvoiceLine line1 = new MInvoiceLine(_invoice);
line1.SetShipLine(sLine);
line1.SetQtyEntered(sLine.GetQtyEntered());
line1.SetQtyInvoiced(sLine.GetMovementQty());
line1.SetLine(_line + sLine.GetLine());
line1.SetM_AttributeSetInstance_ID(sLine.GetM_AttributeSetInstance_ID());
if (sLine.GetA_Asset_ID() > 0)
{
line1.SetA_Asset_ID(sLine.GetA_Asset_ID());
if (line1.Get_ColumnIndex("VAFAM_AssetCost") > 0)
{
int PAcctSchema_ID = 0;
int pCurrency_ID = 0;
MAcctSchema as1 = MClient.Get(GetCtx(), GetAD_Client_ID()).GetAcctSchema();
if (as1 != null)
{
PAcctSchema_ID = as1.GetC_AcctSchema_ID();
pCurrency_ID = as1.GetC_Currency_ID();
}
decimal LineNetAmt = Decimal.Multiply(line1.GetPriceActual(), line1.GetQtyEntered());
decimal AssetCost = GetAssetCost(sLine.GetA_Asset_ID(), sLine.GetM_Product_ID(), PAcctSchema_ID);
AssetCost = Decimal.Multiply(AssetCost, line1.GetQtyEntered());
if (LineNetAmt > 0)
{
LineNetAmt = MConversionRate.Convert(GetCtx(), LineNetAmt, _invoice.GetC_Currency_ID(), pCurrency_ID, _invoice.GetAD_Client_ID(), _invoice.GetAD_Org_ID());
}
decimal Diff = LineNetAmt - AssetCost;
line1.Set_Value("VAFAM_AssetCost", AssetCost);
line1.Set_Value("VAFAM_Difference", Diff);
}
}
if (Env.IsModuleInstalled("VA077_"))
{
//invoice line
line1.Set_Value("VA077_CNAutodesk", sLine.Get_Value("VA077_CNAutodesk"));
line1.Set_Value("VA077_Duration", sLine.Get_Value("VA077_Duration"));
line1.Set_Value("VA077_MarginAmt", sLine.Get_Value("VA077_MarginAmt"));
line1.Set_Value("VA077_MarginPercent", sLine.Get_Value("VA077_MarginPercent"));
line1.Set_Value("VA077_OldSN", sLine.Get_Value("VA077_OldSN"));
line1.Set_Value("VA077_ProductInfo", sLine.Get_Value("VA077_ProductInfo"));
line1.Set_Value("VA077_PurchasePrice", sLine.Get_Value("VA077_PurchasePrice"));
line1.Set_Value("VA077_RegEmail", sLine.Get_Value("VA077_RegEmail"));
line1.Set_Value("VA077_SerialNo", sLine.Get_Value("VA077_SerialNo"));
line1.Set_Value("VA077_UpdateFromVersn", sLine.Get_Value("VA077_UpdateFromVersn"));
line1.Set_Value("VA077_UserRef_ID", sLine.Get_Value("VA077_UserRef_ID"));
line1.Set_Value("VA077_EndDate", sLine.Get_Value("VA077_EndDate"));
line1.Set_Value("VA077_StartDate", sLine.Get_Value("VA077_StartDate"));
}
if (!line1.Save())
{
ValueNamePair pp = VAdvantage.Logging.VLogger.RetrieveError();
if (pp != null)
{
throw new ArgumentException("Could not create Invoice Line (s). " + pp.GetName());
}
throw new Exception("Could not create Invoice Line (s)");
}
// Link
sLine.SetIsInvoiced(true);
if (!sLine.Save())
{
ValueNamePair pp = VAdvantage.Logging.VLogger.RetrieveError();
if (pp != null)
{
throw new ArgumentException("Could not update Shipment Line. " + pp.GetName());
}
throw new Exception("Could not update Shipment Line");
}
log.Fine(line1.ToString());
}
/**
* Create Invoice Line from Shipment
* @param order order
* @param ship shipment header
* @param sLine shipment line
*/
private void CreateLine(MOrder order, MInOut ship, MInOutLine sLine)
{
if (_invoice == null)
{
_invoice = new MInvoice(order, 0, _DateInvoiced);
//---------------------------Column Added by Anuj------------------
int _CountVA009 = Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(AD_MODULEINFO_ID) FROM AD_MODULEINFO WHERE PREFIX='VA009_' AND IsActive = 'Y'"));
if (_CountVA009 > 0)
{
int _PaymentMethod_ID = order.GetVA009_PaymentMethod_ID();
if (_PaymentMethod_ID > 0)
{
_invoice.SetVA009_PaymentMethod_ID(_PaymentMethod_ID);
}
}
//-----------------Column Added by Anuj------------------
int _CountVA026 = Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(AD_MODULEINFO_ID) FROM AD_MODULEINFO WHERE PREFIX='VA026_' AND IsActive = 'Y'"));
if (_CountVA026 > 0)
{
_invoice.SetVA026_LCDetail_ID(order.GetVA026_LCDetail_ID());
}
// Added by Bharat on 29 Jan 2018 to set Inco Term from Order
if (_invoice.Get_ColumnIndex("C_IncoTerm_ID") > 0)
{
_invoice.SetC_IncoTerm_ID(order.GetC_IncoTerm_ID());
}
if (!_invoice.Save())
{
throw new Exception("Could not create Invoice (s)");
}
}
#region Comment Create Shipment Comment Line
// Create Shipment Comment Line
//if (_ship == null
// || _ship.GetM_InOut_ID() != ship.GetM_InOut_ID())
//{
// MDocType dt = MDocType.Get(GetCtx(), ship.GetC_DocType_ID());
// if (_bp == null || _bp.GetC_BPartner_ID() != ship.GetC_BPartner_ID())
// {
// _bp = new MBPartner(GetCtx(), ship.GetC_BPartner_ID(), Get_TrxName());
// }
// // Reference: Delivery: 12345 - 12.12.12
// MClient client = MClient.Get(GetCtx(), order.GetAD_Client_ID());
// String AD_Language = client.GetAD_Language();
// if (client.IsMultiLingualDocument() && _bp.GetAD_Language() != null)
// {
// AD_Language = _bp.GetAD_Language();
// }
// if (AD_Language == null)
// {
// // MessageBox.Show("Set base Language");
// //AD_Language = Language.getBaseAD_Language();
// }
// //java.text.SimpleDateFormat format = DisplayType.getDateFormat
// // (DisplayType.Date, Language.getLanguage(AD_Language));
// //String reference = dt.GetPrintName(_bp.GetAD_Language())
// // + ": " + ship.GetDocumentNo()
// // + " - " + format.format(ship.GetMovementDate());
// String reference = dt.GetPrintName(_bp.GetAD_Language())
// + ": " + ship.GetDocumentNo()
// + " - " + ship.GetMovementDate();
// _ship = ship;
// //
// MInvoiceLine line = new MInvoiceLine(_invoice);
// line.SetIsDescription(true);
// line.SetDescription(reference);
// line.SetLine(_line + sLine.GetLine() - 2);
// if (!line.Save())
// {
// throw new Exception("Could not create Invoice Comment Line (sh)");
// }
// // Optional Ship Address if not Bill Address
// if (order.GetBill_Location_ID() != ship.GetC_BPartner_Location_ID())
// {
// MLocation addr = MLocation.GetBPLocation(GetCtx(), ship.GetC_BPartner_Location_ID(), null);
// line = new MInvoiceLine(_invoice);
// line.SetIsDescription(true);
// line.SetDescription(addr.ToString());
// line.SetLine(_line + sLine.GetLine() - 1);
// if (!line.Save())
// {
// throw new Exception("Could not create Invoice Comment Line 2 (sh)");
// }
// }
//}
#endregion
//
MInvoiceLine line1 = new MInvoiceLine(_invoice);
line1.SetShipLine(sLine);
line1.SetQtyEntered(sLine.GetQtyEntered());
line1.SetQtyInvoiced(sLine.GetMovementQty());
line1.SetLine(_line + sLine.GetLine());
line1.SetM_AttributeSetInstance_ID(sLine.GetM_AttributeSetInstance_ID());
if (sLine.GetA_Asset_ID() > 0)
{
line1.SetA_Asset_ID(sLine.GetA_Asset_ID());
if (line1.Get_ColumnIndex("VAFAM_AssetCost") > 0)
{
int PAcctSchema_ID = 0;
int pCurrency_ID = 0;
MAcctSchema as1 = MClient.Get(GetCtx(), GetAD_Client_ID()).GetAcctSchema();
if (as1 != null)
{
PAcctSchema_ID = as1.GetC_AcctSchema_ID();
pCurrency_ID = as1.GetC_Currency_ID();
}
decimal LineNetAmt = Decimal.Multiply(line1.GetPriceActual(), line1.GetQtyEntered());
decimal AssetCost = GetAssetCost(sLine.GetA_Asset_ID(), sLine.GetM_Product_ID(), PAcctSchema_ID);
AssetCost = Decimal.Multiply(AssetCost, line1.GetQtyEntered());
if (LineNetAmt > 0)
{
LineNetAmt = MConversionRate.Convert(GetCtx(), LineNetAmt, _invoice.GetC_Currency_ID(), pCurrency_ID, _invoice.GetAD_Client_ID(), _invoice.GetAD_Org_ID());
}
decimal Diff = LineNetAmt - AssetCost;
line1.Set_Value("VAFAM_AssetCost", AssetCost);
line1.Set_Value("VAFAM_Difference", Diff);
}
}
if (!line1.Save())
{
throw new Exception("Could not create Invoice Line (s)");
}
// Link
sLine.SetIsInvoiced(true);
if (!sLine.Save())
{
throw new Exception("Could not update Shipment Line");
}
log.Fine(line1.ToString());
}
/// <summary>
/// This function is used to create Recognition plan and run
/// </summary>
/// <param name="C_InvoiceLine_ID">invoice line</param>
/// <param name="C_RevenueRecognition_ID">Revenue Recognition</param>
/// <param name="Invoice">Invoice</param>
/// <returns>true, when success</returns>
public static bool CreateRevenueRecognitionPlan(int C_InvoiceLine_ID, int C_RevenueRecognition_ID, MInvoice Invoice)
{
try
{
MRevenueRecognitionRun revenueRecognitionRun = null;
DateTime? RecognizationDate = null;
int NoofMonths = 0;
MRevenueRecognition revenueRecognition = new MRevenueRecognition(Invoice.GetCtx(), C_RevenueRecognition_ID, Invoice.Get_Trx());
int defaultAccSchemaOrg_ID = GetDefaultActSchema(Invoice.GetCtx(), Invoice.GetAD_Client_ID(), Invoice.GetAD_Org_ID());
int ToCurrency = Util.GetValueOfInt(DB.ExecuteScalar("SELECT C_Currency_ID FROM C_AcctSchema WHERE C_AcctSchema_ID=" + defaultAccSchemaOrg_ID));
MInvoiceLine invoiceLine = new MInvoiceLine(Invoice.GetCtx(), C_InvoiceLine_ID, Invoice.Get_Trx());
//if recoganization date is null recognition plan and run cant be generated
if (invoiceLine.Get_Value("RevenueStartDate") == null)
{
_log.Log(Level.SEVERE, "DateIsInvlidOrNull");
return(false);
}
RecognizationDate = Util.GetValueOfDateTime(invoiceLine.Get_Value("RevenueStartDate"));
// precision to be handle based on std precision defined on acct schema
string sql = "SELECT C.StdPrecision FROM C_AcctSchema a INNER JOIN C_Currency c ON c.C_Currency_ID= a.C_Currency_ID WHERE a.C_AcctSchema_ID=" + defaultAccSchemaOrg_ID;
int stdPrecision = Util.GetValueOfInt(DB.ExecuteScalar(sql, null, null));
if (revenueRecognition.GetRecognitionFrequency().Equals(RECOGNITIONFREQUENCY_Month) && RecognizationDate.Value.Day != 1 && revenueRecognition.GetNoMonths() > 0)
{
//if startdate is in between day of month
NoofMonths = revenueRecognition.GetNoMonths() + 1;
}
else
{
//if start date is the first day of the month
NoofMonths = revenueRecognition.GetNoMonths();
}
MRevenueRecognitionPlan revenueRecognitionPlan = new MRevenueRecognitionPlan(Invoice.GetCtx(), 0, Invoice.Get_Trx());
revenueRecognitionPlan.SetRecognitionPlan(invoiceLine, Invoice, C_RevenueRecognition_ID, ToCurrency);
revenueRecognitionPlan.SetC_AcctSchema_ID(defaultAccSchemaOrg_ID);
revenueRecognitionPlan.SetRecognizedAmt(0);
if (!revenueRecognitionPlan.Save())
{
ValueNamePair pp = VLogger.RetrieveError();
string error = pp != null?pp.GetValue() : "";
if (pp != null && string.IsNullOrEmpty(error))
{
error = pp.GetName();
}
if (!string.IsNullOrEmpty(error))
{
_log.Log(Level.SEVERE, error);
return(false);
}
}
else
{
if (!revenueRecognition.IsTimeBased())
{
}
else
{
if (revenueRecognition.GetRecognitionFrequency().Equals(RECOGNITIONFREQUENCY_Month))
{
decimal totaldays = Util.GetValueOfDecimal((RecognizationDate.Value.AddMonths(revenueRecognition.GetNoMonths()) - RecognizationDate.Value.Date).TotalDays);
decimal perdayAmt = Math.Round(revenueRecognitionPlan.GetTotalAmt() / (totaldays > 0?totaldays:1), 12);
decimal recognizedAmt = 0;
DateTime?lastdate = null;
int days = 0;
for (int i = 0; i < NoofMonths; i++)
{
if (i == 0)
{
if (RecognizationDate.Value.Month == 12)
{
//last date of the month
lastdate = new DateTime(RecognizationDate.Value.Year, RecognizationDate.Value.Month, 1).AddMonths(1).AddDays(-1);
}
else
{
//last date of the month
lastdate = new DateTime(RecognizationDate.Value.Year, RecognizationDate.Value.Month + 1, 1).AddDays(-1);
}
days = Util.GetValueOfInt((lastdate.Value.Date - RecognizationDate.Value.Date).TotalDays);
days += 1;
}
else if (i == (revenueRecognition.GetNoMonths()))
{
//last date of the month would the day before the recoganizationdate
lastdate = RecognizationDate.Value.AddMonths(i).AddDays(-1);
DateTime startDate = new DateTime(lastdate.Value.Year, lastdate.Value.Month, 1);
days = Util.GetValueOfInt((lastdate.Value.Date - startDate.Date).TotalDays);
days += 1;
}
else
{
DateTime startDate = lastdate.Value.AddDays(1);
days = DateTime.DaysInMonth(startDate.Year, startDate.Month);
lastdate = startDate.AddDays(days - 1);
}
recognizedAmt = Math.Round(days * perdayAmt, stdPrecision);
revenueRecognitionRun = new MRevenueRecognitionRun(Invoice.GetCtx(), 0, Invoice.Get_Trx());
revenueRecognitionRun.SetRecognitionRun(revenueRecognitionPlan);
revenueRecognitionRun.SetRecognizedAmt(recognizedAmt);
revenueRecognitionRun.SetRecognitionDate(lastdate);
if (!revenueRecognitionRun.Save())
{
ValueNamePair pp = VLogger.RetrieveError();
string error = pp != null?pp.GetValue() : "";
if (pp != null && string.IsNullOrEmpty(error))
{
error = pp.GetName();
}
if (!string.IsNullOrEmpty(error))
{
_log.Log(Level.SEVERE, error);
return(false);
}
}
recognizedAmt = 0;
}
}
else if (revenueRecognition.GetRecognitionFrequency().Equals(RECOGNITIONFREQUENCY_Day))
{
Decimal recognizedAmt = Math.Round(revenueRecognitionPlan.GetTotalAmt() / revenueRecognition.GetNoMonths(), stdPrecision);
int days = 0;
for (int i = 0; i < revenueRecognition.GetNoMonths(); i++)
{
revenueRecognitionRun = new MRevenueRecognitionRun(Invoice.GetCtx(), 0, Invoice.Get_Trx());
revenueRecognitionRun.SetRecognitionRun(revenueRecognitionPlan);
revenueRecognitionRun.SetRecognizedAmt(recognizedAmt);
revenueRecognitionRun.SetRecognitionDate(RecognizationDate.Value.AddDays(days));
days += 1;
if (!revenueRecognitionRun.Save())
{
ValueNamePair pp = VLogger.RetrieveError();
string error = pp != null?pp.GetValue() : "";
if (pp != null && string.IsNullOrEmpty(error))
{
error = pp.GetName();
}
if (!string.IsNullOrEmpty(error))
{
_log.Log(Level.SEVERE, error);
return(false);
}
}
}
}
else if (revenueRecognition.GetRecognitionFrequency().Equals(RECOGNITIONFREQUENCY_Year))
{
DateTime?fstartDate = null;
DateTime?fendDate = null;
int calendar_ID = 0;
DataSet ds = new DataSet();
calendar_ID = Util.GetValueOfInt(DB.ExecuteScalar("SELECT C_Calendar_ID FROM AD_OrgInfo WHERE ad_org_id = " + Invoice.GetAD_Org_ID()));
if (calendar_ID == 0)
{
calendar_ID = Util.GetValueOfInt(DB.ExecuteScalar("SELECT C_Calendar_ID FROM AD_ClientInfo WHERE ad_client_id = " + Invoice.GetAD_Client_ID()));
}
sql = "SELECT startdate , enddate FROM c_period WHERE " +
"c_year_id = (SELECT c_year.c_year_id FROM c_year INNER JOIN C_period ON c_year.c_year_id = C_period.c_year_id " +
"WHERE c_year.c_calendar_id =" + calendar_ID + " AND " + GlobalVariable.TO_DATE(RecognizationDate, true) + " BETWEEN C_period.startdate AND C_period.enddate) AND periodno IN (1, 12)";
ds = DB.ExecuteDataset(sql);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
fstartDate = Convert.ToDateTime(ds.Tables[0].Rows[0]["startdate"]);
fendDate = Convert.ToDateTime(ds.Tables[0].Rows[1]["enddate"]);
}
if (fstartDate != RecognizationDate)
{
//RecognizationDate is not same as financial year's start date
NoofMonths += 1;
}
decimal totaldays = Util.GetValueOfDecimal((RecognizationDate.Value.AddYears(revenueRecognition.GetNoMonths()) - RecognizationDate.Value.Date).TotalDays);
decimal perdayAmt = Math.Round(revenueRecognitionPlan.GetTotalAmt() / (totaldays > 0?totaldays:1), 12);
decimal recognizedAmt = 0;
DateTime?lastdate = null;
int days = 0;
for (int i = 0; i < NoofMonths; i++)
{
if (i == 0)
{
//last date will always be financial year's end date
lastdate = fendDate;
days = Util.GetValueOfInt((lastdate.Value.Date - RecognizationDate.Value.Date).TotalDays);
days += 1;
}
else if (i == revenueRecognition.GetNoMonths())
{
//last date of the year would the day before the recoganizationdate
lastdate = RecognizationDate.Value.AddYears(i).AddDays(-1);
DateTime startDate = fstartDate.Value.AddYears(i);
days = Util.GetValueOfInt((lastdate.Value.Date - startDate.Date).TotalDays);
days += 1;
}
else
{
lastdate = fendDate.Value.AddYears(i);
DateTime _startDate = fstartDate.Value.AddYears(i);
days = Util.GetValueOfInt((lastdate.Value.Date - _startDate.Date).TotalDays);
days += 1;
}
recognizedAmt = Math.Round(days * perdayAmt, stdPrecision);
revenueRecognitionRun = new MRevenueRecognitionRun(Invoice.GetCtx(), 0, Invoice.Get_Trx());
revenueRecognitionRun.SetRecognitionRun(revenueRecognitionPlan);
revenueRecognitionRun.SetRecognizedAmt(recognizedAmt);
revenueRecognitionRun.SetRecognitionDate(lastdate);
if (!revenueRecognitionRun.Save())
{
ValueNamePair pp = VLogger.RetrieveError();
string error = pp != null?pp.GetValue() : "";
if (pp != null && string.IsNullOrEmpty(error))
{
error = pp.GetName();
}
if (!string.IsNullOrEmpty(error))
{
_log.Log(Level.SEVERE, error);
return(false);
}
}
recognizedAmt = 0;
}
}
}
}
}
catch (Exception ex)
{
_log.Severe("Exception during creation of Recognition Plan and Run. " + ex.Message);
return(false);
}
return(true);
}
/**
* Apply Payment Term without schedule to Invoice
* @param invoice invoice
* @return false as no payment schedule
*/
#region Advance Payment by Vivek on 16/06/2016
private bool ApplyNoSchedule(MInvoice invoice)
{
int _CountVA009 = Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(AD_MODULEINFO_ID) FROM AD_MODULEINFO WHERE PREFIX='VA009_' AND IsActive = 'Y'"));
if (_CountVA009 > 0)
{
DeleteInvoicePaySchedule(invoice.GetC_Invoice_ID(), invoice.Get_TrxName());
StringBuilder _sql = new StringBuilder();
MInvoicePaySchedule schedule = null;
MPaymentTerm payterm = new MPaymentTerm(GetCtx(), invoice.GetC_PaymentTerm_ID(), invoice.Get_TrxName());
Decimal remainder = invoice.GetGrandTotal();
int BaseCurrency = 0;
if (Util.GetValueOfInt(DB.ExecuteScalar("Select Count(*) From C_PaySchedule Where C_PaymentTerm_ID=" + invoice.GetC_PaymentTerm_ID())) > 1)
{
for (int i = 0; i < _schedule.Length; i++)
{
MPaySchedule _sch = new MPaySchedule(GetCtx(), _schedule[i].GetC_PaySchedule_ID(), Get_TrxName());
#region IsAdvance true on Payment Schedule
if (_sch.IsVA009_Advance())
{
#region Copy Order Schedules
String sql = "SELECT * FROM VA009_OrderPaySchedule WHERE C_Order_ID=" + invoice.GetC_Order_ID() + " AND VA009_IsPaid='Y' ORDER BY Created";
DataSet _ds = new DataSet();
_ds = DB.ExecuteDataset(sql, null);
if (_ds.Tables[0].Rows.Count > 0 && _ds.Tables[0].Rows != null)
{
for (int j = 0; j < _ds.Tables[0].Rows.Count; j++)
{
schedule = new MInvoicePaySchedule(GetCtx(), 0, invoice.Get_TrxName());
Boolean _isPaid = false;
if (Util.GetValueOfString(_ds.Tables[0].Rows[j]["VA009_IsPaid"]) == "Y")
{
_isPaid = true;
}
schedule.SetAD_Client_ID(Util.GetValueOfInt(_ds.Tables[0].Rows[j]["AD_Client_ID"]));
schedule.SetAD_Org_ID(Util.GetValueOfInt(_ds.Tables[0].Rows[j]["AD_Org_ID"]));
schedule.SetC_Invoice_ID(invoice.GetC_Invoice_ID());
schedule.SetC_DocType_ID(invoice.GetC_DocType_ID());
schedule.SetC_PaymentTerm_ID(Util.GetValueOfInt(_ds.Tables[0].Rows[j]["C_PaymentTerm_ID"]));
schedule.SetVA009_GrandTotal(Util.GetValueOfInt(_ds.Tables[0].Rows[j]["VA009_GrandTotal"]));
schedule.SetVA009_PaymentMethod_ID(Util.GetValueOfInt(_ds.Tables[0].Rows[j]["VA009_PaymentMethod_ID"]));
schedule.SetDueDate(invoice.GetDateInvoiced());
schedule.SetDueAmt(Util.GetValueOfInt(_ds.Tables[0].Rows[j]["DueAmt"]));
schedule.SetDiscountDate(Util.GetValueOfDateTime(_ds.Tables[0].Rows[j]["DiscountDate"]));
schedule.SetDiscountAmt(Util.GetValueOfInt(_ds.Tables[0].Rows[j]["DiscountAmt"]));
schedule.SetVA009_IsPaid(_isPaid);
schedule.SetC_Payment_ID(Util.GetValueOfInt(_ds.Tables[0].Rows[j]["C_Payment_ID"]));
schedule.SetDiscountDays2(Util.GetValueOfDateTime(_ds.Tables[0].Rows[j]["DiscountDays2"]));
schedule.SetDiscount2(Util.GetValueOfInt(_ds.Tables[0].Rows[j]["Discount2"]));
schedule.SetVA009_PlannedDueDate(Util.GetValueOfDateTime(_ds.Tables[0].Rows[j]["VA009_PlannedDueDate"]));
schedule.SetVA009_OpenAmnt(Util.GetValueOfInt(_ds.Tables[0].Rows[j]["VA009_OpenAmnt"]));
schedule.SetC_Currency_ID(Util.GetValueOfInt(_ds.Tables[0].Rows[j]["C_Currency_ID"]));
schedule.SetVA009_BseCurrncy(Util.GetValueOfInt(_ds.Tables[0].Rows[j]["VA009_bseCurrncy"]));
schedule.SetVA009_OpnAmntInvce(Util.GetValueOfInt(_ds.Tables[0].Rows[j]["VA009_OpnAmntInvce"]));
schedule.SetC_BPartner_ID(Util.GetValueOfInt(_ds.Tables[0].Rows[j]["C_Bpartner_ID"]));
schedule.SetVA009_FollowupDate(Util.GetValueOfDateTime(_ds.Tables[0].Rows[j]["VA009_FollowUpDate"]));
schedule.SetVA009_PaymentMode(Util.GetValueOfString(_ds.Tables[0].Rows[j]["va009_paymentmode"]));
schedule.SetVA009_PaymentType(Util.GetValueOfString(_ds.Tables[0].Rows[j]["va009_paymenttype"]));
schedule.SetVA009_PaymentTrigger(Util.GetValueOfString(_ds.Tables[0].Rows[j]["va009_paymenttrigger"]));
schedule.SetVA009_ExecutionStatus(Util.GetValueOfString(_ds.Tables[0].Rows[j]["VA009_ExecutionStatus"]));
schedule.SetProcessed(true);
if (!schedule.Save(invoice.Get_TrxName()))
{
return(false);
}
}
}
#endregion
}
#endregion
#region IsAdvance false on Payment Schedule
else
{
schedule = new MInvoicePaySchedule(invoice, _schedule[i]);
schedule.SetVA009_ExecutionStatus("A");
schedule.SetAD_Client_ID(invoice.GetAD_Client_ID());
schedule.SetAD_Org_ID(invoice.GetAD_Org_ID());
schedule.SetC_Invoice_ID(invoice.GetC_Invoice_ID());
schedule.SetC_DocType_ID(invoice.GetC_DocType_ID());
MOrder _Order = new MOrder(GetCtx(), invoice.GetC_Order_ID(), Get_TrxName());
schedule.SetVA009_PaymentMethod_ID(invoice.GetVA009_PaymentMethod_ID());
schedule.SetC_PaymentTerm_ID(invoice.GetC_PaymentTerm_ID());
schedule.SetVA009_GrandTotal(invoice.GetGrandTotal());
MPaymentTerm paytrm = new MPaymentTerm(GetCtx(), invoice.GetC_PaymentTerm_ID(), Get_TrxName());
int _graceDay = paytrm.GetGraceDays();
//DateTime? _followUpDay = GetDueDate(invoice);
schedule.SetVA009_FollowupDate(schedule.GetDueDate().Value.AddDays(_graceDay));
//schedule.SetVA009_PlannedDueDate(GetDueDate(invoice));
schedule.SetVA009_PlannedDueDate(schedule.GetDueDate());
//schedule.SetDueDate(GetDueDate(invoice));
//change by amit 25-11-2015
StringBuilder _sqlBsCrrncy = new StringBuilder();
_sql.Clear();
_sqlBsCrrncy.Append(@"SELECT UNIQUE asch.C_Currency_ID FROM c_acctschema asch INNER JOIN ad_clientinfo ci ON ci.c_acctschema1_id = asch.c_acctschema_id
INNER JOIN ad_client c ON c.ad_client_id = ci.ad_client_id INNER JOIN c_invoice i ON c.ad_client_id = i.ad_client_id
WHERE i.ad_client_id = " + invoice.GetAD_Client_ID());
BaseCurrency = Util.GetValueOfInt(DB.ExecuteScalar(_sqlBsCrrncy.ToString(), null, null));
if (BaseCurrency != invoice.GetC_Currency_ID())
{
_sqlBsCrrncy.Clear();
_sqlBsCrrncy.Append(@"SELECT multiplyrate FROM c_conversion_rate WHERE AD_Client_ID = " + invoice.GetAD_Client_ID() + " AND c_currency_id = " + invoice.GetC_Currency_ID() +
" AND c_currency_to_id = " + BaseCurrency + " AND " + GlobalVariable.TO_DATE(invoice.GetDateAcct(), true) + " BETWEEN ValidFrom AND ValidTo");
decimal multiplyRate = Util.GetValueOfDecimal(DB.ExecuteScalar(_sqlBsCrrncy.ToString(), null, null));
if (multiplyRate == 0)
{
_sqlBsCrrncy.Clear();
_sqlBsCrrncy.Append(@"SELECT dividerate FROM c_conversion_rate WHERE AD_Client_ID = " + invoice.GetAD_Client_ID() + " AND c_currency_id = " + BaseCurrency +
" AND c_currency_to_id = " + invoice.GetC_Currency_ID() + " AND " + GlobalVariable.TO_DATE(invoice.GetDateAcct(), true) + " BETWEEN ValidFrom AND ValidTo");
multiplyRate = Util.GetValueOfDecimal(DB.ExecuteScalar(_sqlBsCrrncy.ToString(), null, null));
}
schedule.SetVA009_OpenAmnt(schedule.GetDueAmt() * multiplyRate);
}
else
{
schedule.SetVA009_OpenAmnt(schedule.GetDueAmt());
}
schedule.SetC_Currency_ID(invoice.GetC_Currency_ID());
schedule.SetVA009_BseCurrncy(BaseCurrency);
schedule.SetVA009_OpnAmntInvce(schedule.GetDueAmt());
schedule.SetC_BPartner_ID(invoice.GetC_BPartner_ID());
//end
string _sqlPaymentMthd = "Select va009_paymentmode, va009_paymenttype, va009_paymenttrigger From va009_paymentmethod where va009_paymentmethod_ID=" + invoice.GetVA009_PaymentMethod_ID() + " AND IsActive = 'Y' AND AD_Client_ID = " + invoice.GetAD_Client_ID();
DataSet dsPayMthd = new DataSet();
dsPayMthd = DB.ExecuteDataset(_sqlPaymentMthd);
if (dsPayMthd.Tables != null && dsPayMthd.Tables.Count > 0 && dsPayMthd.Tables[0].Rows.Count > 0)
{
for (int j = 0; j < dsPayMthd.Tables[0].Rows.Count; j++)
{
schedule.SetVA009_PaymentMode(Util.GetValueOfString(dsPayMthd.Tables[0].Rows[j]["va009_paymentmode"]));
schedule.SetVA009_PaymentType(Util.GetValueOfString(dsPayMthd.Tables[0].Rows[j]["va009_paymenttype"]));
schedule.SetVA009_PaymentTrigger(Util.GetValueOfString(dsPayMthd.Tables[0].Rows[j]["va009_paymenttrigger"]));
schedule.SetVA009_ExecutionStatus("A");
}
}
schedule.SetProcessed(true);
if (!schedule.Save(invoice.Get_TrxName()))
{
return(false);
}
}
}
#endregion
if (invoice.GetC_PaymentTerm_ID() != GetC_PaymentTerm_ID())
{
invoice.SetC_PaymentTerm_ID(GetC_PaymentTerm_ID());
}
return(invoice.ValidatePaySchedule());
}
else if (Util.GetValueOfInt(DB.ExecuteScalar("Select Count(*) From C_PaySchedule Where C_PaymentTerm_ID=" + invoice.GetC_PaymentTerm_ID())) <= 1)
{
schedule = new MInvoicePaySchedule(GetCtx(), 0, Get_TrxName());
schedule.SetAD_Client_ID(invoice.GetAD_Client_ID());
schedule.SetAD_Org_ID(invoice.GetAD_Org_ID());
schedule.SetC_Invoice_ID(invoice.GetC_Invoice_ID());
schedule.SetC_DocType_ID(invoice.GetC_DocType_ID());
schedule.SetC_PaymentTerm_ID(invoice.GetC_PaymentTerm_ID());
schedule.SetVA009_GrandTotal(invoice.GetGrandTotal());
schedule.SetVA009_PaymentMethod_ID(invoice.GetVA009_PaymentMethod_ID());
schedule.SetDueDate(GetDueDate(invoice));
schedule.SetDueAmt(invoice.GetGrandTotal());
schedule.SetDiscountDate(invoice.GetDateInvoiced().Value.AddDays(Util.GetValueOfInt(payterm.GetDiscountDays())));
schedule.SetDiscountAmt((Util.GetValueOfDecimal((invoice.GetGrandTotal() * payterm.GetDiscount()) / 100)));
schedule.SetDiscountDays2(invoice.GetDateInvoiced().Value.AddDays(Util.GetValueOfInt(payterm.GetDiscountDays2())));
schedule.SetDiscount2((Util.GetValueOfDecimal((invoice.GetGrandTotal() * payterm.GetDiscount2()) / 100)));
schedule.SetVA009_PlannedDueDate(GetDueDate(invoice));
_sql.Clear();
_sql.Append(@"SELECT UNIQUE asch.C_Currency_ID FROM c_acctschema asch INNER JOIN ad_clientinfo ci ON ci.c_acctschema1_id = asch.c_acctschema_id
INNER JOIN ad_client c ON c.ad_client_id = ci.ad_client_id INNER JOIN c_invoice i ON c.ad_client_id = i.ad_client_id
WHERE i.ad_client_id = " + invoice.GetAD_Client_ID());
BaseCurrency = Util.GetValueOfInt(DB.ExecuteScalar(_sql.ToString(), null, null));
if (BaseCurrency != invoice.GetC_Currency_ID())
{
// change by amit
_sql.Clear();
_sql.Append(@"SELECT multiplyrate FROM c_conversion_rate WHERE AD_Client_ID = " + GetCtx().GetAD_Client_ID() + " AND c_currency_id = " + invoice.GetC_Currency_ID() +
" AND c_currency_to_id = " + BaseCurrency + " AND " + GlobalVariable.TO_DATE(invoice.GetDateAcct(), true) + " BETWEEN ValidFrom AND ValidTo");
decimal multiplyRate = Util.GetValueOfDecimal(DB.ExecuteScalar(_sql.ToString(), null, null));
if (multiplyRate == 0)
{
_sql.Clear();
_sql.Append(@"SELECT dividerate FROM c_conversion_rate WHERE AD_Client_ID = " + GetCtx().GetAD_Client_ID() + " AND c_currency_id = " + BaseCurrency +
" AND c_currency_to_id = " + invoice.GetC_Currency_ID() + " AND " + GlobalVariable.TO_DATE(invoice.GetDateAcct(), true) + " BETWEEN ValidFrom AND ValidTo");
multiplyRate = Util.GetValueOfDecimal(DB.ExecuteScalar(_sql.ToString(), null, null));
}
schedule.SetVA009_OpenAmnt(invoice.GetGrandTotal() * multiplyRate);
}
else
{
schedule.SetVA009_OpenAmnt(invoice.GetGrandTotal());
}
schedule.SetC_Currency_ID(invoice.GetC_Currency_ID());
schedule.SetVA009_BseCurrncy(BaseCurrency);
schedule.SetVA009_OpnAmntInvce(invoice.GetGrandTotal());
schedule.SetC_BPartner_ID(invoice.GetC_BPartner_ID());
MOrder _Order = new MOrder(GetCtx(), invoice.GetC_Order_ID(), Get_TrxName());
//schedule.SetVA009_PaymentMethod_ID(_Order.GetVA009_PaymentMethod_ID());
//schedule.SetC_PaymentTerm_ID(_Order.GetC_PaymentTerm_ID());
int _graceDay = payterm.GetGraceDays();
DateTime?_followUpDay = GetDueDate(invoice);
schedule.SetVA009_FollowupDate(_followUpDay.Value.AddDays(_graceDay));
_sql.Clear();
_sql.Append("Select va009_paymentmode, va009_paymenttype, va009_paymenttrigger From va009_paymentmethod where va009_paymentmethod_ID=" + invoice.GetVA009_PaymentMethod_ID() + " AND IsActive = 'Y' AND AD_Client_ID = " + invoice.GetAD_Client_ID());
DataSet ds = new DataSet();
ds = DB.ExecuteDataset(_sql.ToString());
if (ds.Tables != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
schedule.SetVA009_PaymentMode(Util.GetValueOfString(ds.Tables[0].Rows[i]["va009_paymentmode"]));
schedule.SetVA009_PaymentType(Util.GetValueOfString(ds.Tables[0].Rows[i]["va009_paymenttype"]));
schedule.SetVA009_PaymentTrigger(Util.GetValueOfString(ds.Tables[0].Rows[i]["va009_paymenttrigger"]));
schedule.SetVA009_ExecutionStatus("A");
}
}
if (!schedule.Save())
{
return(false);
}
if (invoice.GetC_PaymentTerm_ID() != GetC_PaymentTerm_ID())
{
invoice.SetC_PaymentTerm_ID(GetC_PaymentTerm_ID());
}
return(invoice.ValidatePaySchedule());
}
}
return(true);
}
