This question has been flagged
2 Replies
5027 Views

i've changed the decimal precision for the cost_price. i put it to 4. but, when I make a new purchase for a product, the calculation of the new cost_price is based on 2 decimals then it is displayed on 4 Decimals.

What can I do to adjust the problem?

Avatar
Discard
Author

An exple: having put the decimal precision "product price" and "account" to 4 and the method of calculating cost to "average price". I make simulation of a computing cost for Article X.

I start with qty in stock: 149 cost price = 340.8322

new acquisition: qty = 23 purchase price = 326.22

after receipt, result: qty = 172 cost = 338.8763

manual calculation I found: qty = 172 and cost = 338.8782 which is <> that gave OpenERP.

I round cost price to 2 and recalculate.I find the same value OpenERP: ((149 * 340.83 + 23 * 326.22) / (149 +23) = 338.8763 that's the pb

Best Answer

What is the currency you are using? I can imagine that when the currency is less than 4 (EURO for example is 2), it will show nothing more than 2, becuase that is what the currency is doing.

Avatar
Discard
Author

i use DZD. what can i do plz?

Author Best Answer

I prefer give An exple to explain the problem: having put the decimal precision "product price" and "account" to 4 and the method of calculating cost to "average price". I make simulation of a computing cost for Article X.

I start with qty in stock: 149 cost price = 340.8322

new acquisition: qty = 23 purchase price = 326.22

after receipt, result: qty = 172 cost = 338.8763

manual calculation I found: qty = 172 and cost = 338.8782 which is <> that gave OpenERP.

I round cost price to 2 and recalculate.I find the same value OpenERP: ((149 * 340.83 + 23 * 326.22) / (149 +23) = 338.8763

So, I feel OpenERP although the decimal precision is 4, it rounds to 2 before calculating which gives a false result

Avatar
Discard

have you modified the rounding factor of the currency? you might need to do that if you want your computations to be correct.