/**************************************************************************
* 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());
}
/**
* Set Order Line.
* Does not set Quantity!
* @param oLine order line
* @param M_Locator_ID locator
* @param Qty used only to find suitable locator
*/
public void SetOrderLine(MOrderLine oLine, int M_Locator_ID, Decimal Qty)
{
SetC_OrderLine_ID(oLine.GetC_OrderLine_ID());
SetLine(oLine.GetLine());
SetC_UOM_ID(oLine.GetC_UOM_ID());
MProduct product = oLine.GetProduct();
if (product == null)
{
SetM_Product_ID(0);
SetM_AttributeSetInstance_ID(0);
base.SetM_Locator_ID(0);
}
else
{
SetM_Product_ID(oLine.GetM_Product_ID());
SetM_AttributeSetInstance_ID(oLine.GetM_AttributeSetInstance_ID());
//
if (product.IsItem())
{
if (M_Locator_ID == 0)
{
SetM_Locator_ID(Qty); // requires warehouse, product, asi
}
else
{
SetM_Locator_ID(M_Locator_ID);
}
}
else
{
base.SetM_Locator_ID(0);
}
}
SetC_Charge_ID(oLine.GetC_Charge_ID());
SetDescription(oLine.GetDescription());
SetIsDescription(oLine.IsDescription());
//
SetC_Project_ID(oLine.GetC_Project_ID());
SetC_ProjectPhase_ID(oLine.GetC_ProjectPhase_ID());
SetC_ProjectTask_ID(oLine.GetC_ProjectTask_ID());
SetC_Activity_ID(oLine.GetC_Activity_ID());
SetC_Campaign_ID(oLine.GetC_Campaign_ID());
SetAD_OrgTrx_ID(oLine.GetAD_OrgTrx_ID());
SetUser1_ID(oLine.GetUser1_ID());
SetUser2_ID(oLine.GetUser2_ID());
}
/// <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 Line
/// </summary>
/// <param name="order">order</param>
/// <param name="orderLine">line</param>
/// <param name="qty">Quantity</param>
/// <param name="storages">storage info</param>
/// <param name="force">force delivery</param>
private void CreateLine(MOrder order, MOrderLine orderLine, Decimal qty,
MStorage[] storages, bool force)
{
// Complete last Shipment - can have multiple shipments
if (_lastC_BPartner_Location_ID != orderLine.GetC_BPartner_Location_ID())
{
CompleteShipment();
}
_lastC_BPartner_Location_ID = orderLine.GetC_BPartner_Location_ID();
// Create New Shipment
if (_shipment == null)
{
_shipment = new MInOut(order, 0, _movementDate);
_shipment.SetM_Warehouse_ID(orderLine.GetM_Warehouse_ID()); // sets Org too
if (order.GetC_BPartner_ID() != orderLine.GetC_BPartner_ID())
{
_shipment.SetC_BPartner_ID(orderLine.GetC_BPartner_ID());
}
if (order.GetC_BPartner_Location_ID() != orderLine.GetC_BPartner_Location_ID())
{
_shipment.SetC_BPartner_Location_ID(orderLine.GetC_BPartner_Location_ID());
}
if (!_shipment.Save())
{
throw new Exception("Could not create Shipment");
}
}
// Non Inventory Lines
if (storages == null)
{
MInOutLine line = new MInOutLine(_shipment);
line.SetOrderLine(orderLine, 0, Env.ZERO);
line.SetQty(qty); // Correct UOM
if (orderLine.GetQtyEntered().CompareTo(orderLine.GetQtyOrdered()) != 0)
{
line.SetQtyEntered(Decimal.Round(Decimal.Divide(Decimal.Multiply(qty,
orderLine.GetQtyEntered()), orderLine.GetQtyOrdered()),
12, MidpointRounding.AwayFromZero));
}
line.SetLine(_line + orderLine.GetLine());
//Amit 27-jan-2014
if (Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(AD_MODULEINFO_ID) FROM AD_MODULEINFO WHERE PREFIX='DTD001_'")) > 0)
{
line.SetDTD001_IsAttributeNo(true);
}
if (!line.Save())
{
throw new Exception("Could not create Shipment Line");
}
log.Fine(line.ToString());
return;
}
// Product
MProduct product = orderLine.GetProduct();
bool linePerASI = false;
if (product.GetM_AttributeSet_ID() != 0)
{
MAttributeSet mas = MAttributeSet.Get(GetCtx(), product.GetM_AttributeSet_ID());
linePerASI = mas.IsInstanceAttribute();
}
// Inventory Lines
List <MInOutLine> list = new List <MInOutLine>();
Decimal toDeliver = qty;
for (int i = 0; i < storages.Length; i++)
{
MStorage storage = storages[i];
Decimal deliver = toDeliver;
// Not enough On Hand
if (deliver.CompareTo(storage.GetQtyOnHand()) > 0 &&
Env.Signum(storage.GetQtyOnHand()) >= 0) // positive storage
{
if (!force || // Adjust to OnHand Qty
(i + 1 != storages.Length)) // if force don't adjust last location
{
deliver = storage.GetQtyOnHand();
}
}
if (Env.Signum(deliver) == 0) // zero deliver
{
continue;
}
int M_Locator_ID = storage.GetM_Locator_ID();
//
MInOutLine line = null;
if (!linePerASI) // find line with Locator
{
for (int n = 0; n < list.Count; n++)
{
MInOutLine test = (MInOutLine)list[n];
if (test.GetM_Locator_ID() == M_Locator_ID)
{
line = test;
break;
}
}
}
if (line == null) // new line
{
line = new MInOutLine(_shipment);
line.SetOrderLine(orderLine, M_Locator_ID, order.IsSOTrx() ? deliver : Env.ZERO);
line.SetQty(deliver);
list.Add(line);
}
else
{
// existing line
line.SetQty(Decimal.Add(line.GetMovementQty(), deliver));
}
if (orderLine.GetQtyEntered().CompareTo(orderLine.GetQtyOrdered()) != 0)
{
line.SetQtyEntered(Decimal.Round(Decimal.Divide(Decimal.Multiply(line.GetMovementQty(), orderLine.GetQtyEntered()),
orderLine.GetQtyOrdered()), 12, MidpointRounding.AwayFromZero));
}
line.SetLine(_line + orderLine.GetLine());
if (linePerASI)
{
line.SetM_AttributeSetInstance_ID(storage.GetM_AttributeSetInstance_ID());
}
//Amit 27-jan-2014
if (Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(AD_MODULEINFO_ID) FROM AD_MODULEINFO WHERE PREFIX='DTD001_'")) > 0)
{
line.SetDTD001_IsAttributeNo(true);
}
if (!line.Save())
{
throw new Exception("Could not create Shipment Line");
}
log.Fine("ToDeliver=" + qty + "/" + deliver + " - " + line);
toDeliver = Decimal.Subtract(toDeliver, deliver);
// Temp adjustment
storage.SetQtyOnHand(Decimal.Subtract(storage.GetQtyOnHand(), deliver));
//
if (Env.Signum(toDeliver) == 0)
{
break;
}
}
if (Env.Signum(toDeliver) != 0)
{
throw new Exception("Not All Delivered - Remainder=" + toDeliver);
}
}
/// <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());
}