Dolibarr/dolibarr — Issue #33: VAT/Tax Calculation Error with multiple line items
Author: pdt256
Created: 2011-10-20 04:50:43+00:00
State: open

Dolibarr is calculating VAT/Tax rates by rounding per order-line and then summing them to get the total tax due. This causes the sales tax totals to be off by a few pennies in some cases.

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.