/**
* Set Value, Name, Description
* @param invoice
* @param deliveryCount count
* @param product product
* @param partner partner
*/
public void SetValueNameDescription(MInvoice invoice,
int deliveryCount, MProduct product, MBPartner partner)
{
String documentNo = "_" + invoice.GetDocumentNo();
if (deliveryCount > 1)
{
documentNo += "_" + deliveryCount;
}
// Value
String value = partner.GetValue() + "_" + product.GetValue();
if (value.Length > 40 - documentNo.Length)
{
value = value.Substring(0, 40 - documentNo.Length) + documentNo;
}
// Change to set Value from Document Sequence
// SetValue(value);
// Change to set only name of product as value in Asset
// Name MProduct.afterSave
// String name = partner.GetName() + " - " + product.GetName();
String name = product.GetName();
if (name.Length > 60)
{
name = name.Substring(0, 60);
}
SetName(name);
// Description
String description = product.GetDescription();
SetDescription(description);
}
/// <summary>
/// Complete Invoice
/// </summary>
/// <param name="invoice">invoice</param>
private void CompleteInvoice(MInvoice invoice, MTimeExpense te)
{
if (invoice == null)
{
return;
}
invoice.SetDocAction(DocActionVariables.ACTION_PREPARE);
invoice.ProcessIt(DocActionVariables.ACTION_COMPLETE);
if (!invoice.Save())
{
//Added By Siddheshwar
if (!IncompleteInvoice.Contains(te.GetS_TimeExpense_ID()))
{
IncompleteInvoice.Add(te.GetS_TimeExpense_ID());
if (string.IsNullOrEmpty(bpNameInvoice))
{
bpNameInvoice = te.GetDocumentNo();
}
else
{
bpNameInvoice += te.GetDocumentNo() + ", ";
}
}
new Exception(invoice + "Cannot save Invoice");
Rollback();
}
else
{
Commit();
_noInvoices++;
AddLog(invoice.Get_ID(), invoice.GetDateInvoiced(),
invoice.GetGrandTotal(), invoice.GetDocumentNo());
}
} // completeInvoice
} // toString
/// <summary>
/// Execute Run.
/// </summary>
/// <returns>clear text info</returns>
public String ExecuteRun()
{
DateTime?dateDoc = GetDateNextRun();
if (!CalculateRuns())
{
throw new Exception("No Runs Left");
}
// log
MRecurringRun run = new MRecurringRun(GetCtx(), this);
String msg = "@Created@ ";
// Copy
if (GetRecurringType().Equals(MRecurring.RECURRINGTYPE_Order))
{
MOrder from = new MOrder(GetCtx(), GetC_Order_ID(), Get_TrxName());
MOrder order = MOrder.CopyFrom(from, dateDoc,
from.GetC_DocType_ID(), false, false, Get_TrxName());
run.SetC_Order_ID(order.GetC_Order_ID());
msg += order.GetDocumentNo();
}
else if (GetRecurringType().Equals(MRecurring.RECURRINGTYPE_Invoice))
{
MInvoice from = new MInvoice(GetCtx(), GetC_Invoice_ID(), Get_TrxName());
MInvoice invoice = MInvoice.CopyFrom(from, dateDoc,
from.GetC_DocType_ID(), false, Get_TrxName(), false);
run.SetC_Invoice_ID(invoice.GetC_Invoice_ID());
msg += invoice.GetDocumentNo();
}
else if (GetRecurringType().Equals(MRecurring.RECURRINGTYPE_Project))
{
MProject project = MProject.CopyFrom(GetCtx(), GetC_Project_ID(), dateDoc, Get_TrxName());
run.SetC_Project_ID(project.GetC_Project_ID());
msg += project.GetValue();
}
else if (GetRecurringType().Equals(MRecurring.RECURRINGTYPE_GLJournal))
{
MJournalBatch journal = MJournalBatch.CopyFrom(GetCtx(), GetGL_JournalBatch_ID(), dateDoc, Get_TrxName());
run.SetGL_JournalBatch_ID(journal.GetGL_JournalBatch_ID());
msg += journal.GetDocumentNo();
}
else
{
return("Invalid @RecurringType@ = " + GetRecurringType());
}
run.Save(Get_TrxName());
//
SetDateLastRun(run.GetUpdated());
SetRunsRemaining(GetRunsRemaining() - 1);
SetDateNextRun();
Save(Get_TrxName());
return(msg);
} // execureRun
/// <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);
if (_M_InOut_ID == 0)
{
throw new ArgumentException("No Shipment");
}
//
MInOut ship = new MInOut(GetCtx(), _M_InOut_ID, null);
if (ship.Get_ID() == 0)
{
throw new ArgumentException("Shipment not found");
}
if (!MInOut.DOCSTATUS_Completed.Equals(ship.GetDocStatus()))
{
throw new ArgumentException("Shipment not completed");
}
MInvoice invoice = new MInvoice(ship, null);
if (ship.IsReturnTrx())
{
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);
}
if (!invoice.Save())
{
throw new ArgumentException("Cannot save Invoice");
}
MInOutLine[] shipLines = ship.GetLines(false);
for (int i = 0; i < shipLines.Length; i++)
{
MInOutLine sLine = shipLines[i];
MInvoiceLine line = new MInvoiceLine(invoice);
line.SetShipLine(sLine);
line.SetQtyEntered(sLine.GetQtyEntered());
line.SetQtyInvoiced(sLine.GetMovementQty());
if (!line.Save())
{
throw new ArgumentException("Cannot save Invoice Line");
}
}
return(invoice.GetDocumentNo());
}
} // doIt
/// <summary>
/// Complete Invoice
/// </summary>
private void CompleteInvoice()
{
if (_invoice == null)
{
return;
}
_invoice.SetDocAction(_DocAction);
_invoice.ProcessIt(_DocAction);
_invoice.Save();
AddLog(0, _invoice.GetDateInvoiced(), _invoice.GetGrandTotal(), _invoice.GetDocumentNo());
_count++;
_invoice = null;
} // completeInvoice
} // doIt
/// <summary>
/// Complete Invoice
/// </summary>
/// <param name="invoice">invoice</param>
private void CompleteInvoice(MInvoice invoice)
{
if (invoice == null)
{
return;
}
invoice.SetDocAction(DocActionVariables.ACTION_PREPARE);
invoice.ProcessIt(DocActionVariables.ACTION_PREPARE);
if (!invoice.Save())
{
new Exception("Cannot save Invoice");
}
//
_noInvoices++;
AddLog(invoice.Get_ID(), invoice.GetDateInvoiced(),
invoice.GetGrandTotal(), invoice.GetDocumentNo());
} // completeInvoice
/// <summary>
/// Perrform Process.
/// </summary>
/// <returns>Message (clear text)</returns>
protected override String DoIt()
{
log.Info("C_Order_ID=" + _C_Order_ID + ", C_Invoice_ID=" + _C_Invoice_ID);
if (_C_Order_ID == 0 && _C_Invoice_ID == 0)
{
throw new Exception("Nothing to do");
}
String retValue = "";
if (_C_Order_ID != 0)
{
MOrder order = new MOrder(GetCtx(), _C_Order_ID, Get_TrxName());
Decimal oldPrice = order.GetGrandTotal();
MOrderLine[] lines = order.GetLines();
for (int i = 0; i < lines.Length; i++)
{
lines[i].SetPrice(order.GetM_PriceList_ID());
lines[i].Save();
}
order = new MOrder(GetCtx(), _C_Order_ID, Get_TrxName());
Decimal newPrice = order.GetGrandTotal();
retValue = order.GetDocumentNo() + ": " + oldPrice + " -> " + newPrice;
}
if (_C_Invoice_ID != 0)
{
MInvoice invoice = new MInvoice(GetCtx(), _C_Invoice_ID, null);
Decimal oldPrice = invoice.GetGrandTotal();
MInvoiceLine[] lines = invoice.GetLines(false);
for (int i = 0; i < lines.Length; i++)
{
lines[i].SetPrice(invoice.GetM_PriceList_ID(), invoice.GetC_BPartner_ID());
lines[i].Save();
}
invoice = new MInvoice(GetCtx(), _C_Invoice_ID, null);
Decimal newPrice = invoice.GetGrandTotal();
if (retValue.Length > 0)
{
retValue += Env.NL;
}
retValue += invoice.GetDocumentNo() + ": " + oldPrice + " -> " + newPrice;
}
//
return(retValue);
}
} // doIt
/// <summary>
/// Done with Invoice
/// </summary>
private void InvoiceDone()
{
// Close Old
if (_m_invoice != null)
{
if (_m_linecount == 0)
{
_m_invoice.Delete(false);
}
else
{
//_m_invoice.ProcessIt(MInvoice.ACTION_Prepare);
_m_invoice.ProcessIt(DocActionVariables.ACTION_PREPARE);
_m_invoice.Save();
AddLog(0, null, _m_invoice.GetGrandTotal(), _m_invoice.GetDocumentNo());
}
}
_m_invoice = null;
} // invoiceDone
/**
* Complete Document
* @return new status (Complete, In Progress, Invalid, Waiting ..)
*/
public String CompleteIt()
{
// Re-Check
if (!_justPrepared)
{
String status = PrepareIt();
if (!DocActionVariables.STATUS_INPROGRESS.Equals(status))
{
return(status);
}
}
// Implicit Approval
if (!IsApproved())
{
ApproveIt();
}
log.Info(ToString());
//
MInOut inout = new MInOut(GetCtx(), GetM_InOut_ID(), Get_TrxName());
MInOutLineConfirm[] lines = GetLines(false);
// Check if we need to split Shipment
if (IsInDispute())
{
MDocType dt = MDocType.Get(GetCtx(), inout.GetC_DocType_ID());
if (dt.IsSplitWhenDifference())
{
if (dt.GetC_DocTypeDifference_ID() == 0)
{
_processMsg = "No Split Document Type defined for: " + dt.GetName();
return(DocActionVariables.STATUS_INVALID);
}
SplitInOut(inout, dt.GetC_DocTypeDifference_ID(), lines);
_lines = null;
}
}
// All lines
for (int i = 0; i < lines.Length; i++)
{
MInOutLineConfirm confirmLine = lines[i];
confirmLine.Set_TrxName(Get_TrxName());
if (!confirmLine.ProcessLine(inout.IsSOTrx(), GetConfirmType()))
{
_processMsg = "ShipLine not saved - " + confirmLine;
return(DocActionVariables.STATUS_INVALID);
}
if (confirmLine.IsFullyConfirmed())
{
confirmLine.SetProcessed(true);
confirmLine.Save(Get_TrxName());
}
else
{
if (CreateDifferenceDoc(inout, confirmLine))
{
confirmLine.SetProcessed(true);
confirmLine.Save(Get_TrxName());
}
else
{
log.Log(Level.SEVERE, "Scrapped=" + confirmLine.GetScrappedQty()
+ " - Difference=" + confirmLine.GetDifferenceQty());
return(DocActionVariables.STATUS_INVALID);
}
}
} // for all lines
if (_creditMemo != null)
{
_processMsg += " @C_Invoice_ID@=" + _creditMemo.GetDocumentNo();
}
if (_inventory != null)
{
_processMsg += " @M_Inventory_ID@=" + _inventory.GetDocumentNo();
}
// User Validation
String valid = ModelValidationEngine.Get().FireDocValidate(this,
ModalValidatorVariables.DOCTIMING_AFTER_COMPLETE);
if (valid != null)
{
_processMsg = valid;
return(DocActionVariables.STATUS_INVALID);
}
SetProcessed(true);
SetDocAction(DOCACTION_Close);
return(DocActionVariables.STATUS_COMPLETED);
}
} // toString
/// <summary>
/// Execute Run.
/// </summary>
/// <returns>clear text info</returns>
public String ExecuteRun()
{
DateTime?dateDoc = GetDateNextRun();
if (!CalculateRuns())
{
throw new Exception("No Runs Left");
}
// log
MRecurringRun run = new MRecurringRun(GetCtx(), this);
String msg = "@Created@ ";
//Checked if the Next Date Run is less then the date pressent Arpit on 15th Dec,2016
if (GetDateNextRun() == DateTime.Now.Date || GetDateNextRun() == null)
{
// Copy
if (GetRecurringType().Equals(MRecurring.RECURRINGTYPE_Order))
{
MOrder from = new MOrder(GetCtx(), GetC_Order_ID(), Get_TrxName());
MOrder order = MOrder.CopyFrom(from, dateDoc,
from.GetC_DocType_ID(), false, false, Get_TrxName());
run.SetC_Order_ID(order.GetC_Order_ID());
msg += order.GetDocumentNo();
}
else if (GetRecurringType().Equals(MRecurring.RECURRINGTYPE_Invoice))
{
MInvoice from = new MInvoice(GetCtx(), GetC_Invoice_ID(), Get_TrxName());
MInvoice invoice = MInvoice.CopyFrom(from, dateDoc,
from.GetC_DocType_ID(), false, Get_TrxName(), false);
run.SetC_Invoice_ID(invoice.GetC_Invoice_ID());
//Set Invoice Refrence and Description from Orignal to Recurring
invoice.Set_Value("InvoiceReference", from.GetDocumentNo() + "_" + (GetRunsMax() - GetRunsRemaining() + 1));
invoice.AddDescription(Msg.GetMsg(from.GetCtx(), "RecurringDocument") + from.GetDocumentNo());
if (!invoice.Save(Get_TrxName()))
{
ValueNamePair pp = VLogger.RetrieveError();
if (pp != null)
{
from.SetProcessMsg(Msg.GetMsg(from.GetCtx(), "CouldNotCreateInvoice") + pp.GetName());
}
else
{
from.SetProcessMsg(Msg.GetMsg(from.GetCtx(), "CouldNotCreateInvoice"));
}
throw new Exception(Msg.GetMsg(from.GetCtx(), "CouldNotCreateInvoice") + (pp != null ? pp.GetName() : ""));
}
msg += invoice.GetDocumentNo();
}
else if (GetRecurringType().Equals(MRecurring.RECURRINGTYPE_Project))
{
MProject project = MProject.CopyFrom(GetCtx(), GetC_Project_ID(), dateDoc, Get_TrxName());
run.SetC_Project_ID(project.GetC_Project_ID());
msg += project.GetValue();
}
else if (GetRecurringType().Equals(MRecurring.RECURRINGTYPE_GLJournalBatch)) //Changes to GL Journal Batch by Arpit
{
MJournalBatch journal = MJournalBatch.CopyFrom(GetCtx(), GetGL_JournalBatch_ID(), dateDoc, Get_TrxName());
run.SetGL_JournalBatch_ID(journal.GetGL_JournalBatch_ID());
msg += journal.GetDocumentNo();
}
//Added by Arpit on 14th, Dec,2016
else if (GetRecurringType().Equals(MRecurring.RECURRINGTYPE_GLJournal))
{
MJournal Journal = MJournal.CopyFrom(GetCtx(), GetGL_Journal_ID(), dateDoc, Get_TrxName());
run.SetGL_Journal_ID(Journal.GetGL_Journal_ID());
msg += Journal.GetDocumentNo();
}
//End here
else if (GetRecurringType().Equals(MRecurring.RECURRINGTYPE_Payment))
{
MPayment from = new MPayment(GetCtx(), GetC_Payment_ID(), Get_TrxName());
MPayment payment = MPayment.CopyFrom(from, dateDoc,
from.GetC_DocType_ID(), Get_TrxName());
run.SetC_Payment_ID(payment.GetC_Payment_ID());
msg += payment.GetDocumentNo();
}
else
{
return("Invalid @RecurringType@ = " + GetRecurringType());
}
run.Save(Get_TrxName());
//
SetDateLastRun(run.GetUpdated());
SetRunsRemaining(GetRunsRemaining() - 1);
SetDateNextRun();
Save(Get_TrxName());
return(msg);
}
else
{
return(Msg.GetMsg(GetCtx(), "RecurringNotCompleted") + String.Format("{0:dd/M/yyyy}", Convert.ToDateTime(GetDateNextRun())));
}
} // execureRun
protected override string DoIt()
{
try
{
_log.Info("Foreign Cost Calculation start at : " + DateTime.Now);
// Calculate Foreign Cost for Average Invoice
sql = @"SELECT i.c_invoice_id , il.c_invoiceline_id
FROM c_invoice i INNER JOIN c_invoiceline il ON i.c_invoice_id = il.c_invoice_id
WHERE il.isactive = 'Y' AND il.isfuturecostcalculated = 'N' AND i.isfuturecostcalculated = 'N'
AND docstatus IN ('CO' , 'CL') AND i.issotrx = 'N' AND i.isreturntrx = 'N' AND NVL(il.m_inoutline_ID , 0) <> 0
ORDER BY i.c_invoice_id ASC";
ds = DB.ExecuteDataset(sql, null, null);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
_log.Info("Foreign Cost Calculation : Average Invoice Record : " + ds.Tables[0].Rows.Count);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
try
{
invoice = new MInvoice(GetCtx(), Util.GetValueOfInt(ds.Tables[0].Rows[i]["c_invoice_id"]), Get_Trx());
invoiceLine = new MInvoiceLine(GetCtx(), Util.GetValueOfInt(ds.Tables[0].Rows[i]["c_invoiceline_id"]), Get_Trx());
if (!MCostForeignCurrency.InsertForeignCostAverageInvoice(GetCtx(), invoice, invoiceLine, Get_Trx()))
{
Get_Trx().Rollback();
ValueNamePair pp = VLogger.RetrieveError();
_log.Info("Error found for calcualting Av. Invoice Foreign Cost for this record ID = " + invoice.GetDocumentNo() +
" Error Name is " + pp.GetName() + " And Error Value is " + pp.GetValue());
continue;
}
else
{
if (Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(*) FROM C_InvoiceLine WHERE IsFutureCostCalculated = 'N' AND C_Invoice_ID = " + invoice.GetC_Invoice_ID(), null, Get_Trx())) <= 0)
{
int no = Util.GetValueOfInt(DB.ExecuteQuery("UPDATE C_Invoice Set IsFutureCostCalculated = 'Y' WHERE C_Invoice_ID = " + invoice.GetC_Invoice_ID(), null, Get_Trx()));
}
Get_Trx().Commit();
}
}
catch (Exception ex1) { }
}
}
// Calculate Foriegn Cost for Average PO
sql = @"SELECT i.m_inout_id , il.m_inoutline_id , il.c_orderline_id
FROM m_inout i INNER JOIN m_inoutline il ON i.m_inout_id = il.m_inout_id
WHERE il.isactive = 'Y' AND il.isfuturecostcalculated = 'N' AND i.isfuturecostcalculated = 'N'
AND docstatus IN ('CO' , 'CL') AND i.issotrx = 'N' AND i.isreturntrx = 'N' AND NVL(il.c_orderline_ID , 0) <> 0
ORDER BY i.m_inout_id ASC";
ds = DB.ExecuteDataset(sql, null, null);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
_log.Info("Foreign Cost Calculation : Average PO Record : " + ds.Tables[0].Rows.Count);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
try
{
orderLine = new MOrderLine(GetCtx(), Util.GetValueOfInt(ds.Tables[0].Rows[i]["c_orderline_id"]), Get_Trx());
order = new MOrder(GetCtx(), orderLine.GetC_Order_ID(), Get_Trx());
inoutLine = new MInOutLine(GetCtx(), Util.GetValueOfInt(ds.Tables[0].Rows[i]["m_inoutline_id"]), Get_Trx());
if (!MCostForeignCurrency.InsertForeignCostAveragePO(GetCtx(), order, orderLine, inoutLine, Get_Trx()))
{
Get_Trx().Rollback();
ValueNamePair pp = VLogger.RetrieveError();
_log.Info("Error found for calcualting Av. PO Foreign Cost for this record ID = " + inoutLine.GetM_InOut_ID() +
" Error Name is " + pp.GetName() + " And Error Value is " + pp.GetValue());
continue;
}
else
{
if (Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(*) FROM M_InoutLine WHERE IsFutureCostCalculated = 'N' AND M_InOut_ID = " + inoutLine.GetM_InOut_ID(), null, Get_Trx())) <= 0)
{
int no = Util.GetValueOfInt(DB.ExecuteQuery("UPDATE M_Inout Set IsFutureCostCalculated = 'Y' WHERE M_Inout_ID = " + inoutLine.GetM_InOut_ID(), null, Get_Trx()));
}
Get_Trx().Commit();
}
}
catch (Exception ex2) { }
}
}
}
catch (Exception ex)
{
}
_log.Info("Foreign Cost Calculation End : " + DateTime.Now);
return(Msg.GetMsg(GetCtx(), "SuccessFullyCompleted"));
}
/// <summary>
/// Perform Process.
/// </summary>
/// <returns>Message (variables are parsed)</returns>
protected override String DoIt()
{
log.Info("doIt - C_CommissionRun_ID=" + GetRecord_ID());
// Load Data
MCommissionRun comRun = new MCommissionRun(GetCtx(), GetRecord_ID(), Get_Trx());
if (comRun.Get_ID() == 0)
{
throw new ArgumentException("CommissionAPInvoice - No Commission Run");
}
if (Env.ZERO.CompareTo(comRun.GetGrandTotal()) == 0)
{
throw new ArgumentException("@GrandTotal@ = 0");
}
MCommission com = new MCommission(GetCtx(), comRun.GetC_Commission_ID(), Get_Trx());
if (com.Get_ID() == 0)
{
throw new ArgumentException("CommissionAPInvoice - No Commission");
}
if (com.GetC_Charge_ID() == 0)
{
throw new ArgumentException("CommissionAPInvoice - No Charge on Commission");
}
MBPartner bp = new MBPartner(GetCtx(), com.GetC_BPartner_ID(), Get_Trx());
if (bp.Get_ID() == 0)
{
throw new ArgumentException("CommissionAPInvoice - No BPartner");
}
// Create Invoice
MInvoice invoice = new MInvoice(GetCtx(), 0, null);
invoice.SetClientOrg(com.GetAD_Client_ID(), com.GetAD_Org_ID());
invoice.SetC_DocTypeTarget_ID(MDocBaseType.DOCBASETYPE_APINVOICE); // API
invoice.SetBPartner(bp);
// JID_0101: When we generate the AP invoice from Commission run window, its giving price list error.
if (invoice.GetM_PriceList_ID() == 0)
{
string sql = "SELECT M_PriceList_ID FROM M_PriceList WHERE IsActive = 'Y' AND AD_Client_ID = " + com.GetAD_Client_ID() + " AND AD_Org_ID = " + com.GetAD_Org_ID()
+ " AND IsDefault='Y' AND IsSOPriceList='N'";
int pricelist = Util.GetValueOfInt(DB.ExecuteScalar(sql, null, Get_Trx()));
if (pricelist == 0)
{
pricelist = MPriceList.GetDefault(GetCtx(), false).Get_ID();
}
if (pricelist > 0)
{
invoice.SetM_PriceList_ID(pricelist);
}
}
// invoice.setDocumentNo (comRun.getDocumentNo()); // may cause unique constraint
invoice.SetSalesRep_ID(GetAD_User_ID()); // caller
//
if (com.GetC_Currency_ID() != invoice.GetC_Currency_ID())
{
throw new ArgumentException("CommissionAPInvoice - Currency of PO Price List not Commission Currency");
}
//
if (!invoice.Save())
{
//return GetReterivedError(invoice, "CommissionAPInvoice - cannot save Invoice");
throw new Exception("CommissionAPInvoice - cannot save Invoice");
}
// Create Invoice Line
MInvoiceLine iLine = new MInvoiceLine(invoice);
iLine.SetC_Charge_ID(com.GetC_Charge_ID());
iLine.SetQty(1);
iLine.SetPrice(comRun.GetGrandTotal());
iLine.SetTax();
if (!iLine.Save())
{
//return GetReterivedError(iLine, "CommissionAPInvoice - cannot save Invoice Line");
throw new Exception("CommissionAPInvoice - cannot save Invoice Line");
}
//
return("@C_Invoice_ID@ = " + invoice.GetDocumentNo());
}
/**
* Complete Invoice
*/
private void CompleteInvoice()
{
if (_invoice != null)
{
if (!_invoice.ProcessIt(_docAction))
{
log.Warning("completeInvoice - failed: " + _invoice);
}
_invoice.Save();
//
AddLog(_invoice.GetC_Invoice_ID(), Convert.ToDateTime(_invoice.GetDateInvoiced()), null, _invoice.GetDocumentNo());
_created++;
}
_invoice = null;
_ship = null;
_line = 0;
}
protected override string DoIt()
{
ds = new DataSet();
ds = DB.ExecuteDataset("SELECT C_Recurring_ID From C_Recurring Where IsActive='Y' AND AD_Client_ID=" + GetAD_Client_ID()
+ " AND TRUNC(DateNextRun)=" + GlobalVariable.TO_DATE(DateTime.Now, true));
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
for (Int32 i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Recurring = new MRecurring(GetCtx(), Util.GetValueOfInt(ds.Tables[0].Rows[i]["C_Recurring_ID"]), Get_Trx());
dateDoc = Recurring.GetDateNextRun();
if (dateDoc != null && Recurring.CalculateRuns())
{
// throw new Exception("No Runs Left");
MRecurringRun run = new MRecurringRun(GetCtx(), Recurring);
String msg = "@Created@ ";
// if (Recurring.GetDateNextRun() == DateTime.Now.Date || Recurring.GetDateNextRun() == null)
//{
// Copy
if (Recurring.GetRecurringType().Equals(MRecurring.RECURRINGTYPE_Order))
{
MOrder from = new MOrder(GetCtx(), Recurring.GetC_Order_ID(), Get_TrxName());
MOrder order = MOrder.CopyFrom(from, dateDoc,
from.GetC_DocType_ID(), false, false, Get_TrxName());
run.SetC_Order_ID(order.GetC_Order_ID());
msg += order.GetDocumentNo();
}
else if (Recurring.GetRecurringType().Equals(MRecurring.RECURRINGTYPE_Invoice))
{
MInvoice from = new MInvoice(GetCtx(), Recurring.GetC_Invoice_ID(), Get_TrxName());
MInvoice invoice = MInvoice.CopyFrom(from, dateDoc,
from.GetC_DocType_ID(), false, Get_TrxName(), false);
run.SetC_Invoice_ID(invoice.GetC_Invoice_ID());
msg += invoice.GetDocumentNo();
}
else if (Recurring.GetRecurringType().Equals(MRecurring.RECURRINGTYPE_Project))
{
MProject project = MProject.CopyFrom(GetCtx(), Recurring.GetC_Project_ID(), dateDoc, Get_TrxName());
run.SetC_Project_ID(project.GetC_Project_ID());
msg += project.GetValue();
}
else if (Recurring.GetRecurringType().Equals(MRecurring.RECURRINGTYPE_GLJournalBatch))
{
MJournalBatch journal = MJournalBatch.CopyFrom(GetCtx(), Recurring.GetGL_JournalBatch_ID(), dateDoc, Get_TrxName());
run.SetGL_JournalBatch_ID(journal.GetGL_JournalBatch_ID());
msg += journal.GetDocumentNo();
}
else if (Recurring.GetRecurringType().Equals(MRecurring.RECURRINGTYPE_GLJournal))
{
MJournal Journal = MJournal.CopyFrom(GetCtx(), Recurring.GetGL_Journal_ID(), dateDoc, Get_TrxName());
run.SetGL_Journal_ID(Journal.GetGL_Journal_ID());
msg += Journal.GetDocumentNo();
}
else if (Recurring.GetRecurringType().Equals(MRecurring.RECURRINGTYPE_Payment))
{
MPayment from = new MPayment(GetCtx(), Recurring.GetC_Payment_ID(), Get_TrxName());
MPayment payment = MPayment.CopyFrom(from, dateDoc,
from.GetC_DocType_ID(), Get_TrxName());
run.SetC_Payment_ID(payment.GetC_Payment_ID());
msg += payment.GetDocumentNo();
}
//else
// return "Invalid @RecurringType@ = " + Recurring.GetRecurringType();
if (run.Save(Get_TrxName()))
{
Recurring.SetDateLastRun(run.GetUpdated());
Recurring.SetRunsRemaining(Recurring.GetRunsRemaining() - 1);
SetDateNextRun();
Recurring.Save(Get_TrxName());
}
// }
}
}
}
DisposeVariables();
return("");
// throw new NotImplementedException();
}
/// <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>
/// Perform Process.
/// </summary>
/// <returns>Message (variables are parsed)</returns>
protected override String DoIt()
{
log.Info("doIt - C_CommissionRun_ID=" + GetRecord_ID());
// Load Data
MCommissionRun comRun = new MCommissionRun(GetCtx(), GetRecord_ID(), Get_Trx());
if (comRun.Get_ID() == 0)
{
throw new ArgumentException("CommissionAPInvoice - No Commission Run");
}
if (Env.ZERO.CompareTo(comRun.GetGrandTotal()) == 0)
{
throw new ArgumentException("@GrandTotal@ = 0");
}
MCommission com = new MCommission(GetCtx(), comRun.GetC_Commission_ID(), Get_Trx());
if (com.Get_ID() == 0)
{
throw new ArgumentException("CommissionAPInvoice - No Commission");
}
if (com.GetC_Charge_ID() == 0)
{
throw new ArgumentException("CommissionAPInvoice - No Charge on Commission");
}
MBPartner bp = new MBPartner(GetCtx(), com.GetC_BPartner_ID(), Get_Trx());
if (bp.Get_ID() == 0)
{
throw new ArgumentException("CommissionAPInvoice - No BPartner");
}
// Create Invoice
MInvoice invoice = new MInvoice(GetCtx(), 0, null);
invoice.SetClientOrg(com.GetAD_Client_ID(), com.GetAD_Org_ID());
invoice.SetC_DocTypeTarget_ID(MDocBaseType.DOCBASETYPE_APINVOICE); // API
invoice.SetBPartner(bp);
// invoice.setDocumentNo (comRun.getDocumentNo()); // may cause unique constraint
invoice.SetSalesRep_ID(GetAD_User_ID()); // caller
//
if (com.GetC_Currency_ID() != invoice.GetC_Currency_ID())
{
throw new ArgumentException("CommissionAPInvoice - Currency of PO Price List not Commission Currency");
}
//
if (!invoice.Save())
{
throw new Exception("CommissionAPInvoice - cannot save Invoice");
}
// Create Invoice Line
MInvoiceLine iLine = new MInvoiceLine(invoice);
iLine.SetC_Charge_ID(com.GetC_Charge_ID());
iLine.SetQty(1);
iLine.SetPrice(comRun.GetGrandTotal());
iLine.SetTax();
if (!iLine.Save())
{
throw new Exception("CommissionAPInvoice - cannot save Invoice Line");
}
//
return("@C_Invoice_ID@ = " + invoice.GetDocumentNo());
}
/// <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"));
}
}
/**
* Complete Document
* @return new status (Complete, In Progress, Invalid, Waiting ..)
*/
public String CompleteIt()
{
// Re-Check
if (!_justPrepared)
{
String status = PrepareIt();
if (!DocActionVariables.STATUS_INPROGRESS.Equals(status))
{
return(status);
}
}
// Implicit Approval
if (!IsApproved())
{
ApproveIt();
}
log.Info(ToString());
//
MInOut inout = new MInOut(GetCtx(), GetM_InOut_ID(), Get_TrxName());
MInOutLineConfirm[] lines = GetLines(false);
/* created by sunil 19/9/2016*/
if (Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(*) FROM AD_ModuleInfo WHERE Prefix = 'DTD001_'")) > 0)
{
MPackage package = new MPackage(GetCtx(), inout.GetM_Package_ID(), Get_Trx());
if (inout.GetM_Package_ID() > 0 && !package.IsDTD001_IsPackgConfirm())
{
_processMsg = Msg.GetMsg(GetCtx(), "PleaseConfirmPackage");
return(DocActionVariables.STATUS_INVALID);
}
}
//End
// Check if we need to split Shipment
if (IsInDispute())
{
MDocType dt = MDocType.Get(GetCtx(), inout.GetC_DocType_ID());
if (dt.IsSplitWhenDifference())
{
if (dt.GetC_DocTypeDifference_ID() == 0)
{
_processMsg = "No Split Document Type defined for: " + dt.GetName();
return(DocActionVariables.STATUS_INVALID);
}
SplitInOut(inout, dt.GetC_DocTypeDifference_ID(), lines);
_lines = null;
}
}
// All lines
for (int i = 0; i < lines.Length; i++)
{
MInOutLineConfirm confirmLine = lines[i];
confirmLine.Set_TrxName(Get_TrxName());
if (!confirmLine.ProcessLine(inout.IsSOTrx(), GetConfirmType()))
{
_processMsg = "ShipLine not saved - " + confirmLine;
return(DocActionVariables.STATUS_INVALID);
}
if (confirmLine.IsFullyConfirmed())
{
confirmLine.SetProcessed(true);
confirmLine.Save(Get_TrxName());
}
else
{
if (CreateDifferenceDoc(inout, confirmLine))
{
confirmLine.SetProcessed(true);
confirmLine.Save(Get_TrxName());
}
else
{
log.Log(Level.SEVERE, "Scrapped=" + confirmLine.GetScrappedQty()
+ " - Difference=" + confirmLine.GetDifferenceQty());
return(DocActionVariables.STATUS_INVALID);
}
}
} // for all lines
if (_creditMemo != null)
{
_processMsg += " @C_Invoice_ID@=" + _creditMemo.GetDocumentNo();
}
if (_inventory != null)
{
// _processMsg += " @M_Inventory_ID@=" + _inventory.GetDocumentNo();
//new 13 jan
_processMsg += " Internal.Inventory= " + _inventory.GetDocumentNo();
}
// User Validation
String valid = ModelValidationEngine.Get().FireDocValidate(this,
ModalValidatorVariables.DOCTIMING_AFTER_COMPLETE);
if (valid != null)
{
_processMsg = valid;
return(DocActionVariables.STATUS_INVALID);
}
SetProcessed(true);
if (!Save(Get_Trx()))
{
Get_Trx().Rollback();
_processMsg = "Ship/Receipt Confirmation Not saved";
return(DocActionVariables.STATUS_INVALID);
}
// Created By Sunil 17/9/2016
// Complete Shipment
MInOut io = new MInOut(GetCtx(), GetM_InOut_ID(), Get_TrxName());
var Status = io.CompleteIt();
if (Status == "CO")
{
io.SetProcessed(true);
io.SetDocStatus(DocActionVariables.STATUS_COMPLETED);
io.SetDocAction(DocActionVariables.ACTION_CLOSE);
io.Save();
}
else if (Status == "IN")
{
Get_Trx().Rollback();
_processMsg = "Shipment Not Completed";
return(DocActionVariables.STATUS_INVALID);
}
//end
//SetProcessed(true);
SetDocAction(DOCACTION_Close);
return(DocActionVariables.STATUS_COMPLETED);
}
