You’re offline. This is a read only version of the page.
I want to view the product's unit cost (Item Model Group set to Weighted Average)
where do i view the Item Unit Cost in AX ?
*This post is locked for comments
All items cost in inventory + logic behind standard cost.
Hi
you can see the Cost Amount (weighted average of Items) in Inventory Management module.
Do you want some kind of reports or what?
Regards
Adineh
if i understand you ,if you ask about unit cost for every transaction ?!
you can go to inventory and warehouse management /inquires / transaction form .
you will find unit cost for every transaction
Hi,
Please use the following job/code to get the product's unit cost which has item model group as a weighted average. Let me know if anything is missing.
Share
Report
All responses (
Answers (
static void itemModelGroup(Args _args)
{
InventTable inventTable;
EcoResProduct ecoResProduct;
InventModelGroup inventModelGroup;
InventModelGroupItem inventModelGroupItem;
InventItemPrice inventItemPrice;
InventDim inventDim;
while select * from inventTable
where inventTable.ItemId == "XYZ"
join ecoResProduct
where inventTable.Product == ecoResProduct.RecId
join ModelGroupId from inventModelGroupItem
where inventModelGroupItem.ItemDataAreaId == InventTable.dataAreaId
&& inventModelGroupItem.ItemId == InventTable.ItemId
join inventModelGroup
where inventModelGroupItem.ModelGroupDataAreaId == inventModelGroup.dataAreaId
&& inventModelGroupItem.ModelGroupId == inventModelGroup.ModelGroupId
&& inventModelGroup.InventModel == InventModel::AverageCost // Weighted avg
{
select firstOnly inventItemPrice
order by ActivationDate desc
where inventItemPrice.ItemId == inventTable.ItemId
&& inventItemPrice.PriceType == CostingVersionPriceType::Cost
join inventDim
where inventItemPrice.InventDimId == inventDim.inventDimId;
if (inventItemPrice)
{
info(strFmt("Item: %1, ModelGroup: %2, Cost: %3, Price: %4", inventItemPrice.ItemId, inventModelGroupItem.ModelGroupId, inventItemPrice.CostingType, inventItemPrice.Price));
}
}
}
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,219
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156