Skip to Content
This question has been flagged
1 Reply
251 Views
Avatar
Christopher Chong

Hello Oddoers,


I am testing Odoo 19 for my main DB migration and I facing some issues with the Inventory Valuation.

For Context:
- I used a trial version and re-uploaded my data to the test ver. 19 DB.
- Set up my valuation as perpetual and used the default accounts suggested by Odoo.
Cost Method: AVCO
Valuation Account: Inventory (
Journal: Inventory Valuation
Variation Account: Stock Variation
- Defined all my product categories with Perpetual

Problem:
- When I do a sample purchase (set with a 3-step process), the value of the good is not updated in the move analysis, stock, etc. Basically, the valuation on the product is recorded in the inventory valuation. Even after I post the bill, the valuation of the product I purchased is still 0.

- Looking at the Inventory Valuation Review in the Accounting App.
Here are the results
Product When received
Initial Balance -- 999
​Inventory -- 999

Stock Variation-- 999
​Inventory (Cr.) --- 999
​Stock Variation (Dr.) --- 999

Closing --- 0.00

This is the case when I receive the product or have it billed. I think there is something wrong with the configuration because when I compared the videos online I notice that for stock variations, they get a different entry. That is,

Stock Variation-- 999
Stock Variation (Cr.) --- 999
Inventory (Dr.) --- 999
Closing --- 999

How can I fix this?

Avatar
Discard
Pinky Shah

This should work as expected. Please verify the Product Category configuration.

Ray Carnes (ray)

What is the Product Type and the value of Track Inventory for the Product(s) you are testing with?

Christopher Chong
Author

Product Type are goods

Track Inventory is checked and tacked by lots with expiration.

Ray Carnes (ray)

I would suggest discussing with Odoo Support - odoo.com/help - so they can do a deep dive on your configuration.

Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer
Hi,

This issue is not caused by AVCO itself, but by a configuration problem in inventory valuation when using perpetual valuation with a 3-step purchase flow in Odoo 19. In this setup, stock value is not finalized at the time of receipt; it is only confirmed when the vendor bill is posted and correctly linked to the receipt.

The zero closing valuation you are seeing indicates that Inventory and Stock Variation accounts are canceling each other out. This typically happens when the Stock Interim (Received) and Stock Interim (Delivered) accounts are missing, incorrectly configured, or reused as Inventory or Stock Variation accounts.

To fix this, review the product category configuration carefully. Ensure that Cost Method is AVCO, Inventory Valuation is Perpetual, and that separate accounts are defined for Inventory, Stock Interim (Received), and Stock Interim (Delivered). These interim accounts must be different from the Stock Variation account.

With a correct setup, the receipt posts values to the Stock Interim account, and posting the vendor bill moves the value from the interim account to Inventory. This results in a non-zero closing valuation that correctly reflects the on-hand stock value in Odoo 19.

Hope it helps

Avatar
Discard
Ray Carnes (ray)

1. The original post states "Even after I post the bill, the valuation of the product I purchased is still 0."
2. The Stock Interim Accounts do not exist in Odoo 19
3. This answer (probably from an AI tool) is mixing information from different versions

If you are not prepare to check the accuracy of your answers, please stop posting them