Hello,
I'm trying to show consistantly the VAT on Order (Checkout) and Invoice.
(ubercart 2 rc6 (patched) vat 2 dev module
I've setup (maybe that's wrong) the tax rule as follow:
Name: VAT 21%
Rate: 0.21
Apply tax to any product
Taxed line items: shipping, tax
Weight: 0
Now the problem:
Showing ok on checkout cart contents:
Price excl. VAT VAT Price
5.79€ 1.21€ 7.00€
Calculated shipping costs: included vat = ok
5.70
Payment method (here is the first problem:
Order total preview:
Subtotal: 7.00€
Shipping cost: 5.70€
VAT (21%): 2.20€
Order total: 12.70€
The Order total is correct, but I want to show the subtotal, shipping cost without VAT,
the VAT line: 2.20
and total: 12.70, price including VAT
Review order: problem (calculated VAT is incorrect) 2.46 iso 2.20€
Payment method
Subtotal: 7.00€
Shipping cost: 5.70€
VAT (21%): 2.46€
Total: 12.70€
On the invoice, same problem as above, wrong VAT calculated and I also want to show Subtotal and Shipping cost without VAT, the VAT line and Order total inclusive VAT
Subtotal: 7.00€
Shipping cost: 5.70€
VAT (21%): 2.46€
Total: 12.70€
Why is the subtotal inclusive VAT, do I have to change a setting?
TIA,
Fossie
Comments
Comment #1
fossie commentedUpdate:
I've looked at the 'sponsor' site and their it seems like exact the same problem:
https://www.londonkettlebells.com/
If you shop something, you'll see 'a VAT amount' when you click further (Review Order) the VAT amount changes.
So their should be some bug, changed to bug iso Support request
Upgrade from normal to critical, because the VAT is incorrectly calculated
Maybe someone has an idea, why this is happening? This evening I'll go through the code to see where the problem pops up.
Fossie
Comment #2
xibun commented1. you write that you're using the uc_vat dev version -> did you apply the patch for it? (uc_vat_order_product.patch: http://drupal.org/node/518916#comment-2003008)
2. you will only see an additional line excluding VAT only after you enter a postal code - did you enter one? (at least for my site this is necessary)
Comment #3
fossie commentedYes intitially I applied the patch, tested, but it wasn't consistant.
I've now repatched (with patch mentioned above) and this is happening now:
Order total preview:
Subtotal: 10.00€
Shipping cost: 5.70€
Subtotal excluding taxes: 12.97€
Calculated VAT (21%): 2.72€
Order total: 15.70€
(their is a rounding issue, but maybe that's another story, missing 0.01€)
BUT
when you click Review Order
Payment method
Subtotal: 10.00€
Shipping cost: 5.70€
Subtotal excluding taxes: 14.71€
Calculated VAT (21%): 3.09€
Total: 15.70€
The excluding taxes line is wrong.
The 'subtotal' is taken into account, but their is the VAT already added + the shipping cost without VAT
Maybe this is what (in my opinion) it should be:
Or, showing everithing with VAT until the exclude VAT line, or splitting it up into
Qty | Product | Price Excl VAT | VAT % applicable | Price Including VAT
1 | prod 1 | 8.26 | 21% | 10.00
Subtotal | excl VAT | ----------------- | incl VAT
8.26 | | 10.00
Shipping |4.71 | 21% | 5.70
Total excl VAT | 12.97 |
VAT 21 % | 2.72
Total incl VAT | ---------- 15.70 ------------ |
(or simular) but it's important that it's clear:
a) which VAT % is applicable on what items
b) the subtotal is without VAT and or with
c) extra costs / discounts on the order should be stated which VAT % is applicable
d) the numbers are correct :-)
Maybe this is too ambitious, but it's like it should be in some way.
HTH,
Fossie
Comment #4
xibun commentedrounding error: yes, this is known, you can follow it here: #479784: Order rounding.
order review: this doesn't happen on my site. it feels like a problem on your local installation. can you try to clear cache, create a new product and reproduce the problem?
ambitious VAT implementation: I also see many possible improvements, you can find ideas in different issues already. right now we have to concentrate to get the minimum working for UC 2.0.
Comment #5
fossie commentedYes, that was more or less the ideal situation :-)
but the basics need to be working first off course. I was aware of the rounding problem, that's with some prices where I do need 4 or 5 decimals.
I'll do a clean install and try again tomorrow, but can you let me know which versions you are using?
Ubercart (R6, r6-patches or .dev)
which patches applied in case you didn't use the patched version
uc_vat (version .dev I suppose): wich patches?
drupal 6.13 of 6.14 (I was testing with drupal 6.14)
Please let me know, then I'll re-install everything tomorrow, clean.
TIA,
Fossie
Comment #6
xibun commentedYou probably see a problem which I had the 1st of September. (http://drupal.org/node/518916#comment-1995352)
But this problem was solved soon after - so I believe you are using the wrong UC version resp. the wrong patch with it. Find more info in the other issue posts.
Comment #7
longwaveThis should all be fixed with the latest releases of Ubercart and uc_vat.