Inventory closing (Weighted average) - Inventory accounting in Microsoft Dynamics 365 for FinOps

[@upcomingvictory]

Excellent explanation. As you said, trainers are not giving in detail explanation how cost is calculating in system at different stages and how it is accumulating at the time of closing. All the best for future videos 👍

[@maryamhagh4816]

Thank you sir! Excellent explanation!

[@gopalthorve09]

Thanks for watching. Please subscribe the channel.

[@anandkumar4813]

Sir grt videos...

[@happyeverysingleday606]

I have question is inventory value balance must be equal to Inventory value in Aging Report? Thanks

[@gopalthorve09]

I don't think that's always the case. Inventory value report should always match with the trial balance. I have most of the time seen differences in inventory aging value and TB in cases of Inventory models Weighted average and weighted average date. In cases of clients using Moving average and Standard invent models it always matches.

[@rismahidajat]

Hi Gopal, I’d like to ask why in my inventory value report, there is items with 0 qty but has value amount? and i’m using weighted average

[@gopalthorve09]

Hi Risma, Zero quantity with negative or positive value is a very common phenomenon in Dynamics AX World, specially in case of Weighted average valuation methods. It's not only about this but it also impacts inventory valuation of items having stock. This happens because of following: Assume you received (Product receipt) one quantity of an item at 10. When the quantity is consumed the consumption cost will be the on-hand running cost of the item i.e. 10. Now if you generate the inventory value report you will see zero quantity with zero amount. After few days you are invoicing the Product receipt at 12 before Closing/Recalculating the inventory. Generate the inventory value report now it will show zero quantity but value of 2 in the report. To avoid this you need to Close or Recalculate your inventory, during the closing/recalculation process the additional value of 2 will be adjusted on the consumption transaction and then you will have the correct inventory. The same can happen on negative side also i.e. if you invoice the Product receipt at lesser cost than the Product receipt cost.

[@ShabirAhmad-lw4yq]

Thanks for your videos, please start finance side as well. One thing if you will upload videos on Retail side as well.

[@ShabirAhmad-lw4yq]

@@gopalthorve09 Thanks for your reply, i watched your videos and you have good experience but fianance modules i need.One have you worked on Transport Management Module that is also my target if you have any idea or link etc

[@guptaadarsh10]

Magnificent

[@gopalthorve09]

Thank you 😊

[@SaiKumar-et5fo]

Hi i want to close inventory for specific item.is it possible? And i want to cancel the inventory closing. Can u give me suggestions

[@gopalthorve09]

You can not close the inventory for specific items. For cancelation of inventory closing, you can find the Cancel button on Closing and adjustment form.