跳至內容
選單
此問題已被標幟
2 回覆
5720 瀏覽次數

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?

頭像
捨棄
作者

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

最佳答案

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.

頭像
捨棄
作者

i use DZD. what can i do plz?

作者 最佳答案

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

頭像
捨棄

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