public bool SetProductQty(int recordID, string keyColName, List <string> product, List <string> attribute, List <string> qty, List <string> qtybook, List <string> oline_ID, int ordID, List <string> locID, int lineID, VAdvantage.Utility.Ctx ctx)
{
if (keyColName.ToUpper().Trim() == "C_ORDER_ID")
{
MOrder ord = new MOrder(ctx, recordID, null);
for (int i = 0; i < product.Count; i++)
{
MOrderLine oline = new MOrderLine(ctx, lineID, null);
oline.SetAD_Client_ID(ord.GetAD_Client_ID());
oline.SetAD_Org_ID(ord.GetAD_Org_ID());
oline.SetM_Product_ID(Util.GetValueOfInt(product[i]));
oline.SetQty(Util.GetValueOfDecimal(qty[i]));
oline.SetC_Order_ID(recordID);
if (Util.GetValueOfInt(attribute[i]) != 0)
{
oline.SetM_AttributeSetInstance_ID(Util.GetValueOfInt(attribute[i]));
}
if (!ord.IsSOTrx())
{
MProduct pro = new MProduct(ctx, oline.GetM_Product_ID(), null);
String qryUom = "SELECT vdr.C_UOM_ID FROM M_Product p LEFT JOIN M_Product_Po vdr ON p.M_Product_ID= vdr.M_Product_ID WHERE p.M_Product_ID=" + oline.GetM_Product_ID() + " AND vdr.C_BPartner_ID = " + ord.GetC_BPartner_ID();
int uom = Util.GetValueOfInt(DB.ExecuteScalar(qryUom));
if (pro.GetC_UOM_ID() != 0)
{
if (pro.GetC_UOM_ID() != uom && uom != 0)
{
decimal?Res = Util.GetValueOfDecimal(DB.ExecuteScalar("SELECT trunc(multiplyrate,4) FROM C_UOM_Conversion WHERE C_UOM_ID = " + pro.GetC_UOM_ID() + " AND C_UOM_To_ID = " + uom + " AND M_Product_ID= " + oline.GetM_Product_ID() + " AND IsActive='Y'"));
if (Res > 0)
{
oline.SetQtyEntered(oline.GetQtyEntered() * Res);
//OrdQty = MUOMConversion.ConvertProductTo(GetCtx(), _M_Product_ID, UOM, OrdQty);
}
else
{
decimal?res = Util.GetValueOfDecimal(DB.ExecuteScalar("SELECT trunc(multiplyrate,4) FROM C_UOM_Conversion WHERE C_UOM_ID = " + pro.GetC_UOM_ID() + " AND C_UOM_To_ID = " + uom + " AND IsActive='Y'"));
if (res > 0)
{
oline.SetQtyEntered(oline.GetQtyEntered() * res);
//OrdQty = MUOMConversion.Convert(GetCtx(), prdUOM, UOM, OrdQty);
}
}
oline.SetC_UOM_ID(uom);
}
else
{
oline.SetC_UOM_ID(pro.GetC_UOM_ID());
}
}
}
if (!oline.Save())
{
}
}
}
else if (keyColName.ToUpper().Trim() == "C_INVOICE_ID")
{
MInvoice inv = new MInvoice(ctx, recordID, null);
for (int i = 0; i < product.Count; i++)
{
MInvoiceLine invline = new MInvoiceLine(ctx, lineID, null);
invline.SetAD_Client_ID(inv.GetAD_Client_ID());
invline.SetAD_Org_ID(inv.GetAD_Org_ID());
invline.SetM_Product_ID(Util.GetValueOfInt(product[i]));
invline.SetQty(Util.GetValueOfDecimal(qty[i]));
invline.SetC_Invoice_ID(recordID);
if (Util.GetValueOfInt(attribute[i]) != 0)
{
invline.SetM_AttributeSetInstance_ID(Util.GetValueOfInt(attribute[i]));
}
if (!inv.IsSOTrx())
{
MProduct pro = new MProduct(ctx, invline.GetM_Product_ID(), null);
String qryUom = "SELECT vdr.C_UOM_ID FROM M_Product p LEFT JOIN M_Product_Po vdr ON p.M_Product_ID= vdr.M_Product_ID WHERE p.M_Product_ID=" + invline.GetM_Product_ID() + " AND vdr.C_BPartner_ID = " + inv.GetC_BPartner_ID();
int uom = Util.GetValueOfInt(DB.ExecuteScalar(qryUom));
if (pro.GetC_UOM_ID() != 0)
{
if (pro.GetC_UOM_ID() != uom && uom != 0)
{
decimal?Res = Util.GetValueOfDecimal(DB.ExecuteScalar("SELECT trunc(multiplyrate,4) FROM C_UOM_Conversion WHERE C_UOM_ID = " + pro.GetC_UOM_ID() + " AND C_UOM_To_ID = " + uom + " AND M_Product_ID= " + invline.GetM_Product_ID() + " AND IsActive='Y'"));
if (Res > 0)
{
invline.SetQtyEntered(invline.GetQtyEntered() * Res);
//OrdQty = MUOMConversion.ConvertProductTo(GetCtx(), _M_Product_ID, UOM, OrdQty);
}
else
{
decimal?res = Util.GetValueOfDecimal(DB.ExecuteScalar("SELECT trunc(multiplyrate,4) FROM C_UOM_Conversion WHERE C_UOM_ID = " + pro.GetC_UOM_ID() + " AND C_UOM_To_ID = " + uom + " AND IsActive='Y'"));
if (res > 0)
{
invline.SetQtyEntered(invline.GetQtyEntered() * res);
//OrdQty = MUOMConversion.Convert(GetCtx(), prdUOM, UOM, OrdQty);
}
}
invline.SetC_UOM_ID(uom);
}
else
{
invline.SetC_UOM_ID(pro.GetC_UOM_ID());
}
}
}
if (!invline.Save())
{
}
}
}
else if (keyColName.ToUpper().Trim() == "M_INOUT_ID")
{
MInOut inv = new MInOut(ctx, recordID, null);
if (ordID > 0)
{
inv.SetC_Order_ID(ordID);
}
if (inv.Save())
{
for (int i = 0; i < product.Count; i++)
{
MInOutLine ioline = new MInOutLine(ctx, lineID, null);
ioline.SetAD_Client_ID(inv.GetAD_Client_ID());
ioline.SetAD_Org_ID(inv.GetAD_Org_ID());
ioline.SetM_Product_ID(Util.GetValueOfInt(product[i]));
ioline.SetQty(Util.GetValueOfDecimal(qty[i]));
ioline.SetM_InOut_ID(recordID);
ioline.SetC_OrderLine_ID(Util.GetValueOfInt(oline_ID[i]));
ioline.SetM_Locator_ID(Util.GetValueOfInt(locID[i]));
if (Util.GetValueOfInt(attribute[i]) != 0)
{
ioline.SetM_AttributeSetInstance_ID(Util.GetValueOfInt(attribute[i]));
}
if (!inv.IsSOTrx())
{
MProduct pro = new MProduct(ctx, ioline.GetM_Product_ID(), null);
String qryUom = "SELECT vdr.C_UOM_ID FROM M_Product p LEFT JOIN M_Product_Po vdr ON p.M_Product_ID= vdr.M_Product_ID WHERE p.M_Product_ID=" + ioline.GetM_Product_ID() + " AND vdr.C_BPartner_ID = " + inv.GetC_BPartner_ID();
int uom = Util.GetValueOfInt(DB.ExecuteScalar(qryUom));
if (pro.GetC_UOM_ID() != 0)
{
if (pro.GetC_UOM_ID() != uom && uom != 0)
{
decimal?Res = Util.GetValueOfDecimal(DB.ExecuteScalar("SELECT trunc(multiplyrate,4) FROM C_UOM_Conversion WHERE C_UOM_ID = " + pro.GetC_UOM_ID() + " AND C_UOM_To_ID = " + uom + " AND M_Product_ID= " + ioline.GetM_Product_ID() + " AND IsActive='Y'"));
if (Res > 0)
{
ioline.SetQtyEntered(ioline.GetQtyEntered() * Res);
//OrdQty = MUOMConversion.ConvertProductTo(GetCtx(), _M_Product_ID, UOM, OrdQty);
}
else
{
decimal?res = Util.GetValueOfDecimal(DB.ExecuteScalar("SELECT trunc(multiplyrate,4) FROM C_UOM_Conversion WHERE C_UOM_ID = " + pro.GetC_UOM_ID() + " AND C_UOM_To_ID = " + uom + " AND IsActive='Y'"));
if (res > 0)
{
ioline.SetQtyEntered(ioline.GetQtyEntered() * res);
//OrdQty = MUOMConversion.Convert(GetCtx(), prdUOM, UOM, OrdQty);
}
}
ioline.SetC_UOM_ID(uom);
}
else
{
ioline.SetC_UOM_ID(pro.GetC_UOM_ID());
}
}
}
if (!ioline.Save())
{
}
}
}
}
else if (keyColName.ToUpper().Trim() == "M_PACKAGE_ID")
{
MPackage pkg = new MPackage(ctx, recordID, null);
for (int i = 0; i < product.Count; i++)
{
MPackageLine mline = new MPackageLine(ctx, lineID, null);
mline.SetAD_Client_ID(pkg.GetAD_Client_ID());
mline.SetAD_Org_ID(pkg.GetAD_Org_ID());
mline.SetM_Product_ID(Util.GetValueOfInt(product[i]));
mline.SetQty(Util.GetValueOfDecimal(qty[i]));
if (Util.GetValueOfInt(oline_ID[i]) > 0)
{
mline.SetM_MovementLine_ID(Util.GetValueOfInt(oline_ID[i]));
MMovementLine mov = new MMovementLine(ctx, Util.GetValueOfInt(oline_ID[i]), null);
mline.SetDTD001_TotalQty(mov.GetMovementQty());
}
if (Util.GetValueOfInt(attribute[i]) != 0)
{
mline.SetM_AttributeSetInstance_ID(Util.GetValueOfInt(attribute[i]));
}
mline.SetM_Package_ID(recordID);
if (!mline.Save())
{
}
}
}
else if (keyColName.ToUpper().Trim() == "M_INVENTORY_ID")
{
MInventory inv = new MInventory(ctx, recordID, null);
for (int i = 0; i < product.Count; i++)
{
MInventoryLine invline = new MInventoryLine(ctx, lineID, null);
invline.SetAD_Client_ID(inv.GetAD_Client_ID());
invline.SetAD_Org_ID(inv.GetAD_Org_ID());
invline.SetM_Locator_ID(Util.GetValueOfInt(locID[i]));
invline.SetM_Product_ID(Util.GetValueOfInt(product[i]));
invline.SetQtyCount(Util.GetValueOfDecimal(qty[i]));
invline.SetQtyBook(Util.GetValueOfDecimal(qtybook[i]));
invline.SetAsOnDateCount(Util.GetValueOfDecimal(qty[i]));
invline.SetOpeningStock(Util.GetValueOfDecimal(qtybook[i]));
invline.SetM_Inventory_ID(recordID);
if (Util.GetValueOfInt(attribute[i]) != 0)
{
invline.SetM_AttributeSetInstance_ID(Util.GetValueOfInt(attribute[i]));
}
else
{
invline.SetM_AttributeSetInstance_ID(0);
}
if (!invline.Save())
{
}
}
}
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 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 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 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);
}
}