Odoo Help


How to get Real Price to update on receipt of goods not on sale of goods

on 2/9/15, 8:14 AM 1,242 views


I would like to have the cost price update after receipt of goods.  Average price works but Real Price (preferred) only updates after sale of the goods.  This leads to an accounting discrepency and also means the sales pricelists dont function as expected.  Full example below:

Odoo V8
Anglo Saxxon Accounting
Product set to Real Price + Real Time (Automated)

Purchase product A for $100.
Purchase an additional Product A for $200.

Now if you look at the cost price for the product it will still be $100.
You sell the first product A, the cost is accounted as $100.  After the sale the product cost remains $100. (Balanced)

You sell the second product A.  The cost will be accounted as $100 leaving a $100 discrepency.  Now when you check the product cost it will have updated to $200. 

How can I get the product cost to update BEFORE sale of the goods?

Thank you.

Just for clarification, why you do not use the average costing method instead of the real costing you use?

Rami Talat
on 2/14/15, 9:49 PM
Due to significant currency fluctuations it is far more efficient for us to use real cost with FIFO.  For example we have some products that have increased in cost by 30% since January.  So using average cost we would either have to make many adjustments or sell items below cost.  We could get away with last cost but I cannot see a way of having that automatically update from purchase orders.
on 2/14/15, 9:58 PM
Emad Jaddo
On 4/4/15, 7:07 AM

We are actually facing a similar situation.

Odoo V8

Anglo Saxxon Accounting

Product set to Average price + Real Time (Automated)

Product Category is set FIFO

First buy a one unit of a product for $1000. cost get update to $1000. Next you get another unit for free, cost remains $1000 (Which is totally wrong of course).

Next try to sell 1 unit, cost of the product remains $1000. accounting entry passed for COGS @ $1000 (which is correct).

Try to sell the other unit and the product cost remains $1000 and accounting entry is passed @ $1000 for COGS? How come?????

this is a serious bug in the system and when dealing with hundreds of products and many daily transaction it is easy to have totally wrong accounting entries in the system and wrong financials as well.

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)


Asked: 2/9/15, 8:14 AM
Seen: 1242 times
Last updated: 8/2/16, 3:30 AM