When you use excel you ask to round the sum of each invoice line.
When you use dolibarr, you ask to sum the rounding of each invoice line.
2 different way of rounding and two different results. Both solution can be user to make accounting but solution used by dolibarr is easy to use when you need to dispatch vat when vat rate differs.
Yes I have the same issue I think.
All of my suppliers invoices are miscalculated by a penny (UK 1p) when I enter them into Dolibarr. I have been either reducing the amount before tax or adding an extra invoice item with the correction.
Is there a way to solve this by changing the decimal places calculated maybe?
I have a similar problem when Dolibarr is calculating sales tax in US Dollars. I have 39 line items with a quantity of 400 products.
Here are the calculations from Dolibarr:
Amount (net of tax): $2,097.60
Amount Sales Tax: $173.11
Amount (inc. tax): $2,270.71
The correct calculation using 8.25% Texas sales tax: (2097.6 * .0825)
Amount (net of tax): $2,097.60
Amount Sales Tax: $173.05
Amount (inc. tax): $2,270.65
Dolibarr is charging $0.06 more than it should in this case. Is this a rounding error or a desired feature? Can I fix this via a setting or programmatically?
Difference on rounding between excel and dolibarr are not on the mathematic function to round but there difference because you dont use the same method to make clauclation.
Dolibarr calculate amount of vat or sales tax by summing rounded lines.
When you make calculation manually, you calculate amount of vat or sales tax by rounding summed lines.
summ of rounded lines is not round of summed lines.
Can Dolibarr be changed to sum all line items that use the same VAT rate and then round? This would solve the rounding issue that I am seeing and still maintain the same ability to work with various VAT rates in a single order for your needs.
I have not fully tested this yet. This is a possible solution to the VAT rounding errors. Someone who knows the system better will need to verify this will actually work.
I will be adding this to my production install to see how it goes. I am not using localtax1 or localtax2 rates so I did not account for those in the total amount (inc. tax). Let me know if you will be using this patch and need me to fix the localtax1 or localtax2 totals for you. Otherwise, I hope this gets merged into Dolibarr trunk.
I have set up:
Home - Setup - Limits and accuracy
Max decimals for unit prices 5
Max decimals for total prices 5
Max decimals for prices shown on screen 2
And have result.
But if I edit the row, nothing changes and I save, the amount changed.
Please, add:
Max decimals for unit prices shown on screen 5
Max decimals for total prices shown on screen 2
ok, what I am realizing is that there is no error in vat calculation. I want to round Rs 30,514.16 to 30,514.00. This is not working well. Any manipulation in limits and accuracy messes the number words. I start seeing cents in along with Indian Rupee.