Results 1 to 9 of 9

Hybrid View

  1. #1
    Join Date
    May 2009
    Posts
    3
    Plugin Contributions
    0

    Default Sales Tax incorrect with percentage discount coupon

    V1.3.8a

    I'm having an issue with a 25% discount coupon. When I use it on the order of one item, the tax is calculated incorrectly. For example

    Sub-Total: 11.00
    United Parcel Service (Ground): $6.88
    Discount Coupon: Patriot : -$2.75
    NE TAX 5.5%: $0.74
    Total: $15.87

    The tax should actually be $.83 since we tax shipping in the state:
    11.00 + 6.88 - 2.75 = 15.13
    15.13 * .055 = 0.83215

    The ot_coupon module is configured as follows:
    <><><><><><><
    This module is installed
    true
    Sort Order
    280
    Include Shipping
    false
    Include Tax
    false
    Re-calculate Tax
    Standard
    Tax Class
    --none--
    <><><><><><><

    Any help would be appreciated. I've read much related to miscalculation of VAT taxes, but all of those issues seemed related to quantity discounts and coupons.

    Thanks.

  2. #2
    Join Date
    Aug 2009
    Posts
    18
    Plugin Contributions
    0

    Default Re: Sales Tax incorrect with percentage discount coupon

    I'm having the exact same issue with a 15% coupon. I have the same settings in the coupon admin, just a different tax rate where I am.

    Were you able to resolve this issue?

    Thanks,

  3. #3
    Join Date
    Aug 2009
    Posts
    18
    Plugin Contributions
    0

    Default Re: Sales Tax incorrect with percentage discount coupon

    I determined what the issue is, just don't know how to fix it.

    The Discount Coupon when it recalculates the Tax it does the following:

    Tax = (Subtotal - %15) * Tax Rate + (Shipping - %15) * Tax Rate

    Even though we have "Include Shipping" = False in the config.

    The Shipping is not included in the Discount Coupon amount though, so it half works, just not perfect...

    Any solutions would be a great help.

    Thanks!

  4. #4
    Join Date
    Aug 2009
    Posts
    18
    Plugin Contributions
    0

    Default Re: Sales Tax incorrect with percentage discount coupon

    In looking at this further It appears the issue is in file:
    /includes/modules/order_total/ot_coupon.php

    Lines 65-70:
    while (list($key, $value) = each($order->info['tax_groups'])) {
    if ($od_amount['tax_groups'][$key]) {
    $order->info['tax_groups'][$key] -= $od_amount['tax_groups'][$key];
    $tax += $od_amount['tax_groups'][$key];
    }
    }


    How do I add an If statement to check if $this->include_shipping is false and the $key,$value is the class "ot_shipping" and ignore it for tax purposes?

    Potentially I'm not looking in the right place, but I should be close...

  5. #5
    Join Date
    Apr 2009
    Posts
    25
    Plugin Contributions
    0

    Idea or Suggestion Re: Sales Tax incorrect with percentage discount coupon

    I had the same problem. I can't believe it, but I figured it out by chance! Try this out, and see if it works for you.

    1- Create a coupon code (if you don't have one already).
    2- In your Admin area go to Modules->Order Total
    3- Choose Discount Coupon Module
    4- Click Edit and set the Recalculate Tax option to Standard.

    That's what worked for me. I tested an order and it calculated the tax correctly. Let me know if it works for you.

    You're welcome to try it out on my site at - pursebling.com. I setup a coupon code you can use: zencarters It's good for 10% off. We only charge tax for the state of Florida. So if you're trying to test this out on my site, you'll have to create a shipping address with Florida as the state.

    Hope this helps!

  6. #6
    Join Date
    Jul 2008
    Location
    Ontario, Canada
    Posts
    83
    Plugin Contributions
    0

    Default Re: Sales Tax incorrect with percentage discount coupon

    This doesn't work for me. Has anyone found a solution to this problem??

 

 

Similar Threads

  1. Sales Tax & Discount Coupon problems
    By Kamino84 in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 4
    Last Post: 17 Nov 2010, 08:30 PM
  2. Incorrect tax calculation when using discount coupon
    By Royal in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 0
    Last Post: 20 Jul 2010, 01:02 PM
  3. Replies: 0
    Last Post: 14 Oct 2009, 05:07 PM
  4. Sales Tax incorrect when using Discount Coupons
    By twiddletails in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 2
    Last Post: 6 Apr 2009, 12:43 PM
  5. Replies: 0
    Last Post: 13 Jun 2008, 12:57 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR