How to Revalue Inventory in Odoo 16

In this video, I detail how to revalue your inventory in Odoo 16. In order to revalue your inventory you must utilize automated inventory valuation. Navigate to the Stock Valuation menu in reporting then group your items by product. As a result, once you hover over your product group a button will appear to revalue your inventory item. You will need to set a reason, accounting date, and counterpart account. Once submitted a journal entry will be created and your inventory will be revalued.

[miguelmendoza]

Man you have the best tutorials keep it up it really helps!

[delbudge]

Hi Kevin, Great video once again. I have a couple of questions, if you wouldn't mind taking a look:
1)If you select an accounting date in the past, will there be a mismatch between the Inventory Date and the Accounting Date? For example, if today is 3/21/2023 and I select an accounting date of 3/1/2023, will my GL show an entry on 3/1/2023 but my inventory valuation report show 3/21/2023? I remember in a previous version that you needed to ensure the inventory and accounting date matched, otherwise you'll have a variance between your GL and your inventory reports.
2) If we are tracking inventory by specific lots, and each of those lots have their own value, does this method allow us to revalue a specific lot? Or does this only work at the SKU level?

[jacowaes]

Thank you so much for doing this request !! works in 15 just as well.

[cedriceveleigh]

I don't see the menu item shown in the video of Inventory > Reporting > Valuation. I checked the settings and didn't find a solution there.

[joietan]

Hello Kevin, thank you for helpful video. Isn't it easier just to change the cost from product form, I tried it on odoo 16 and it creates correct inventory valuation entry as well. What is you consideration for creating through the Stock Valuation page instead of directly on Product Form ?

[hasanelamin]

Hello Kevin, thank you for amazing illustration . I understand that when using AVCO for inventory evaluation the cost of one product cost will be unified in all location/warehouse, my question how can we make each product in each location /warehouse has independent cost ?

[bennyyeung]

How about SCRAP the product due to damaged, the COGS and calculate the margin on sales order refecting the inventory changed at same cost.