/**
* Set Invoice Line.
* Does not set Quantity!
* @param iLine invoice line
* @param M_Locator_ID locator
* @param Qty qty only fo find suitable locator
*/
public void SetInvoiceLine(MInvoiceLine iLine, int M_Locator_ID, Decimal Qty)
{
SetC_OrderLine_ID(iLine.GetC_OrderLine_ID());
SetLine(iLine.GetLine());
SetC_UOM_ID(iLine.GetC_UOM_ID());
int M_Product_ID = iLine.GetM_Product_ID();
if (M_Product_ID == 0)
{
Set_ValueNoCheck("M_Product_ID", null);
Set_ValueNoCheck("M_Locator_ID", null);
Set_ValueNoCheck("M_AttributeSetInstance_ID", null);
}
else
{
SetM_Product_ID(M_Product_ID);
SetM_AttributeSetInstance_ID(iLine.GetM_AttributeSetInstance_ID());
if (M_Locator_ID == 0)
{
SetM_Locator_ID(Qty); // requires warehouse, product, asi
}
else
{
SetM_Locator_ID(M_Locator_ID);
}
}
SetC_Charge_ID(iLine.GetC_Charge_ID());
SetDescription(iLine.GetDescription());
SetIsDescription(iLine.IsDescription());
//
SetC_Project_ID(iLine.GetC_Project_ID());
SetC_ProjectPhase_ID(iLine.GetC_ProjectPhase_ID());
SetC_ProjectTask_ID(iLine.GetC_ProjectTask_ID());
SetC_Activity_ID(iLine.GetC_Activity_ID());
SetC_Campaign_ID(iLine.GetC_Campaign_ID());
SetAD_OrgTrx_ID(iLine.GetAD_OrgTrx_ID());
SetUser1_ID(iLine.GetUser1_ID());
SetUser2_ID(iLine.GetUser2_ID());
}
/// <summary>
/// Create Gl Journal Line
/// </summary>
/// <param name="Journal">GL Journal</param>
/// <param name="Invoice">Invoice</param>
/// <param name="InvoiceLine">Invoice Line</param>
/// <param name="RevenueRecognitionPlan">Revenue Recognition Plan</param>
/// <param name="TotalAmt">Sum of RecognizeAmt</param>
/// <param name="RecognitionType">Recognition Type</param>
/// <param name="k">loop variable</param>
/// <returns>>Journal line object</returns>
public MJournalLine GenerateJounalLine(MJournal Journal, MInvoice Invoice, MInvoiceLine InvoiceLine,
MRevenueRecognitionPlan RevenueRecognitionPlan, Decimal TotalAmt, string RecognitionType, int k)
{
int combination_ID = 0;
if (k == 0)
{
combination_ID = RevenueRun.GetCombinationID(InvoiceLine.GetM_Product_ID(), InvoiceLine.GetC_Charge_ID(), journal.GetC_AcctSchema_ID(), Invoice.IsSOTrx(), Invoice.IsReturnTrx(), totalAmt, RevenueRecognitionPlan.GetC_RevenueRecognition_ID());
journalLine.SetLine(lineno);
if (RecognitionType.Equals("E") && TotalAmt > 0)
{
journalLine.SetAmtAcctDr(TotalAmt);
journalLine.SetAmtSourceDr(TotalAmt);
journalLine.SetAmtSourceCr(0);
journalLine.SetAmtAcctCr(0);
}
else if (RecognitionType.Equals("E") && TotalAmt < 0)
{
journalLine.SetAmtAcctCr(Decimal.Negate(TotalAmt));
journalLine.SetAmtSourceCr(Decimal.Negate(TotalAmt));
journalLine.SetAmtSourceDr(0);
journalLine.SetAmtAcctDr(0);
}
else if (RecognitionType.Equals("R") && TotalAmt > 0)
{
journalLine.SetAmtAcctCr(TotalAmt);
journalLine.SetAmtSourceCr(TotalAmt);
journalLine.SetAmtSourceDr(0);
journalLine.SetAmtAcctDr(0);
}
else if (RecognitionType.Equals("R") && TotalAmt < 0)
{
journalLine.SetAmtAcctDr(Decimal.Negate(TotalAmt));
journalLine.SetAmtSourceDr(Decimal.Negate(TotalAmt));
journalLine.SetAmtSourceCr(0);
journalLine.SetAmtAcctCr(0);
}
int account_ID = Util.GetValueOfInt(DB.ExecuteScalar("SELECT Account_ID From C_ValidCombination Where C_ValidCombination_ID=" + combination_ID));
journalLine.Set_ValueNoCheck("Account_ID", account_ID);
journalLine.Set_ValueNoCheck("C_BPartner_ID", Invoice.GetC_BPartner_ID());
journalLine.SetAD_OrgTrx_ID(InvoiceLine.Get_ColumnIndex("AD_OrgTrx_ID") > 0 ? InvoiceLine.GetAD_OrgTrx_ID() : Invoice.GetAD_OrgTrx_ID());
journalLine.Set_ValueNoCheck("C_Project_ID", InvoiceLine.GetC_Project_ID() > 0 ? InvoiceLine.GetC_Project_ID() : Invoice.Get_Value("C_ProjectRef_ID"));
journalLine.Set_ValueNoCheck("C_Campaign_ID", InvoiceLine.Get_ColumnIndex("C_Campaign_ID") > 0 ? InvoiceLine.GetC_Campaign_ID() : Invoice.GetC_Campaign_ID());
journalLine.Set_ValueNoCheck("C_Activity_ID", InvoiceLine.Get_ColumnIndex("C_Activity_ID") > 0 ? InvoiceLine.GetC_Activity_ID() : Invoice.GetC_Activity_ID());
journalLine.Set_ValueNoCheck("M_Product_ID", InvoiceLine.GetM_Product_ID());
}
else
{
combination_ID = RevenueRun.GetCombinationID(0, 0, RevenueRecognitionPlan.GetC_AcctSchema_ID(), Invoice.IsSOTrx(), Invoice.IsReturnTrx(), totalAmt, RevenueRecognitionPlan.GetC_RevenueRecognition_ID());
int account_ID = Util.GetValueOfInt(DB.ExecuteScalar("SELECT Account_ID From C_ValidCombination Where C_ValidCombination_ID=" + combination_ID));
journalLine = RevenueRun.GetOrCreate(journal, journalLine, InvoiceLine.GetM_Product_ID(), InvoiceLine.GetC_Charge_ID(),
InvoiceLine.Get_ColumnIndex("C_Campaign_ID") > 0 ? InvoiceLine.GetC_Campaign_ID() : Invoice.GetC_Campaign_ID(),
account_ID, InvoiceLine.GetC_Project_ID() > 0 ? InvoiceLine.GetC_Project_ID() : Util.GetValueOfInt(Invoice.Get_Value("C_ProjectRef_ID")),
InvoiceLine.Get_ColumnIndex("C_Activity_ID") > 0 ? InvoiceLine.GetC_Activity_ID() : Invoice.GetC_Activity_ID(), Invoice.GetC_BPartner_ID(),
Invoice.GetAD_Org_ID(), InvoiceLine.Get_ColumnIndex("AD_OrgTrx_ID") > 0 ? InvoiceLine.GetAD_OrgTrx_ID() : Invoice.GetAD_OrgTrx_ID());
journalLine.SetLine(lineno);
if (RecognitionType.Equals("E") && TotalAmt > 0)
{
journalLine.SetAmtAcctCr(journalLine.GetAmtAcctCr() + TotalAmt);
journalLine.SetAmtSourceCr(journalLine.GetAmtSourceCr() + TotalAmt);
journalLine.SetAmtSourceDr(0);
journalLine.SetAmtAcctDr(0);
}
else if (RecognitionType.Equals("E") && TotalAmt < 0)
{
journalLine.SetAmtAcctDr(journalLine.GetAmtAcctDr() + Decimal.Negate(TotalAmt));
journalLine.SetAmtSourceDr(journalLine.GetAmtSourceDr() + Decimal.Negate(TotalAmt));
journalLine.SetAmtSourceCr(0);
journalLine.SetAmtAcctCr(0);
}
else if (RecognitionType.Equals("R") && TotalAmt > 0)
{
journalLine.SetAmtAcctDr(journalLine.GetAmtAcctDr() + TotalAmt);
journalLine.SetAmtSourceDr(journalLine.GetAmtSourceDr() + TotalAmt);
journalLine.SetAmtSourceCr(0);
journalLine.SetAmtAcctCr(0);
}
else if (RecognitionType.Equals("R") && TotalAmt < 0)
{
journalLine.SetAmtAcctCr(journalLine.GetAmtAcctCr() + Decimal.Negate(TotalAmt));
journalLine.SetAmtSourceCr(journalLine.GetAmtSourceCr() + Decimal.Negate(TotalAmt));
journalLine.SetAmtSourceDr(0);
journalLine.SetAmtAcctDr(0);
}
}
return(journalLine);
}
