Friday, December 30, 2016

Get Lastest Purchase price of an item ax 2012

private Price GetLatestPurchPrice(ItemId _item)
{
    InventItemPrice invItemprice;
    ;
    select firstOnly invItemprice order by RecId desc
        where invItemprice.ItemId == _item
            && invItemprice.PriceType == CostingVersionPriceType::Purch
                && invItemprice.CostingType == InventItemCostingType::Last;
   
    return  invItemprice.Price;
}

No comments:

Post a Comment

WMS Mobile app flow - Adding Detour fields for Process guided framework custom implementation

 WMS Mobile app flow => Adding Detour fields for Process guided framework custom implementation Before fix: Adding code fix to get thos r...