} // afterSave
/// <summary>
/// This function is used to set Values on Recognition Plan
/// </summary>
/// <param name="invoiceLine">invoice line object </param>
/// <param name="invoice">invoice object</param>
/// <param name="C_RevenueRecognition_ID">Recognition ID</param>
/// <param name="ToCurrency">Currency</param>
public void SetRecognitionPlan(MInvoiceLine invoiceLine, MInvoice invoice, int C_RevenueRecognition_ID, int ToCurrency)
{
SetAD_Client_ID(invoice.GetAD_Client_ID());
SetAD_Org_ID(invoice.GetAD_Org_ID());
SetC_Currency_ID(ToCurrency);
SetC_InvoiceLine_ID(invoiceLine.GetC_InvoiceLine_ID());
SetC_RevenueRecognition_ID(C_RevenueRecognition_ID);
// when tax include into price list, then reduce tax from Line Net Amount
bool isTaxIncide = (new MPriceList(invoice.GetCtx(), invoice.GetM_PriceList_ID(), invoice.Get_Trx())).IsTaxIncluded();
Decimal Amount = invoiceLine.GetLineNetAmt() - (isTaxIncide ? (invoiceLine.GetTaxAmt() + invoiceLine.GetSurchargeAmt()) : 0);
if (invoice.GetC_Currency_ID() != ToCurrency)
{
Amount = MConversionRate.Convert(GetCtx(), Amount, invoice.GetC_Currency_ID(), ToCurrency, invoice.GetDateInvoiced(), invoice.GetC_ConversionType_ID(), invoice.GetAD_Client_ID(), invoice.GetAD_Org_ID());
}
SetTotalAmt(Amount);
SetRecognizedAmt(Env.ZERO);
}
/**
* 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);
}
} // 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
/// <summary>
/// This function is used to create Recognition plan and run
/// </summary>
/// <param name="C_InvoiceLine_ID">invoice line</param>
/// <param name="C_RevenueRecognition_ID">Revenue Recognition</param>
/// <param name="Invoice">Invoice</param>
/// <returns>true, when success</returns>
public static bool CreateRevenueRecognitionPlan(int C_InvoiceLine_ID, int C_RevenueRecognition_ID, MInvoice Invoice)
{
try
{
MRevenueRecognitionRun revenueRecognitionRun = null;
DateTime? RecognizationDate = null;
int NoofMonths = 0;
MRevenueRecognition revenueRecognition = new MRevenueRecognition(Invoice.GetCtx(), C_RevenueRecognition_ID, Invoice.Get_Trx());
int defaultAccSchemaOrg_ID = GetDefaultActSchema(Invoice.GetCtx(), Invoice.GetAD_Client_ID(), Invoice.GetAD_Org_ID());
int ToCurrency = Util.GetValueOfInt(DB.ExecuteScalar("SELECT C_Currency_ID FROM C_AcctSchema WHERE C_AcctSchema_ID=" + defaultAccSchemaOrg_ID));
MInvoiceLine invoiceLine = new MInvoiceLine(Invoice.GetCtx(), C_InvoiceLine_ID, Invoice.Get_Trx());
//if recoganization date is null recognition plan and run cant be generated
if (invoiceLine.Get_Value("RevenueStartDate") == null)
{
_log.Log(Level.SEVERE, "DateIsInvlidOrNull");
return(false);
}
RecognizationDate = Util.GetValueOfDateTime(invoiceLine.Get_Value("RevenueStartDate"));
// precision to be handle based on std precision defined on acct schema
string sql = "SELECT C.StdPrecision FROM C_AcctSchema a INNER JOIN C_Currency c ON c.C_Currency_ID= a.C_Currency_ID WHERE a.C_AcctSchema_ID=" + defaultAccSchemaOrg_ID;
int stdPrecision = Util.GetValueOfInt(DB.ExecuteScalar(sql, null, null));
if (revenueRecognition.GetRecognitionFrequency().Equals(RECOGNITIONFREQUENCY_Month) && RecognizationDate.Value.Day != 1 && revenueRecognition.GetNoMonths() > 0)
{
//if startdate is in between day of month
NoofMonths = revenueRecognition.GetNoMonths() + 1;
}
else
{
//if start date is the first day of the month
NoofMonths = revenueRecognition.GetNoMonths();
}
MRevenueRecognitionPlan revenueRecognitionPlan = new MRevenueRecognitionPlan(Invoice.GetCtx(), 0, Invoice.Get_Trx());
revenueRecognitionPlan.SetRecognitionPlan(invoiceLine, Invoice, C_RevenueRecognition_ID, ToCurrency);
revenueRecognitionPlan.SetC_AcctSchema_ID(defaultAccSchemaOrg_ID);
revenueRecognitionPlan.SetRecognizedAmt(0);
if (!revenueRecognitionPlan.Save())
{
ValueNamePair pp = VLogger.RetrieveError();
string error = pp != null?pp.GetValue() : "";
if (pp != null && string.IsNullOrEmpty(error))
{
error = pp.GetName();
}
if (!string.IsNullOrEmpty(error))
{
_log.Log(Level.SEVERE, error);
return(false);
}
}
else
{
if (!revenueRecognition.IsTimeBased())
{
}
else
{
if (revenueRecognition.GetRecognitionFrequency().Equals(RECOGNITIONFREQUENCY_Month))
{
decimal totaldays = Util.GetValueOfDecimal((RecognizationDate.Value.AddMonths(revenueRecognition.GetNoMonths()) - RecognizationDate.Value.Date).TotalDays);
decimal perdayAmt = Math.Round(revenueRecognitionPlan.GetTotalAmt() / (totaldays > 0?totaldays:1), 12);
decimal recognizedAmt = 0;
DateTime?lastdate = null;
int days = 0;
for (int i = 0; i < NoofMonths; i++)
{
if (i == 0)
{
if (RecognizationDate.Value.Month == 12)
{
//last date of the month
lastdate = new DateTime(RecognizationDate.Value.Year, RecognizationDate.Value.Month, 1).AddMonths(1).AddDays(-1);
}
else
{
//last date of the month
lastdate = new DateTime(RecognizationDate.Value.Year, RecognizationDate.Value.Month + 1, 1).AddDays(-1);
}
days = Util.GetValueOfInt((lastdate.Value.Date - RecognizationDate.Value.Date).TotalDays);
days += 1;
}
else if (i == (revenueRecognition.GetNoMonths()))
{
//last date of the month would the day before the recoganizationdate
lastdate = RecognizationDate.Value.AddMonths(i).AddDays(-1);
DateTime startDate = new DateTime(lastdate.Value.Year, lastdate.Value.Month, 1);
days = Util.GetValueOfInt((lastdate.Value.Date - startDate.Date).TotalDays);
days += 1;
}
else
{
DateTime startDate = lastdate.Value.AddDays(1);
days = DateTime.DaysInMonth(startDate.Year, startDate.Month);
lastdate = startDate.AddDays(days - 1);
}
recognizedAmt = Math.Round(days * perdayAmt, stdPrecision);
revenueRecognitionRun = new MRevenueRecognitionRun(Invoice.GetCtx(), 0, Invoice.Get_Trx());
revenueRecognitionRun.SetRecognitionRun(revenueRecognitionPlan);
revenueRecognitionRun.SetRecognizedAmt(recognizedAmt);
revenueRecognitionRun.SetRecognitionDate(lastdate);
if (!revenueRecognitionRun.Save())
{
ValueNamePair pp = VLogger.RetrieveError();
string error = pp != null?pp.GetValue() : "";
if (pp != null && string.IsNullOrEmpty(error))
{
error = pp.GetName();
}
if (!string.IsNullOrEmpty(error))
{
_log.Log(Level.SEVERE, error);
return(false);
}
}
recognizedAmt = 0;
}
}
else if (revenueRecognition.GetRecognitionFrequency().Equals(RECOGNITIONFREQUENCY_Day))
{
Decimal recognizedAmt = Math.Round(revenueRecognitionPlan.GetTotalAmt() / revenueRecognition.GetNoMonths(), stdPrecision);
int days = 0;
for (int i = 0; i < revenueRecognition.GetNoMonths(); i++)
{
revenueRecognitionRun = new MRevenueRecognitionRun(Invoice.GetCtx(), 0, Invoice.Get_Trx());
revenueRecognitionRun.SetRecognitionRun(revenueRecognitionPlan);
revenueRecognitionRun.SetRecognizedAmt(recognizedAmt);
revenueRecognitionRun.SetRecognitionDate(RecognizationDate.Value.AddDays(days));
days += 1;
if (!revenueRecognitionRun.Save())
{
ValueNamePair pp = VLogger.RetrieveError();
string error = pp != null?pp.GetValue() : "";
if (pp != null && string.IsNullOrEmpty(error))
{
error = pp.GetName();
}
if (!string.IsNullOrEmpty(error))
{
_log.Log(Level.SEVERE, error);
return(false);
}
}
}
}
else if (revenueRecognition.GetRecognitionFrequency().Equals(RECOGNITIONFREQUENCY_Year))
{
DateTime?fstartDate = null;
DateTime?fendDate = null;
int calendar_ID = 0;
DataSet ds = new DataSet();
calendar_ID = Util.GetValueOfInt(DB.ExecuteScalar("SELECT C_Calendar_ID FROM AD_OrgInfo WHERE ad_org_id = " + Invoice.GetAD_Org_ID()));
if (calendar_ID == 0)
{
calendar_ID = Util.GetValueOfInt(DB.ExecuteScalar("SELECT C_Calendar_ID FROM AD_ClientInfo WHERE ad_client_id = " + Invoice.GetAD_Client_ID()));
}
sql = "SELECT startdate , enddate FROM c_period WHERE " +
"c_year_id = (SELECT c_year.c_year_id FROM c_year INNER JOIN C_period ON c_year.c_year_id = C_period.c_year_id " +
"WHERE c_year.c_calendar_id =" + calendar_ID + " AND " + GlobalVariable.TO_DATE(RecognizationDate, true) + " BETWEEN C_period.startdate AND C_period.enddate) AND periodno IN (1, 12)";
ds = DB.ExecuteDataset(sql);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
fstartDate = Convert.ToDateTime(ds.Tables[0].Rows[0]["startdate"]);
fendDate = Convert.ToDateTime(ds.Tables[0].Rows[1]["enddate"]);
}
if (fstartDate != RecognizationDate)
{
//RecognizationDate is not same as financial year's start date
NoofMonths += 1;
}
decimal totaldays = Util.GetValueOfDecimal((RecognizationDate.Value.AddYears(revenueRecognition.GetNoMonths()) - RecognizationDate.Value.Date).TotalDays);
decimal perdayAmt = Math.Round(revenueRecognitionPlan.GetTotalAmt() / (totaldays > 0?totaldays:1), 12);
decimal recognizedAmt = 0;
DateTime?lastdate = null;
int days = 0;
for (int i = 0; i < NoofMonths; i++)
{
if (i == 0)
{
//last date will always be financial year's end date
lastdate = fendDate;
days = Util.GetValueOfInt((lastdate.Value.Date - RecognizationDate.Value.Date).TotalDays);
days += 1;
}
else if (i == revenueRecognition.GetNoMonths())
{
//last date of the year would the day before the recoganizationdate
lastdate = RecognizationDate.Value.AddYears(i).AddDays(-1);
DateTime startDate = fstartDate.Value.AddYears(i);
days = Util.GetValueOfInt((lastdate.Value.Date - startDate.Date).TotalDays);
days += 1;
}
else
{
lastdate = fendDate.Value.AddYears(i);
DateTime _startDate = fstartDate.Value.AddYears(i);
days = Util.GetValueOfInt((lastdate.Value.Date - _startDate.Date).TotalDays);
days += 1;
}
recognizedAmt = Math.Round(days * perdayAmt, stdPrecision);
revenueRecognitionRun = new MRevenueRecognitionRun(Invoice.GetCtx(), 0, Invoice.Get_Trx());
revenueRecognitionRun.SetRecognitionRun(revenueRecognitionPlan);
revenueRecognitionRun.SetRecognizedAmt(recognizedAmt);
revenueRecognitionRun.SetRecognitionDate(lastdate);
if (!revenueRecognitionRun.Save())
{
ValueNamePair pp = VLogger.RetrieveError();
string error = pp != null?pp.GetValue() : "";
if (pp != null && string.IsNullOrEmpty(error))
{
error = pp.GetName();
}
if (!string.IsNullOrEmpty(error))
{
_log.Log(Level.SEVERE, error);
return(false);
}
}
recognizedAmt = 0;
}
}
}
}
}
catch (Exception ex)
{
_log.Severe("Exception during creation of Recognition Plan and Run. " + ex.Message);
return(false);
}
return(true);
}
public static string CreateRevenueRecognitionPlan(int C_InvoiceLine_ID, int C_RevenueRecognition_ID, MInvoice Invoice)
{
try
{
MRevenueRecognitionRun revenueRecognitionRun = null;
DateTime? RecognizationDate = null;
MRevenueRecognition revenueRecognition = new MRevenueRecognition(Invoice.GetCtx(), C_RevenueRecognition_ID, Invoice.Get_Trx());
int defaultAccSchemaOrg_ID = GetDefaultActSchema(Invoice.GetAD_Org_ID());
if (defaultAccSchemaOrg_ID <= 0)
{
_log.Log(Level.SEVERE, "Default Schema not found for the oraganization");
return("Default Schema not found for the oraganization");
}
MINT15AccountingSchemaOrg accountingSchemaOrg = new MINT15AccountingSchemaOrg(Invoice.GetCtx(), defaultAccSchemaOrg_ID, Invoice.Get_Trx());
MRevenueRecognitionPlan revenueRecognitionPlan = new MRevenueRecognitionPlan(Invoice.GetCtx(), 0, Invoice.Get_Trx());
MInvoiceLine invoiceLine = new MInvoiceLine(Invoice.GetCtx(), C_InvoiceLine_ID, Invoice.Get_Trx());
MInvoice invoice = new MInvoice(Invoice.GetCtx(), invoiceLine.GetC_Invoice_ID(), Invoice.Get_Trx());
string sql = "Select INT15_StartDate From C_InvoiceLine Where C_InvoiceLine_ID=" + invoiceLine.GetC_InvoiceLine_ID();
RecognizationDate = Util.GetValueOfDateTime(DB.ExecuteScalar(sql));
if (RecognizationDate == null)
{
RecognizationDate = invoice.GetDateInvoiced();
}
revenueRecognitionPlan.SetRecognitionPlan(invoiceLine, invoice, C_RevenueRecognition_ID);
revenueRecognitionPlan.SetC_AcctSchema_ID(accountingSchemaOrg.GetC_AcctSchema_ID());
revenueRecognitionPlan.SetRecognizedAmt(0);
if (revenueRecognition.GetINT15_RecognizeType() == "R")
{
revenueRecognitionPlan.SetUnEarnedRevenue_Acct(RecognitionCombination(accountingSchemaOrg, "UR", invoiceLine));
revenueRecognitionPlan.SetP_Revenue_Acct(RecognitionCombination(accountingSchemaOrg, "TR", invoiceLine));
}
else
{
revenueRecognitionPlan.SetINT15_PrepaidExpense(RecognitionCombination(accountingSchemaOrg, "DE", invoiceLine));
revenueRecognitionPlan.SetINT15_ProductExpense(RecognitionCombination(accountingSchemaOrg, "PE", invoiceLine));
}
revenueRecognitionPlan.Save();
if (!revenueRecognition.IsTimeBased())
{
MINT15RevenueService[] revenueService = GetServices(revenueRecognition);
for (int i = 0; i < revenueService.Length; i++)
{
MINT15RevenueService revenueserviceline = revenueService[i];
revenueRecognitionRun = new MRevenueRecognitionRun(Invoice.GetCtx(), 0, Invoice.Get_Trx());
revenueRecognitionRun.SetRecognitionRun(revenueRecognition, revenueserviceline, revenueRecognitionPlan);
Decimal recognizedAmt = (revenueRecognitionPlan.GetTotalAmt() * revenueserviceline.GetINT15_Percentage()) / 100;
revenueRecognitionRun.SetRecognizedAmt(recognizedAmt);
revenueRecognitionRun.SetINT15_RevenueService_ID(revenueserviceline.GetINT15_RevenueService_ID());
revenueRecognitionRun.Save();
}
}
else
{
if (revenueRecognition.GetRecognitionFrequency() == "M")
{
//Decimal recognizedAmt = revenueRecognitionPlan.GetTotalAmt() / revenueRecognition.GetNoMonths();
double totaldays = (RecognizationDate.Value.AddMonths(revenueRecognition.GetNoMonths()) - RecognizationDate.Value.Date).TotalDays;
decimal perdayAmt = revenueRecognitionPlan.GetTotalAmt() / Convert.ToDecimal(totaldays);
decimal recognizedAmt = 0;
DateTime?lastdate = null;
int days = 0;
for (int i = 0; i < revenueRecognition.GetNoMonths() + 1; i++)
{
if (i == 0)
{
if (RecognizationDate.Value.Month == 12)
{
lastdate = new DateTime(RecognizationDate.Value.Year, RecognizationDate.Value.Month, 1).AddMonths(1).AddDays(-1);
}
else
{
lastdate = new DateTime(RecognizationDate.Value.Year, RecognizationDate.Value.Month + 1, 1).AddDays(-1);
}
days = Util.GetValueOfInt((lastdate.Value.Date - RecognizationDate.Value.Date).TotalDays);
days += 1;
}
else if (i == (revenueRecognition.GetNoMonths()))
{
DateTime EndDate = RecognizationDate.Value.AddMonths(i);
var startDate = new DateTime(EndDate.Year, EndDate.Month, 1);
days = Util.GetValueOfInt((EndDate.Date - startDate.Date).TotalDays);
}
else
{
DateTime startdate = RecognizationDate.Value.AddMonths(i);
days = DateTime.DaysInMonth(startdate.Year, startdate.Month);
}
recognizedAmt = Convert.ToDecimal(days) * perdayAmt;
revenueRecognitionRun = new MRevenueRecognitionRun(Invoice.GetCtx(), 0, Invoice.Get_Trx());
revenueRecognitionRun.SetRecognitionRun(revenueRecognition, null, revenueRecognitionPlan);
revenueRecognitionRun.SetRecognizedAmt(recognizedAmt);
revenueRecognitionRun.SetINT15_RecognitionDate(RecognizationDate.Value.AddMonths(i));
revenueRecognitionRun.Save();
recognizedAmt = 0;
}
}
else if (revenueRecognition.GetRecognitionFrequency() == "D")
{
Decimal recognizedAmt = revenueRecognitionPlan.GetTotalAmt() / revenueRecognition.GetNoMonths();
int days = 0;
for (int i = 0; i < revenueRecognition.GetNoMonths(); i++)
{
revenueRecognitionRun = new MRevenueRecognitionRun(Invoice.GetCtx(), 0, Invoice.Get_Trx());
revenueRecognitionRun.SetRecognitionRun(revenueRecognition, null, revenueRecognitionPlan);
revenueRecognitionRun.SetRecognizedAmt(recognizedAmt);
revenueRecognitionRun.SetINT15_RecognitionDate(RecognizationDate.Value.AddDays(days));
days += 1;
revenueRecognitionRun.Save();
}
}
}
}
catch (Exception ex)
{
return(ex.ToString());
}
return("Revenue Recognition Created");
}
