/// <summary>
/// Shipment Line Constructor
/// </summary>
/// <param name="sLine">shipment line</param>
/// <param name="dateTrx">optional date</param>
/// <param name="qty">matched quantity</param>
public MMatchPO(MInOutLine sLine, DateTime?dateTrx, Decimal qty)
: this(sLine.GetCtx(), 0, sLine.Get_Trx())
{
SetClientOrg(sLine);
SetM_InOutLine_ID(sLine.GetM_InOutLine_ID());
SetC_OrderLine_ID(sLine.GetC_OrderLine_ID());
if (dateTrx != null)
{
SetDateTrx(dateTrx);
}
SetM_Product_ID(sLine.GetM_Product_ID());
SetM_AttributeSetInstance_ID(sLine.GetM_AttributeSetInstance_ID());
SetQty(qty);
SetProcessed(true); // auto
}
public void SetInoutLine(VAdvantage.Model.MInOutLine line)
{
int _CountDTD001 = Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(AD_MODULEINFO_ID) FROM AD_MODULEINFO WHERE PREFIX='DTD001_'"));
if (_CountDTD001 > 0)
{
SetM_InOutLine_ID(line.GetM_InOut_ID());
SetDTD001_TotalQty(line.GetMovementQty());
SetM_Product_ID(line.GetM_Product_ID());
SetM_AttributeSetInstance_ID(line.GetM_AttributeSetInstance_ID());
decimal totalPackQty = Util.GetValueOfDecimal(DB.ExecuteScalar("SELECT SUM(Qty) FROM M_PackageLine WHERE M_InOutLine_ID=" + GetM_InOutLine_ID()));
SetQty(line.GetMovementQty() - totalPackQty);
SetDTD001_AlreadyPackQty(totalPackQty);
SetConfirmedQty(line.GetMovementQty() - totalPackQty);
SetDTD001_ConfirmDate(System.DateTime.Now);
}
}
/// <summary>
/// Set Shipment Line
/// </summary>
/// <param name="line">line</param>
public void SetInOutLine(MInOutLine line, DateTime?moveDate, String DocumentNo, Int32 Client_ID, Int32 Org_ID)
{
SetM_InOutLine_ID(line.GetM_InOutLine_ID());
SetQty(line.GetMovementQty());
//Edited :Arpit Rai ,13 Sept,2017
//to Set Client,Org,Confirm Date,Confirm Date, Scrapped Qty, Difference Qty & Reference No
SetAD_Client_ID(Client_ID);
SetAD_Org_ID(Org_ID);
SetM_Product_ID(line.GetM_Product_ID());
SetM_AttributeSetInstance_ID(line.GetM_AttributeSetInstance_ID());
if (Util.GetValueOfInt(DB.ExecuteQuery("SELECT COUNT(AD_MODULEINFO_ID) FROM AD_MODULEINFO WHERE PREFIX='DTD001_' AND IsActive='Y'")) > 0
)
{
if (moveDate != null)
{
SetDTD001_ConfirmDate(moveDate);
}
SetDTD001_ReferenceNo(DocumentNo); //Set Reference No from MR/Shipment to package Lines
}
SetConfirmedQty(line.GetConfirmedQty());
SetScrappedQty(line.GetScrappedQty());
SetDifferenceQty(Decimal.Subtract(line.GetMovementQty(), line.GetConfirmedQty() + line.GetScrappedQty()));
//Arpit
}
/// <summary>
/// Process Confirmation Line.
/// - Update InOut Line
/// </summary>
/// <param name="isSOTrx">sales order</param>
/// <param name="confirmType">type</param>
/// <returns>success</returns>
public Boolean ProcessLine(bool isSOTrx, String confirmType)
{
MInOutLine line = GetLine();
// Customer
if (MInOutConfirm.CONFIRMTYPE_CustomerConfirmation.Equals(confirmType))
{
line.SetConfirmedQty(GetConfirmedQty());
}
// Drop Ship
else if (MInOutConfirm.CONFIRMTYPE_DropShipConfirm.Equals(confirmType))
{
}
// Pick or QA
else if (MInOutConfirm.CONFIRMTYPE_PickQAConfirm.Equals(confirmType))
{
line.SetTargetQty(GetTargetQty());
line.SetMovementQty(GetConfirmedQty()); // Entered NOT changed
line.SetPickedQty(GetConfirmedQty());
//
line.SetScrappedQty(GetScrappedQty());
}
// Ship or Receipt
else if (MInOutConfirm.CONFIRMTYPE_ShipReceiptConfirm.Equals(confirmType))
{
//Arpit
if (GetDifferenceQty() > 0)
{
GetCtx().SetContext("DifferenceQty_", VAdvantage.Utility.Util.GetValueOfString(GetDifferenceQty()));
}
MProduct _pro = new MProduct(GetCtx(), line.GetM_Product_ID(), Get_TrxName());
if (_pro.GetC_UOM_ID() != line.GetC_UOM_ID())
{
decimal?pc = null;
pc = MUOMConversion.ConvertProductFrom(GetCtx(), line.GetM_Product_ID(), GetC_UOM_ID(), GetTargetQty());
line.SetTargetQty(Util.GetValueOfDecimal(pc)); //TargetQty
Decimal qty = GetConfirmedQty();
Boolean isReturnTrx = line.GetParent().IsReturnTrx();
/* In PO receipts and SO Returns, we have the responsibility
* for scrapped quantity
*/
if ((!isSOTrx && !isReturnTrx) || (isSOTrx && isReturnTrx))
{
qty = Decimal.Add(qty, GetScrappedQty());
}
pc = MUOMConversion.ConvertProductFrom(GetCtx(), line.GetM_Product_ID(), GetC_UOM_ID(), qty);
line.SetMovementQty(Util.GetValueOfDecimal(pc)); //MovementQty
pc = MUOMConversion.ConvertProductFrom(GetCtx(), line.GetM_Product_ID(), GetC_UOM_ID(), GetScrappedQty());
line.SetScrappedQty(Util.GetValueOfDecimal(pc)); //ScrappedQty
pc = MUOMConversion.ConvertProductFrom(GetCtx(), line.GetM_Product_ID(), GetC_UOM_ID(), GetConfirmedQty());
line.SetConfirmedQty(Util.GetValueOfDecimal(pc)); //confirm Qty
}
else
{
line.SetTargetQty(GetTargetQty());
Decimal qty = GetConfirmedQty();
Boolean isReturnTrx = line.GetParent().IsReturnTrx();
/* In PO receipts and SO Returns, we have the responsibility
* for scrapped quantity
*/
if ((!isSOTrx && !isReturnTrx) || (isSOTrx && isReturnTrx))
{
qty = Decimal.Add(qty, GetScrappedQty());
}
line.SetMovementQty(qty); // Entered NOT changed
//
line.SetScrappedQty(GetScrappedQty());
// vikas 12/28/2015 Mantis Issue (0000335)
line.SetConfirmedQty(GetConfirmedQty());
}
}
// Vendor
else if (MInOutConfirm.CONFIRMTYPE_VendorConfirmation.Equals(confirmType))
{
line.SetConfirmedQty(GetConfirmedQty());
}
return(line.Save(Get_TrxName()));
}
/**
* 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());
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);
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);
//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());
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 += "??";
}
}
