Rounding problem

Using my Dolibarr
1

I need to set up rounding to closest 0.05 like you see parameters under.
But when i make order this happens

error.pdf (149 KB)
And whitout rounding

Whitoutrounding.pdf (149 KB)

look at total net of tax

Limits/Precision setup
You can define limits, precisions and optimisations used by Dolibarr here

Parameter Value
Max decimals for unit prices
5
Max decimals for total prices
2
Max decimals for prices shown on screen (Add … after this number if you want to see … when number is truncated when shown on screen) 8
Size of rounding range (for rare countries where rounding is done on something else than base 10)
0.05
Modify
Examples with current running setup:
Net unit price of a product: 0.28571 x Quantity: 1 - Sales tax: 0% -> Total price (net/vat/incl tax) after rounding: 0.3 / 0 / 0.3
Net unit price of a product: 3.33333 x Quantity: 1 - Sales tax: 0% -> Total price (net/vat/incl tax) after rounding: 3.35 / 0 / 3.35
Net unit price of a product: 3.33333 x Quantity: 2 - Sales tax: 0% -> Total price (net/vat/incl tax) after rounding: 6.65 / 0 / 6.65
Net unit price of a product: 3.33333 x Quantity: 1 - Sales tax: 24% -> Total price (net/vat/incl tax) after rounding: 3.35 / 0.8 / 4.15
Net unit price of a product: 3.33333 x Quantity: 2 - Sales tax: 24% -> Total price (net/vat/incl tax) after rounding: 6.65 / 1.6 / 8.25

-Tomi-

2

Which language are set ?
Do you have also problem with invoice ? or only order ?

3

English
And i have tried finnish also but same thing happens.
I have same problem in invoices and orders.

4

I tried wit 3.7 version and i got:
Total (net of tax) 14.10
Total tax 24% 3.40
Total (inc. tax) 17.50

So it looks ok.
Did you try with 3.7 ?
Does the template pdf for order is “einstein” ?

5

i have version 3.4.1
in ovh-hosting webhotel

6

Its einstein and i tried to upgrade it to 3.7 and still same problem

7

It makes it before generating pdf also.

8

It makes it before generating pdf also.

9

See picture above

10

now i found when it does problem.
If i make product and put price including vat. it makes that problem when making order.

But if i make product and put price whitout vat it works ok.

How i can change my all 3000 product prices easily?

11

why the program rounds the price badly ?

example:
the result from the calculator - 3.33 x 23% = 4.09
the result from the dolibarr - 3.33 x 23% = 4.1

Step of rounding range (for countries where rounding is done on something else than base 10. For example, put 0.05 if rounding is done by 0.05 steps) = 0.05

12

With the v12.0.1 installation, when modifying the limits and precision parameters, it deletes the following lines from the ilx-const table: 1) MAIN_MAX_DECIMALS_UNIT, 2) MAIN_MAX_DECIMALS_TOT and 3) MAIN_MAX_DECIMALS_SHOWN.
And it leaves the default values ​​5, 2, 8, respectively.

In this section is the VAT rounding parameter, but the% MAIN_ROUND% line does not appear.
I need to round the total prices to integer (for example 9874.62 -> 9875.00 and VAT 19% 1876.18 -> 1876.00). How can I do this?

13

This seems fixed in 12.0.2 soon available.