/**
* 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());
}
// Create Asset From Invoice Mohit
/**
* Shipment Constructor
* @param Invoice
* @param shipLine shipment line
* @param deliveryCount 0 or number of delivery
*/
public MAsset(MInvoice invoice, MInvoiceLine invoiceline, int deliveryCount)
: this(invoiceline.GetCtx(), 0, invoiceline.Get_TrxName())
{
SetClientOrg(invoiceline);
SetValueNameDescription(invoice, invoiceline, deliveryCount);
// Header
//SetIsOwned(true);
SetC_BPartner_ID(invoice.GetC_BPartner_ID());
SetC_BPartner_Location_ID(invoice.GetC_BPartner_Location_ID());
SetAD_User_ID(invoice.GetAD_User_ID());
//SetM_Locator_ID(invoice.GetM_Locator_ID());
SetIsInPosession(true);
SetAssetServiceDate(invoice.GetDateAcct());
// Line
MProduct product = invoiceline.GetProduct();
SetM_Product_ID(product.GetM_Product_ID());
SetA_Asset_Group_ID(product.GetA_Asset_Group_ID());
//////////////////////////////*
//Changes for vafam
// SetAssetServiceDate(shipment.GetMovementDate());
//SetGuaranteeDate(TimeUtil.AddDays(shipment.GetMovementDate(), product.GetGuaranteeDays()));
MAssetGroup _assetGroup = new MAssetGroup(GetCtx(), GetA_Asset_Group_ID(), invoice.Get_TrxName());
if (_assetGroup.IsOwned())
{
SetIsOwned(true);
//SetC_BPartner_ID(0);
}
if (_assetGroup.IsDepreciated())
{
SetIsDepreciated(true);
SetIsFullyDepreciated(false);
}
////////////////////////////////////
//Change by Sukhwinder for setting Asset type and amortization template on Asset window, MANTIS ID:1762
int countVA038 = Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(AD_MODULEINFO_ID) FROM AD_MODULEINFO WHERE PREFIX='VA038_' "));
int countVAFAM = Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(AD_MODULEINFO_ID) FROM AD_MODULEINFO WHERE PREFIX='VAFAM_' "));
if (countVA038 > 0)
{
Set_Value("VA038_AmortizationTemplate_ID", Utility.Util.GetValueOfInt(_assetGroup.Get_Value("VA038_AmortizationTemplate_ID")));
}
if (countVAFAM > 0)
{
Set_Value("VAFAM_AssetType", _assetGroup.Get_Value("VAFAM_AssetType").ToString());
Set_Value("VAFAM_DepreciationType_ID", Utility.Util.GetValueOfInt(_assetGroup.Get_Value("VAFAM_DepreciationType_ID")));
}
////////////////////////////////////
// Guarantee & Version
SetGuaranteeDate(TimeUtil.AddDays(invoice.GetDateInvoiced(), product.GetGuaranteeDays()));
SetVersionNo(product.GetVersionNo());
if (invoiceline.GetM_AttributeSetInstance_ID() != 0) // Instance
{
MAttributeSetInstance asi = new MAttributeSetInstance(GetCtx(), invoiceline.GetM_AttributeSetInstance_ID(), Get_TrxName());
SetM_AttributeSetInstance_ID(asi.GetM_AttributeSetInstance_ID());
SetLot(asi.GetLot());
SetSerNo(asi.GetSerNo());
}
SetHelp(invoiceline.GetDescription());
// Qty
int units = product.GetSupportUnits();
if (units == 0)
{
units = 1;
}
if (deliveryCount != 0) // one asset per UOM
{
SetQty(invoiceline.GetQtyEntered(), units);
}
else
{
SetQty((Decimal)units);
}
SetM_InOutLine_ID(invoiceline.GetM_InOutLine_ID());
Set_Value("C_InvoiceLine_ID", invoiceline.GetC_InvoiceLine_ID());
// Activate
MAssetGroup ag = MAssetGroup.Get(GetCtx(), GetA_Asset_Group_ID());
if (!ag.IsCreateAsActive())
{
SetIsActive(false);
}
}
/// <summary>
/// Create Landed Cost accounting & Cost lines
/// </summary>
/// <param name="as1">accounting schema</param>
/// <param name="fact">fact</param>
/// <param name="line">document line</param>
/// <param name="dr">DR entry (normal api)</param>
/// <returns>true if landed costs were created</returns>
private bool LandedCost(MAcctSchema as1, Fact fact, DocLine line, bool dr)
{
int C_InvoiceLine_ID = line.Get_ID();
MLandedCostAllocation[] lcas = MLandedCostAllocation.GetOfInvoiceLine(
GetCtx(), C_InvoiceLine_ID, GetTrx());
if (lcas.Length == 0)
{
return(false);
}
// Delete Old
String sql = "DELETE FROM M_CostDetail WHERE C_InvoiceLine_ID=" + C_InvoiceLine_ID;
int no = DataBase.DB.ExecuteQuery(sql, null, GetTrx());
if (no != 0)
{
log.Config("CostDetail Deleted #" + no);
}
// Calculate Total Base
double totalBase = 0;
for (int i = 0; i < lcas.Length; i++)
{
totalBase += Convert.ToDouble(lcas[i].GetBase());//.doubleValue();
}
// Create New
MInvoiceLine il = new MInvoiceLine(GetCtx(), C_InvoiceLine_ID, GetTrx());
for (int i = 0; i < lcas.Length; i++)
{
MLandedCostAllocation lca = lcas[i];
if (Env.Signum(lca.GetBase()) == 0)
{
continue;
}
double percent = totalBase / Convert.ToDouble(lca.GetBase());
String desc = il.GetDescription();
if (desc == null)
{
desc = percent + "%";
}
else
{
desc += " - " + percent + "%";
}
if (line.GetDescription() != null)
{
desc += " - " + line.GetDescription();
}
// Accounting
ProductCost pc = new ProductCost(GetCtx(),
lca.GetM_Product_ID(), lca.GetM_AttributeSetInstance_ID(), GetTrx());
Decimal?drAmt = null;
Decimal?crAmt = null;
if (dr)
{
drAmt = lca.GetAmt();
}
else
{
crAmt = lca.GetAmt();
}
FactLine fl = fact.CreateLine(line, pc.GetAccount(ProductCost.ACCTTYPE_P_CostAdjustment, as1),
GetC_Currency_ID(), drAmt, crAmt);
fl.SetDescription(desc);
// Cost Detail - Convert to AcctCurrency
Decimal allocationAmt = lca.GetAmt();
if (GetC_Currency_ID() != as1.GetC_Currency_ID())
{
allocationAmt = MConversionRate.Convert(GetCtx(), allocationAmt,
GetC_Currency_ID(), as1.GetC_Currency_ID(),
GetDateAcct(), GetC_ConversionType_ID(),
GetAD_Client_ID(), GetAD_Org_ID());
}
if (Env.Scale(allocationAmt) > as1.GetCostingPrecision())
{
allocationAmt = Decimal.Round(allocationAmt, as1.GetCostingPrecision(), MidpointRounding.AwayFromZero);
}
if (!dr)
{
allocationAmt = Decimal.Negate(allocationAmt);
}
if (!IsPosted())
{
MCostDetail cd = new MCostDetail(as1, lca.GetAD_Org_ID(),
lca.GetM_Product_ID(), lca.GetM_AttributeSetInstance_ID(),
lca.GetM_CostElement_ID(),
allocationAmt, lca.GetQty(), // Qty
desc, GetTrx());
cd.SetC_InvoiceLine_ID(C_InvoiceLine_ID);
bool ok = cd.Save();
if (ok && !cd.IsProcessed())
{
MClient client = MClient.Get(as1.GetCtx(), as1.GetAD_Client_ID());
if (client.IsCostImmediate())
{
cd.Process();
}
}
}
}
log.Config("Created #" + lcas.Length);
return(true);
}
