How NAV/BC calculates the Unit Cost on the Item Card.

In Dynamics 365 Nav/BC, At Item Card there is One flow field "Unit Cost".

No alt text provided for this image

There's a Myth that Unit Cost value update based on Costing Method, it has nothing to do with Costing Method.

* Unit Cost works on Weighted Average. It's Formulae is:

Unit Cost = ( Cost Amount (Actual) + Cost Amount (Expected)) / Item ledger Qty.

Let us Understand with example, how system calculating this field Value. Here I have taken the Transaction scenario.

No alt text provided for this image

Value Entries:

No alt text provided for this image

Item Ledger Entries:

No alt text provided for this image

Updated Unit Cost at Item Card:

No alt text provided for this image

To get the track of Weighted Avg. Calculation, click on the Unit Cost Value, system will take you directly to Average Cost Calc. Overview Page.

No alt text provided for this image

END

Hope this will help.

Thanks for reading.

要查看或添加评论,请登录

Aman Kumar的更多文章

社区洞察

其他会员也浏览了