Still trying to make sense of this. Here is a method that is used in the InventItemPrice table. It finds the current item/priceType record from the table.
public static InventItemPrice findCurrent(
ItemId _itemId,
CostingVersionPriceType _priceType,
InventDimId _inventDimId,
TransDate _activationDate = systemDateGet(),
InventSiteId _newSiteId = '',
InventItemCostingType _costingType = InventItemCostingType::Default,
boolean _forUpdate = false
)
{
InventItemPrice inventItemPrice;
InventTable inventTable;
InventDim inventDim;
InventDim inventDimCriteria;
InventDimParm inventDimParm;
;
if (_itemId)
{
inventTable = InventTable::find(_itemId);
[inventDimParm, inventDimCriteria] = InventItemPrice::setupInventDimParmAndCriteria(inventTable, _inventDimId);
inventDimCriteria.InventSiteId = InventItemPrice::changeSiteId(inventDimCriteria.InventSiteId, _newSiteId);
inventItemPrice.selectForUpdate(_forUpdate);
select firstonly inventItemPrice
order by ActivationDate desc, CreatedDateTime desc
where inventItemPrice.ItemId == _itemId
&& inventItemPrice.PriceType == _priceType
&& inventItemPrice.ActivationDate <= _activationDate
&& (inventItemPrice.CostingType == _costingType || _costingType == InventItemCostingType::Default)
#InventDimExistsJoin(inventItemPrice.inventDimId, inventDim, inventDimCriteria, inventDimParm);
}
return inventItemPrice;
}
Is there a way I can use this in my AOT Query? Or am I going about this the wrong way?
In my old system, I would add a 'method' called (IsCurrent) to the table that would pass back either a Y or N, so I could bypass all the N's. Just don't know how to do the same thing with this setup. Too bad we can't learn like they do in The Matrix - but that was just a movie - I know -- wishful thinking on my part!
