Cod fee VAT error

[gustafr]

Hi,

I'm using the Cash on delivery (COD) payment module and i have installed the Cod fee module from Order total. I'm using 25% VAT (Sweden) on products, shipping and Cod fee. However, i'm experiencing a VAT calculation-error as follows:

Sub-total: 439.00 SEK
Table Rate (Best Way): 49.00 SEK
COD Fee: 49.00 SEK
25% VAT: 109,85 SEK

Total: 549.25 SEK

The correct calculation is: 439+49+49 = 539 / 1,25 = 429,6 (price excl VAT)
The VAT should be 107,4 SEK and the Total should be 537 SEK.

The system is calculating the VAT correct for products and shipping but for the cod fee it's adding VAT on the top, even though i show prices on the site including VAT. This is causing both the VAT and the total too display incorrectly. Is this problem familiar to anyone and if yes, do you know how to solve it?

[gustafr]

The problem is that the calculation interperates the 49 SEK COD-fee to be displayed excl. VAT (even though i have choosen to display prices incl VAT). So instead of basing the VAT on 25% of 49 SEK it's adding 25% VAT to 49 SEK.
If i change the COD fee to 39,2 in admin which is the price excl VAT the total and VAT will be displayed correctly but than all prices will be including VAT except for the Cod-fee which is not a good solution. What to do?

[gustafr]

If i put in the COD fee without tax in admin, in this case 39.2 SEK the total sums are calculated correct in order total så actually the problem is that the COD fee is not displayed including Tax in the web-shop even though i have choosen this option.
Is this a bug or am i doing something wrong?

[wilt]

Looks like a bug

try this. In includes/modules/order_total/ot_cod_fee.php find line 85

            $order->info['total'] += zen_calculate_tax($cod_cost, $tax); 

and immediately after add

 if (DISPLAY_PRICE_WITH_TAX == 'true') {
   $cod_cost += zen_calculate_tax($cod_cost, $tax);
 } 

[Ajeh]

NOTE: you may also need to adjust the sort order for Modules ... Order Totals ... COD Fee ot_cod_fee to 270 so that the tax makes sense ...

You will have to experiment with that setting to meet your needs when tax is used ...

[gustafr]

Wilt: Thank you very much, that solved the problem.

Linda: I already tried to alter the sortorder but that didn't help. It seem like it was a bug but the code from wilt solved the problem. Perhaps something to correct to the next version.

Best Regards
Gustaf

[Ajeh]

The idea of the sort order was because the totals looked odd ...

Placing the COD Fee above tax when tax is involved on it with the fix wilt posted ... so that it read right ...

[paulm]

Thnx for the fix!

Will this be corrected in 1.3.6 ?

[wickedklown]

how are you guys calculating VAT fees from within zencart, i cant find the option, but it would be great to set it up that way...

please let me know what you enabled to setup VAT to calculate in the order total.