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
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)); } } }
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
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
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)?
All items cost in inventory + logic behind standard cost.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Tocauer 4
Alexey Lekanov 3
Willem van Duren 2
