/**
* Get Payment Schedule
* @param requery if true re-query
* @return array of schedule
*/
public MPaySchedule[] GetSchedule(bool requery)
{
if (_schedule != null && !requery)
{
return(_schedule);
}
String sql = "SELECT * FROM C_PaySchedule WHERE C_PaymentTerm_ID=" + GetC_PaymentTerm_ID() + " ORDER BY NetDays";
List <MPaySchedule> list = new List <MPaySchedule>();
try
{
DataSet ds = DataBase.DB.ExecuteDataset(sql, null, Get_TrxName());
if (ds.Tables.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
MPaySchedule ps = new MPaySchedule(GetCtx(), dr, Get_TrxName());
ps.SetParent(this);
list.Add(ps);
}
}
}
catch (Exception e)
{
log.Log(Level.SEVERE, "GetSchedule", e);
}
_schedule = new MPaySchedule[list.Count];
_schedule = list.ToArray();
return(_schedule);
}
/**
* Parent Constructor
* @param invoice invoice
* @param paySchedule payment schedule
*/
public MInvoicePaySchedule(MInvoice invoice, MPaySchedule paySchedule)
: base(invoice.GetCtx(), 0, invoice.Get_TrxName())
{
_parent = invoice;
SetClientOrg(invoice);
SetC_Invoice_ID(invoice.GetC_Invoice_ID());
SetC_PaySchedule_ID(paySchedule.GetC_PaySchedule_ID());
// Amounts
int scale = MCurrency.GetStdPrecision(GetCtx(), invoice.GetC_Currency_ID());
// distribute schedule based on GrandTotalAfterWithholding which is (GrandTotal – WithholdingAmount)
Decimal due = (invoice.Get_ColumnIndex("GrandTotalAfterWithholding") > 0 &&
invoice.GetGrandTotalAfterWithholding() != 0 ? invoice.GetGrandTotalAfterWithholding() : invoice.GetGrandTotal());
if (due.CompareTo(Env.ZERO) == 0)
{
SetDueAmt(Env.ZERO);
SetDiscountAmt(Env.ZERO);
SetIsValid(false);
}
else
{
//due = due.multiply(paySchedule.getPercentage()).divide(HUNDRED, scale, Decimal.ROUND_HALF_UP);
due = Decimal.Multiply(due, Decimal.Divide(paySchedule.GetPercentage(),
Decimal.Round(HUNDRED, scale, MidpointRounding.AwayFromZero)));
SetDueAmt(due);
Decimal discount = Decimal.Multiply(due, Decimal.Divide(paySchedule.GetDiscount(),
Decimal.Round(HUNDRED, scale, MidpointRounding.AwayFromZero)));
SetDiscountAmt(discount);
SetIsValid(true);
}
/** Adhoc Payment - Setting DueDate for an InvoicePaySchedule ** Dt: 18/01/2021 ** Modified By: Kumar **/
// Dates
DateTime?dueDate = (invoice.Get_ColumnIndex("DueDate") >= 0 && invoice.GetDueDate() >= invoice.GetDateInvoiced()) ? invoice.GetDueDate() : TimeUtil.AddDays(invoice.GetDateInvoiced(), paySchedule.GetNetDays());
SetDueDate(dueDate);
DateTime discountDate = TimeUtil.AddDays(invoice.GetDateInvoiced(), paySchedule.GetDiscountDays());
SetDiscountDate(discountDate);
}
/**
* Parent Constructor
* @param invoice invoice
* @param paySchedule payment schedule
*/
public MInvoicePaySchedule(MInvoice invoice, MPaySchedule paySchedule)
: base(invoice.GetCtx(), 0, invoice.Get_TrxName())
{
_parent = invoice;
SetClientOrg(invoice);
SetC_Invoice_ID(invoice.GetC_Invoice_ID());
SetC_PaySchedule_ID(paySchedule.GetC_PaySchedule_ID());
// Amounts
int scale = MCurrency.GetStdPrecision(GetCtx(), invoice.GetC_Currency_ID());
Decimal due = invoice.GetGrandTotal();
if (due.CompareTo(Env.ZERO) == 0)
{
SetDueAmt(Env.ZERO);
SetDiscountAmt(Env.ZERO);
SetIsValid(false);
}
else
{
//due = due.multiply(paySchedule.getPercentage()).divide(HUNDRED, scale, Decimal.ROUND_HALF_UP);
due = Decimal.Multiply(due, Decimal.Divide(paySchedule.GetPercentage(),
Decimal.Round(HUNDRED, scale, MidpointRounding.AwayFromZero)));
SetDueAmt(due);
Decimal discount = Decimal.Multiply(due, Decimal.Divide(paySchedule.GetDiscount(),
Decimal.Round(HUNDRED, scale, MidpointRounding.AwayFromZero)));
SetDiscountAmt(discount);
SetIsValid(true);
}
// Dates
DateTime dueDate = TimeUtil.AddDays(invoice.GetDateInvoiced(), paySchedule.GetNetDays());
SetDueDate(dueDate);
DateTime discountDate = TimeUtil.AddDays(invoice.GetDateInvoiced(), paySchedule.GetDiscountDays());
SetDiscountDate(discountDate);
}