/**************************************************************************
* Create Invoice Line from Order Line
* @param order order
* @param orderLine line
* @param qtyInvoiced qty
* @param qtyEntered qty
*/
private void CreateLine(MOrder order, MOrderLine orderLine,
Decimal qtyInvoiced, Decimal qtyEntered)
{
if (_invoice == null)
{
_invoice = new MInvoice(order, 0, _DateInvoiced);
if (!_invoice.Save())
{
throw new Exception("Could not create Invoice (o)");
}
}
//
MInvoiceLine line = new MInvoiceLine(_invoice);
line.SetOrderLine(orderLine);
line.SetQtyInvoiced(qtyInvoiced);
log.Info("Qty Invoiced" + line.GetQtyInvoiced());
line.SetQtyEntered(qtyEntered);
line.SetLine(_line + orderLine.GetLine());
if (!line.Save())
{
throw new Exception("Could not create Invoice Line (o)");
}
log.Fine(line.ToString());
}
/**************************************************************************
* Create Invoice Line from Order Line
* @param order order
* @param orderLine line
* @param qtyInvoiced qty
* @param qtyEntered qty
*/
private void CreateLine(MOrder order, MOrderLine orderLine,
Decimal qtyInvoiced, Decimal qtyEntered)
{
if (_invoice == null)
{
_invoice = new MInvoice(order, 0, _DateInvoiced);
//-----------------Column Added by Anuj------------------
int _CountVA009 = Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(AD_MODULEINFO_ID) FROM AD_MODULEINFO WHERE PREFIX='VA009_' AND IsActive = 'Y'"));
if (_CountVA009 > 0)
{
int _PaymentMethod_ID = order.GetVA009_PaymentMethod_ID();
if (_PaymentMethod_ID > 0)
{
_invoice.SetVA009_PaymentMethod_ID(_PaymentMethod_ID);
}
}
//-----------------Column Added by Anuj------------------
int _CountVA026 = Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(AD_MODULEINFO_ID) FROM AD_MODULEINFO WHERE PREFIX='VA026_' AND IsActive = 'Y'"));
if (_CountVA026 > 0)
{
_invoice.SetVA026_LCDetail_ID(order.GetVA026_LCDetail_ID());
}
// Added by Bharat on 29 Jan 2018 to set Inco Term from Order
if (_invoice.Get_ColumnIndex("C_IncoTerm_ID") > 0)
{
_invoice.SetC_IncoTerm_ID(order.GetC_IncoTerm_ID());
}
if (!_invoice.Save())
{
throw new Exception("Could not create Invoice (o)");
}
}
//
MInvoiceLine line = new MInvoiceLine(_invoice);
line.SetOrderLine(orderLine);
line.SetQtyInvoiced(qtyInvoiced);
// if drop ship line true
line.SetIsDropShip(orderLine.IsDropShip());
log.Info("Qty Invoiced" + line.GetQtyInvoiced());
line.SetQtyEntered(qtyEntered);
line.SetLine(_line + orderLine.GetLine());
if (!line.Save())
{
throw new Exception("Could not create Invoice Line (o)");
}
log.Fine(line.ToString());
}
public static bool InsertForeignCostAverageInvoice(Ctx ctx, MInvoice invoice, MInvoiceLine invoiceLine, Trx trx)
{
int acctSchema_ID = 0;
int M_CostElement_ID = 0;
int AD_Org_ID = 0;
int M_ASI_ID = 0;
MProduct product = null;
MAcctSchema acctSchema = null;
MCostForeignCurrency foreignCost = null;
dynamic pc = null;
String cl = null;
try
{
// if cost is calculated then not to calculate again
if (invoiceLine.IsFutureCostCalculated())
{
return(true);
}
acctSchema_ID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT asch.c_acctschema_id FROM c_acctschema asch INNER JOIN ad_clientinfo ci
ON ci.c_acctschema1_id = asch.c_acctschema_id WHERE ci.ad_client_id = " + invoice.GetAD_Client_ID()));
acctSchema = new MAcctSchema(ctx, acctSchema_ID, trx);
if (acctSchema.GetC_Currency_ID() != invoice.GetC_Currency_ID())
{
// Get Costing Element of Av. Invoice
M_CostElement_ID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT M_CostElement_ID FROM M_CostElement WHERE AD_Client_ID = "
+ invoice.GetAD_Client_ID() + " AND IsActive = 'Y' AND CostingMethod = 'I'"));
product = new MProduct(ctx, invoiceLine.GetM_Product_ID(), trx);
if (product != null && product.GetProductType() == "I" && product.GetM_Product_ID() > 0) // for Item Type product
{
pc = MProductCategory.Get(product.GetCtx(), product.GetM_Product_Category_ID());
// Get Costing Level
if (pc != null)
{
cl = pc.GetCostingLevel();
}
if (cl == null)
{
cl = acctSchema.GetCostingLevel();
}
if (cl == "C" || cl == "B")
{
AD_Org_ID = 0;
}
else
{
AD_Org_ID = invoice.GetAD_Org_ID();
}
if (cl != "B")
{
M_ASI_ID = 0;
}
else
{
M_ASI_ID = invoiceLine.GetM_AttributeSetInstance_ID();
}
foreignCost = MCostForeignCurrency.Get(product, M_ASI_ID, AD_Org_ID, M_CostElement_ID, invoice.GetC_BPartner_ID(), invoice.GetC_Currency_ID());
foreignCost.SetC_Invoice_ID(invoice.GetC_Invoice_ID());
foreignCost.SetCumulatedQty(Decimal.Add(foreignCost.GetCumulatedQty(), invoiceLine.GetQtyInvoiced()));
foreignCost.SetCumulatedAmt(Decimal.Add(foreignCost.GetCumulatedAmt(), invoiceLine.GetLineNetAmt()));
if (foreignCost.GetCumulatedQty() != 0)
{
foreignCost.SetCostPerUnit(Decimal.Round(Decimal.Divide(foreignCost.GetCumulatedAmt(), foreignCost.GetCumulatedQty()), acctSchema.GetCostingPrecision()));
}
else
{
foreignCost.SetCostPerUnit(0);
}
if (!foreignCost.Save(trx))
{
ValueNamePair pp = VLogger.RetrieveError();
_log.Severe("Error occured during updating M_Cost_ForeignCurrency. Error name : " + pp.GetName() +
" AND Error Value : " + pp.GetValue() + " , For Invoice line : " + invoiceLine.GetC_InvoiceLine_ID() +
" , AND Ad_Client_ID : " + invoiceLine.GetAD_Client_ID());
return(false);
}
else
{
invoiceLine.SetIsFutureCostCalculated(true);
if (!invoiceLine.Save(trx))
{
ValueNamePair pp = VLogger.RetrieveError();
_log.Severe("Error occured during updating Is Foreign Cost On C_invoice. Error name : " + pp.GetName() +
" AND Error Value : " + pp.GetValue() + " , For Invoice line : " + invoiceLine.GetC_InvoiceLine_ID() +
" , AND Ad_Client_ID : " + invoiceLine.GetAD_Client_ID());
return(false);
}
}
}
}
}
catch (Exception ex)
{
_log.Log(Level.SEVERE, "", ex);
return(false);
}
return(true);
}
/// <summary>
/// Create Shipment
/// </summary>
/// <returns>info</returns>
protected override String DoIt()
{
//log.info("C_Invoice_ID=" + _C_Invoice_ID
// + ", M_Warehouse_ID=" + _M_Warehouse_ID
// + ", C_DocType_ID=" + _C_DocType_ID);
if (_C_Invoice_ID == 0)
{
throw new ArgumentException("@NotFound@ @C_Invoice_ID@");
}
if (_M_Warehouse_ID == 0)
{
throw new ArgumentException("@NotFound@ @M_Warehouse_ID@");
}
//
MInvoice invoice = new MInvoice(GetCtx(), _C_Invoice_ID, Get_Trx());
if (invoice.Get_ID() == 0)
{
throw new ArgumentException("@NotFound@ @C_Invoice_ID@");
}
if (!MInvoice.DOCSTATUS_Completed.Equals(invoice.GetDocStatus()))
{
throw new ArgumentException("@InvoiceCreateDocNotCompleted@");
}
MDocType dt = MDocType.Get(GetCtx(), _C_DocType_ID);
if (invoice.IsSOTrx() != dt.IsSOTrx() ||
invoice.IsReturnTrx() != dt.IsReturnTrx())
{
throw new ArgumentException("@C_DocType_ID@ <> @C_Invoice_ID@");
}
//*****************************Vikas 1 Dec 2015 *********************************
//Case Msg Not Showing Proper
MInOut ship = null;
MOrder ord = new MOrder(GetCtx(), invoice.GetC_Order_ID(), null);
if (ord.GetC_BPartner_ID() > 0)
{
ship = new MInOut(invoice, _C_DocType_ID, null, _M_Warehouse_ID);
// Change by Mohit Asked by Amardeep sir 02/03/2016
ship.SetPOReference(invoice.GetPOReference());
// End
if (!ship.Save())
{
return(GetRetrievedError(ship, "@SaveError@ Receipt"));
// throw new ArgumentException("@SaveError@ Receipt");
}
}
else
{
return(GetRetrievedError(ship, "InvoiceNotLinkedWithPO"));
//throw new ArgumentException("@InvoiceNotLinkedWithPO@");
}
/*
* MInOut ship = new MInOut(invoice, _C_DocType_ID, null, _M_Warehouse_ID);
* if (!ship.Save())
* {
* throw new ArgumentException("@SaveError@ Receipt");
* }
*/
//************************END*****************************************
MInvoiceLine[] invoiceLines = invoice.GetLines(false);
for (int i = 0; i < invoiceLines.Length; i++)
{
MInvoiceLine invoiceLine = invoiceLines[i];
MProduct product = invoiceLine.GetProduct();
// Nothing to Deliver
// Get the lines of Invoice based on the setting taken on Tenant to allow non item Product
if (Util.GetValueOfString(GetCtx().GetContext("$AllowNonItem")).Equals("N") &&
((product != null && product.GetProductType() != MProduct.PRODUCTTYPE_Item) || invoiceLine.GetC_Charge_ID() != 0))
{
continue;
}
MInOutLine sLine = new MInOutLine(ship);
//JID_1679 Generate Receipt from Invoice(Vendor) for remaining quantity
//decimal movementqty = 0;
//if (invoiceLine.GetC_OrderLine_ID() != 0)
//{
// decimal? res = 0;
// movementqty = Util.GetValueOfDecimal(DB.ExecuteScalar(@" select (QtyOrdered-sum(MovementQty)) from C_OrderLine ol Inner join M_InOutLine il on il.C_orderline_ID= ol.C_Orderline_Id "
// + " WHERE il.C_OrderLine_ID =" + invoiceLine.GetC_OrderLine_ID() + "group by QtyOrdered", null, Get_Trx()));
// // in case of partial receipt
// if (invoiceLine.GetQtyInvoiced() > movementqty && movementqty != 0)
// {
// if (product.GetC_UOM_ID() != invoiceLine.GetC_UOM_ID())
// {
// res = MUOMConversion.ConvertProductTo(GetCtx(), product.GetM_Product_ID(), invoiceLine.GetC_UOM_ID(), movementqty);
// }
// sLine.SetInvoiceLine(invoiceLine, 0, // Locator
// invoice.IsSOTrx() ? (movementqty) : Env.ZERO);
// sLine.SetQtyEntered(res == 0 ? (movementqty) : res);
// sLine.SetMovementQty(movementqty);
// }
// // if QtyInvoiced is less or No Material receipt is found against the order
// else
// {
// sLine.SetInvoiceLine(invoiceLine, 0, // Locator
// invoice.IsSOTrx() ? invoiceLine.GetQtyInvoiced() : Env.ZERO);
// sLine.SetQtyEntered(invoiceLine.GetQtyEntered());
// sLine.SetMovementQty(invoiceLine.GetQtyInvoiced());
// }
//}
//else
//{
sLine.SetInvoiceLine(invoiceLine, 0, // Locator
invoice.IsSOTrx() ? invoiceLine.GetQtyInvoiced() : Env.ZERO);
sLine.SetQtyEntered(invoiceLine.GetQtyEntered());
sLine.SetMovementQty(invoiceLine.GetQtyInvoiced());
//}
if (invoice.IsCreditMemo())
{
sLine.SetQtyEntered(Decimal.Negate(sLine.GetQtyEntered())); //.negate());
sLine.SetMovementQty(Decimal.Negate(sLine.GetMovementQty())); //.negate());
}
if (!sLine.Save())
{
ship.Get_Trx().Rollback();
//if (movementqty == 0)
//{
// _processMsg += ", LineNo: " + invoiceLine.GetLine() + Msg.GetMsg(GetCtx(), "MRIsAlreadyCreated");
// return _processMsg;
//}
//else
//{
return(GetRetrievedError(sLine, "@SaveError@ @M_InOutLine_ID@"));
//}
// throw new ArgumentException("@SaveError@ @M_InOutLine_ID@");
}
invoiceLine.SetM_InOutLine_ID(sLine.GetM_InOutLine_ID());
// _processMsg+= ", LineNo: "+invoiceLine.GetLine()+Msg.GetMsg(GetCtx(), "MRCreatedWithDocNo" + ship.GetDocumentNo());
if (!invoiceLine.Save())
{
return(GetRetrievedError(invoiceLine, "@SaveError@ @C_InvoiceLine_ID@"));
//throw new ArgumentException("@SaveError@ @C_InvoiceLine_ID@");
}
}
return(ship.GetDocumentNo());
}
/// <summary>
/// Create Facts (the accounting logic) for
/// MXI.
/// (single line)
/// <pre>
/// NotInvoicedReceipts DR (Receipt Org)
/// InventoryClearing CR
/// InvoicePV DR CR (difference)
/// Commitment
/// Expense CR
/// Offset DR
/// </pre>
/// </summary>
/// <param name="as1"></param>
/// <returns></returns>
public override List <Fact> CreateFacts(MAcctSchema as1)
{
List <Fact> facts = new List <Fact>();
// Nothing to do
if (GetM_Product_ID() == 0 || // no Product
Env.Signum(GetQty().Value) == 0 ||
Env.Signum(_receiptLine.GetMovementQty()) == 0) // Qty = 0
{
log.Fine("No Product/Qty - M_Product_ID=" + GetM_Product_ID()
+ ",Qty=" + GetQty() + ",InOutQty=" + _receiptLine.GetMovementQty());
return(facts);
}
MMatchInv matchInv = (MMatchInv)GetPO();
// create Fact Header
Fact fact = new Fact(this, as1, Fact.POST_Actual);
SetC_Currency_ID(as1.GetC_Currency_ID());
/** Needs to be handeled in PO Matching as1 no Receipt info
* if (_pc.isService())
* {
* log.Fine("Service - skipped");
* return fact;
* }
**/
// NotInvoicedReceipt DR
// From Receipt
Decimal multiplier = Math.Abs(Decimal.Round(Decimal.Divide(GetQty().Value, _receiptLine.GetMovementQty()), 12, MidpointRounding.AwayFromZero));
FactLine dr = fact.CreateLine(null,
GetAccount(Doc.ACCTTYPE_NotInvoicedReceipts, as1),
as1.GetC_Currency_ID(), Env.ONE, null); // updated below
if (dr == null)
{
_error = "No Product Costs";
return(null);
}
dr.SetQty(GetQty());
// dr.setM_Locator_ID(_receiptLine.getM_Locator_ID());
// MInOut receipt = _receiptLine.getParent();
// dr.setLocationFromBPartner(receipt.getC_BPartner_Location_ID(), true); // from Loc
// dr.setLocationFromLocator(_receiptLine.getM_Locator_ID(), false); // to Loc
Decimal temp = dr.GetAcctBalance();
// Set AmtAcctCr/Dr from Receipt (sets also Project)
if (!dr.UpdateReverseLine(MInOut.Table_ID, // Amt updated
_receiptLine.GetM_InOut_ID(), _receiptLine.GetM_InOutLine_ID(),
multiplier))
{
_error = "Mat.Receipt not posted yet";
return(null);
}
log.Fine("CR - Amt(" + temp + "->" + dr.GetAcctBalance()
+ ") - " + dr.ToString());
// InventoryClearing CR
// From Invoice
MAccount expense = _pc.GetAccount(ProductCost.ACCTTYPE_P_InventoryClearing, as1);
if (_pc.IsService())
{
expense = _pc.GetAccount(ProductCost.ACCTTYPE_P_Expense, as1);
}
Decimal LineNetAmt = _invoiceLine.GetLineNetAmt();
multiplier = Math.Abs(Decimal.Round(Decimal.Divide(GetQty().Value, _invoiceLine.GetQtyInvoiced()), 12, MidpointRounding.AwayFromZero));
if (multiplier.CompareTo(Env.ONE) != 0)
{
LineNetAmt = Decimal.Multiply(LineNetAmt, multiplier);
}
if (_pc.IsService())
{
LineNetAmt = dr.GetAcctBalance(); // book out exact receipt amt
}
FactLine cr = null;
if (as1.IsAccrual())
{
cr = fact.CreateLine(null, expense,
as1.GetC_Currency_ID(), null, LineNetAmt); // updated below
if (cr == null)
{
log.Fine("Line Net Amt=0 - M_Product_ID=" + GetM_Product_ID()
+ ",Qty=" + GetQty() + ",InOutQty=" + _receiptLine.GetMovementQty());
facts.Add(fact);
return(facts);
}
cr.SetQty(Decimal.Negate(GetQty().Value));
temp = cr.GetAcctBalance();
// Set AmtAcctCr/Dr from Invoice (sets also Project)
if (as1.IsAccrual() && !cr.UpdateReverseLine(MInvoice.Table_ID, // Amt updated
_invoiceLine.GetC_Invoice_ID(), _invoiceLine.GetC_InvoiceLine_ID(), multiplier))
{
_error = "Invoice not posted yet";
return(null);
}
log.Fine("DR - Amt(" + temp + "->" + cr.GetAcctBalance()
+ ") - " + cr.ToString());
}
else // Cash Acct
{
MInvoice invoice = _invoiceLine.GetParent();
if (as1.GetC_Currency_ID() == invoice.GetC_Currency_ID())
{
LineNetAmt = MConversionRate.Convert(GetCtx(), LineNetAmt,
invoice.GetC_Currency_ID(), as1.GetC_Currency_ID(),
invoice.GetDateAcct(), invoice.GetC_ConversionType_ID(),
invoice.GetAD_Client_ID(), invoice.GetAD_Org_ID());
}
cr = fact.CreateLine(null, expense,
as1.GetC_Currency_ID(), null, LineNetAmt);
cr.SetQty(Decimal.Negate(Decimal.Multiply(GetQty().Value, multiplier)));
}
cr.SetC_Activity_ID(_invoiceLine.GetC_Activity_ID());
cr.SetC_Campaign_ID(_invoiceLine.GetC_Campaign_ID());
cr.SetC_Project_ID(_invoiceLine.GetC_Project_ID());
cr.SetC_UOM_ID(_invoiceLine.GetC_UOM_ID());
cr.SetUser1_ID(_invoiceLine.GetUser1_ID());
cr.SetUser2_ID(_invoiceLine.GetUser2_ID());
// Invoice Price Variance difference
Decimal ipv = Decimal.Negate(Decimal.Add(cr.GetAcctBalance(), dr.GetAcctBalance()));
if (Env.Signum(ipv) != 0)
{
FactLine pv = fact.CreateLine(null,
_pc.GetAccount(ProductCost.ACCTTYPE_P_IPV, as1),
as1.GetC_Currency_ID(), ipv);
pv.SetC_Activity_ID(_invoiceLine.GetC_Activity_ID());
pv.SetC_Campaign_ID(_invoiceLine.GetC_Campaign_ID());
pv.SetC_Project_ID(_invoiceLine.GetC_Project_ID());
pv.SetC_UOM_ID(_invoiceLine.GetC_UOM_ID());
pv.SetUser1_ID(_invoiceLine.GetUser1_ID());
pv.SetUser2_ID(_invoiceLine.GetUser2_ID());
}
log.Fine("IPV=" + ipv + "; Balance=" + fact.GetSourceBalance());
MInOut inOut = _receiptLine.GetParent();
bool isReturnTrx = inOut.IsReturnTrx();
if (!IsPosted())
{
// Cost Detail Record - data from Expense/IncClearing (CR) record
MCostDetail.CreateInvoice(as1, GetAD_Org_ID(),
GetM_Product_ID(), matchInv.GetM_AttributeSetInstance_ID(),
_invoiceLine.GetC_InvoiceLine_ID(), 0, // No cost element
Decimal.Negate(cr.GetAcctBalance()), isReturnTrx ? Decimal.Negate(Utility.Util.GetValueOfDecimal(GetQty())) : Utility.Util.GetValueOfDecimal(GetQty()), // correcting
GetDescription(), GetTrx(), GetRectifyingProcess());
// Update Costing
UpdateProductInfo(as1.GetC_AcctSchema_ID(),
MAcctSchema.COSTINGMETHOD_StandardCosting.Equals(as1.GetCostingMethod()));
}
//
facts.Add(fact);
/** Commitment release ****/
if (as1.IsAccrual() && as1.IsCreateCommitment())
{
fact = Doc_Order.GetCommitmentRelease(as1, this,
Utility.Util.GetValueOfDecimal(GetQty()), _invoiceLine.GetC_InvoiceLine_ID(), Env.ONE);
if (fact == null)
{
return(null);
}
facts.Add(fact);
} // Commitment
return(facts);
}
/// <summary>
/// Load Invoice Line
/// </summary>
/// <param name="invoice">invoice</param>
/// <returns>DocLine Array</returns>
private DocLine[] LoadLines(MInvoice invoice)
{
List <DocLine> list = new List <DocLine>();
//
MInvoiceLine[] lines = invoice.GetLines(false);
for (int i = 0; i < lines.Length; i++)
{
MInvoiceLine line = lines[i];
if (line.IsDescription())
{
continue;
}
DocLine docLine = new DocLine(line, this);
// Qty
Decimal Qty = line.GetQtyInvoiced();
bool cm = GetDocumentType().Equals(MDocBaseType.DOCBASETYPE_ARCREDITMEMO) ||
GetDocumentType().Equals(MDocBaseType.DOCBASETYPE_APCREDITMEMO);
docLine.SetQty(cm ? Decimal.Negate(Qty) : Qty, invoice.IsSOTrx());
//
Decimal LineNetAmt = line.GetLineNetAmt();
Decimal PriceList = line.GetPriceList();
int C_Tax_ID = docLine.GetC_Tax_ID();
// Correct included Tax
if (IsTaxIncluded() && C_Tax_ID != 0)
{
MTax tax = MTax.Get(GetCtx(), C_Tax_ID);
if (!tax.IsZeroTax())
{
Decimal LineNetAmtTax = tax.CalculateTax(LineNetAmt, true, GetStdPercision());
log.Fine("LineNetAmt=" + LineNetAmt + " - Tax=" + LineNetAmtTax);
LineNetAmt = Decimal.Subtract(LineNetAmt, LineNetAmtTax);
for (int t = 0; t < _taxes.Length; t++)
{
if (_taxes[t].GetC_Tax_ID() == C_Tax_ID)
{
_taxes[t].AddIncludedTax(LineNetAmtTax);
break;
}
}
Decimal PriceListTax = tax.CalculateTax(PriceList, true, GetStdPercision());
PriceList = Decimal.Subtract(PriceList, PriceListTax);
}
} // correct included Tax
docLine.SetAmount(LineNetAmt, PriceList, Qty); // qty for discount calc
if (docLine.IsItem())
{
_allLinesService = false;
}
else
{
_allLinesItem = false;
}
//
log.Fine(docLine.ToString());
list.Add(docLine);
}
// Convert to Array
DocLine[] dls = new DocLine[list.Count];
dls = list.ToArray();
// Included Tax - make sure that no difference
if (IsTaxIncluded())
{
for (int i = 0; i < _taxes.Length; i++)
{
if (_taxes[i].IsIncludedTaxDifference())
{
Decimal diff = _taxes[i].GetIncludedTaxDifference();
for (int j = 0; j < dls.Length; j++)
{
if (dls[j].GetC_Tax_ID() == _taxes[i].GetC_Tax_ID())
{
dls[j].SetLineNetAmtDifference(diff);
break;
}
} // for all lines
} // tax difference
} // for all taxes
} // Included Tax difference
// Return Array
return(dls);
}
/// <summary>
/// Create Invoice Line from Order Line
/// </summary>
/// <param name="order">order</param>
/// <param name="orderLine">line</param>
/// <param name="qtyInvoiced">qty</param>
/// <param name="qtyEntered">qty</param>
private void CreateLine(MOrder order, MOrderLine orderLine,
Decimal qtyInvoiced, Decimal qtyEntered)
{
if (_invoice == null)
{
_invoice = new MInvoice(order, 0, _DateInvoiced);
int _CountVA009 = Env.IsModuleInstalled("VA009_") ? 1 : 0;
if (_CountVA009 > 0)
{
int _PaymentMethod_ID = order.GetVA009_PaymentMethod_ID();
// Get Payment method from Business partner
int bpPamentMethod_ID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT " + (order.IsSOTrx() ? " VA009_PaymentMethod_ID " : " VA009_PO_PaymentMethod_ID ") +
@" FROM C_BPartner WHERE C_BPartner_ID = " + order.GetC_BPartner_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
if (_ConsolidateDocument && bpPamentMethod_ID != 0)
{
_PaymentMethod_ID = bpPamentMethod_ID;
}
if (_PaymentMethod_ID > 0)
{
_invoice.SetVA009_PaymentMethod_ID(_PaymentMethod_ID);
}
}
int _CountVA026 = Env.IsModuleInstalled("VA026_") ? 1 : 0;
if (_CountVA026 > 0)
{
_invoice.SetVA026_LCDetail_ID(order.GetVA026_LCDetail_ID());
}
// Added by Bharat on 29 Jan 2018 to set Inco Term from Order
if (_invoice.Get_ColumnIndex("C_IncoTerm_ID") > 0)
{
_invoice.SetC_IncoTerm_ID(order.GetC_IncoTerm_ID());
}
if (Env.IsModuleInstalled("VA077_"))
{
//.setva077
_invoice.Set_Value("VA077_AdditionalAnnualCharge", order.Get_Value("VA077_AdditionalAnnualCharge"));
_invoice.Set_Value("VA077_ChangeStartDate", order.Get_Value("VA077_ChangeStartDate"));
_invoice.Set_Value("VA077_ContractCPEndDate", order.Get_Value("VA077_ContractCPEndDate"));
_invoice.Set_Value("VA077_ContractCPStartDate", order.Get_Value("VA077_ContractCPStartDate"));
_invoice.Set_Value("VA077_HistoricContractDate", order.Get_Value("VA077_HistoricContractDate"));
_invoice.Set_Value("VA077_IsLegalEntity", order.Get_Value("VA077_IsLegalEntity"));
_invoice.Set_Value("VA077_MarginPercent", order.Get_Value("VA077_MarginPercent"));
_invoice.Set_Value("VA077_NewAnnualContractTotal", order.Get_Value("VA077_NewAnnualContractTotal"));
_invoice.Set_Value("VA077_OldAnnualContractTotal", order.Get_Value("VA077_OldAnnualContractTotal"));
_invoice.Set_Value("VA077_PartialAmtCatchUp", order.Get_Value("VA077_PartialAmtCatchUp"));
_invoice.Set_Value("VA077_SalesCoWorker", order.Get_Value("VA077_SalesCoWorker"));
_invoice.Set_Value("VA077_SalesCoWorkerPer", order.Get_Value("VA077_SalesCoWorkerPer"));
_invoice.Set_Value("VA077_TotalMarginAmt", order.Get_Value("VA077_TotalMarginAmt"));
_invoice.Set_Value("VA077_TotalPurchaseAmt", order.Get_Value("VA077_TotalPurchaseAmt"));
_invoice.Set_Value("VA077_TotalSalesAmt", order.Get_Value("VA077_TotalSalesAmt"));
}
if (!_invoice.Save())
{
ValueNamePair pp = VAdvantage.Logging.VLogger.RetrieveError();
if (pp != null)
{
throw new ArgumentException("Could not create Invoice (o). " + pp.GetName());
}
throw new Exception("Could not create Invoice (o)");
}
}
//
MInvoiceLine line = new MInvoiceLine(_invoice);
line.SetOrderLine(orderLine);
line.SetQtyInvoiced(qtyInvoiced);
// if drop ship line true
line.SetIsDropShip(orderLine.IsDropShip());
log.Info("Qty Invoiced" + line.GetQtyInvoiced());
line.SetQtyEntered(qtyEntered);
line.SetLine(_line + orderLine.GetLine());
if (Env.IsModuleInstalled("VA077_"))
{
//invoice line
line.Set_Value("VA077_CNAutodesk", orderLine.Get_Value("VA077_CNAutodesk"));
line.Set_Value("VA077_Duration", orderLine.Get_Value("VA077_Duration"));
line.Set_Value("VA077_MarginAmt", orderLine.Get_Value("VA077_MarginAmt"));
line.Set_Value("VA077_MarginPercent", orderLine.Get_Value("VA077_MarginPercent"));
line.Set_Value("VA077_OldSN", orderLine.Get_Value("VA077_OldSN"));
line.Set_Value("VA077_ProductInfo", orderLine.Get_Value("VA077_ProductInfo"));
line.Set_Value("VA077_PurchasePrice", orderLine.Get_Value("VA077_PurchasePrice"));
line.Set_Value("VA077_RegEmail", orderLine.Get_Value("VA077_RegEmail"));
line.Set_Value("VA077_SerialNo", orderLine.Get_Value("VA077_SerialNo"));
line.Set_Value("VA077_UpdateFromVersn", orderLine.Get_Value("VA077_UpdateFromVersn"));
line.Set_Value("VA077_UserRef_ID", orderLine.Get_Value("VA077_UserRef_ID"));
line.Set_Value("VA077_StartDate", orderLine.Get_Value("VA077_StartDate"));
line.Set_Value("VA077_EndDate", orderLine.Get_Value("VA077_EndDate"));
}
if (!line.Save())
{
ValueNamePair pp = VAdvantage.Logging.VLogger.RetrieveError();
if (pp != null)
{
throw new ArgumentException("Could not create Invoice Line (o). " + pp.GetName());
}
throw new Exception("Could not create Invoice Line (o)");
}
log.Fine(line.ToString());
}
/// <summary>
/// Create Shipment
/// </summary>
/// <returns>info</returns>
protected override String DoIt()
{
//log.info("C_Invoice_ID=" + _C_Invoice_ID
// + ", M_Warehouse_ID=" + _M_Warehouse_ID
// + ", C_DocType_ID=" + _C_DocType_ID);
if (_C_Invoice_ID == 0)
{
throw new ArgumentException("@NotFound@ @C_Invoice_ID@");
}
if (_M_Warehouse_ID == 0)
{
throw new ArgumentException("@NotFound@ @M_Warehouse_ID@");
}
//
MInvoice invoice = new MInvoice(GetCtx(), _C_Invoice_ID, null);
if (invoice.Get_ID() == 0)
{
throw new ArgumentException("@NotFound@ @C_Invoice_ID@");
}
if (!MInvoice.DOCSTATUS_Completed.Equals(invoice.GetDocStatus()))
{
throw new ArgumentException("@InvoiceCreateDocNotCompleted@");
}
MDocType dt = MDocType.Get(GetCtx(), _C_DocType_ID);
if (invoice.IsSOTrx() != dt.IsSOTrx() ||
invoice.IsReturnTrx() != dt.IsReturnTrx())
{
throw new ArgumentException("@C_DocType_ID@ <> @C_Invoice_ID@");
}
//*****************************Vikas 1 Dec 2015 *********************************
//Case Msg Not Showing Proper
MInOut ship = null;
MOrder ord = new MOrder(GetCtx(), invoice.GetC_Order_ID(), null);
if (ord.GetC_BPartner_ID() > 0)
{
ship = new MInOut(invoice, _C_DocType_ID, null, _M_Warehouse_ID);
// Change by Mohit Asked by Amardeep sir 02/03/2016
ship.SetPOReference(invoice.GetPOReference());
// End
if (!ship.Save())
{
return(GetRetrievedError(ship, "@SaveError@ Receipt"));
// throw new ArgumentException("@SaveError@ Receipt");
}
}
else
{
return(GetRetrievedError(ship, "InvoiceNotLinkedWithPO"));
//throw new ArgumentException("@InvoiceNotLinkedWithPO@");
}
/*
* MInOut ship = new MInOut(invoice, _C_DocType_ID, null, _M_Warehouse_ID);
* if (!ship.Save())
* {
* throw new ArgumentException("@SaveError@ Receipt");
* }
*/
//************************END*****************************************
MInvoiceLine[] invoiceLines = invoice.GetLines(false);
for (int i = 0; i < invoiceLines.Length; i++)
{
MInvoiceLine invoiceLine = invoiceLines[i];
MProduct product = invoiceLine.GetProduct();
// Nothing to Deliver
// Get the lines of Invoice based on the setting taken on Tenant to allow non item Product
if (Util.GetValueOfString(GetCtx().GetContext("$AllowNonItem")).Equals("N") &&
((product != null && product.GetProductType() != MProduct.PRODUCTTYPE_Item) || invoiceLine.GetC_Charge_ID() != 0))
{
continue;
}
MInOutLine sLine = new MInOutLine(ship);
sLine.SetInvoiceLine(invoiceLine, 0, // Locator
invoice.IsSOTrx() ? invoiceLine.GetQtyInvoiced() : Env.ZERO);
sLine.SetQtyEntered(invoiceLine.GetQtyEntered());
sLine.SetMovementQty(invoiceLine.GetQtyInvoiced());
if (invoice.IsCreditMemo())
{
sLine.SetQtyEntered(Decimal.Negate(sLine.GetQtyEntered())); //.negate());
sLine.SetMovementQty(Decimal.Negate(sLine.GetMovementQty())); //.negate());
}
if (!sLine.Save())
{
return(GetRetrievedError(sLine, "@SaveError@ @M_InOutLine_ID@"));
//throw new ArgumentException("@SaveError@ @M_InOutLine_ID@");
}
//
invoiceLine.SetM_InOutLine_ID(sLine.GetM_InOutLine_ID());
if (!invoiceLine.Save())
{
return(GetRetrievedError(invoiceLine, "@SaveError@ @C_InvoiceLine_ID@"));
//throw new ArgumentException("@SaveError@ @C_InvoiceLine_ID@");
}
}
return(ship.GetDocumentNo());
}
/// <summary>
/// Create Shipment
/// </summary>
/// <returns>info</returns>
protected override String DoIt()
{
//log.info("C_Invoice_ID=" + _C_Invoice_ID
// + ", M_Warehouse_ID=" + _M_Warehouse_ID
// + ", C_DocType_ID=" + _C_DocType_ID);
if (_C_Invoice_ID == 0)
{
throw new ArgumentException("@NotFound@ @C_Invoice_ID@");
}
if (_M_Warehouse_ID == 0)
{
throw new ArgumentException("@NotFound@ @M_Warehouse_ID@");
}
//
MInvoice invoice = new MInvoice(GetCtx(), _C_Invoice_ID, null);
if (invoice.Get_ID() == 0)
{
throw new ArgumentException("@NotFound@ @C_Invoice_ID@");
}
if (!MInvoice.DOCSTATUS_Completed.Equals(invoice.GetDocStatus()))
{
throw new ArgumentException("@InvoiceCreateDocNotCompleted@");
}
MDocType dt = MDocType.Get(GetCtx(), _C_DocType_ID);
if (invoice.IsSOTrx() != dt.IsSOTrx() ||
invoice.IsReturnTrx() != dt.IsReturnTrx())
{
throw new ArgumentException("@C_DocType_ID@ <> @C_Invoice_ID@");
}
//
MInOut ship = new MInOut(invoice, _C_DocType_ID, null, _M_Warehouse_ID);
if (!ship.Save())
{
throw new ArgumentException("@SaveError@ Receipt");
}
//
MInvoiceLine[] invoiceLines = invoice.GetLines(false);
for (int i = 0; i < invoiceLines.Length; i++)
{
MInvoiceLine invoiceLine = invoiceLines[i];
MInOutLine sLine = new MInOutLine(ship);
sLine.SetInvoiceLine(invoiceLine, 0, // Locator
invoice.IsSOTrx() ? invoiceLine.GetQtyInvoiced() : Env.ZERO);
sLine.SetQtyEntered(invoiceLine.GetQtyEntered());
sLine.SetMovementQty(invoiceLine.GetQtyInvoiced());
if (invoice.IsCreditMemo())
{
sLine.SetQtyEntered(Decimal.Negate(sLine.GetQtyEntered())); //.negate());
sLine.SetMovementQty(Decimal.Negate(sLine.GetMovementQty())); //.negate());
}
if (!sLine.Save())
{
throw new ArgumentException("@SaveError@ @M_InOutLine_ID@");
}
//
invoiceLine.SetM_InOutLine_ID(sLine.GetM_InOutLine_ID());
if (!invoiceLine.Save())
{
throw new ArgumentException("@SaveError@ @C_InvoiceLine_ID@");
}
}
return(ship.GetDocumentNo());
}
/// <summary>
/// Create Invoice Line from Order Line
/// </summary>
/// <param name="order">order</param>
/// <param name="orderLine">line</param>
/// <param name="qtyInvoiced">qty</param>
/// <param name="qtyEntered">qty</param>
private void CreateLine(MOrder order, MOrderLine orderLine,
Decimal qtyInvoiced, Decimal qtyEntered)
{
if (_invoice == null)
{
_invoice = new MInvoice(order, 0, _DateInvoiced);
int _CountVA009 = Env.IsModuleInstalled("VA009_") ? 1 : 0;
if (_CountVA009 > 0)
{
int _PaymentMethod_ID = order.GetVA009_PaymentMethod_ID();
// Get Payment method from Business partner
int bpPamentMethod_ID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT " + (order.IsSOTrx() ? " VA009_PaymentMethod_ID " : " VA009_PO_PaymentMethod_ID ") +
@" FROM C_BPartner WHERE C_BPartner_ID = " + order.GetC_BPartner_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
if (_ConsolidateDocument && bpPamentMethod_ID != 0)
{
_PaymentMethod_ID = bpPamentMethod_ID;
}
if (_PaymentMethod_ID > 0)
{
_invoice.SetVA009_PaymentMethod_ID(_PaymentMethod_ID);
}
}
int _CountVA026 = Env.IsModuleInstalled("VA026_") ? 1 : 0;
if (_CountVA026 > 0)
{
_invoice.SetVA026_LCDetail_ID(order.GetVA026_LCDetail_ID());
}
// Added by Bharat on 29 Jan 2018 to set Inco Term from Order
if (_invoice.Get_ColumnIndex("C_IncoTerm_ID") > 0)
{
_invoice.SetC_IncoTerm_ID(order.GetC_IncoTerm_ID());
}
if (!_invoice.Save())
{
ValueNamePair pp = VAdvantage.Logging.VLogger.RetrieveError();
if (pp != null)
{
throw new ArgumentException("Could not create Invoice (o). " + pp.GetName());
}
throw new Exception("Could not create Invoice (o)");
}
}
//
MInvoiceLine line = new MInvoiceLine(_invoice);
line.SetOrderLine(orderLine);
line.SetQtyInvoiced(qtyInvoiced);
// if drop ship line true
line.SetIsDropShip(orderLine.IsDropShip());
log.Info("Qty Invoiced" + line.GetQtyInvoiced());
line.SetQtyEntered(qtyEntered);
line.SetLine(_line + orderLine.GetLine());
if (!line.Save())
{
ValueNamePair pp = VAdvantage.Logging.VLogger.RetrieveError();
if (pp != null)
{
throw new ArgumentException("Could not create Invoice Line (o). " + pp.GetName());
}
throw new Exception("Could not create Invoice Line (o)");
}
log.Fine(line.ToString());
}
