Odoo Help

Welcome!

This community 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.

0

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

By
Morgan
on 2/9/15, 8:14 AM 868 views

Hello,

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.
Morgan
on 2/14/15, 9:58 PM
0
Emad Jaddou
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.



Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

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