تخطي للذهاب إلى المحتوى
القائمة
لقد تم الإبلاغ عن هذا السؤال
2 الردود
4833 أدوات العرض

Hi,

As my vendors seem to use a higher precision on the price of their products, I chainget the product precision to 6. This works now fine when no Tax is in the calculation, so 5x 8,0546 is correctly 40,27, instead of 40,25.

But now I have the problem that it seems for TAX calculation only two digits are used from the product price. E.g. 5,825 + 20% TAX results to 7 instead of 6,99. (see attached screenshot).


https://ibb.co/QHHfGpx


Is there a way that for the calculation it uses the 6 digits as configured in the precision for the product? So, 5,825000 x 1,2 = 6,99

I would like to keep the monetary fields and the sums with two digits, as this is standard.

Thanks,

Andi

الصورة الرمزية
إهمال
الكاتب

It is in Odoo 16 CE

الكاتب

Anyone a Idea how to solve this?

Thanks, Andi

الكاتب

Has no one a idea why it is like that and how to fix it? Seems just the amount is calculated correctly with the full decimal precision, So 2x 5,825 results to 11,65. here Odoo uses also the 3rd digit after the comma.
But just calculating the 20% Tax out of 5,825 it seems odoo first rounds to 5,83 and then calculates the 20%.
I have actually no Idea how to solve this.

الكاتب أفضل إجابة

Hi!

I do it now with an extra line "rounding correction" which is also on a own account. Seems this is the cleanest way to deal with it.

Best regards.

الصورة الرمزية
إهمال
أفضل إجابة

Did you solve it? I have the same Issue.

I change the monetary decimal precision to 6 decimals and show digits to 2 (With SQL) but this give me lot of error with balances in journal entries. 
¿How did you solve it?

الصورة الرمزية
إهمال
المنشورات ذات الصلة الردود أدوات العرض النشاط
2
أغسطس 25
709
3
أكتوبر 19
10187
1
مارس 15
6048
1
مارس 21
3322
7
أبريل 20
9325