/// <summary>
/// GetMInOutLine
/// </summary>
/// <param name="ctx"></param>
/// <param name="fields"></param>
/// <returns></returns>
public Dictionary <string, string> GetMInOutLine(Ctx ctx, string fields)
{
string[] paramValue = fields.Split(',');
//Assign parameter value
int Orig_InOutLine_ID = Util.GetValueOfInt(paramValue[0].ToString());
//End Assign parameter value
MInOutLine ioLine = new MInOutLine(ctx, Orig_InOutLine_ID, null);
Dictionary <string, string> result = new Dictionary <string, string>();
result["M_Locator_ID"] = ioLine.GetM_Locator_ID().ToString();
result["MovementQty"] = ioLine.GetMovementQty().ToString();
result["C_Project_ID"] = ioLine.GetC_Project_ID().ToString();
result["C_Campaign_ID"] = ioLine.GetC_Campaign_ID().ToString();
result["M_Product_ID"] = ioLine.GetM_Product_ID().ToString();
result["M_AttributeSetInstance_ID"] = ioLine.GetM_AttributeSetInstance_ID().ToString();
result["C_UOM_ID"] = ioLine.GetC_UOM_ID().ToString();
result["IsDropShip"] = ioLine.IsDropShip() ? "Y" : "N";
// JID_1310: On Selection of Shipment line on Customer/Vendor RMA. System should check Total Delivred - Total Return Qty From Sales PO line and Balance show in qty field
decimal qtyRMA = Util.GetValueOfDecimal(DB.ExecuteScalar(@"SELECT SUM(QtyEntered) FROM C_Order o INNER JOIN C_OrderLine ol ON o.C_Order_ID = ol.C_Order_ID
WHERE ol.Orig_InOutLine_ID = " + Orig_InOutLine_ID
+ @" AND ol.Isactive = 'Y' AND o.docstatus NOT IN ('RE' , 'VO')", null, null));
decimal QtyNotDelivered = ioLine.GetQtyEntered() - qtyRMA;
result["QtyEntered"] = QtyNotDelivered.ToString();
//retlst.Add(retValue);
return(result);
}
/// <summary>
/// GetMInOutLine
/// </summary>
/// <param name="ctx"></param>
/// <param name="fields"></param>
/// <returns></returns>
public Dictionary <string, string> GetMInOutLine(Ctx ctx, string fields)
{
string[] paramValue = fields.Split(',');
//Assign parameter value
int Orig_InOutLine_ID = Util.GetValueOfInt(paramValue[0].ToString());
//End Assign parameter value
MInOutLine ioLine = new MInOutLine(ctx, Orig_InOutLine_ID, null);
Dictionary <string, string> result = new Dictionary <string, string>();
result["M_Locator_ID"] = ioLine.GetM_Locator_ID().ToString();
result["MovementQty"] = ioLine.GetMovementQty().ToString();
result["C_Project_ID"] = ioLine.GetC_Project_ID().ToString();
result["C_Campaign_ID"] = ioLine.GetC_Campaign_ID().ToString();
result["M_Product_ID"] = ioLine.GetM_Product_ID().ToString();
result["M_AttributeSetInstance_ID"] = ioLine.GetM_AttributeSetInstance_ID().ToString();
result["C_UOM_ID"] = ioLine.GetC_UOM_ID().ToString();
//retlst.Add(retValue);
return(result);
}
/**
* Shipment Constructor
* @param shipment shipment
* @param shipLine shipment line
* @param deliveryCount 0 or number of delivery
*/
public MAsset(MInOut shipment, MInOutLine shipLine, int deliveryCount)
: this(shipment.GetCtx(), 0, shipment.Get_TrxName())
{
SetClientOrg(shipment);
SetValueNameDescription(shipment, shipLine, deliveryCount);
// Header
//SetIsOwned(true);
SetC_BPartner_ID(shipment.GetC_BPartner_ID());
SetC_BPartner_Location_ID(shipment.GetC_BPartner_Location_ID());
SetAD_User_ID(shipment.GetAD_User_ID());
SetM_Locator_ID(shipLine.GetM_Locator_ID());
SetIsInPosession(true);
SetAssetServiceDate(shipment.GetDateAcct());
// Line
VAdvantage.Model.MProduct product = shipLine.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(), shipment.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_' "));
Set_Value("VAFAM_AssetType", _assetGroup.Get_Value("VAFAM_AssetType").ToString());
if (countVA038 > 0)
{
Set_Value("VA038_AmortizationTemplate_ID", VAdvantage.Utility.Util.GetValueOfInt(_assetGroup.Get_Value("VA038_AmortizationTemplate_ID")));
}
Set_Value("VAFAM_DepreciationType_ID", VAdvantage.Utility.Util.GetValueOfInt(_assetGroup.Get_Value("VAFAM_DepreciationType_ID")));
////////////////////////////////////
// Guarantee & Version
SetGuaranteeDate(TimeUtil.AddDays(shipment.GetMovementDate(), product.GetGuaranteeDays()));
SetVersionNo(product.GetVersionNo());
if (shipLine.GetM_AttributeSetInstance_ID() != 0) // Instance
{
MAttributeSetInstance asi = new MAttributeSetInstance(GetCtx(), shipLine.GetM_AttributeSetInstance_ID(), Get_TrxName());
SetM_AttributeSetInstance_ID(asi.GetM_AttributeSetInstance_ID());
SetLot(asi.GetLot());
SetSerNo(asi.GetSerNo());
}
SetHelp(shipLine.GetDescription());
// Qty
int units = product.GetSupportUnits();
if (units == 0)
{
units = 1;
}
if (deliveryCount != 0) // one asset per UOM
{
SetQty(shipLine.GetMovementQty(), units);
}
else
{
SetQty((Decimal)units);
}
SetM_InOutLine_ID(shipLine.GetM_InOutLine_ID());
// Activate
MAssetGroup ag = MAssetGroup.Get(GetCtx(), GetA_Asset_Group_ID());
if (!ag.IsCreateAsActive())
{
SetIsActive(false);
}
}
/**
* Create Difference Document
* @param inout shipment/receipt
* @param confirm confirm line
* @return true if created
*/
private bool CreateDifferenceDoc(MInOut inout, MInOutLineConfirm confirm)
{
if (_processMsg == null)
{
_processMsg = "";
}
else if (_processMsg.Length > 0)
{
_processMsg += "; ";
}
// Credit Memo if linked Document
if (Env.Signum(confirm.GetDifferenceQty()) != 0 &&
!inout.IsSOTrx() && !inout.IsReturnTrx() && inout.GetRef_InOut_ID() != 0)
{
log.Info("Difference=" + confirm.GetDifferenceQty());
if (_creditMemo == null)
{
_creditMemo = new MInvoice(inout, null);
_creditMemo.SetDescription(Msg.Translate(GetCtx(),
"M_InOutConfirm_ID") + " " + GetDocumentNo());
_creditMemo.SetC_DocTypeTarget_ID(MDocBaseType.DOCBASETYPE_APCREDITMEMO);
if (!_creditMemo.Save(Get_TrxName()))
{
_processMsg += "Credit Memo not created";
return(false);
}
SetC_Invoice_ID(_creditMemo.GetC_Invoice_ID());
}
MInvoiceLine line = new MInvoiceLine(_creditMemo);
line.SetShipLine(confirm.GetLine());
line.SetQty(confirm.GetDifferenceQty()); // Entered/Invoiced
if (!line.Save(Get_TrxName()))
{
_processMsg += "Credit Memo Line not created";
return(false);
}
confirm.SetC_InvoiceLine_ID(line.GetC_InvoiceLine_ID());
}
// Create Inventory Difference
if (Env.Signum(confirm.GetScrappedQty()) != 0)
{
log.Info("Scrapped=" + confirm.GetScrappedQty());
if (_inventory == null)
{
MWarehouse wh = MWarehouse.Get(GetCtx(), inout.GetM_Warehouse_ID());
_inventory = new MInventory(wh);
_inventory.SetDescription(Msg.Translate(GetCtx(),
"M_InOutConfirm_ID") + " " + GetDocumentNo());
//vikas new 13 jan 2016 1
_inventory.SetIsInternalUse(true);
if (_inventory.GetC_DocType_ID() == 0)
{
MDocType[] types = MDocType.GetOfDocBaseType(GetCtx(), MDocBaseType.DOCBASETYPE_MATERIALPHYSICALINVENTORY);
if (types.Length > 0)
{
// Get Internal Use Inv Doc Type
for (int i = 0; i < types.Length; i++)
{
int _count = Util.GetValueOfInt(DB.ExecuteScalar("SELECT Count(*) FROM C_DocType WHERE IsActive='Y' AND IsInternalUse='Y' AND C_DocType_ID=" + types[i].GetC_DocType_ID()));
if (_count > 0)
{
_inventory.SetC_DocType_ID(types[i].GetC_DocType_ID());
break;
}
}
}
else
{
log.SaveError("Error", Msg.ParseTranslation(GetCtx(), "@NotFound@ @C_DocType_ID@"));
return(false);
}
}
// 13 jan End
if (!_inventory.Save(Get_TrxName()))
{
_processMsg += "Inventory not created";
return(false);
}
SetM_Inventory_ID(_inventory.GetM_Inventory_ID());
}
MInOutLine ioLine = confirm.GetLine();
MInventoryLine line = new MInventoryLine(_inventory,
ioLine.GetM_Locator_ID(), ioLine.GetM_Product_ID(),
ioLine.GetM_AttributeSetInstance_ID(),
confirm.GetScrappedQty(), Env.ZERO);
//new 15 jan
line.SetQtyInternalUse(line.GetQtyBook());
line.SetQtyBook(0);
line.SetIsInternalUse(true);
Tuple <String, String, String> mInfo = null;
if (Env.HasModulePrefix("DTD001_", out mInfo))
{
int _charge = Util.GetValueOfInt(DB.ExecuteScalar("SELECT C_Charge_ID FROM C_Charge WHERE isactive='Y' AND DTD001_ChargeType='INV'"));
line.SetC_Charge_ID(_charge);
}
// End
if (!line.Save(Get_TrxName()))
{
_processMsg += "Inventory Line not created";
return(false);
}
confirm.SetM_InventoryLine_ID(line.GetM_InventoryLine_ID());
}
//
if (!confirm.Save(Get_TrxName()))
{
_processMsg += "Confirmation Line not saved";
return(false);
}
return(true);
}
/**
* Split Shipment into confirmed and dispute
* @param original original shipment
* @param C_DocType_ID target DocType
* @param confirmLines confirm lines
*/
private void SplitInOut(MInOut original, int C_DocType_ID, MInOutLineConfirm[] confirmLines)
{
MInOut split = new MInOut(original, C_DocType_ID, original.GetMovementDate());
split.AddDescription("Splitted from " + original.GetDocumentNo());
split.SetIsInDispute(true);
// new 13 jan
int _count = Util.GetValueOfInt(DB.ExecuteScalar("SELECT count(*) FROM AD_Column clm INNER JOIN ad_table tbl on (tbl.ad_table_id=clm.ad_table_id) where tbl.tablename='M_InOutLineConfirm' and clm.columnname = 'M_Locator_ID' "));
//nnayak : Change for bug 1431337
split.SetRef_InOut_ID(original.Get_ID());
if (!split.Save(Get_TrxName()))
{
throw new Exception("Cannot save Split");
}
original.AddDescription("Split: " + split.GetDocumentNo());
if (!original.Save(Get_TrxName()))
{
throw new Exception("Cannot update original Shipment");
}
// Go through confirmations
for (int i = 0; i < confirmLines.Length; i++)
{
MInOutLineConfirm confirmLine = confirmLines[i];
Decimal differenceQty = confirmLine.GetDifferenceQty();
if (differenceQty.CompareTo(Env.ZERO) == 0)
{
continue;
}
//
MInOutLine oldLine = confirmLine.GetLine();
log.Fine("Qty=" + differenceQty + ", Old=" + oldLine);
//
MInOutLine splitLine = new MInOutLine(split);
splitLine.SetC_OrderLine_ID(oldLine.GetC_OrderLine_ID());
splitLine.SetC_UOM_ID(oldLine.GetC_UOM_ID());
splitLine.SetDescription(oldLine.GetDescription());
splitLine.SetIsDescription(oldLine.IsDescription());
splitLine.SetLine(oldLine.GetLine());
splitLine.SetM_AttributeSetInstance_ID(oldLine.GetM_AttributeSetInstance_ID());
//new 13 jan vikas ,assigne by surya sir
if (_count > 0)
{
if (confirmLine.GetM_Locator_ID() > 0)
{
splitLine.SetM_Locator_ID(confirmLine.GetM_Locator_ID());
}
else
{
splitLine.SetM_Locator_ID(oldLine.GetM_Locator_ID());
}
}
else
{
splitLine.SetM_Locator_ID(oldLine.GetM_Locator_ID());
}
//End
// splitLine.SetM_Locator_ID(oldLine.GetM_Locator_ID());
splitLine.SetM_Product_ID(oldLine.GetM_Product_ID());
splitLine.SetM_Warehouse_ID(oldLine.GetM_Warehouse_ID());
splitLine.SetRef_InOutLine_ID(oldLine.GetRef_InOutLine_ID());
splitLine.AddDescription("Split: from " + oldLine.GetMovementQty());
// Qtys
splitLine.SetQty(differenceQty); // Entered/Movement
if (!splitLine.Save(Get_TrxName()))
{
throw new Exception("Cannot save Split Line");
}
// Old
oldLine.AddDescription("Splitted: from " + oldLine.GetMovementQty());
oldLine.SetQty(Decimal.Subtract(oldLine.GetMovementQty(), differenceQty));
if (!oldLine.Save(Get_TrxName()))
{
throw new Exception("Cannot save Splited Line");
}
// Update Confirmation Line
confirmLine.SetTargetQty(Decimal.Subtract(confirmLine.GetTargetQty(), differenceQty));
confirmLine.SetDifferenceQty(Env.ZERO);
if (!confirmLine.Save(Get_TrxName()))
{
throw new Exception("Cannot save Split Confirmation");
}
} // for all confirmations
_processMsg = "Split @M_InOut_ID@=" + split.GetDocumentNo()
+ " - @M_InOutConfirm_ID@=";
// Create Dispute Confirmation
split.ProcessIt(DocActionVariables.ACTION_PREPARE);
// split.createConfirmation();
split.Save(Get_TrxName());
MInOutConfirm[] splitConfirms = split.GetConfirmations(true);
if (splitConfirms.Length > 0)
{
int index = 0;
if (splitConfirms[index].IsProcessed())
{
if (splitConfirms.Length > 1)
{
index++; // try just next
}
if (splitConfirms[index].IsProcessed())
{
_processMsg += splitConfirms[index].GetDocumentNo() + " processed??";
return;
}
}
splitConfirms[index].SetIsInDispute(true);
splitConfirms[index].Save(Get_TrxName());
_processMsg += splitConfirms[index].GetDocumentNo();
// Set Lines to unconfirmed
MInOutLineConfirm[] splitConfirmLines = splitConfirms[index].GetLines(false);
for (int i = 0; i < splitConfirmLines.Length; i++)
{
MInOutLineConfirm splitConfirmLine = splitConfirmLines[i];
splitConfirmLine.SetScrappedQty(Env.ZERO);
splitConfirmLine.SetConfirmedQty(Env.ZERO);
splitConfirmLine.Save(Get_TrxName());
}
}
else
{
_processMsg += "??";
}
}
/// <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);
}
}
