/** * Get Tax * @return tax */ public MTax GetTax() { if (_tax == null) { _tax = MTax.Get(GetCtx(), GetC_Tax_ID()); } return(_tax); }
protected override String DoIt() { //int C_Contract_ID = 0; String Sql = "SELECT C_OrderLine_ID FROM C_OrderLine WHERE C_Order_ID=" + orderID + " AND CreateServiceContract='N' AND IsContract='Y' AND IsActive='Y'"; dr = DB.ExecuteReader(Sql); try { VAdvantage.Model.X_C_Order order = new VAdvantage.Model.X_C_Order(GetCtx(), orderID, Get_TrxName()); string DocStatus = order.GetDocStatus(); if (DocStatus != "CO") { if (dr != null) { dr.Close(); dr = null; } return(Msg.GetMsg(GetCtx(), "FirstCompleteOrder")); } while (dr.Read()) { line = new VAdvantage.Model.X_C_OrderLine(GetCtx(), Util.GetValueOfInt(dr[0]), Get_TrxName()); if (line.IsContract() && line.GetC_Contract_ID() == 0) { contact = new VAdvantage.Model.X_C_Contract(GetCtx(), 0, Get_TrxName()); int M_PriceList_ID = Util.GetValueOfInt(order.GetM_PriceList_ID()); //Neha---Commented code because object created but not used in further class---04 Sep,2018 //VAdvantage.Model.MProductPricing pp = new VAdvantage.Model.MProductPricing(GetCtx().GetAD_Client_ID(), GetCtx().GetAD_Org_ID(), // line.GetM_Product_ID(), order.GetC_BPartner_ID(), line.GetQtyOrdered(), true); //pp.SetM_PriceList_ID(M_PriceList_ID); //VAdvantage.Model.MProduct prd = new VAdvantage.Model.MProduct(GetCtx(), line.GetM_Product_ID(), null); //pp.SetC_UOM_ID(prd.GetC_UOM_ID()); string sql = "SELECT pl.IsTaxIncluded,pl.EnforcePriceLimit,pl.C_Currency_ID,c.StdPrecision," + "plv.M_PriceList_Version_ID,plv.ValidFrom " + "FROM M_PriceList pl,C_Currency c,M_PriceList_Version plv " + "WHERE pl.C_Currency_ID=c.C_Currency_ID" + " AND pl.M_PriceList_ID=plv.M_PriceList_ID" + " AND pl.M_PriceList_ID=" + M_PriceList_ID // 1 + "ORDER BY plv.ValidFrom DESC"; //int M_PriceList_Version_ID = 0; int C_Currency_ID = 0; DataSet ds = DB.ExecuteDataset(sql, null, Get_TrxName()); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow dr1 = ds.Tables[0].Rows[i]; // Tax Included isTaxIncluded = Util.GetValueOfString(ds.Tables[0].Rows[i]["IsTaxIncluded"]).Equals("Y"); // Currency C_Currency_ID = Util.GetValueOfInt(ds.Tables[0].Rows[i]["C_Currency_ID"]); // Std Precision StdPrecision = Util.GetValueOfInt(ds.Tables[0].Rows[i]["StdPrecision"]); // int prislst = Util.GetValueOfInt(dr[4].ToString()); // PriceList Version //M_PriceList_Version_ID = Util.GetValueOfInt(ds.Tables[0].Rows[i]["M_PriceList_Version_ID"]); } //int M_PriceList_Version_ID = GetCtx().GetContextAsInt(WindowNo, "M_PriceList_Version_ID"); //pp.SetM_PriceList_Version_ID(M_PriceList_Version_ID); //Neha---Set Tenant,Organization from Sales Order---11 Sep,2018 contact.SetAD_Client_ID(order.GetAD_Client_ID()); contact.SetAD_Org_ID(order.GetAD_Org_ID()); //---------------------End ------------------ contact.SetDescription(order.GetDescription()); contact.SetC_Order_ID(order.GetC_Order_ID()); contact.SetC_OrderLine_ID(line.GetC_OrderLine_ID()); contact.SetStartDate(line.GetStartDate()); contact.SetBillStartDate(line.GetStartDate()); contact.SetEndDate(line.GetEndDate()); contact.SetC_BPartner_ID(order.GetC_BPartner_ID()); contact.SetBill_Location_ID(order.GetBill_Location_ID()); contact.SetBill_User_ID(order.GetBill_User_ID()); contact.SetSalesRep_ID(order.GetSalesRep_ID()); contact.SetC_Currency_ID(line.GetC_Currency_ID()); contact.SetC_ConversionType_ID(order.GetC_ConversionType_ID()); contact.SetC_PaymentTerm_ID(order.GetC_PaymentTerm_ID()); contact.SetM_PriceList_ID(order.GetM_PriceList_ID()); contact.SetC_Frequency_ID(line.GetC_Frequency_ID()); //Neha--Set List Price,Price,Unit Price,Discount from Order Line--4 Sep,2018 //contact.SetPriceList(pp.GetPriceList()); //contact.SetPriceActual(pp.GetPriceStd()); //contact.SetPriceEntered(pp.GetPriceStd()); contact.SetPriceList(line.GetPriceList()); contact.SetPriceActual(line.GetPriceActual()); contact.SetPriceEntered(line.GetPriceEntered()); contact.SetQtyEntered(line.GetQtyPerCycle()); //Decimal discount = Decimal.Round(Decimal.Divide(Decimal.Multiply(Decimal.Subtract(pp.GetPriceList(), pp.GetPriceStd()), new Decimal(100)), pp.GetPriceList()), 2); contact.SetDiscount(line.GetDiscount()); //------------------End---------------------------- //contact.SetGrandTotal( // invoice Count Start //DateTime SDate = (DateTime)(line.GetStartDate()); //DateTime Edate = (DateTime)(line.GetEndDate()); //int frequency = Util.GetValueOfInt(line.GetC_Frequency_ID()); //string PSql = "Select NoOfDays from C_Frequency where C_Frequency_ID=" + frequency; //int days = Util.GetValueOfInt(DB.ExecuteScalar(PSql, null, null)); //int totaldays = (Edate - SDate).Days; //int count = totaldays / days; contact.SetTotalInvoice(line.GetNoofCycle()); //invoice Count end contact.SetC_Project_ID(order.GetC_Project_ID()); // contact.SetPriceList(line.GetPriceList()); //contact.SetPriceActual(line.GetPriceActual()); contact.SetC_UOM_ID(line.GetC_UOM_ID()); contact.SetM_Product_ID(line.GetM_Product_ID()); // Added by Vivek on 21/11/2017 asigned by Pradeep contact.SetM_AttributeSetInstance_ID(line.GetM_AttributeSetInstance_ID()); // contact.SetPriceEntered(line.GetPriceEntered()); //contact.SetQtyEntered(line.GetQtyEntered()); // contact.SetDiscount(line.GetDiscount()); contact.SetC_Tax_ID(line.GetC_Tax_ID()); contact.SetC_Campaign_ID(order.GetC_Campaign_ID()); contact.SetLineNetAmt(Decimal.Multiply(line.GetQtyPerCycle(), line.GetPriceActual())); // if Surcharge Tax is selected on Tax, then set value in Surcharge Amount MTax tax = MTax.Get(GetCtx(), line.GetC_Tax_ID()); if (contact.Get_ColumnIndex("SurchargeAmt") > 0 && tax.GetSurcharge_Tax_ID() > 0) { Decimal surchargeAmt = Env.ZERO; // Calculate Surcharge Amount Decimal TotalRate = tax.CalculateSurcharge(contact.GetLineNetAmt(), isTaxIncluded, StdPrecision, out surchargeAmt); contact.SetTaxAmt(TotalRate); contact.SetSurchargeAmt(surchargeAmt); } else { sql = "SELECT Rate FROM C_Tax WHERE C_Tax_ID = " + line.GetC_Tax_ID(); Decimal?rate = Util.GetValueOfDecimal(DB.ExecuteScalar(sql, null, Get_TrxName())); //Decimal? amt = Decimal.Multiply(pp.GetPriceStd(), (Decimal.Divide(rate.Value, 100))); Decimal?amt = Decimal.Multiply(line.GetPriceActual(), (Decimal.Divide(rate.Value, 100))); amt = Decimal.Round(amt.Value, 2, MidpointRounding.AwayFromZero); Decimal?taxAmt = Decimal.Multiply(amt.Value, line.GetQtyPerCycle()); contact.SetTaxAmt(taxAmt); } // Set Grand Total Amount if (isTaxIncluded) { contact.SetGrandTotal(contact.GetLineNetAmt()); } else { if (contact.Get_ColumnIndex("SurchargeAmt") > 0) { contact.SetGrandTotal(Decimal.Add(Decimal.Add(contact.GetLineNetAmt(), contact.GetTaxAmt()), contact.GetSurchargeAmt())); } else { contact.SetGrandTotal(Decimal.Add(contact.GetLineNetAmt(), contact.GetTaxAmt())); } } //-------------------------End-------------------------- contact.SetDocStatus("DR"); contact.SetRenewContract("N"); if (!contact.Save()) { //Neha----If Service Contract not saved then will show the exception---17 Sep,2018 ValueNamePair pp = VAdvantage.Logging.VLogger.RetrieveError(); if (pp != null) { throw new ArgumentException("Cannot save Service Contract. " + pp.GetName()); } throw new ArgumentException("Cannot save Service Contract"); } else { if (!line.Save()) { //Neha----If Order Line not saved then will show the exception---17 Sep,2018 ValueNamePair pp = VAdvantage.Logging.VLogger.RetrieveError(); if (pp != null) { throw new ArgumentException("Cannot save Order Line. " + pp.GetName()); } throw new ArgumentException("Cannot save Order Line"); } //Neha---Set CreateServiceContract,Order Line ID on Order Line tab---17 Sep,2018 String _qry = "UPDATE C_ORDERLINE SET C_CONTRACT_ID=" + contact.GetC_Contract_ID() + " ,CreateServiceContract='Y' WHERE C_ORDERLINE_ID=" + line.GetC_OrderLine_ID(); DB.ExecuteScalar(_qry, null, Get_TrxName()); } //C_Contract_ID = contact.GetC_Contract_ID(); DocumntNo += contact.GetDocumentNo() + ","; } } dr.Close(); order.SetCreateServiceContract("Y"); if (!order.Save()) { } // Added Document No on Message return(Msg.GetMsg(GetCtx(), "ServiceContractGenerationDone") + DocumntNo.TrimEnd(',')); } catch (Exception ex) { if (dr != null) { dr.Close(); dr = null; } return(Msg.GetMsg(GetCtx(), ex.Message)); } // return ""; }
/// <summary> /// Load Invoice Line /// </summary> /// <param name="invoice">invoice</param> /// <returns>DocLine Array</returns> private DocLine[] LoadLines(MInvoice invoice) { List <DocLine> list = new List <DocLine>(); // MInvoiceLine[] lines = invoice.GetLines(false); for (int i = 0; i < lines.Length; i++) { MInvoiceLine line = lines[i]; if (line.IsDescription()) { continue; } DocLine docLine = new DocLine(line, this); // Qty Decimal Qty = line.GetQtyInvoiced(); bool cm = GetDocumentType().Equals(MDocBaseType.DOCBASETYPE_ARCREDITMEMO) || GetDocumentType().Equals(MDocBaseType.DOCBASETYPE_APCREDITMEMO); docLine.SetQty(cm ? Decimal.Negate(Qty) : Qty, invoice.IsSOTrx()); // Decimal LineNetAmt = line.GetLineNetAmt(); Decimal PriceList = line.GetPriceList(); int C_Tax_ID = docLine.GetC_Tax_ID(); // Correct included Tax if (IsTaxIncluded() && C_Tax_ID != 0) { MTax tax = MTax.Get(GetCtx(), C_Tax_ID); if (!tax.IsZeroTax()) { Decimal LineNetAmtTax = tax.CalculateTax(LineNetAmt, true, GetStdPercision()); log.Fine("LineNetAmt=" + LineNetAmt + " - Tax=" + LineNetAmtTax); LineNetAmt = Decimal.Subtract(LineNetAmt, LineNetAmtTax); for (int t = 0; t < _taxes.Length; t++) { if (_taxes[t].GetC_Tax_ID() == C_Tax_ID) { _taxes[t].AddIncludedTax(LineNetAmtTax); break; } } Decimal PriceListTax = tax.CalculateTax(PriceList, true, GetStdPercision()); PriceList = Decimal.Subtract(PriceList, PriceListTax); } } // correct included Tax docLine.SetAmount(LineNetAmt, PriceList, Qty); // qty for discount calc if (docLine.IsItem()) { _allLinesService = false; } else { _allLinesItem = false; } // log.Fine(docLine.ToString()); list.Add(docLine); } // Convert to Array DocLine[] dls = new DocLine[list.Count]; dls = list.ToArray(); // Included Tax - make sure that no difference if (IsTaxIncluded()) { for (int i = 0; i < _taxes.Length; i++) { if (_taxes[i].IsIncludedTaxDifference()) { Decimal diff = _taxes[i].GetIncludedTaxDifference(); for (int j = 0; j < dls.Length; j++) { if (dls[j].GetC_Tax_ID() == _taxes[i].GetC_Tax_ID()) { dls[j].SetLineNetAmtDifference(diff); break; } } // for all lines } // tax difference } // for all taxes } // Included Tax difference // Return Array return(dls); }
protected override String DoIt() { StringBuilder Sql = new StringBuilder(); string newcon = ""; String date = string.Format("{0:dd/MM/yy}", today); int Record_id = GetRecord_ID(); X_C_Contract con = new X_C_Contract(GetCtx(), Record_id, Get_TrxName()); if (Record_id != 0) { Sql.Append("SELECT RenewalType FROM C_Contract WHERE C_Contract_ID = " + Record_id + " AND RenewContract = 'N' AND IsActive = 'Y' AND AD_Client_ID = " + GetAD_Client_ID()); string renewType = Util.GetValueOfString(DB.ExecuteScalar(Sql.ToString(), null, Get_TrxName())); if (renewType == "M") { Sql.Clear(); Sql.Append("SELECT C_Contract_ID FROM C_Contract WHERE C_Contract_ID=" + Record_id + " AND RenewContract = 'N' AND AD_Client_ID = " + GetAD_Client_ID()); } else { Sql.Clear(); Sql.Append("SELECT C_Contract_ID FROM C_Contract WHERE (EndDate- NVL(CancelBeforeDays,0)) <= SYSDATE AND C_Contract_ID=" + Record_id + " AND RenewContract = 'N' AND AD_Client_ID = " + GetAD_Client_ID()); } } else { Sql.Clear(); Sql.Append("SELECT C_Contract_ID FROM C_Contract WHERE (EndDate- NVL(CancelBeforeDays,0)) <= SYSDATE AND RenewalType='A' AND RenewContract = 'N' AND AD_Client_ID = " + GetAD_Client_ID()); } IDataReader dr = DB.ExecuteReader(Sql.ToString(), null, Get_TrxName()); int count = 0; decimal Listprice = 0, Stdprice = 0, TotalRate = 0; int cycles = 0, duration = 0, frequency = 0, months = 0; DateTime? CDate = null; DateTime OldStart, Start, endDate; MPriceList priceList = null; MTax tax = null; X_C_Contract contact = null; X_C_Contract New = null; ValueNamePair pp = null; try { while (dr.Read()) { contact = new X_C_Contract(GetCtx(), Util.GetValueOfInt(dr[0]), Get_TrxName()); if (contact.GetRenewalType() == "M") { // SI_0772: By Clicking on Renew Contract, System is throwing an error as 'NoContractReNewed'. CDate = contact.GetCancellationDate(); cycles = Util.GetValueOfInt(contact.GetCycles()); if (CDate != null) { continue; } New = new X_C_Contract(GetCtx(), 0, Get_TrxName()); New.SetRefContract(contact.GetDocumentNo()); New.SetC_Order_ID(contact.GetC_Order_ID()); New.SetC_OrderLine_ID(contact.GetC_OrderLine_ID()); OldStart = (DateTime)(contact.GetStartDate()); Start = (DateTime)(contact.GetEndDate()); New.SetStartDate(Start.AddDays(1)); New.SetC_BPartner_ID(contact.GetC_BPartner_ID()); New.SetBill_Location_ID(contact.GetBill_Location_ID()); New.SetBill_User_ID(contact.GetBill_User_ID()); New.SetSalesRep_ID(contact.GetSalesRep_ID()); New.SetC_ConversionType_ID(contact.GetC_ConversionType_ID()); New.SetC_PaymentTerm_ID(contact.GetC_PaymentTerm_ID()); frequency = contact.GetC_Frequency_ID(); New.SetC_Frequency_ID(frequency); // Get No Of Months from Frequency months = Util.GetValueOfInt(DB.ExecuteScalar("SELECT NoOfMonths FROM C_Frequency WHERE C_Frequency_ID=" + frequency, null, Get_TrxName())); duration = months * cycles; endDate = New.GetStartDate().Value.AddMonths(duration); endDate = endDate.AddDays(-1); New.SetEndDate(endDate); New.SetTotalInvoice(cycles); if (Record_id != 0) { // JID_1124: System has to pick the Pricelist in Service Contract as defined in Renewal Pricelist. also need to pick Price from Latest Valid From Date Version New.SetM_PriceList_ID(contact.GetRef_PriceList_ID()); priceList = new MPriceList(GetCtx(), contact.GetRef_PriceList_ID(), Get_TrxName()); Sql.Clear(); Sql.Append("SELECT pp.PriceList, pp.PriceStd FROM M_ProductPrice pp INNER JOIN M_PriceList_Version plv ON pp.M_PriceList_Version_ID = plv.M_PriceList_Version_ID" + " WHERE pp.M_Product_ID=" + contact.GetM_Product_ID() + " AND plv.IsActive='Y' AND plv.M_PriceList_ID=" + contact.GetRef_PriceList_ID() + " AND plv.VALIDFROM <= SYSDATE ORDER BY plv.VALIDFROM DESC"); DataSet ds = DB.ExecuteDataset(Sql.ToString(), null, Get_TrxName()); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { Listprice = Util.GetValueOfDecimal(ds.Tables[0].Rows[0]["PriceList"]); Stdprice = Util.GetValueOfDecimal(ds.Tables[0].Rows[0]["PriceStd"]); } else { dr.Close(); Get_TrxName().Rollback(); return(Msg.GetMsg(GetCtx(), "ProductNotOnPriceList")); } //int Version = Util.GetValueOfInt(DB.ExecuteScalar(Query)); //Query = "SELECT PriceList FROM M_ProductPrice WHERE M_PriceList_Version_ID=" + Version + " AND M_Product_ID=" + contact.GetM_Product_ID(); //decimal Listprice = Util.GetValueOfInt(DB.ExecuteScalar(Query)); //Query = "SELECT PriceStd FROM M_ProductPrice WHERE M_PriceList_Version_ID=" + Version + " AND M_Product_ID=" + contact.GetM_Product_ID(); //decimal Stdprice = Util.GetValueOfInt(DB.ExecuteScalar(Query)); //if (Stdprice == 0 && Listprice == 0) //{ // dr.Close(); // return Msg.GetMsg(GetCtx(), "ProductNotINPriceList"); //} New.SetPriceEntered(Stdprice); New.SetPriceActual(Stdprice); New.SetPriceList(Listprice); } else { priceList = new MPriceList(GetCtx(), contact.GetM_PriceList_ID(), Get_TrxName()); New.SetM_PriceList_ID(contact.GetM_PriceList_ID()); New.SetPriceEntered(contact.GetPriceEntered()); New.SetPriceActual(contact.GetPriceActual()); New.SetPriceList(contact.GetPriceList()); } New.SetC_Currency_ID(priceList.GetC_Currency_ID()); New.SetC_UOM_ID(contact.GetC_UOM_ID()); New.SetM_Product_ID(contact.GetM_Product_ID()); New.SetM_AttributeSetInstance_ID(contact.GetM_AttributeSetInstance_ID()); New.SetQtyEntered(contact.GetQtyEntered()); New.SetC_Tax_ID(contact.GetC_Tax_ID()); New.SetC_Campaign_ID(contact.GetC_Campaign_ID()); New.SetRef_Contract_ID(contact.GetC_Contract_ID()); New.SetC_Project_ID(contact.GetC_Project_ID()); New.SetDescription(contact.GetDescription()); //New.SetTaxAmt(contact.GetTaxAmt()); New.SetCancelBeforeDays(contact.GetCancelBeforeDays()); New.SetCycles(contact.GetCycles()); New.SetRenewContract("N"); New.SetScheduleContract("N"); New.SetDocStatus("DR"); New.SetRenewalType("M"); New.SetLineNetAmt(Decimal.Multiply(New.GetPriceEntered(), New.GetQtyEntered())); //String sqltax = "SELECT Rate FROM C_Tax WHERE C_Tax_ID=" + contact.GetC_Tax_ID(); //Decimal? Rate = Util.GetValueOfDecimal(DB.ExecuteScalar(sqltax, null, Get_TrxName())); //Decimal? TotalRate = Util.GetValueOfDecimal((Util.GetValueOfDecimal(New.GetLineNetAmt()) * Util.GetValueOfDecimal(Rate)) / 100); //TotalRate = Decimal.Round(TotalRate.Value, 2); // if Surcharge Tax is selected on Tax, then set value in Surcharge Amount if (New.Get_ColumnIndex("SurchargeAmt") > 0 && tax.GetSurcharge_Tax_ID() > 0) { Decimal surchargeAmt = Env.ZERO; // Calculate Surcharge Amount TotalRate = tax.CalculateSurcharge(New.GetLineNetAmt(), priceList.IsTaxIncluded(), priceList.GetStandardPrecision(), out surchargeAmt); New.SetTaxAmt(TotalRate); New.SetSurchargeAmt(surchargeAmt); } else { // Calculate Tax Amount tax = MTax.Get(GetCtx(), contact.GetC_Tax_ID()); TotalRate = tax.CalculateTax(New.GetLineNetAmt(), priceList.IsTaxIncluded(), priceList.GetPricePrecision()); New.SetTaxAmt(TotalRate); } // Calculate Discount % Decimal?dis = Decimal.Multiply(Decimal.Divide(Decimal.Subtract(New.GetPriceList(), New.GetPriceEntered()), New.GetPriceList()), 100); New.SetDiscount(dis); // Set Grand Total Amount if (priceList.IsTaxIncluded()) { New.SetGrandTotal(New.GetLineNetAmt()); } else { if (New.Get_ColumnIndex("SurchargeAmt") > 0) { New.SetGrandTotal(Decimal.Add(Decimal.Add(New.GetLineNetAmt(), New.GetTaxAmt()), New.GetSurchargeAmt())); } else { New.SetGrandTotal(Decimal.Add(New.GetLineNetAmt(), New.GetTaxAmt())); } } if (contact.GetBillStartDate() != null) { New.SetBillStartDate(contact.GetBillStartDate().Value.AddMonths(contact.GetTotalInvoice())); } else { New.SetBillStartDate(New.GetStartDate()); } if (New.Save()) { newcon = New.GetDocumentNo(); count++; if (Record_id != 0) { contact.SetRef_Contract_ID(New.GetC_Contract_ID()); contact.SetRenewContract("Y"); if (!contact.Save()) { dr.Close(); Get_TrxName().Rollback(); return(Msg.GetMsg(GetCtx(), "ContractNotRenew")); } } } else { dr.Close(); Get_TrxName().Rollback(); pp = VLogger.RetrieveError(); if (pp != null) { return(!String.IsNullOrEmpty(pp.GetName()) ? pp.GetName() : Msg.GetMsg(GetCtx(), "ContractNotRenew")); } else { return(Msg.GetMsg(GetCtx(), "ContractNotRenew")); } } } else { // SI_0772: By Clicking on Renew Contract, System is throwing an error as 'NoContractReNewed'. CDate = contact.GetCancellationDate(); cycles = contact.GetCycles(); if (CDate != null) { continue; } New = new X_C_Contract(GetCtx(), 0, Get_TrxName()); New.SetRefContract(contact.GetDocumentNo()); New.SetC_Order_ID(contact.GetC_Order_ID()); New.SetC_OrderLine_ID(contact.GetC_OrderLine_ID()); OldStart = (DateTime)(contact.GetStartDate()); Start = (DateTime)(contact.GetEndDate()); New.SetStartDate(Start.AddDays(1)); frequency = contact.GetC_Frequency_ID(); // Get No Of Months from Frequency months = Util.GetValueOfInt(DB.ExecuteScalar("SELECT NoOfMonths FROM C_Frequency WHERE C_Frequency_ID=" + frequency, null, Get_TrxName())); duration = months * cycles; endDate = New.GetStartDate().Value.AddMonths(duration); endDate = endDate.AddDays(-1); New.SetEndDate(endDate); New.SetC_BPartner_ID(contact.GetC_BPartner_ID()); New.SetBill_Location_ID(contact.GetBill_Location_ID()); New.SetBill_User_ID(contact.GetBill_User_ID()); New.SetSalesRep_ID(contact.GetSalesRep_ID()); New.SetC_ConversionType_ID(contact.GetC_ConversionType_ID()); New.SetC_PaymentTerm_ID(contact.GetC_PaymentTerm_ID()); New.SetC_Frequency_ID(frequency); // invoice Count Start if (Record_id != 0) { if (contact.GetRef_PriceList_ID() == 0) { dr.Close(); Get_TrxName().Rollback(); return(Msg.GetMsg(GetCtx(), "FirstSelectPriceList")); } New.SetM_PriceList_ID(contact.GetRef_PriceList_ID()); priceList = new MPriceList(GetCtx(), contact.GetRef_PriceList_ID(), Get_TrxName()); Sql.Clear(); Sql.Append("SELECT pp.PriceList, pp.PriceStd FROM M_ProductPrice pp INNER JOIN M_PriceList_Version plv ON pp.M_PriceList_Version_ID = plv.M_PriceList_Version_ID" + " WHERE pp.M_Product_ID=" + contact.GetM_Product_ID() + " AND plv.IsActive='Y' AND plv.M_PriceList_ID=" + contact.GetRef_PriceList_ID() + " AND plv.VALIDFROM <= SYSDATE ORDER BY plv.VALIDFROM DESC"); DataSet ds = DB.ExecuteDataset(Sql.ToString(), null, Get_TrxName()); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { Listprice = Util.GetValueOfDecimal(ds.Tables[0].Rows[0]["PriceList"]); Stdprice = Util.GetValueOfDecimal(ds.Tables[0].Rows[0]["PriceStd"]); } else { dr.Close(); Get_TrxName().Rollback(); return(Msg.GetMsg(GetCtx(), "ProductNotOnPriceList")); } //String Query = "Select M_PriceList_Version_id from M_PriceList_Version where IsActive='Y' and M_PriceList_Id=" + contact.GetRef_PriceList_ID(); //int Version = Util.GetValueOfInt(DB.ExecuteScalar(Query)); //Query = "Select PriceList,PriceStd from M_ProductPrice where M_PriceList_Version_id=" + Version + " and M_Product_ID=" + contact.GetM_Product_ID(); //decimal Listprice = Util.GetValueOfInt(DB.ExecuteScalar(Query)); //Query = "Select PriceList,PriceStd from M_ProductPrice where M_PriceList_Version_id=" + Version + " and M_Product_ID=" + contact.GetM_Product_ID(); //decimal Stdprice = Util.GetValueOfInt(DB.ExecuteScalar(Query)); //if (Stdprice == 0 && Listprice == 0) //{ // return Msg.GetMsg(GetCtx(), "ProductNotINPriceList"); //} New.SetPriceEntered(Stdprice); New.SetPriceActual(Stdprice); New.SetPriceList(Listprice); } else { priceList = new MPriceList(GetCtx(), contact.GetM_PriceList_ID(), Get_TrxName()); New.SetM_PriceList_ID(contact.GetM_PriceList_ID()); New.SetPriceActual(contact.GetPriceActual()); New.SetPriceList(contact.GetPriceList()); New.SetPriceEntered(contact.GetPriceEntered()); } New.SetTotalInvoice(contact.GetCycles()); New.SetC_Currency_ID(priceList.GetC_Currency_ID()); New.SetC_UOM_ID(contact.GetC_UOM_ID()); New.SetM_Product_ID(contact.GetM_Product_ID()); New.SetM_AttributeSetInstance_ID(contact.GetM_AttributeSetInstance_ID()); New.SetQtyEntered(contact.GetQtyEntered()); New.SetC_Tax_ID(contact.GetC_Tax_ID()); New.SetC_Campaign_ID(contact.GetC_Campaign_ID()); New.SetRef_Contract_ID(contact.GetC_Contract_ID()); New.SetC_Project_ID(contact.GetC_Project_ID()); New.SetDescription(contact.GetDescription()); New.SetCancelBeforeDays(contact.GetCancelBeforeDays()); New.SetCycles(contact.GetCycles()); New.SetRenewContract("N"); New.SetScheduleContract("Y"); New.SetRenewalType("A"); New.SetDocStatus("DR"); New.SetLineNetAmt(Decimal.Multiply(New.GetPriceEntered(), New.GetQtyEntered())); // Calculate Tax Amount tax = MTax.Get(GetCtx(), contact.GetC_Tax_ID()); // if Surcharge Tax is selected on Tax, then set value in Surcharge Amount if (New.Get_ColumnIndex("SurchargeAmt") > 0 && tax.GetSurcharge_Tax_ID() > 0) { Decimal surchargeAmt = Env.ZERO; // Calculate Surcharge Amount TotalRate = tax.CalculateSurcharge(New.GetLineNetAmt(), priceList.IsTaxIncluded(), priceList.GetStandardPrecision(), out surchargeAmt); New.SetTaxAmt(TotalRate); New.SetSurchargeAmt(surchargeAmt); } else { TotalRate = tax.CalculateTax(New.GetLineNetAmt(), priceList.IsTaxIncluded(), priceList.GetPricePrecision()); New.SetTaxAmt(TotalRate); } // Calculate Discount % Decimal?dis = Decimal.Multiply(Decimal.Divide(Decimal.Subtract(New.GetPriceList(), New.GetPriceEntered()), New.GetPriceList()), 100); New.SetDiscount(dis); // Set Grand Total Amount if (priceList.IsTaxIncluded()) { New.SetGrandTotal(New.GetLineNetAmt()); } else { if (New.Get_ColumnIndex("SurchargeAmt") > 0) { New.SetGrandTotal(Decimal.Add(Decimal.Add(New.GetLineNetAmt(), New.GetTaxAmt()), New.GetSurchargeAmt())); } else { New.SetGrandTotal(Decimal.Add(New.GetLineNetAmt(), New.GetTaxAmt())); } } if (contact.GetBillStartDate() != null) { New.SetBillStartDate(contact.GetBillStartDate().Value.AddMonths(contact.GetTotalInvoice())); } else { New.SetBillStartDate(New.GetStartDate()); } if (New.Save()) { newcon = New.GetDocumentNo(); count++; contact.SetRef_Contract_ID(New.GetC_Contract_ID()); contact.SetRenewContract("Y"); if (!contact.Save()) { dr.Close(); Get_TrxName().Rollback(); return(Msg.GetMsg(GetCtx(), "ContractNotRenew")); } if (!EnterSchedules(New.GetC_Contract_ID(), cycles)) { dr.Close(); Get_TrxName().Rollback(); return(Msg.GetMsg(GetCtx(), "ContractNotRenew")); } New.SetProcessed(true); if (!New.Save()) { dr.Close(); Get_TrxName().Rollback(); return(Msg.GetMsg(GetCtx(), "ContractNotRenew")); } } else { dr.Close(); Get_TrxName().Rollback(); pp = VLogger.RetrieveError(); if (pp != null) { return(!String.IsNullOrEmpty(pp.GetName()) ? pp.GetName() : Msg.GetMsg(GetCtx(), "ContractNotRenew")); } else { return(Msg.GetMsg(GetCtx(), "ContractNotRenew")); } } } } dr.Close(); if (count != 0 && Record_id != 0) { return(Msg.GetMsg(GetCtx(), "ContractReNewed") + ": " + newcon); } if (count != 0) { return(Msg.GetMsg(GetCtx(), "ContractReNewed")); } return(Msg.GetMsg(GetCtx(), "ContractNotRenew")); } catch { if (dr != null) { dr.Close(); dr = null; } } finally { if (dr != null) { dr.Close(); dr = null; } } return(Msg.GetMsg(GetCtx(), "ContractNotRenew")); }
/// <summary> /// Load Invoice Line /// </summary> /// <param name="order">order</param> /// <returns>DocLine Array</returns> private DocLine[] LoadLines(MOrder order) { List <DocLine> list = new List <DocLine>(); MOrderLine[] lines = order.GetLines(); for (int i = 0; i < lines.Length; i++) { MOrderLine line = lines[i]; DocLine docLine = new DocLine(line, this); Decimal Qty = line.GetQtyOrdered(); docLine.SetQty(Qty, order.IsSOTrx()); // // Decimal PriceActual = line.getPriceActual(); Decimal?PriceCost = null; if (GetDocumentType().Equals(MDocBaseType.DOCBASETYPE_PURCHASEORDER)) // PO { PriceCost = line.GetPriceCost(); } Decimal?LineNetAmt = null; if (PriceCost != null && Env.Signum(PriceCost.Value) != 0) { LineNetAmt = Decimal.Multiply(Qty, PriceCost.Value); } else { LineNetAmt = line.GetLineNetAmt(); } docLine.SetAmount(LineNetAmt); // DR Decimal PriceList = line.GetPriceList(); int C_Tax_ID = docLine.GetC_Tax_ID(); // Correct included Tax if (IsTaxIncluded() && C_Tax_ID != 0) { MTax tax = MTax.Get(GetCtx(), C_Tax_ID); if (!tax.IsZeroTax()) { Decimal LineNetAmtTax = tax.CalculateTax(LineNetAmt.Value, true, GetStdPrecision()); log.Fine("LineNetAmt=" + LineNetAmt + " - Tax=" + LineNetAmtTax); LineNetAmt = Decimal.Subtract(LineNetAmt.Value, LineNetAmtTax); for (int t = 0; t < _taxes.Length; t++) { if (_taxes[t].GetC_Tax_ID() == C_Tax_ID) { _taxes[t].AddIncludedTax(LineNetAmtTax); break; } } Decimal PriceListTax = tax.CalculateTax(PriceList, true, GetStdPrecision()); PriceList = Decimal.Subtract(PriceList, PriceListTax); } } // correct included Tax docLine.SetAmount(LineNetAmt, PriceList, Qty); list.Add(docLine); } // Return Array DocLine[] dl = new DocLine[list.Count]; dl = list.ToArray(); return(dl); }
/// <summary> /// Get Commitments /// </summary> /// <param name="doc">document</param> /// <param name="maxQty">Qty invoiced/matched</param> /// <param name="C_InvoiceLine_ID">invoice line</param> /// <returns>commitments (order lines)</returns> protected static DocLine[] GetCommitments(Doc doc, Decimal maxQty, int C_InvoiceLine_ID) { int precision = -1; // List <DocLine> list = new List <DocLine>(); String sql = "SELECT * FROM C_OrderLine ol " + "WHERE EXISTS " + "(SELECT * FROM C_InvoiceLine il " + "WHERE il.C_OrderLine_ID=ol.C_OrderLine_ID" + " AND il.C_InvoiceLine_ID=" + C_InvoiceLine_ID + ")" + " OR EXISTS " + "(SELECT * FROM M_MatchPO po " + "WHERE po.C_OrderLine_ID=ol.C_OrderLine_ID" + " AND po.C_InvoiceLine_ID=" + C_InvoiceLine_ID + ")"; IDataReader idr = null; try { idr = DataBase.DB.ExecuteReader(sql, null, null); while (idr.Read()) { if (Env.Signum(maxQty) == 0) { continue; } MOrderLine line = new MOrderLine(doc.GetCtx(), idr, null); DocLine docLine = new DocLine(line, doc); // Currency if (precision == -1) { doc.SetC_Currency_ID(docLine.GetC_Currency_ID()); precision = MCurrency.GetStdPrecision(doc.GetCtx(), docLine.GetC_Currency_ID()); } // Qty Decimal Qty = Math.Max(line.GetQtyOrdered(), maxQty); docLine.SetQty(Qty, false); // Decimal PriceActual = line.GetPriceActual(); Decimal PriceCost = line.GetPriceCost(); Decimal?LineNetAmt = null; if (Env.Signum(PriceCost) != 0) { LineNetAmt = Decimal.Multiply(Qty, PriceCost); } else if (Qty.Equals(maxQty)) { LineNetAmt = line.GetLineNetAmt(); } else { LineNetAmt = Decimal.Multiply(Qty, PriceActual); } maxQty = Decimal.Subtract(maxQty, Qty); docLine.SetAmount(LineNetAmt); // DR Decimal PriceList = line.GetPriceList(); int C_Tax_ID = docLine.GetC_Tax_ID(); // Correct included Tax if (C_Tax_ID != 0 && line.GetParent().IsTaxIncluded()) { MTax tax = MTax.Get(doc.GetCtx(), C_Tax_ID); if (!tax.IsZeroTax()) { Decimal LineNetAmtTax = tax.CalculateTax(LineNetAmt.Value, true, precision); _log.Fine("LineNetAmt=" + LineNetAmt + " - Tax=" + LineNetAmtTax); LineNetAmt = Decimal.Subtract(LineNetAmt.Value, LineNetAmtTax); Decimal PriceListTax = tax.CalculateTax(PriceList, true, precision); PriceList = Decimal.Subtract(PriceList, PriceListTax); } } // correct included Tax docLine.SetAmount(LineNetAmt, PriceList, Qty); list.Add(docLine); } idr.Close(); } catch (Exception e) { if (idr != null) { idr.Close(); idr = null; } _log.Log(Level.SEVERE, sql, e); } // Return Array DocLine[] dl = new DocLine[list.Count]; dl = list.ToArray(); return(dl); }