Translate

Sunday, January 12, 2020

Get Batch Reserve Quantity with Item Id Unit Conversion

The code below returns the batch-reserved quantity with unit conversion based on the item's unit setup. If unit conversion is not required, use the method without conversion logic.

/// <summary>

/// Get reserve physical Quantity
/// </summary>
/// <param name = "_salesLine">Sales line</param>
/// <returns>Reserve physical Qty</returns>
public InventQtyReservPhysical getReservedPhysicalQty(SalesLine  _salesLine)
{
    InventQtyReservPhysical inventQtyReservPhysical;
    if(_salesLine!=null)
    {
        InventTable inventTable = InventTable::find(_salesLine.ItemId);
        inventQtyReservPhysical = decRound(UnitOfMeasureConverter::convert(_salesLine.reservedPhysical(),
        UnitOfMeasure::unitOfMeasureIdBySymbol(inventTable.inventUnitId()),
        UnitOfMeasure::unitOfMeasureIdBySymbol(_salesLine.SalesUnit),
        NoYes::No,
        InventTable::itemProduct(inventTable.ItemId),
        NoYes::No), 
        0);
    }
    return inventQtyReservPhysical;
}