0

I know, this topic or related problems have been covered a lot in the past.

We are having problems with {item_subtotal:plus_tax} calculations in the case of having a quantity greater than 1. We are having those problems for a quite some time and I always shyed away from trying to fix it (made a couple of attempts but could never find a way through).

Now we had an order where the discrepancy between what should be calculated and what has been calculated is 2 cents (Euro). It's not much but the accountant has to make an extra step and the invoice we send the customer just doesn't fit his order.

So, we are runnning EE 2.7.3, CT 2.5 and I have these settings:

Tab Global:
Decimal Precision: 2
Round Decimals to Nearest: .01 (standard)

Tab Taxes:
Tax plugin: Tax by location - Percentage
Tax 19% - Country Germany - Tax Shipping: Yes

Tab Shipping:
Shipping plugin: By Location - Price Threshold
Location: DEU - Rate: 4.12 - Threshold: 74.78

Generally we enter all prices net (without tax) and let the software do the tax calculations.

The order in question contains this product:

 product A
 net price: 22,65

The cart looks like this:

 Product A | Quantity 3 | {item_subtotal} = 67,95 | {item_subtotal:plus_tax} = 80,85

In my opinion this is where the problems stem from: the item_subtotal:plus_tax calculation.

CartThrob calculates like so:

26,95 * 3 = 80,85

where it should calculate:

22,65 * 3 * tax (in our case 1,19) = 80,86

I believe the calculation is done in 2 steps or something because I don't know where or how CT gets the 26,95 from because even if I calculate like this:

 (22,65 * 1,19) * 3 = 80,86

I am not sure why nobody else has had this problem or if taxes are being calculated differently in other countries or not. For us at least it's wrong and I would like to fix this without hacking the core.

I am still hoping to have somehow overlooked something, so I'd be happy for any head-ups.

Thanks and Cheers.

1
  • I found this age old thread just now which describes the same problem basically (it's from CT 1.x Support Forums, so I believe that there must be some sort of fix or weird config at my side causing this): cartthrob.com/forums/viewthread/2286
    – Marc
    Commented May 23, 2014 at 9:46

1 Answer 1

0

In the meantime I scheduled a support call with the people at CartThrob and they confirmed that this is an issue. They are working on an aditional tax-rate option for the next release of CartThrob (which will also be compatible to EE 2.8 & 2.9) and I have recieved a beta build which already takes care of the problem described above - at least to a certain degree. It's not perfect yet but I have reported my testing results back to CT and believe that it will be completely fixed once the final build will be released.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.