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
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.
Do you mean the cost (value) of one unit of the inventory of an item (which, with the Weighted average model, is the running average cost of the inventory)?
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.
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)); } } }
André Arnaud de Cal... 291,391 Super User 2024 Season 2
Martin Dráb 230,445 Most Valuable Professional
nmaenpaa 101,156