Pages

Monday, March 27, 2017

Get Last Price in AX 2012

public static Price TIDgetSTDCostItemPrice(ItemId _itemId,TransDate _activationDate,InventSiteId _inventSiteId)
{
    InventDim       InventDimLoc;
    InventItemPrice inventItemPriceLoc;
     
    InventDimLoc.clear();
    InventDimLoc.InventSiteId = _inventSiteId;
    InventDimLoc = InventDim::findOrCreate(InventDimLoc);
     
    inventItemPriceLoc = InventItemPrice::findCurrent(_itemId,CostingVersionPriceType::Cost,InventDimLoc.inventDimId,_activationDate,_inventSiteId,InventItemCostingType::Standard);
     
    return inventItemPriceLoc.Price;
}


oR

public static Price Addit_getSTDCostItemPrice(ItemId _itemId = 'A010001001',TransDate _activationDate = systemDateGet(),InventSiteId _inventSiteId = 'KSR')
{
    InventDim       InventDimLoc;
    InventItemPrice inventItemPriceLoc;

    InventDimLoc.clear();
    InventDimLoc.InventSiteId = _inventSiteId;
    InventDimLoc = InventDim::findOrCreate(InventDimLoc);

    inventItemPriceLoc = InventItemPrice::findCurrent(_itemId,CostingVersionPriceType::Cost,InventDimLoc.inventDimId,
                                                      _activationDate,_inventSiteId,InventItemCostingType::Last);

    info(strFmt("%1", inventItemPriceLoc.Price));

    return inventItemPriceLoc.Price;

}

No comments:

Post a Comment

Give me feedback.