Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.There is the same problem as in this issue: https://drupal.org/node/1403498. However, a change in weight was not successful and i couldn't fix this.
The subtotal and taxes are charged by the undiscounted face value. Curiously, the product price is displayed with discount while checkout. By calculating the taxes due to the undiscounted subtotal there is a miscalculation and wrong display in checkout form.
Calculation of taxes with discount (in Germany):
-> Product Price without tax
-> Discount
-> ----------------------------------------
-> Subtotal = Product Price without tax - Discount
-> ----------------------------------------
-> VAT = Subtotal * tax Rate
-> Total = Subtotal + VAT
Current Calculation (false):
-> Product Price without tax
-> Discount
-> ----------------------------------------
-> Subtotal = Product Price without tax
-> ----------------------------------------
-> VAT = Subtotal * tax Rate
-> Total = Subtotal + VAT - Discount
I'm thankful for ideas.
| Comment | File | Size | Author |
|---|---|---|---|
| #3 | tax_on_order_discount_incorrect.jpg | 61.29 KB | deardagny |
| #3 | tax_on_product_discount_correct.jpg | 61.83 KB | deardagny |
Comments
Comment #1
lsolesen CreditAttribution: lsolesen commentedCould you supply a screenshot og the problem and the exact steps to reproduce on a clean install.
Comment #2
lsolesen CreditAttribution: lsolesen commentedPlease reopen with exact steps to reproduce on a clean Commerce Kickstart, if shifting the weights did not solve your problem.
Comment #3
deardagny CreditAttribution: deardagny commentedI've been trying to solve this issue for a while (with Sales Tax as opposed to VAT), and following along with https://drupal.org/node/1403498 as well. I'm now testing on a fresh install and see the same problem with tax calculation and adjusting weights of the rules has made no difference. I figured I'd chime in here also...
Using:
- Commerce Kickstart 2.19 base install
- Commerce Discount - Tested both alpha4 and dev versions, as well as this patch: https://www.drupal.org/node/1962484#comment-8803335
- No other contrib modules
I've found that when using a Product Discount, taxes are correctly calculated on the discounted line item, as shown here:
However, when an Order Discount is created, the following incorrect calculation occurs:
Tax on the order should be calculated on the total price of products minus the 20% discount, not the original price of $8.00.
Steps to reproduce:
Please let me know if you need any more info. I'd love to know how other people are dealing with this.
Comment #4
deardagny CreditAttribution: deardagny commentedComment #5
valentino@digors.com CreditAttribution: valentino@digors.com commentedHi everybody,
I am struggling with this bug and I didn't have success so far.
What I've found out is that VAT is calculated right when applying discount if the price DOES NOT include VAT.
If the item price includes VAT, then the discount is calculated right but VAT result is wrong.
Comment #6
mglamanThis is actually a bug in Commerce Discount #2202433: Sales tax is calculated before discounts, moving there, should probably be marked as duplicate, or information combined some how. This one seems to have better details than other, though.
Comment #7
mglamanTagging for Commerce sprint
Comment #8
mglamanMarking this as a duplicate of #1962484: Product discounts: Taxes should applied to SUBTOTAL minus DISCOUNT. There's a patch and work being done there. If this isn't the same issue around discounts and tax, please reopen.