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

Thanks for watching. Please subscribe the channel.

@@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

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.

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

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.

Thank you 😊

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.