Vat calculate problem

Hi,

I think that i found a problem on final VAT for invoice.
I have 6 lines with products and if i sum VAT on calculator i get 165.6, but Amount VAT in Dolibarr is 165.2.

From picture below
Lines

  1. Unit VAT 16.2 x 3qty = 48.6
  2. Unit VAT 16.2
  3. Unit VAT 16.2
  4. Unit VAT 18 x 2qty = 36
  5. Unit VAT 16.2 x 2qty = 32.4
  6. Unit VAT 16.2
    Amount VAT = 165.6

Limits/Precision setup
|Max. decimals for unit prices |2|
|Max. decimals for total prices |2|
|Max. decimals for prices shown on screen. Add an ellipsis … after this parameter (e.g. “2…”) if you want to see “…” suffixed to the truncated price. |2|
|Step of rounding range (for countries where rounding is done on something other than base 10. For example, put 0.05 if rounding is done by 0.05 steps) |0|

Hello :grinning:

have you changed your parameters during this document creation ?
can you control this invoice using phpmyadmin, the table is named “prefix_facturedet”, where prefix default value is “llx” ?

Good continuation

Hello @pcbleu

Thank you for your answare.

First setting was rounding 1, but i have different final price.
I set rounding on 0 and than i see why is a different on final price…

And yes, i have full access on phpmyadmin.

@Zuiko maybe you know what is the problem…

Hey :grinning:

with phpmyadmin, you might be able to understand which lines have incorrect rounded values…

or if you use 2 decimals for precision, then reenter each lines, you will obtain good results

Good continuation

Hi @pcbleu

It is ok after update on V13, but still not working rounding…

Hi @martin54
It seems that you could contribute to fix this issue #14765 and maybe try the precision values given in the associated screen shot…

Hi @Zuiko

I tried with setup like you send me

If i set Step of rounding range to 1 i get final price 1947 MKD, but i need to be rounded on 1946 MKD, with rounding i have a different on final price…

It must be have some option to round only Final price with VAT…

This result could be a consequence of your other post I fear…

1 Like