Pages

Banner 468 x 60px

 

Monday, March 27, 2017

Get Last Price in AX 2012

0 comments
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;

}

0 comments:

A financial dimension value is based on the record and has been used on a transaction. You cannot delete the record

  SOLUTION delete in table DimensionAttributeLevelValue base on Bank Account  :  and Delete the Bank Account FINISH