Commerce over taxes orders when a discount is applied. The sales tax is calculated on the undercounted prices of the order. This issue is easily reporducable:
1. Install Commerce Kickstart 2.12 with default install options + example tax rate option "US - Sales taxes displayed in checkout".
2. Add a discount (admin/commerce/store/discounts/add). I used options, Order discount - % off = 0.10.
3. Add a product to your shopping cart.
4. Checkout and enter Michigan (MI) as address because there is already a Michigan sales tax setup.
BUG: The site calculates sales tax based on the full price of the product and does not take into account the discount, i.e.
Coffee Mug 1 $8.00
Subtotal $8.00
Sample Michigan Sales Tax 6% $0.48
10% discount -$0.80
Express shipping: 1 business day $15.00
Order total $22.68
The sales tax should be 0.06 * (8.00 - 0.80) = $0.432
I have seen many other discussions of this issue with some people reporting that changing the weight of the rules for discount/taxes fixes it.
https://drupal.org/node/1403498
Rules weights DO NOT fix the issue, at least not in this version of Kickstart it seems because the rules react on different events. The discount is triggered by "Apply a discount to a given order" event. The tax is triggered by "Calculating the sell price of a product" event.
Comment | File | Size | Author |
---|---|---|---|
Screen Shot 2014-02-21 at 11.37.37 AM.png | 56.8 KB | happyloman |
Comments
Comment #1
bojanz CreditAttribution: bojanz commentedMoving to Commerce Discount, Jonathan might find the report useful.
Tax support in Commerce in general is every uneven.
Comment #2
jkuma CreditAttribution: jkuma commentedThank you bojan to have moved the issue to the right place.
Hello happyloman, first thank you for your well explained issue, we are spent quality time working on a patch to solve this long time issue. The patch is located here. May you check this patch and tell me if it solves your issue ?
Best, jo
Comment #3
discipolo CreditAttribution: discipolo commentedOrder and product discounts seem to behave differently in respect to what they react to
Comment #4
AdamGerthel CreditAttribution: AdamGerthel commentedIsn't this a duplicate of #1962484: Product discounts: Taxes should applied to SUBTOTAL minus DISCOUNT ?
Comment #5
geek-merlinSee #2276227: [META] Use order discount with VAT and child issues for a potential fix.
Comment #6
joelpittetBeen thinking about this some...
Here are my assumptions:
Proposal:
Alternatively, get commerce 1.x to have an order level event, and have it move the tax apply to that instead of sell price calculation.
Comment #7
stephenevans CreditAttribution: stephenevans commentedtried #66-#68 here: https://www.drupal.org/node/1612662#comment-10154372
Worked very well (for USA taxes)
Comment #8
mglamanTagging for Commerce Sprint, and focus on tax items for 1.0 release
Comment #9
Scott Robertson CreditAttribution: Scott Robertson commentedSeems like the most recent discussion on this topic is happening in #2429595: Order discounts are not taken into account during tax calculation; going to mark as a duplicate.
Comment #10
tewdin CreditAttribution: tewdin commentedI wrote temporary fix for this. This is not a patch.
You can read more here.