/// <summary>
/// Get Charge Account
/// </summary>
/// <param name="as1">account schema</param>
/// <param name="amount">amount for expense(+)/revenue(-)</param>
/// <returns>Charge Account or null</returns>
public MAccount GetChargeAccount(MAcctSchema as1, Decimal?amount)
{
int C_Charge_ID = GetC_Charge_ID();
if (C_Charge_ID == 0)
{
return(null);
}
return(MCharge.GetAccount(C_Charge_ID, as1, amount.Value));
}
/// <summary>
/// New Order Line (different Product)
/// </summary>
/// <param name="rLine">request line</param>
private void NewLine(MRequisitionLine rLine)
{
if (_orderLine != null)
{
if (!_orderLine.Save())
{
throw new Exception("Cannot update Order Line");
}
}
_orderLine = null;
MProduct product = null;
// Get Business Partner
int C_BPartner_ID = rLine.GetC_BPartner_ID();
if (C_BPartner_ID != 0)
{
;
}
else if (rLine.GetC_Charge_ID() != 0)
{
MCharge charge = MCharge.Get(GetCtx(), rLine.GetC_Charge_ID());
C_BPartner_ID = charge.GetC_BPartner_ID();
if (C_BPartner_ID == 0)
{
throw new Exception("No Vendor for Charge " + charge.GetName());
}
}
else
{
// Find Vendor from Produt
product = MProduct.Get(GetCtx(), rLine.GetM_Product_ID());
MProductPO[] ppos = MProductPO.GetOfProduct(GetCtx(), product.GetM_Product_ID(), null);
for (int i = 0; i < ppos.Length; i++)
{
if (ppos[i].IsCurrentVendor() && ppos[i].GetC_BPartner_ID() != 0)
{
C_BPartner_ID = ppos[i].GetC_BPartner_ID();
break;
}
}
if (C_BPartner_ID == 0 && ppos.Length > 0)
{
C_BPartner_ID = ppos[0].GetC_BPartner_ID();
}
if (C_BPartner_ID == 0)
{
throw new Exception("No Vendor for " + product.GetName());
}
}
// New Order - Different Vendor
if (_order == null ||
_order.GetC_BPartner_ID() != C_BPartner_ID)
{
NewOrder(rLine, C_BPartner_ID);
}
// No Order Line
_orderLine = new MOrderLine(_order);
if (product != null)
{
_orderLine.SetProduct(product);
_orderLine.SetM_AttributeSetInstance_ID(rLine.GetM_AttributeSetInstance_ID());
}
else
{
_orderLine.SetC_Charge_ID(rLine.GetC_Charge_ID());
_orderLine.SetPriceActual(rLine.GetPriceActual());
}
_orderLine.SetAD_Org_ID(rLine.GetAD_Org_ID());
// Prepare Save
_m_M_Product_ID = rLine.GetM_Product_ID();
_m_M_AttributeSetInstance_ID = rLine.GetM_AttributeSetInstance_ID();
if (!_orderLine.Save())
{
throw new Exception("Cannot save Order Line");
}
}
/// <summary>
/// Create Invoice.
/// </summary>
/// <returns>document no</returns>
protected override String DoIt()
{
StringBuilder invDocumentNo = new StringBuilder();
int count = Util.GetValueOfInt(DB.ExecuteScalar(" SELECT Count(*) FROM M_Inout WHERE ISSOTRX='Y' AND M_Inout_ID=" + GetRecord_ID()));
MInOut ship = null;
bool isAllownonItem = Util.GetValueOfString(GetCtx().GetContext("$AllowNonItem")).Equals("Y");
if (count > 0)
{
if (_M_InOut_ID == 0)
{
throw new ArgumentException("No Shipment");
}
//
ship = new MInOut(GetCtx(), _M_InOut_ID, Get_Trx());
if (ship.Get_ID() == 0)
{
throw new ArgumentException("Shipment not found");
}
if (!MInOut.DOCSTATUS_Completed.Equals(ship.GetDocStatus()))
{
// JID_0750: done by Bharat on 05 Feb 2019 if Customer Return document and status is not complete it should give message "Customer Return Not Completed".
if (ship.IsReturnTrx())
{
throw new ArgumentException("Customer Return Not Completed");
}
else
{
throw new ArgumentException("Shipment Not Completed");
}
}
}
else
{
if (_M_InOut_ID == 0)
{
throw new ArgumentException("No Material Receipt");
}
//
ship = new MInOut(GetCtx(), _M_InOut_ID, Get_Trx());
if (ship.Get_ID() == 0)
{
throw new ArgumentException("Material Receipt not found");
}
if (!MInOut.DOCSTATUS_Completed.Equals(ship.GetDocStatus()))
{
// JID_0750: done by Bharat on 05 Feb 2019 if Return to vendor document and status is not complete it should give message "Return To Vendor Not Completed".
if (ship.IsReturnTrx())
{
throw new ArgumentException("Return To Vendor Not Completed");
}
else
{
throw new ArgumentException("Material Receipt Not Completed");
}
}
}
// When record contain more than single order and order having different Payment term or Price List then not to generate invoices
// JID_0976 - For conversion Type
if (ship.GetC_Order_ID() > 0 && Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT COUNT(DISTINCT c_order.m_pricelist_id) + count(distinct c_order.c_paymentterm_id) + count(distinct COALESCE( c_order.C_ConversionType_ID , " + MConversionType.GetDefault(GetAD_Client_ID()) + @")) as recordcount
FROM m_inoutline INNER JOIN c_orderline ON m_inoutline.c_orderline_id = c_orderline.c_orderline_id
INNER JOIN c_order ON c_order.c_order_id = c_orderline.c_order_id
WHERE m_inoutline.m_inout_id = " + _M_InOut_ID + @" GROUP BY m_inoutline.m_inout_id ", null, Get_Trx())) > 3)
{
if (ship.IsSOTrx())
{
//Different Payment Terms, Price list found against the selected orders, use "Generate Invoice" process to create multiple invoices.
throw new ArgumentException(Msg.GetMsg(GetCtx(), "VIS_SoDifferentPayAndPrice"));
}
else
{
//Different Payment Terms, Price list found against the selected orders
throw new ArgumentException(Msg.GetMsg(GetCtx(), "VIS_DifferentPayAndPrice"));
}
}
// Create Invoice Header
MInvoice invoice = new MInvoice(ship, null);
//Payment Management
int _CountVA009 = Env.IsModuleInstalled("VA009_") ? 1 : 0;
// Amortization
int _CountVA038 = Env.IsModuleInstalled("VA038_") ? 1 : 0;
if (_CountVA009 > 0)
{
int _PaymentMethod_ID = Util.GetValueOfInt(DB.ExecuteScalar("Select VA009_PaymentMethod_ID From C_Order Where C_Order_ID=" + ship.GetC_Order_ID(), null, Get_Trx()));
// 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
int bpPamentMethod_ID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT " + (ship.IsSOTrx() ? " VA009_PaymentMethod_ID " : " VA009_PO_PaymentMethod_ID ") +
@" FROM C_BPartner WHERE C_BPartner_ID = " + ship.GetC_BPartner_ID(), null, Get_Trx()));
if (bpPamentMethod_ID != 0)
{
_PaymentMethod_ID = bpPamentMethod_ID;
}
if (_PaymentMethod_ID > 0)
{
invoice.SetVA009_PaymentMethod_ID(_PaymentMethod_ID);
}
}
// Letter Of Credit
int _CountVA026 = Env.IsModuleInstalled("VA026_") ? 1 : 0;
if (_CountVA026 > 0)
{
int VA026_LCDetail_ID = Util.GetValueOfInt(DB.ExecuteScalar("Select VA026_LCDetail_ID From C_Order Where C_Order_ID=" + ship.GetC_Order_ID(), null, Get_Trx()));
if (VA026_LCDetail_ID > 0)
{
invoice.SetVA026_LCDetail_ID(VA026_LCDetail_ID);
}
}
//end
if (ship.IsReturnTrx())
{
if (!ship.IsSOTrx())
{
// Purchase Return
// set target document from documnet type window -- based on documnet type available on material receipt / return to vendor
// JID_0779: Create AP Credit memo if we run the Generate TO process from Returm to Vendor window.
//if (invoice.GetC_DocTypeTarget_ID() == 0)
//{
if (_C_DocType_ID > 0)
{
invoice.SetC_DocTypeTarget_ID(_C_DocType_ID);
}
else
{
int C_DocTypeTarget_ID = DB.GetSQLValue(null, "SELECT C_DocTypeInvoice_ID FROM C_DocType WHERE C_DocType_ID=@param1", ship.GetC_DocType_ID());
if (C_DocTypeTarget_ID > 0)
{
invoice.SetC_DocTypeTarget_ID(C_DocTypeTarget_ID);
}
else
{
invoice.SetC_DocTypeTarget_ID(ship.IsSOTrx() ? MDocBaseType.DOCBASETYPE_ARCREDITMEMO : MDocBaseType.DOCBASETYPE_APCREDITMEMO);
}
}
invoice.SetIsReturnTrx(ship.IsReturnTrx());
invoice.SetIsSOTrx(ship.IsSOTrx());
}
else
{
// Sales Return
if (_C_DocType_ID > 0)
{
invoice.SetC_DocTypeTarget_ID(_C_DocType_ID);
}
else
{
if (ship.GetC_Order_ID() >= 0)
{
int C_DocType_ID = Util.GetValueOfInt(DB.ExecuteScalar("Select C_DocType_ID From C_Order Where C_Order_ID=" + ship.GetC_Order_ID(), null, Get_Trx()));
MDocType dt = MDocType.Get(GetCtx(), C_DocType_ID);
if (dt.GetC_DocTypeInvoice_ID() != 0)
{
invoice.SetC_DocTypeTarget_ID(dt.GetC_DocTypeInvoice_ID(), true);
}
else
{
invoice.SetC_DocTypeTarget_ID(ship.IsSOTrx() ? MDocBaseType.DOCBASETYPE_ARCREDITMEMO : MDocBaseType.DOCBASETYPE_APCREDITMEMO);
}
}
else
{
invoice.SetC_DocTypeTarget_ID(ship.IsSOTrx() ? MDocBaseType.DOCBASETYPE_ARCREDITMEMO : MDocBaseType.DOCBASETYPE_APCREDITMEMO);
}
}
}
}
if (_M_PriceList_ID != 0)
{
invoice.SetM_PriceList_ID(_M_PriceList_ID);
}
//Set InvoiceDocumentNo to InvoiceReference
if (_InvoiceDocumentNo != null && _InvoiceDocumentNo.Length > 0)
{
invoice.Set_Value("InvoiceReference", _InvoiceDocumentNo);
}
//Set TargetDoctype
if (_C_DocType_ID > 0 && !ship.IsReturnTrx())
{
invoice.Set_Value("C_DocTypeTarget_ID", _C_DocType_ID);
}
// Added by Bharat on 30 Jan 2018 to set Inco Term from Order
if (invoice.Get_ColumnIndex("C_IncoTerm_ID") > 0)
{
invoice.SetC_IncoTerm_ID(ship.GetC_IncoTerm_ID());
}
//To get Payment Rule and set the Payment method
if (invoice.GetPaymentRule() != "")
{
invoice.SetPaymentMethod(invoice.GetPaymentRule());
}
if (!invoice.Save())
{
//SI_0708 - message was not upto the mark
ValueNamePair pp = VAdvantage.Logging.VLogger.RetrieveError();
if (pp != null)
{
throw new ArgumentException("Cannot save Invoice. " + pp.GetName());
}
throw new ArgumentException("Cannot save Invoice");
}
MInOutLine[] shipLines = ship.GetLines(false);
DateTime? AmortStartDate = null;
DateTime? AmortEndDate = null;
count = 0;
DataSet ds = null;
DataSet dsDoc = null;
for (int i = 0; i < shipLines.Length; i++)
{
MInOutLine sLine = shipLines[i];
// Changes done by Bharat on 06 July 2017 restrict to create invoice if Invoice already created against that for same quantity
string sql = @"SELECT ml.QtyEntered - SUM(COALESCE(li.QtyEntered,0)) as QtyEntered, ml.MovementQty- SUM(COALESCE(li.QtyInvoiced, 0)) as QtyInvoiced" +
" FROM M_InOutLine ml INNER JOIN C_InvoiceLine li ON li.M_InOutLine_ID = ml.M_InOutLine_ID INNER JOIN C_Invoice ci ON ci.C_Invoice_ID = li.C_Invoice_ID " +
" WHERE ci.DocStatus NOT IN ('VO', 'RE') AND ml.M_InOutLine_ID =" + sLine.GetM_InOutLine_ID() + " GROUP BY ml.MovementQty, ml.QtyEntered";
ds = DB.ExecuteDataset(sql, null, Get_Trx());
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
decimal qtyEntered = Util.GetValueOfDecimal(ds.Tables[0].Rows[0]["QtyEntered"]);
decimal qtyInvoiced = Util.GetValueOfDecimal(ds.Tables[0].Rows[0]["QtyInvoiced"]);
if (qtyEntered <= 0)
{
// Getting document number Count if Invoice already generated for Material Receipt
string StrSql = "SELECT ci.DocumentNo,li.M_InOutLine_ID FROM C_InvoiceLine li INNER JOIN C_Invoice ci ON ci.C_Invoice_ID = li.C_Invoice_ID " +
" WHERE ci.DocStatus NOT IN ('VO', 'RE') AND li.M_InOutLine_ID = " + sLine.GetM_InOutLine_ID();
dsDoc = DB.ExecuteDataset(StrSql, null, Get_Trx());
if (dsDoc != null && dsDoc.Tables[0].Rows.Count > 0)
{
for (int j = 0; j < dsDoc.Tables[0].Rows.Count; j++)
{
// JID_1358: Need to show document number in message if Invoice already generated for Material Receipt
string no = invDocumentNo.ToString();
if (invDocumentNo.Length > 0 && no != Util.GetValueOfString(dsDoc.Tables[0].Rows[j]["DocumentNo"]))
{
invDocumentNo.Append(", " + Util.GetValueOfString(dsDoc.Tables[0].Rows[j]["DocumentNo"]));
}
else
{
invDocumentNo.Clear();
invDocumentNo.Append(Util.GetValueOfString(dsDoc.Tables[0].Rows[j]["DocumentNo"]));
}
ds.Dispose();
log.Info("Invoice Line already exist for Receipt Line ID - " + sLine.GetM_InOutLine_ID());
continue;
}
dsDoc.Dispose();
}
}
else
{
MInvoiceLine line = new MInvoiceLine(invoice);
line.SetShipLine(sLine);
line.SetQtyEntered(qtyEntered);
line.SetQtyInvoiced(qtyInvoiced);
// Change By Mohit Amortization process -------------
if (_CountVA038 > 0)
{
if (line.GetM_Product_ID() > 0)
{
//MProduct pro = new MProduct(GetCtx(), sLine.GetM_Product_ID(), Get_TrxName());
int VA038_AmortizationTemplate_ID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT VA038_AmortizationTemplate_ID
FROM M_Product WHERE M_Product_ID = " + sLine.GetM_Product_ID(), null, Get_Trx()));
if (VA038_AmortizationTemplate_ID > 0)
{
line.Set_Value("VA038_AmortizationTemplate_ID", VA038_AmortizationTemplate_ID);
DataSet amrtDS = DB.ExecuteDataset("SELECT VA038_AmortizationType,VA038_AmortizationPeriod,VA038_TermSource,VA038_PeriodType,Name FROM VA038_AmortizationTemplate WHERE IsActive='Y' AND VA038_AMORTIZATIONTEMPLATE_ID=" + VA038_AmortizationTemplate_ID);
AmortStartDate = null;
AmortEndDate = null;
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_TermSource"]) == "A")
{
AmortStartDate = invoice.GetDateAcct();
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_TermSource"]) == "T")
{
AmortStartDate = invoice.GetDateInvoiced();
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_PeriodType"]) == "M")
{
AmortEndDate = AmortStartDate.Value.AddMonths(Util.GetValueOfInt(amrtDS.Tables[0].Rows[0]["VA038_AmortizationPeriod"]));
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_PeriodType"]) == "Y")
{
AmortEndDate = AmortStartDate.Value.AddYears(Util.GetValueOfInt(amrtDS.Tables[0].Rows[0]["VA038_AmortizationPeriod"]));
}
line.Set_Value("FROMDATE", AmortStartDate);
line.Set_Value("EndDate", AmortEndDate);
if (amrtDS != null)
{
amrtDS.Dispose();
}
}
}
if (line.GetC_Charge_ID() > 0)
{
//MCharge charge = new MCharge(GetCtx(), sLine.GetC_Charge_ID(), Get_TrxName());
int VA038_AmortizationTemplate_ID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT VA038_AmortizationTemplate_ID
FROM C_Charge WHERE C_Charge_ID = " + sLine.GetC_Charge_ID(), null, Get_Trx()));
if (VA038_AmortizationTemplate_ID > 0)
{
line.Set_Value("VA038_AmortizationTemplate_ID", VA038_AmortizationTemplate_ID);
DataSet amrtDS = DB.ExecuteDataset("SELECT VA038_AmortizationType,VA038_AmortizationPeriod,VA038_TermSource,VA038_PeriodType,Name FROM VA038_AmortizationTemplate WHERE IsActive='Y' AND VA038_AMORTIZATIONTEMPLATE_ID=" + VA038_AmortizationTemplate_ID);
AmortStartDate = null;
AmortEndDate = null;
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_TermSource"]) == "A")
{
AmortStartDate = invoice.GetDateAcct();
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_TermSource"]) == "T")
{
AmortStartDate = invoice.GetDateInvoiced();
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_PeriodType"]) == "M")
{
AmortEndDate = AmortStartDate.Value.AddMonths(Util.GetValueOfInt(amrtDS.Tables[0].Rows[0]["VA038_AmortizationPeriod"]));
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_PeriodType"]) == "Y")
{
AmortEndDate = AmortStartDate.Value.AddYears(Util.GetValueOfInt(amrtDS.Tables[0].Rows[0]["VA038_AmortizationPeriod"]));
}
line.Set_Value("FROMDATE", AmortStartDate);
line.Set_Value("EndDate", AmortEndDate);
if (amrtDS != null)
{
amrtDS.Dispose();
}
}
}
}
// End Change Amortization process--------------
if (!line.Save())
{
//SI_0708 - message was not upto the mark
ValueNamePair pp = VAdvantage.Logging.VLogger.RetrieveError();
if (pp != null)
{
throw new ArgumentException("Cannot save Invoice Line. " + pp.GetName());
}
throw new ArgumentException("Cannot save Invoice Line");
}
count++;
}
ds.Dispose();
}
else
{
MInvoiceLine line = new MInvoiceLine(invoice);
// JID_1850 Avoid the duplicate charge line
if (sLine.GetC_Charge_ID() > 0 && (!isAllownonItem || _GenerateCharges))
{
continue;
}
line.SetShipLine(sLine);
line.SetQtyEntered(sLine.GetQtyEntered());
line.SetQtyInvoiced(sLine.GetMovementQty());
line.Set_ValueNoCheck("IsDropShip", sLine.Get_Value("IsDropShip")); //Arpit Rai 20-Sept-2017
// Change By Mohit Amortization process -------------
if (_CountVA038 > 0)
{
if (line.GetM_Product_ID() > 0)
{
//MProduct pro = new MProduct(GetCtx(), sLine.GetM_Product_ID(), Get_TrxName());
int VA038_AmortizationTemplate_ID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT VA038_AmortizationTemplate_ID
FROM M_Product WHERE M_Product_ID = " + sLine.GetM_Product_ID(), null, Get_Trx()));
if (VA038_AmortizationTemplate_ID > 0)
{
line.Set_Value("VA038_AmortizationTemplate_ID", VA038_AmortizationTemplate_ID);
DataSet amrtDS = DB.ExecuteDataset("SELECT VA038_AmortizationType,VA038_AmortizationPeriod,VA038_TermSource,VA038_PeriodType,Name FROM VA038_AmortizationTemplate WHERE IsActive='Y' AND VA038_AMORTIZATIONTEMPLATE_ID=" + VA038_AmortizationTemplate_ID);
AmortStartDate = null;
AmortEndDate = null;
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_TermSource"]) == "A")
{
AmortStartDate = invoice.GetDateAcct();
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_TermSource"]) == "T")
{
AmortStartDate = invoice.GetDateInvoiced();
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_PeriodType"]) == "M")
{
AmortEndDate = AmortStartDate.Value.AddMonths(Util.GetValueOfInt(amrtDS.Tables[0].Rows[0]["VA038_AmortizationPeriod"]));
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_PeriodType"]) == "Y")
{
AmortEndDate = AmortStartDate.Value.AddYears(Util.GetValueOfInt(amrtDS.Tables[0].Rows[0]["VA038_AmortizationPeriod"]));
}
line.Set_Value("FROMDATE", AmortStartDate);
line.Set_Value("EndDate", AmortEndDate);
if (amrtDS != null)
{
amrtDS.Dispose();
}
}
}
if (line.GetC_Charge_ID() > 0)
{
//MCharge charge = new MCharge(GetCtx(), sLine.GetC_Charge_ID(), Get_TrxName());
int VA038_AmortizationTemplate_ID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT VA038_AmortizationTemplate_ID
FROM C_Charge WHERE C_Charge_ID = " + sLine.GetC_Charge_ID(), null, Get_Trx()));
if (VA038_AmortizationTemplate_ID > 0)
{
line.Set_Value("VA038_AmortizationTemplate_ID", VA038_AmortizationTemplate_ID);
DataSet amrtDS = DB.ExecuteDataset("SELECT VA038_AmortizationType,VA038_AmortizationPeriod,VA038_TermSource,VA038_PeriodType,Name FROM VA038_AmortizationTemplate WHERE IsActive='Y' AND VA038_AMORTIZATIONTEMPLATE_ID=" + VA038_AmortizationTemplate_ID);
AmortStartDate = null;
AmortEndDate = null;
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_TermSource"]) == "A")
{
AmortStartDate = invoice.GetDateAcct();
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_TermSource"]) == "T")
{
AmortStartDate = invoice.GetDateInvoiced();
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_PeriodType"]) == "M")
{
AmortEndDate = AmortStartDate.Value.AddMonths(Util.GetValueOfInt(amrtDS.Tables[0].Rows[0]["VA038_AmortizationPeriod"]));
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_PeriodType"]) == "Y")
{
AmortEndDate = AmortStartDate.Value.AddYears(Util.GetValueOfInt(amrtDS.Tables[0].Rows[0]["VA038_AmortizationPeriod"]));
}
line.Set_Value("FROMDATE", AmortStartDate);
line.Set_Value("EndDate", AmortEndDate);
if (amrtDS != null)
{
amrtDS.Dispose();
}
}
}
}
// End Change Amortization process--------------
if (!line.Save())
{
//SI_0708 - message was not upto the mark
ValueNamePair pp = VAdvantage.Logging.VLogger.RetrieveError();
if (pp != null)
{
throw new ArgumentException("Cannot save Invoice Line. " + pp.GetName());
}
throw new ArgumentException("Cannot save Invoice Line");
}
count++;
}
}
#region [Enhancement for Charges Distribution/Generation by Sukhwinder on 13 December 2017]
if (_GenerateCharges && count > 0)
{
StringBuilder OrderSql = new StringBuilder();
OrderSql.Append(" SELECT CO.C_ORDER_ID, "
+ " SUM(ML.QTYENTERED) AS MRLINEQTY, "
+ " SUM(OL.QTYENTERED) AS ORDERQTY "
+ " FROM M_INOUTLINE ML "
+ " INNER JOIN C_ORDERLINE OL "
+ " ON OL.C_ORDERLINE_ID = ML.C_ORDERLINE_ID "
+ " INNER JOIN C_ORDER CO "
+ " ON CO.C_ORDER_ID = OL.C_ORDER_ID "
+ " WHERE ML.M_INOUT_ID = " + _M_InOut_ID
+ " AND (OL.C_CHARGE_ID IS NULL "
+ " OR OL.C_CHARGE_ID = 0) "
+ " GROUP BY CO.C_ORDER_ID ");
DataSet OrderDS = DB.ExecuteDataset(OrderSql.ToString(), null, Get_Trx());
if (OrderDS != null && OrderDS.Tables[0].Rows.Count > 0)
{
StringBuilder ChargesSql = new StringBuilder();
for (int index = 0; index < OrderDS.Tables[0].Rows.Count; index++)
{
ds = null;
ChargesSql.Clear();
ChargesSql.Append(" SELECT C_CHARGE_ID, "
+ " C_ORDERLINE_ID, "
+ " C_ORDER_ID, "
+ " C_CURRENCY_ID, "
+ " PRICEENTERED, "
+ " PRICEACTUAL, "
+ " LINENETAMT, "
+ " QTYENTERED, "
+ " C_UOM_ID, "
+ " C_Tax_ID, "
+ " IsDropShip "
+ " FROM C_ORDERLINE "
+ " WHERE C_ORDER_ID IN "
+ " ( " + Util.GetValueOfInt(OrderDS.Tables[0].Rows[index]["C_ORDER_ID"])
+ " ) "
+ " AND C_CHARGE_ID IS NOT NULL "
+ " AND C_CHARGE_ID > 0 ");
ds = DB.ExecuteDataset(ChargesSql.ToString(), null, Get_Trx());
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
MInvoiceLine line = new MInvoiceLine(invoice);
line.SetQty(1);
line.SetQtyEntered(1);
line.SetQtyInvoiced(1);
line.SetOrderLine(new MOrderLine(GetCtx(), Util.GetValueOfInt(ds.Tables[0].Rows[i]["C_ORDERLINE_ID"]), Get_Trx()));
line.SetC_Charge_ID(Util.GetValueOfInt(ds.Tables[0].Rows[i]["C_CHARGE_ID"]));
line.SetC_UOM_ID(Util.GetValueOfInt(ds.Tables[0].Rows[i]["C_UOM_ID"]));
line.SetC_Tax_ID(Util.GetValueOfInt(ds.Tables[0].Rows[i]["C_TAX_ID"]));
decimal SumOfQty = 0;
if (Util.GetValueOfInt(OrderDS.Tables[0].Rows[index]["ORDERQTY"]) == 0)
{
SumOfQty = 1;
}
else
{
SumOfQty = Util.GetValueOfInt(OrderDS.Tables[0].Rows[index]["ORDERQTY"]);
}
decimal amt = (Util.GetValueOfDecimal(ds.Tables[0].Rows[i]["LINENETAMT"]) / SumOfQty) * Util.GetValueOfInt(OrderDS.Tables[0].Rows[index]["MRLINEQTY"]);
line.SetPrice(Decimal.Round(amt, 3));
line.SetPriceActual(Decimal.Round(amt, 3));
line.SetPriceEntered(Decimal.Round(amt, 3));
line.SetLineNetAmt(Decimal.Round(amt, 3));
line.Set_ValueNoCheck("IsDropShip", Util.GetValueOfString(ds.Tables[0].Rows[i]["ISDROPSHIP"]));
if (_CountVA038 > 0)
{
if (line.GetC_Charge_ID() > 0)
{
MCharge charge = new MCharge(GetCtx(), line.GetC_Charge_ID(), Get_TrxName());
if (Util.GetValueOfInt(charge.Get_Value("VA038_AmortizationTemplate_ID")) > 0)
{
line.Set_Value("VA038_AmortizationTemplate_ID", Util.GetValueOfInt(charge.Get_Value("VA038_AmortizationTemplate_ID")));
DataSet amrtDS = DB.ExecuteDataset("SELECT VA038_AmortizationType,VA038_AmortizationPeriod,VA038_TermSource,VA038_PeriodType,Name FROM VA038_AmortizationTemplate WHERE IsActive='Y' AND VA038_AMORTIZATIONTEMPLATE_ID=" + Util.GetValueOfInt(charge.Get_Value("VA038_AmortizationTemplate_ID")));
AmortStartDate = null;
AmortEndDate = null;
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_TermSource"]) == "A")
{
AmortStartDate = invoice.GetDateAcct();
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_TermSource"]) == "T")
{
AmortStartDate = invoice.GetDateInvoiced();
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_PeriodType"]) == "M")
{
AmortEndDate = AmortStartDate.Value.AddMonths(Util.GetValueOfInt(amrtDS.Tables[0].Rows[0]["VA038_AmortizationPeriod"]));
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_PeriodType"]) == "Y")
{
AmortEndDate = AmortStartDate.Value.AddYears(Util.GetValueOfInt(amrtDS.Tables[0].Rows[0]["VA038_AmortizationPeriod"]));
}
line.Set_Value("FROMDATE", AmortStartDate);
line.Set_Value("EndDate", AmortEndDate);
if (amrtDS != null)
{
amrtDS.Dispose();
}
}
}
}
if (!line.Save())
{
//SI_0708 - message was not upto the mark
ValueNamePair pp = VAdvantage.Logging.VLogger.RetrieveError();
if (pp != null)
{
throw new ArgumentException("Cannot save Invoice Line. " + pp.GetName());
}
throw new ArgumentException("Cannot save Invoice Line");
}
}
}
}
}
}
#endregion
if (count > 0)
{
return(invoice.GetDocumentNo());
}
else
{
//Get_Trx().Rollback();
throw new ArgumentException(Msg.GetMsg(GetCtx(), "InvoiceExist") + ": " + invDocumentNo.ToString());
}
}
/// <summary>
/// Create Facts (the accounting logic) for
/// ARP, APP.
///<pre>
/// ARP
/// BankInTransit DR
/// UnallocatedCash CR
/// or Charge/C_Prepayment
/// APP
/// PaymentSelect DR
/// or Charge/V_Prepayment
/// BankInTransit CR
/// CashBankTransfer
/// -
/// </pre>
/// </summary>
/// <param name="as1"></param>
/// <returns>fact</returns>
public override List <Fact> CreateFacts(MAcctSchema as1)
{
// create Fact Header
Fact fact = new Fact(this, as1, Fact.POST_Actual);
// Cash Transfer
if ("X".Equals(_TenderType))
{
List <Fact> facts = new List <Fact>();
facts.Add(fact);
return(facts);
}
int AD_Org_ID = GetBank_Org_ID(); // Bank Account Org
if (GetDocumentType().Equals(MDocBaseType.DOCBASETYPE_ARRECEIPT))
{
// Work done by Bharat for the posting of ED008 Module
bool addPost = false;
//Check For Module
Tuple <String, String, String> aInfo = null;
if (Env.HasModulePrefix("ED008_", out aInfo))
{
addPost = true;
}
else
{
addPost = false;
}
if (addPost == true)
{
// Tender Type RIBA
if ("R".Equals(_TenderType))
{
MAccount acct = null;
MAccount portAcct = null;
int validComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_RIBA_Acct FROM C_BankAccount_Acct WHERE C_BankAccount_ID=" + GetC_BankAccount_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
if (validComID > 0)
{
acct = MAccount.Get(Env.GetCtx(), validComID);
}
if (acct == null)
{
validComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_RIBA_Acct FROM C_AcctSchema_Default WHERE C_AcctSchema_ID=" + as1.GetC_AcctSchema_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
acct = MAccount.Get(Env.GetCtx(), validComID);
}
FactLine fl = fact.CreateLine(null, acct, GetC_Currency_ID(), GetAmount(), null);
int ComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_Portfolio_Acct FROM C_BP_Customer_Acct WHERE C_BPartner_ID=" + GetC_BPartner_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
if (ComID > 0)
{
portAcct = MAccount.Get(Env.GetCtx(), ComID);
}
if (portAcct == null)
{
ComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_Portfolio_Acct FROM C_AcctSchema_Default WHERE C_AcctSchema_ID=" + as1.GetC_AcctSchema_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
portAcct = MAccount.Get(Env.GetCtx(), ComID);
}
fl = fact.CreateLine(null, portAcct, GetC_Currency_ID(), null, GetAmount());
}
// Tender Type MAV
else if ("M".Equals(_TenderType))
{
MAccount acct = null;
MAccount portAcct = null;
int validComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_MAV_Acct FROM C_BankAccount_Acct WHERE C_BankAccount_ID=" + GetC_BankAccount_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
if (validComID > 0)
{
acct = MAccount.Get(Env.GetCtx(), validComID);
}
if (acct == null)
{
validComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_MAV_Acct FROM C_AcctSchema_Default WHERE C_AcctSchema_ID=" + as1.GetC_AcctSchema_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
acct = MAccount.Get(Env.GetCtx(), validComID);
}
FactLine fl = fact.CreateLine(null, acct,
GetC_Currency_ID(), GetAmount(), null);
int ComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_Portfolio_Acct FROM C_BP_Customer_Acct WHERE C_BPartner_ID=" + GetC_BPartner_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
if (ComID > 0)
{
portAcct = MAccount.Get(Env.GetCtx(), ComID);
}
if (portAcct == null)
{
ComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_Portfolio_Acct FROM C_AcctSchema_Default WHERE C_AcctSchema_ID=" + as1.GetC_AcctSchema_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
portAcct = MAccount.Get(Env.GetCtx(), ComID);
}
fl = fact.CreateLine(null, portAcct,
GetC_Currency_ID(), null, GetAmount());
}
// Tender Type BOE
else if ("E".Equals(_TenderType))
{
MAccount acct = null;
MAccount portAcct = null;
string boeType = Util.GetValueOfString(DB.ExecuteScalar(@"SELECT ED008_BOEType FROM C_Payment WHERE C_Payment_ID = " + Get_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
int boeID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED008_BOE_ID FROM C_Payment WHERE C_Payment_ID = " + Get_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
if ("T".Equals(boeType))
{
int validComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_BOE_Acct FROM ED008_BOEAccounting WHERE ED008_BOE_ID=" + boeID + " AND AD_Client_ID = " + GetAD_Client_ID()));
if (validComID > 0)
{
acct = MAccount.Get(Env.GetCtx(), validComID);
}
if (acct == null)
{
validComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_BOE_Acct FROM C_AcctSchema_Default WHERE C_AcctSchema_ID=" + as1.GetC_AcctSchema_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
acct = MAccount.Get(Env.GetCtx(), validComID);
}
FactLine fl = fact.CreateLine(null, acct, GetC_Currency_ID(), GetAmount(), null);
int ComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_BOETransit_Acct FROM ED008_BOEAccounting WHERE ED008_BOE_ID=" + boeID + " AND AD_Client_ID = " + GetAD_Client_ID()));
if (ComID > 0)
{
portAcct = MAccount.Get(Env.GetCtx(), ComID);
}
if (portAcct == null)
{
ComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_BOETransit_Acct FROM C_AcctSchema_Default WHERE C_AcctSchema_ID=" + as1.GetC_AcctSchema_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
portAcct = MAccount.Get(Env.GetCtx(), ComID);
}
fl = fact.CreateLine(null, portAcct, GetC_Currency_ID(), null, GetAmount());
}
else if ("R".Equals(boeType))
{
FactLine fl = fact.CreateLine(null, GetAccount(Doc.ACCTTYPE_BankInTransit, as1), GetC_Currency_ID(), GetAmount(), null);
int ComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_BOE_Acct FROM ED008_BOEAccounting WHERE ED008_BOE_ID=" + boeID + " AND AD_Client_ID = " + GetAD_Client_ID()));
if (ComID > 0)
{
portAcct = MAccount.Get(Env.GetCtx(), ComID);
}
if (portAcct == null)
{
ComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_BOE_Acct FROM C_AcctSchema_Default WHERE C_AcctSchema_ID=" + as1.GetC_AcctSchema_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
portAcct = MAccount.Get(Env.GetCtx(), ComID);
}
fl = fact.CreateLine(null, portAcct, GetC_Currency_ID(), null, GetAmount());
}
}
// Tender Type RID
else if ("I".Equals(_TenderType))
{
MAccount acct = null;
MAccount portAcct = null;
int validComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_RID_Acct FROM C_BankAccount_Acct WHERE C_BankAccount_ID=" + GetC_BankAccount_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
if (validComID > 0)
{
acct = MAccount.Get(Env.GetCtx(), validComID);
}
if (acct == null)
{
validComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_RID_Acct FROM C_AcctSchema_Default WHERE C_AcctSchema_ID=" + as1.GetC_AcctSchema_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
acct = MAccount.Get(Env.GetCtx(), validComID);
}
FactLine fl = fact.CreateLine(null, acct,
GetC_Currency_ID(), GetAmount(), null);
int ComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_Portfolio_Acct FROM C_BP_Customer_Acct WHERE C_BPartner_ID=" + GetC_BPartner_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
if (ComID > 0)
{
portAcct = MAccount.Get(Env.GetCtx(), ComID);
}
if (portAcct == null)
{
ComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_Portfolio_Acct FROM C_AcctSchema_Default WHERE C_AcctSchema_ID=" + as1.GetC_AcctSchema_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
portAcct = MAccount.Get(Env.GetCtx(), ComID);
}
fl = fact.CreateLine(null, portAcct,
GetC_Currency_ID(), null, GetAmount());
}
else
{
// Asset
FactLine fl = fact.CreateLine(null, GetAccount(Doc.ACCTTYPE_BankInTransit, as1),
GetC_Currency_ID(), GetAmount(), null);
if (fl != null && AD_Org_ID != 0)
{
fl.SetAD_Org_ID(AD_Org_ID);
}
//
MAccount acct = null;
if (GetC_Charge_ID() != 0)
{
acct = MCharge.GetAccount(GetC_Charge_ID(), as1, GetAmount());
}
else if (_Prepayment)
{
acct = GetAccount(Doc.ACCTTYPE_C_Prepayment, as1);
}
else
{
acct = GetAccount(Doc.ACCTTYPE_UnallocatedCash, as1);
}
fl = fact.CreateLine(null, acct, GetC_Currency_ID(), null, GetAmount());
if (fl != null && AD_Org_ID != 0 &&
GetC_Charge_ID() == 0) // don't overwrite charge
{
fl.SetAD_Org_ID(AD_Org_ID);
}
}
}
// Default Posting Logic
else
{
// Asset
FactLine fl = fact.CreateLine(null, GetAccount(Doc.ACCTTYPE_BankInTransit, as1),
GetC_Currency_ID(), GetAmount(), null);
if (fl != null && AD_Org_ID != 0)
{
fl.SetAD_Org_ID(AD_Org_ID);
}
//
MAccount acct = null;
if (GetC_Charge_ID() != 0)
{
acct = MCharge.GetAccount(GetC_Charge_ID(), as1, GetAmount());
}
else if (_Prepayment)
{
acct = GetAccount(Doc.ACCTTYPE_C_Prepayment, as1);
}
else
{
acct = GetAccount(Doc.ACCTTYPE_UnallocatedCash, as1);
}
fl = fact.CreateLine(null, acct,
GetC_Currency_ID(), null, GetAmount());
if (fl != null && AD_Org_ID != 0 &&
GetC_Charge_ID() == 0) // don't overwrite charge
{
fl.SetAD_Org_ID(AD_Org_ID);
}
}
}
// APP
else if (GetDocumentType().Equals(MDocBaseType.DOCBASETYPE_APPAYMENT))
{
// Work Done For Ed008 Module
bool addPost = false;
//Check For Module
Tuple <String, String, String> aInfo = null;
if (Env.HasModulePrefix("ED008_", out aInfo) || Env.HasModulePrefix("ED010_", out aInfo))
{
addPost = true;
}
if (addPost == true)
{
MAccount acct = null;
MAccount portAcct = null;
string boeType = Util.GetValueOfString(DB.ExecuteScalar(@"SELECT ED008_BOEType FROM C_Payment WHERE C_Payment_ID = " + Get_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
int boeID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED008_BOE_ID FROM C_Payment WHERE C_Payment_ID = " + Get_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
if ("E".Equals(_TenderType))
{
if ("T".Equals(boeType))
{
int validComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_BOETransit_Acct FROM ED008_BOEAccounting WHERE ED008_BOE_ID=" + boeID + " AND AD_Client_ID = " + GetAD_Client_ID()));
if (validComID > 0)
{
acct = MAccount.Get(Env.GetCtx(), validComID);
}
if (acct == null)
{
validComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_BOETransit_Acct FROM C_AcctSchema_Default WHERE C_AcctSchema_ID=" + as1.GetC_AcctSchema_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
acct = MAccount.Get(Env.GetCtx(), validComID);
}
FactLine f2 = fact.CreateLine(null, acct, GetC_Currency_ID(), GetAmount(), null);
int ComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_BOE_Acct FROM ED008_BOEAccounting WHERE ED008_BOE_ID=" + boeID + " AND AD_Client_ID = " + GetAD_Client_ID()));
if (ComID > 0)
{
portAcct = MAccount.Get(Env.GetCtx(), ComID);
}
if (portAcct == null)
{
ComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_BOE_Acct FROM C_AcctSchema_Default WHERE C_AcctSchema_ID=" + as1.GetC_AcctSchema_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
portAcct = MAccount.Get(Env.GetCtx(), ComID);
}
f2 = fact.CreateLine(null, portAcct, GetC_Currency_ID(), null, GetAmount());
}
}
else
{
FactLine fl = fact.CreateLine(null, GetAccount(Doc.ACCTTYPE_BankInTransit, as1), GetC_Currency_ID(), null, GetAmount());
if (fl != null && AD_Org_ID != 0 &&
GetC_Charge_ID() == 0) // don't overwrite charge
{
fl.SetAD_Org_ID(AD_Org_ID);
}
DataSet ds = null;
DataSet dsSSCode = null;
decimal amount = 0, WithholdingAmt = 0, sscAmt = 0, payAmt = 0;
payAmt = GetAmount();
string sql = @"SELECT cl.m_product_id, cl.linenetamt,prd.ed010_sscode_id,holddet.ed010_appliedpercentage,holddet.ed010_actualpercentage,withAcct.Withholding_Acct
FROM C_Payment pay INNER JOIN c_invoice inv ON pay.c_invoice_id = inv.c_invoice_id inner join c_invoiceline cl on pay.c_invoice_id=cl.c_invoice_id inner join C_BPartner cb
on pay.c_bpartner_id=cb.c_bpartner_id INNER JOIN m_product prd ON prd.m_product_ID = cl.m_product_ID LEFT JOIN c_withholding hold ON hold.C_WithHolding_Id = prd.c_withholding_id
LEFT JOIN ed010_withholdingdetails holddet ON holddet.C_WithHolding_Id = hold.C_WithHolding_Id left join C_Withholding_Acct withAcct on hold.C_WithHolding_Id=withAcct.C_WithHolding_Id
where cb.ED010_IsWithholding='Y' and cb.ED010_IsSSCode='Y' and pay.ED010_WithholdingAmt > 0 AND " + GlobalVariable.TO_DATE(DateTime.Now.ToLocalTime(), true) +
@"BETWEEN holddet.ED010_FromDate AND holddet.ED010_ToDate and pay.AD_Org_ID = " + GetCtx().GetAD_Org_ID() + " and pay.c_payment_id = " + Get_ID();
ds = new DataSet();
ds = DB.ExecuteDataset(sql, null, null);
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
MAccount withAcct = null;
int validID = 0;
amount = (Decimal.Divide(Decimal.Multiply(Util.GetValueOfDecimal(ds.Tables[0].Rows[i]["linenetamt"]), Util.GetValueOfDecimal(ds.Tables[0].Rows[i]["ed010_appliedpercentage"])), 100));
WithholdingAmt = (Decimal.Divide(Decimal.Multiply(amount, Util.GetValueOfDecimal(ds.Tables[0].Rows[i]["ed010_actualpercentage"])), 100));
validID = Util.GetValueOfInt(ds.Tables[0].Rows[i]["Withholding_Acct"]);
if (validID > 0)
{
withAcct = MAccount.Get(Env.GetCtx(), validID);
}
if (withAcct == null)
{
validID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT Withholding_Acct FROM C_AcctSchema_Default WHERE C_AcctSchema_ID=" + as1.GetC_AcctSchema_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
withAcct = MAccount.Get(Env.GetCtx(), validID);
}
fl = fact.CreateLine(null, withAcct, GetC_Currency_ID(), null, Decimal.Round(WithholdingAmt, 2));
if (fl != null)
{
payAmt += Decimal.Round(WithholdingAmt, 2);
}
if (fl != null && AD_Org_ID != 0)
{
fl.SetAD_Org_ID(AD_Org_ID);
}
}
}
}
ds.Dispose();
sql = @"SELECT cl.m_product_id,cb.c_bpartner_id,cl.linenetamt,prd.ed010_sscode_id,sdet.ed010_percentagetype,sdet.ed010_maxamt,sdet.ed010_minamt,sdet.ed010_socialsecurityprcnt,sdet.ed010_orgpercentage,
sdet.ed010_vendorpercentage,sscAcct.ED000_SecCodeAcct FROM C_Payment pay INNER JOIN c_invoice inv ON pay.c_invoice_id = inv.c_invoice_id inner join c_invoiceline cl on pay.c_invoice_id=cl.c_invoice_id inner join C_BPartner cb
on pay.c_bpartner_id=cb.c_bpartner_id INNER JOIN m_product prd ON prd.m_product_ID = cl.m_product_ID LEFT JOIN ed010_sscode scode ON scode.ed010_sscode_ID = prd.ed010_sscode_id
LEFT JOIN ed010_sscodedetails sdet ON sdet.ed010_sscode_ID = scode.ed010_sscode_ID left join ED010_SSCode_Acct sscAcct on scode.ED010_SSCode_ID=sscAcct.ED010_SSCode_ID
where cb.ED010_IsWithholding='Y' and cb.ED010_IsSSCode='Y' and pay.ED010_WithholdingAmt > 0 AND " + GlobalVariable.TO_DATE(DateTime.Now.ToLocalTime(), true) +
@"BETWEEN sdet.ED010_FromDate AND sdet.ED010_ToDate AND pay.AD_Org_ID = " + GetCtx().GetAD_Org_ID() + " and pay.c_payment_id = " + Get_ID();
dsSSCode = new DataSet();
dsSSCode = DB.ExecuteDataset(sql, null, null);
if (dsSSCode.Tables.Count > 0)
{
if (dsSSCode.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dsSSCode.Tables[0].Rows.Count; i++)
{
MAccount sscAcct = null;
int vlID = 0;
sql = @"SELECT SUM(grandtotal) FROM c_invoice WHERE IsActive = 'Y' AND docstatus = 'CO' AND c_bpartner_Id = " + Util.GetValueOfInt(dsSSCode.Tables[0].Rows[i]["c_bpartner_id"]);
decimal result = Util.GetValueOfDecimal(DB.ExecuteScalar(sql, null, null));
if (result <= Util.GetValueOfDecimal(dsSSCode.Tables[0].Rows[i]["ed010_maxamt"]) && result >= Util.GetValueOfDecimal(dsSSCode.Tables[0].Rows[i]["ed010_minamt"]))
{
if (Util.GetValueOfString(dsSSCode.Tables[0].Rows[i]["ed010_percentagetype"]) == "S")
{
sscAmt = (Decimal.Divide(Decimal.Multiply(Util.GetValueOfDecimal(dsSSCode.Tables[0].Rows[i]["linenetamt"]), Util.GetValueOfDecimal(dsSSCode.Tables[0].Rows[i]["ed010_socialsecurityprcnt"])), 100));
}
else if (Util.GetValueOfString(dsSSCode.Tables[0].Rows[i]["ed010_percentagetype"]) == "M")
{
// amount = (Decimal.Divide(Decimal.Multiply(Util.GetValueOfDecimal(dsSSCode.Tables[0].Rows[i]["linenetamt"]), Util.GetValueOfDecimal(dsSSCode.Tables[0].Rows[i]["ed010_vendorpercentage"])), 100));
sscAmt = (Decimal.Divide(Decimal.Multiply(Util.GetValueOfDecimal(dsSSCode.Tables[0].Rows[i]["linenetamt"]), Util.GetValueOfDecimal(dsSSCode.Tables[0].Rows[i]["ed010_orgpercentage"])), 100));
}
}
vlID = Util.GetValueOfInt(dsSSCode.Tables[0].Rows[i]["ED000_SecCodeAcct"]);
if (vlID > 0)
{
sscAcct = MAccount.Get(Env.GetCtx(), vlID);
}
if (sscAcct == null)
{
vlID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_SecCodeAcct FROM C_AcctSchema_Default WHERE C_AcctSchema_ID=" + as1.GetC_AcctSchema_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
sscAcct = MAccount.Get(Env.GetCtx(), vlID);
}
fl = fact.CreateLine(null, sscAcct, GetC_Currency_ID(), null, Decimal.Round(sscAmt, 2));
if (fl != null)
{
payAmt += Decimal.Round(sscAmt, 2);
}
if (fl != null && AD_Org_ID != 0)
{
fl.SetAD_Org_ID(AD_Org_ID);
}
}
}
}
dsSSCode.Dispose();
fl = fact.CreateLine(null, GetAccount(Doc.ACCTTYPE_PaymentSelect, as1), GetC_Currency_ID(), payAmt, null);
if (fl != null && AD_Org_ID != 0 && GetC_Charge_ID() == 0) // don't overwrite charge
{
fl.SetAD_Org_ID(AD_Org_ID);
}
}
}
// Default Posting Logic
else
{
MAccount acct = null;
if (GetC_Charge_ID() != 0)
{
acct = MCharge.GetAccount(GetC_Charge_ID(), as1, GetAmount());
}
else if (_Prepayment)
{
acct = GetAccount(Doc.ACCTTYPE_V_Prepayment, as1);
}
else
{
acct = GetAccount(Doc.ACCTTYPE_PaymentSelect, as1);
}
FactLine fl = fact.CreateLine(null, acct,
GetC_Currency_ID(), GetAmount(), null);
if (fl != null && AD_Org_ID != 0 &&
GetC_Charge_ID() == 0) // don't overwrite charge
{
fl.SetAD_Org_ID(AD_Org_ID);
}
// Asset
fl = fact.CreateLine(null, GetAccount(Doc.ACCTTYPE_BankInTransit, as1),
GetC_Currency_ID(), null, GetAmount());
if (fl != null && AD_Org_ID != 0)
{
fl.SetAD_Org_ID(AD_Org_ID);
}
}
}
else
{
_error = "DocumentType unknown: " + GetDocumentType();
log.Log(Level.SEVERE, _error);
fact = null;
}
//
List <Fact> facts1 = new List <Fact>();
facts1.Add(fact);
return(facts1);
}
/// <summary>
/// Create Invoice.
/// </summary>
/// <returns>document no</returns>
protected override String DoIt()
{
//log.info("M_InOut_ID=" + _M_InOut_ID
// + ", M_PriceList_ID=" + _M_PriceList_ID
// + ", InvoiceDocumentNo=" + _InvoiceDocumentNo);
// Message Display Wrong Done Vikas and Assigned by Gurinder
int count = Util.GetValueOfInt(DB.ExecuteScalar(" SELECT Count(*) FROM M_Inout WHERE ISSOTRX='Y' AND M_Inout_ID=" + GetRecord_ID()));
MInOut ship = null;
if (count > 0)
{
if (_M_InOut_ID == 0)
{
throw new ArgumentException("No Shipment");
}
//
ship = new MInOut(GetCtx(), _M_InOut_ID, Get_Trx());
if (ship.Get_ID() == 0)
{
throw new ArgumentException("Shipment not found");
}
if (!MInOut.DOCSTATUS_Completed.Equals(ship.GetDocStatus()))
{
throw new ArgumentException("Shipment not completed");
}
}
else
{
if (_M_InOut_ID == 0)
{
throw new ArgumentException("No Material Receipt");
}
//
ship = new MInOut(GetCtx(), _M_InOut_ID, Get_Trx());
if (ship.Get_ID() == 0)
{
throw new ArgumentException("Material Receipt not found");
}
if (!MInOut.DOCSTATUS_Completed.Equals(ship.GetDocStatus()))
{
throw new ArgumentException("Material Receipt not completed");
}
}
//***********************END*****************************//
MInvoice invoice = new MInvoice(ship, null);
//-------------Column Added by Anuj----------------------
//int _CountVA009 = Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(AD_MODULEINFO_ID) FROM AD_MODULEINFO WHERE PREFIX='VA009_' AND IsActive = 'Y'"));
int _CountVA009 = Env.IsModuleInstalled("VA009_") ? 1 : 0;
// Code by Mohit Amortization process
//int _CountVA038 = Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(AD_MODULEINFO_ID) FROM AD_MODULEINFO WHERE PREFIX='VA038_' AND IsActive = 'Y'"));
int _CountVA038 = Env.IsModuleInstalled("VA038_") ? 1 : 0;
// End Amortization Code
if (_CountVA009 > 0)
{
int _PaymentMethod_ID = Util.GetValueOfInt(DB.ExecuteScalar("Select VA009_PaymentMethod_ID From C_Order Where C_Order_ID=" + ship.GetC_Order_ID()));
if (_PaymentMethod_ID > 0)
{
invoice.SetVA009_PaymentMethod_ID(_PaymentMethod_ID);
}
}
//-------------Column Added by Anuj----------------------
// added by Amit 26-may-2016
//int _CountVA026 = Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(AD_MODULEINFO_ID) FROM AD_MODULEINFO WHERE PREFIX='VA026_' AND IsActive = 'Y'"));
int _CountVA026 = Env.IsModuleInstalled("VA026_") ? 1 : 0;
if (_CountVA026 > 0)
{
MOrder order = new MOrder(GetCtx(), ship.GetC_Order_ID(), Get_Trx());
if (order != null && order.GetC_Order_ID() > 0)
{
invoice.SetVA026_LCDetail_ID(order.GetVA026_LCDetail_ID());
}
}
//end
if (ship.IsReturnTrx())
{
if (!ship.IsSOTrx())
{
// Purchase Return
// set target document from documnet type window -- based on documnet type available on material receipt / return to vendor
if (invoice.GetC_DocTypeTarget_ID() == 0)
{
int C_DocTypeTarget_ID = DB.GetSQLValue(null,
"SELECT C_DocTypeInvoice_ID FROM C_DocType WHERE C_DocType_ID=@param1",
ship.GetC_DocType_ID());
if (C_DocTypeTarget_ID >= 0)
{
invoice.SetC_DocTypeTarget_ID(C_DocTypeTarget_ID);
}
else
{
invoice.SetC_DocTypeTarget_ID(ship.IsSOTrx() ? MDocBaseType.DOCBASETYPE_ARCREDITMEMO : MDocBaseType.DOCBASETYPE_APCREDITMEMO);
}
}
invoice.SetIsReturnTrx(ship.IsReturnTrx());
invoice.SetIsSOTrx(ship.IsSOTrx());
}
else
{
// Sales Return
if (ship.GetC_Order_ID() >= 0)
{
MOrder order = new MOrder(GetCtx(), ship.GetC_Order_ID(), Get_Trx());
MDocType dt = MDocType.Get(GetCtx(), order.GetC_DocType_ID());
if (dt.GetC_DocTypeInvoice_ID() != 0)
{
invoice.SetC_DocTypeTarget_ID(dt.GetC_DocTypeInvoice_ID(), true);
}
else
{
invoice.SetC_DocTypeTarget_ID(ship.IsSOTrx() ? MDocBaseType.DOCBASETYPE_ARCREDITMEMO : MDocBaseType.DOCBASETYPE_APCREDITMEMO);
}
}
else
{
invoice.SetC_DocTypeTarget_ID(ship.IsSOTrx() ? MDocBaseType.DOCBASETYPE_ARCREDITMEMO : MDocBaseType.DOCBASETYPE_APCREDITMEMO);
}
}
}
if (_M_PriceList_ID != 0)
{
invoice.SetM_PriceList_ID(_M_PriceList_ID);
}
if (_InvoiceDocumentNo != null && _InvoiceDocumentNo.Length > 0)
{
invoice.SetDocumentNo(_InvoiceDocumentNo);
}
// Added by Bharat on 30 Jan 2018 to set Inco Term from Order
if (invoice.Get_ColumnIndex("C_IncoTerm_ID") > 0)
{
invoice.SetC_IncoTerm_ID(ship.GetC_IncoTerm_ID());
}
if (!invoice.Save())
{
//SI_0708 - message was not upto the mark
ValueNamePair pp = VAdvantage.Logging.VLogger.RetrieveError();
if (pp != null)
{
throw new ArgumentException("Cannot save Invoice. " + pp.GetName());
}
throw new ArgumentException("Cannot save Invoice");
//return GetReterivedError(invoice, "Cannot save Invoice");
}
MInOutLine[] shipLines = ship.GetLines(false);
DateTime? AmortStartDate = null;
DateTime? AmortEndDate = null;
count = 0;
DataSet ds = null;
for (int i = 0; i < shipLines.Length; i++)
{
MInOutLine sLine = shipLines[i];
// Changes done by Bharat on 06 July 2017 restrict to create invoice if Invoice already created against that for same quantity
string sql = @"SELECT ml.QtyEntered - SUM(COALESCE(li.QtyEntered,0)) as QtyEntered, ml.MovementQty-SUM(COALESCE(li.QtyInvoiced,0)) as QtyInvoiced
FROM M_InOutLine ml INNER JOIN C_InvoiceLine li ON li.M_InOutLine_ID = ml.M_InOutLine_ID INNER JOIN C_Invoice ci ON ci.C_Invoice_ID = li.C_Invoice_ID
WHERE ci.DocStatus NOT IN ('VO', 'RE') AND ml.M_InOutLine_ID =" + sLine.GetM_InOutLine_ID() + " GROUP BY ml.MovementQty, ml.QtyEntered";
ds = DB.ExecuteDataset(sql, null, Get_Trx());
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
decimal qtyEntered = Util.GetValueOfDecimal(ds.Tables[0].Rows[0][0]);
decimal qtyInvoiced = Util.GetValueOfDecimal(ds.Tables[0].Rows[0][1]);
if (qtyEntered <= 0)
{
ds.Dispose();
log.Info("Invoice Line already exist for Receipt Line ID - " + sLine.GetM_InOutLine_ID());
continue;
}
else
{
MInvoiceLine line = new MInvoiceLine(invoice);
line.SetShipLine(sLine);
//line.SetQtyEntered(sLine.GetQtyEntered());
//line.SetQtyInvoiced(sLine.GetMovementQty());
line.SetQtyEntered(qtyEntered);
line.SetQtyInvoiced(qtyInvoiced);
// Change By Mohit Amortization process -------------
if (_CountVA038 > 0)
{
if (line.GetM_Product_ID() > 0)
{
MProduct pro = new MProduct(GetCtx(), sLine.GetM_Product_ID(), Get_TrxName());
if (Util.GetValueOfInt(pro.Get_Value("VA038_AmortizationTemplate_ID")) > 0)
{
line.Set_Value("VA038_AmortizationTemplate_ID", Util.GetValueOfInt(pro.Get_Value("VA038_AmortizationTemplate_ID")));
DataSet amrtDS = DB.ExecuteDataset("SELECT VA038_AmortizationType,VA038_AmortizationPeriod,VA038_TermSource,VA038_PeriodType,Name FROM VA038_AmortizationTemplate WHERE IsActive='Y' AND VA038_AMORTIZATIONTEMPLATE_ID=" + Util.GetValueOfInt(pro.Get_Value("VA038_AmortizationTemplate_ID")));
AmortStartDate = null;
AmortEndDate = null;
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_TermSource"]) == "A")
{
AmortStartDate = invoice.GetDateAcct();
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_TermSource"]) == "T")
{
AmortStartDate = invoice.GetDateInvoiced();
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_PeriodType"]) == "M")
{
AmortEndDate = AmortStartDate.Value.AddMonths(Util.GetValueOfInt(amrtDS.Tables[0].Rows[0]["VA038_AmortizationPeriod"]));
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_PeriodType"]) == "Y")
{
AmortEndDate = AmortStartDate.Value.AddYears(Util.GetValueOfInt(amrtDS.Tables[0].Rows[0]["VA038_AmortizationPeriod"]));
}
line.Set_Value("FROMDATE", AmortStartDate);
line.Set_Value("EndDate", AmortEndDate);
if (amrtDS != null)
{
amrtDS.Dispose();
}
}
}
if (line.GetC_Charge_ID() > 0)
{
MCharge charge = new MCharge(GetCtx(), sLine.GetC_Charge_ID(), Get_TrxName());
if (Util.GetValueOfInt(charge.Get_Value("VA038_AmortizationTemplate_ID")) > 0)
{
line.Set_Value("VA038_AmortizationTemplate_ID", Util.GetValueOfInt(charge.Get_Value("VA038_AmortizationTemplate_ID")));
DataSet amrtDS = DB.ExecuteDataset("SELECT VA038_AmortizationType,VA038_AmortizationPeriod,VA038_TermSource,VA038_PeriodType,Name FROM VA038_AmortizationTemplate WHERE IsActive='Y' AND VA038_AMORTIZATIONTEMPLATE_ID=" + Util.GetValueOfInt(charge.Get_Value("VA038_AmortizationTemplate_ID")));
AmortStartDate = null;
AmortEndDate = null;
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_TermSource"]) == "A")
{
AmortStartDate = invoice.GetDateAcct();
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_TermSource"]) == "T")
{
AmortStartDate = invoice.GetDateInvoiced();
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_PeriodType"]) == "M")
{
AmortEndDate = AmortStartDate.Value.AddMonths(Util.GetValueOfInt(amrtDS.Tables[0].Rows[0]["VA038_AmortizationPeriod"]));
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_PeriodType"]) == "Y")
{
AmortEndDate = AmortStartDate.Value.AddYears(Util.GetValueOfInt(amrtDS.Tables[0].Rows[0]["VA038_AmortizationPeriod"]));
}
line.Set_Value("FROMDATE", AmortStartDate);
line.Set_Value("EndDate", AmortEndDate);
if (amrtDS != null)
{
amrtDS.Dispose();
}
}
}
}
// End Change Amortization process--------------
if (!line.Save())
{
//return GetReterivedError(line, "Cannot save Invoice Line");
//SI_0708 - message was not upto the mark
ValueNamePair pp = VAdvantage.Logging.VLogger.RetrieveError();
if (pp != null)
{
throw new ArgumentException("Cannot save Invoice Line. " + pp.GetName());
}
throw new ArgumentException("Cannot save Invoice Line");
}
count++;
}
ds.Dispose();
}
else
{
MInvoiceLine line = new MInvoiceLine(invoice);
line.SetShipLine(sLine);
line.SetQtyEntered(sLine.GetQtyEntered());
line.SetQtyInvoiced(sLine.GetMovementQty());
line.Set_ValueNoCheck("IsDropShip", sLine.Get_Value("IsDropShip")); //Arpit Rai 20-Sept-2017
// Change By Mohit Amortization process -------------
if (_CountVA038 > 0)
{
if (line.GetM_Product_ID() > 0)
{
MProduct pro = new MProduct(GetCtx(), sLine.GetM_Product_ID(), Get_TrxName());
if (Util.GetValueOfInt(pro.Get_Value("VA038_AmortizationTemplate_ID")) > 0)
{
line.Set_Value("VA038_AmortizationTemplate_ID", Util.GetValueOfInt(pro.Get_Value("VA038_AmortizationTemplate_ID")));
DataSet amrtDS = DB.ExecuteDataset("SELECT VA038_AmortizationType,VA038_AmortizationPeriod,VA038_TermSource,VA038_PeriodType,Name FROM VA038_AmortizationTemplate WHERE IsActive='Y' AND VA038_AMORTIZATIONTEMPLATE_ID=" + Util.GetValueOfInt(pro.Get_Value("VA038_AmortizationTemplate_ID")));
AmortStartDate = null;
AmortEndDate = null;
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_TermSource"]) == "A")
{
AmortStartDate = invoice.GetDateAcct();
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_TermSource"]) == "T")
{
AmortStartDate = invoice.GetDateInvoiced();
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_PeriodType"]) == "M")
{
AmortEndDate = AmortStartDate.Value.AddMonths(Util.GetValueOfInt(amrtDS.Tables[0].Rows[0]["VA038_AmortizationPeriod"]));
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_PeriodType"]) == "Y")
{
AmortEndDate = AmortStartDate.Value.AddYears(Util.GetValueOfInt(amrtDS.Tables[0].Rows[0]["VA038_AmortizationPeriod"]));
}
line.Set_Value("FROMDATE", AmortStartDate);
line.Set_Value("EndDate", AmortEndDate);
if (amrtDS != null)
{
amrtDS.Dispose();
}
}
}
if (line.GetC_Charge_ID() > 0)
{
MCharge charge = new MCharge(GetCtx(), sLine.GetC_Charge_ID(), Get_TrxName());
if (Util.GetValueOfInt(charge.Get_Value("VA038_AmortizationTemplate_ID")) > 0)
{
line.Set_Value("VA038_AmortizationTemplate_ID", Util.GetValueOfInt(charge.Get_Value("VA038_AmortizationTemplate_ID")));
DataSet amrtDS = DB.ExecuteDataset("SELECT VA038_AmortizationType,VA038_AmortizationPeriod,VA038_TermSource,VA038_PeriodType,Name FROM VA038_AmortizationTemplate WHERE IsActive='Y' AND VA038_AMORTIZATIONTEMPLATE_ID=" + Util.GetValueOfInt(charge.Get_Value("VA038_AmortizationTemplate_ID")));
AmortStartDate = null;
AmortEndDate = null;
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_TermSource"]) == "A")
{
AmortStartDate = invoice.GetDateAcct();
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_TermSource"]) == "T")
{
AmortStartDate = invoice.GetDateInvoiced();
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_PeriodType"]) == "M")
{
AmortEndDate = AmortStartDate.Value.AddMonths(Util.GetValueOfInt(amrtDS.Tables[0].Rows[0]["VA038_AmortizationPeriod"]));
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_PeriodType"]) == "Y")
{
AmortEndDate = AmortStartDate.Value.AddYears(Util.GetValueOfInt(amrtDS.Tables[0].Rows[0]["VA038_AmortizationPeriod"]));
}
line.Set_Value("FROMDATE", AmortStartDate);
line.Set_Value("EndDate", AmortEndDate);
if (amrtDS != null)
{
amrtDS.Dispose();
}
}
}
}
// End Change Amortization process--------------
if (!line.Save())
{
//return GetReterivedError(line, "Cannot save Invoice Line");
//SI_0708 - message was not upto the mark
ValueNamePair pp = VAdvantage.Logging.VLogger.RetrieveError();
if (pp != null)
{
throw new ArgumentException("Cannot save Invoice Line. " + pp.GetName());
}
throw new ArgumentException("Cannot save Invoice Line");
}
count++;
}
}
#region [Enhancement for Charges Distribution/Generation by Sukhwinder on 13 December 2017]
if (_GenerateCharges && count > 0)
{
StringBuilder OrderSql = new StringBuilder();
OrderSql.Append(" SELECT CO.C_ORDER_ID, "
+ " SUM(ML.QTYENTERED) AS MRLINEQTY, "
+ " SUM(OL.QTYENTERED) AS ORDERQTY, "
+ " SUM(OL.QTYENTERED *OL.PRICEENTERED) AS LINEAMT, "
+ " SUM(ML.QTYENTERED*OL.PRICEENTERED) AS MRLINEVALUE "
+ " FROM M_INOUTLINE ML "
+ " INNER JOIN C_ORDERLINE OL "
+ " ON OL.C_ORDERLINE_ID = ML.C_ORDERLINE_ID "
+ " INNER JOIN C_ORDER CO "
+ " ON CO.C_ORDER_ID = OL.C_ORDER_ID "
+ " WHERE ML.M_INOUT_ID = " + _M_InOut_ID
+ " AND (OL.C_CHARGE_ID IS NULL "
+ " OR OL.C_CHARGE_ID = 0) "
+ " GROUP BY CO.C_ORDER_ID ");
DataSet OrderDS = DB.ExecuteDataset(OrderSql.ToString(), null, Get_Trx());
if (OrderDS != null && OrderDS.Tables[0].Rows.Count > 0)
{
StringBuilder ChargesSql = new StringBuilder();
for (int index = 0; index < OrderDS.Tables[0].Rows.Count; index++)
{
ds = null;
ChargesSql.Clear();
ChargesSql.Append(" SELECT C_CHARGE_ID, "
+ " C_ORDERLINE_ID, "
+ " C_ORDER_ID, "
+ " C_CURRENCY_ID, "
+ " PRICEENTERED, "
+ " PRICEACTUAL, "
+ " LINENETAMT, "
+ " QTYENTERED, "
+ " C_UOM_ID, "
+ " C_Tax_ID, "
+ " IsDropShip "
+ " FROM C_ORDERLINE "
+ " WHERE C_ORDER_ID IN "
+ " ( " + Util.GetValueOfInt(OrderDS.Tables[0].Rows[index]["C_ORDER_ID"])
+ " ) "
+ " AND C_CHARGE_ID IS NOT NULL "
+ " AND C_CHARGE_ID > 0 ");
ds = DB.ExecuteDataset(ChargesSql.ToString(), null, Get_Trx());
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
MInvoiceLine line = new MInvoiceLine(invoice);
line.SetQty(1);
line.SetQtyEntered(1);
line.SetQtyInvoiced(1);
line.SetOrderLine(new MOrderLine(GetCtx(), Util.GetValueOfInt(ds.Tables[0].Rows[i]["C_ORDERLINE_ID"]), Get_Trx()));
line.SetC_Charge_ID(Util.GetValueOfInt(ds.Tables[0].Rows[i]["C_CHARGE_ID"]));
line.SetC_UOM_ID(Util.GetValueOfInt(ds.Tables[0].Rows[i]["C_UOM_ID"]));
line.SetC_Tax_ID(Util.GetValueOfInt(ds.Tables[0].Rows[i]["C_TAX_ID"]));
decimal SumOfQty = 0;
decimal SumOfvalue = 0;
decimal sototval = 0;
string sql = "SELECT SUM(OL.QTYENTERED *OL.PRICEENTERED) AS LINEAMT from C_ORDER CO,C_ORDERLINE OL WHERE CO.C_ORDER_ID=OL.C_ORDER_ID AND (OL.C_CHARGE_ID IS NULL OR OL.C_CHARGE_ID = 0) and CO.C_ORDER_ID =" + ship.GetC_Order_ID();
sototval = VAdvantage.Utility.Util.GetValueOfDecimal(DB.ExecuteScalar(sql));
if (Util.GetValueOfInt(OrderDS.Tables[0].Rows[index]["ORDERQTY"]) == 0)
{
SumOfQty = 1;
}
else
{
SumOfQty = Util.GetValueOfInt(OrderDS.Tables[0].Rows[index]["ORDERQTY"]);
SumOfvalue = Util.GetValueOfDecimal(OrderDS.Tables[0].Rows[index]["LINEAMT"]);
}
//decimal amt = (Util.GetValueOfDecimal(ds.Tables[0].Rows[i]["LINENETAMT"]) / SumOfQty) * Util.GetValueOfInt(OrderDS.Tables[0].Rows[index]["MRLINEQTY"]);
decimal amt = (Util.GetValueOfDecimal(ds.Tables[0].Rows[i]["LINENETAMT"]) / sototval) * Util.GetValueOfInt(OrderDS.Tables[0].Rows[index]["MRLINEVALUE"]);
line.SetPrice(Decimal.Round(amt, 3));
line.SetPriceActual(Decimal.Round(amt, 3));
line.SetPriceEntered(Decimal.Round(amt, 3));
line.SetLineNetAmt(Decimal.Round(amt, 3));
line.Set_ValueNoCheck("IsDropShip", Util.GetValueOfString(ds.Tables[0].Rows[i]["ISDROPSHIP"]));
if (_CountVA038 > 0)
{
if (line.GetC_Charge_ID() > 0)
{
MCharge charge = new MCharge(GetCtx(), line.GetC_Charge_ID(), Get_TrxName());
if (Util.GetValueOfInt(charge.Get_Value("VA038_AmortizationTemplate_ID")) > 0)
{
line.Set_Value("VA038_AmortizationTemplate_ID", Util.GetValueOfInt(charge.Get_Value("VA038_AmortizationTemplate_ID")));
DataSet amrtDS = DB.ExecuteDataset("SELECT VA038_AmortizationType,VA038_AmortizationPeriod,VA038_TermSource,VA038_PeriodType,Name FROM VA038_AmortizationTemplate WHERE IsActive='Y' AND VA038_AMORTIZATIONTEMPLATE_ID=" + Util.GetValueOfInt(charge.Get_Value("VA038_AmortizationTemplate_ID")));
AmortStartDate = null;
AmortEndDate = null;
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_TermSource"]) == "A")
{
AmortStartDate = invoice.GetDateAcct();
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_TermSource"]) == "T")
{
AmortStartDate = invoice.GetDateInvoiced();
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_PeriodType"]) == "M")
{
AmortEndDate = AmortStartDate.Value.AddMonths(Util.GetValueOfInt(amrtDS.Tables[0].Rows[0]["VA038_AmortizationPeriod"]));
}
if (Util.GetValueOfString(amrtDS.Tables[0].Rows[0]["VA038_PeriodType"]) == "Y")
{
AmortEndDate = AmortStartDate.Value.AddYears(Util.GetValueOfInt(amrtDS.Tables[0].Rows[0]["VA038_AmortizationPeriod"]));
}
line.Set_Value("FROMDATE", AmortStartDate);
line.Set_Value("EndDate", AmortEndDate);
if (amrtDS != null)
{
amrtDS.Dispose();
}
}
}
}
if (!line.Save())
{
//return GetReterivedError(line, "Cannot save Invoice Line");
//SI_0708 - message was not upto the mark
ValueNamePair pp = VAdvantage.Logging.VLogger.RetrieveError();
if (pp != null)
{
throw new ArgumentException("Cannot save Invoice Line. " + pp.GetName());
}
throw new ArgumentException("Cannot save Invoice Line");
}
}
}
}
}
}
#endregion
if (count > 0)
{
return(invoice.GetDocumentNo());
}
else
{
Get_Trx().Rollback();
return(Msg.GetMsg(GetCtx(), "InvoiceExist"));
}
}
/// <summary>
/// Create new Charge based on the parameters passed
/// </summary>
/// <param name="ctx"></param>
/// <param name="m_C_AcctSchema_ID"></param>
/// <param name="m_C_TaxCategory_ID"></param>
/// <param name="name"></param>
/// <param name="primaryC_ElementValue_ID"></param>
/// <param name="expense"></param>
/// <returns></returns>
public int CreateCharge(Ctx ctx, int m_C_AcctSchema_ID, int m_C_TaxCategory_ID, String name, int primaryC_ElementValue_ID, Boolean expense)
{
MCharge charge = new MCharge(ctx, 0, null);
charge.SetName(name);
charge.SetC_TaxCategory_ID(m_C_TaxCategory_ID);
if (!charge.Save())
{
// log.Log(Level.SEVERE, name + " not created");
Msg = name + " not created";
ID = 0;
return(0);
}
MAcctSchema m_acctSchema = null;
// Get Primary AcctSchama
if (m_acctSchema == null)
{
m_acctSchema = new MAcctSchema(ctx, m_C_AcctSchema_ID, null);
}
if (m_acctSchema == null || m_acctSchema.GetC_AcctSchema_ID() == 0)
{
ID = 0;
return(0);
}
MAcctSchemaElement primary_ase = m_acctSchema.GetAcctSchemaElement(X_C_AcctSchema_Element.ELEMENTTYPE_Account);
// Get All
MAcctSchema[] ass = MAcctSchema.GetClientAcctSchema(ctx, charge.GetAD_Client_ID());
foreach (MAcctSchema ac in ass)
{
// Target Account
MAccount defaultAcct = MAccount.GetDefault(ac, true); // optional null
// Natural Account
int C_ElementValue_ID = primaryC_ElementValue_ID;
MAcctSchemaElement ase = ac.GetAcctSchemaElement(X_C_AcctSchema_Element.ELEMENTTYPE_Account);
if (primary_ase.GetC_Element_ID() != ase.GetC_Element_ID())
{
MAcctSchemaDefault defAccts = MAcctSchemaDefault.Get(ctx, ac.GetC_AcctSchema_ID());
int C_ValidCombination_ID = defAccts.GetCh_Expense_Acct();
if (!expense)
{
C_ValidCombination_ID = defAccts.GetCh_Revenue_Acct();
}
MAccount chargeAcct = MAccount.Get(ctx, C_ValidCombination_ID);
C_ElementValue_ID = chargeAcct.GetAccount_ID();
// Fallback
if (C_ElementValue_ID == 0)
{
C_ElementValue_ID = defaultAcct.GetAccount_ID();
if (C_ElementValue_ID == 0)
{
C_ElementValue_ID = ase.GetC_ElementValue_ID();
}
if (C_ElementValue_ID == 0)
{
// log.Log(Level.WARNING, "No Default ElementValue for " + ac);
Msg = "No Default ElementValue for " + ac;
continue;
}
}
}
MAccount acct = MAccount.Get(ctx,
charge.GetAD_Client_ID(), charge.GetAD_Org_ID(),
ac.GetC_AcctSchema_ID(),
C_ElementValue_ID, defaultAcct.GetC_SubAcct_ID(),
defaultAcct.GetM_Product_ID(), defaultAcct.GetC_BPartner_ID(), defaultAcct.GetAD_OrgTrx_ID(),
defaultAcct.GetC_LocFrom_ID(), defaultAcct.GetC_LocTo_ID(), defaultAcct.GetC_SalesRegion_ID(),
defaultAcct.GetC_Project_ID(), defaultAcct.GetC_Campaign_ID(), defaultAcct.GetC_Activity_ID(),
defaultAcct.GetUser1_ID(), defaultAcct.GetUser2_ID(),
defaultAcct.GetUserElement1_ID(), defaultAcct.GetUserElement2_ID());
if (acct == null)
{
//log.Log(Level.WARNING, "No Default Account for " + ac);
Msg = "No Default Account for " + ac;
continue;
}
// Update Accounts
StringBuilder sql = new StringBuilder("UPDATE C_Charge_Acct ");
sql.Append("SET CH_Expense_Acct=").Append(acct.GetC_ValidCombination_ID());
sql.Append(", CH_Revenue_Acct=").Append(acct.GetC_ValidCombination_ID());
sql.Append(" WHERE C_Charge_ID=").Append(charge.GetC_Charge_ID());
sql.Append(" AND C_AcctSchema_ID=").Append(ac.GetC_AcctSchema_ID());
//
int no = VAdvantage.DataBase.DB.ExecuteQuery(sql.ToString(), null, null);
if (no != 1)
{
//log.Log(Level.WARNING, "Update #" + no + "\n" + sql.ToString());
Msg = "Update #" + no + "\n" + sql.ToString();
}
}
ID = charge.GetC_Charge_ID();
return(charge.GetC_Charge_ID());
}
/// <summary>
/// Create Facts (the accounting logic) for
/// ARP, APP.
///<pre>
/// ARP
/// BankInTransit DR
/// UnallocatedCash CR
/// or Charge/C_Prepayment
/// APP
/// PaymentSelect DR
/// or Charge/V_Prepayment
/// BankInTransit CR
/// CashBankTransfer
/// -
/// </pre>
/// </summary>
/// <param name="as1"></param>
/// <returns>fact</returns>
public override List <Fact> CreateFacts(MAcctSchema as1)
{
// create Fact Header
Fact fact = new Fact(this, as1, Fact.POST_Actual);
// Cash Transfer
if ("X".Equals(_TenderType))
{
List <Fact> facts = new List <Fact>();
facts.Add(fact);
return(facts);
}
int AD_Org_ID = GetBank_Org_ID(); // Bank Account Org
if (GetDocumentType().Equals(MDocBaseType.DOCBASETYPE_ARRECEIPT))
{
// Asset
FactLine fl = fact.CreateLine(null, GetAccount(Doc.ACCTTYPE_BankInTransit, as1),
GetC_Currency_ID(), GetAmount(), null);
if (fl != null && AD_Org_ID != 0)
{
fl.SetAD_Org_ID(AD_Org_ID);
}
//
MAccount acct = null;
if (GetC_Charge_ID() != 0)
{
acct = MCharge.GetAccount(GetC_Charge_ID(), as1, GetAmount());
}
else if (_Prepayment)
{
acct = GetAccount(Doc.ACCTTYPE_C_Prepayment, as1);
}
else
{
acct = GetAccount(Doc.ACCTTYPE_UnallocatedCash, as1);
}
fl = fact.CreateLine(null, acct,
GetC_Currency_ID(), null, GetAmount());
if (fl != null && AD_Org_ID != 0 &&
GetC_Charge_ID() == 0) // don't overwrite charge
{
fl.SetAD_Org_ID(AD_Org_ID);
}
}
// APP
else if (GetDocumentType().Equals(MDocBaseType.DOCBASETYPE_APPAYMENT))
{
MAccount acct = null;
if (GetC_Charge_ID() != 0)
{
acct = MCharge.GetAccount(GetC_Charge_ID(), as1, GetAmount());
}
else if (_Prepayment)
{
acct = GetAccount(Doc.ACCTTYPE_V_Prepayment, as1);
}
else
{
acct = GetAccount(Doc.ACCTTYPE_PaymentSelect, as1);
}
FactLine fl = fact.CreateLine(null, acct,
GetC_Currency_ID(), GetAmount(), null);
if (fl != null && AD_Org_ID != 0 &&
GetC_Charge_ID() == 0) // don't overwrite charge
{
fl.SetAD_Org_ID(AD_Org_ID);
}
// Asset
fl = fact.CreateLine(null, GetAccount(Doc.ACCTTYPE_BankInTransit, as1),
GetC_Currency_ID(), null, GetAmount());
if (fl != null && AD_Org_ID != 0)
{
fl.SetAD_Org_ID(AD_Org_ID);
}
}
else
{
_error = "DocumentType unknown: " + GetDocumentType();
log.Log(Level.SEVERE, _error);
fact = null;
}
//
List <Fact> facts1 = new List <Fact>();
facts1.Add(fact);
return(facts1);
}