Hi everyone,
I have a problem with VAT calculating. Now VAT calculating on each line separately.
But in my country it must be calculated on final price (without VAT) not on each line.
Main problem is that when it make calculating VAT on each line on the end i am getting different final price with VAT.
On the image i will show you the problem.
So the main question is there a option to make VAT calculation on the Final Price and how can i make this?
Best Regards,
Martin
which Dolibarr version and PHP version are you running.
Also, which country are we talking about? and have you set your location in Dolibarr to that country?
Hi, yes sorry I forgot to tell versions
Dolibarr V.20.0.2
PHP V.8.2.29
And yes, in settings I have selected which country is.
It is Macedonia.
do you have many lines on your orders?
Yes, i have many lines, when i have one line there is no problem
Hi,
did you have a look at this Wiki page: VAT setup, calculation and rounding rules - Dolibarr ERP CRM Wiki
You are probably looking for this variable (under Settings/Others): MAIN_ROUNDOFTOTAL_NOT_TOTALOFROUND.
This lets you configure, if you round the lines first and add them later or calculate the sum first and round this. VAT is then determinded based on these values.
Hope this helps,
Joachim
Hi, yes that’s what i need, but if i set MAIN_ROUNDOFTOTAL_NOT_TOTALOFROUND = 1 than i have a problem with adding any line in invoice.
When i click add it only refresh page and line is not added. In Total Price it show price, but not add lines.
@martin54 that is weird. What is the output in your webservers log file when you have this enabled and try to add a line?
Also, please enable debug logging and send us the output of dolibarr.log while you try to add a line
Hi,
With $dolibarr_main_prod=‘1’; it not show any error when i try to add some line.
But what i see now, that is that the problem is occur only when i add line with VAT. If i set VAT to 0% than it add line.
@martin54 please enable debug logging and post the relevant dolibarr.log snippet as well as the relevant log snippet from your webservers log
Hi @jonbendtsen, sorry for replay after some month, i am such and idiot haha
Here is the log file
dolibarr.log (58.6 KB)
hey @martin54
Line 9-32 contains these lines
2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 BEGIN Transaction
2026-04-15 07:01:38 WARNING 92.53.60.252 3476991 1006 We found a rounding difference after line 6736 between HT*VAT=19.44 and total in database=19 (calculated with UP*qty) but diff=-0.44 is too high (> 0.1) to be corrected. Some data in your lines may be corrupted. Try to edit each line manually to fix this before restarting.
2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 ROLLBACK Transaction
2026-04-15 07:01:38 ERR 92.53.60.252 3476991 1006 Error url=/fourn/facture/card.php?id=2288&action=calculate&token=9a4f3efea1f189b8987d208aa7db53e4&calculationrule=roundoftotal, query_string=id=2288&action=calculate&token=9a4f3efea1f189b8987d208aa7db53e4&calculationrule=roundoftotal, sql=BEGIN, db_error=, msg=We found a rounding difference after line 6736 between HT*VAT=19.44 and total in database=19 (calculated with UP*qty) but diff=-0.44 is too high (> 0.1) to be corrected. Some data in your lines may be corrupted. Try to edit each line manually to fix this before restarting.
2026-04-15 07:01:38 INFO 92.53.60.252 3476991 1006 --- End access to /fourn/facture/card.php
so there is an rounding error somewhere.
Does this only happen on this particular vendor invoice, or also on other vendor invoices?
On all vendor invoices
okay, are you still running this version? because then I’d suggest that you try upgrading, we are now at v23
No, i made update always when i see that there is a new version. Log files is from today from version 23.0.2. Update i made today.
is it the same as this issue?
no it is not the same issue.
okay @martin54 - If you create an entirely new invoice with a product with a set selling price, does it still have the same issue?
Hi, yes. It doesn’t matter if it’s a saved product or it’s a “free text” product.
can you find a matching issue reported here @martin54
