Page 1 of 2 12 LastLast
Results 1 to 10 of 19
  1. #1
    Join Date
    Dec 2007
    Posts
    15
    Plugin Contributions
    1

    Default [fixed 1.3.9a] Group Discount and Discount Coupon Tax Calculation Issue

    Fresh Install fo Zen Cart 1.3.8a

    I have a major tax calculation issue when using either a Discount Coupon or Group Discount (not together). This is what occurs:

    Sub-Total: $69.00
    Standard Shipping (Standard Shipping): $7.15
    Group Discount: -$34.50
    Florida State Sales Tax - 6.00%: $2.29
    Total: $43.94

    As you can see the total does not calculate correctly. 69.00+7.15-34.50 (50%)= 41.65 * 1.06 (tax) = 44.15 (6% tax on $41.65 should be 2.49, not 2.29).

    What's going on? Here are my settings and more comments below. This occurs with both modules. How do I fix this?

    Group Discount

    This module is installed
    true

    Sort Order
    290
    Include Shipping
    false

    Include Tax
    false

    Re-calculate Tax
    Standard

    Tax Class
    --none--

    I have tried both None and Standard for Re-calculating Tax.

    Some how the discount is being applied to the shipping to.

    I am trying to only allow the 50% off on the Sub-Total and NOT the Shipping. I though my options were correct, but the group discount is being applied to the shipping. With this scenario, the tax calculates correctly. How to I only allow a 50% discount on the Sub-Total and NOT the Shippig too, as per my settings reflect? This is a bug.?
    Last edited by Kim; 14 Jul 2010 at 07:55 PM.

  2. #2
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,622
    Plugin Contributions
    123

    Default Re: Group Discount and Discount Coupon Tax Calculation Issue

    Change your sort order and move the discount ABOVE the shipping (in Admin->Modules->Order Totals).
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  3. #3
    Join Date
    Dec 2007
    Posts
    15
    Plugin Contributions
    1

    Default Re: Group Discount and Discount Coupon Tax Calculation Issue

    I tried every combination, including moving the Group Discount aboce the shipping. Here's what I am required to do:

    I need to charge TAX on Shipping so I have my Tax Class as Taxable Goods within the table shipping module. I have set the Tax Class to None within the table module and everything calculates as it should.

    HOWEVER, I am required to charge tax on shipping. So, how do I do the following (still not convinced it's not a bug, or a very confusing way to do things):

    1. Charge Tax on Products
    2. Charge Tax on Shipping
    3. Allow for Group Discounts and Discount Coupons

    Doing all three causes calculatiosn (in every order I try) to be incorrect. Can you try this in a test store? I have tried this in a test store with no code modifications to the tax, order total, or shipping code. Thanks.

  4. #4
    Join Date
    Dec 2007
    Posts
    15
    Plugin Contributions
    1

    Default Re: Group Discount and Discount Coupon Tax Calculation Issue

    *** Read my post above before reading this ***

    I re-ordered the Group Discount to 150 (between Sub-Total and Shipping) as this is how I want to reflect it anyhow. The ONLY way I can get the TAX to show correctly is using Credit Note (see below):

    Include Shipping
    false

    Include Tax
    false

    Re-calculate Tax
    Credit Note

    Tax Class
    Taxable Goods

    After doing so, the tax shows correct, but the total should be $44.15 (not $46.22).

    Sub-Total: $69.00
    Group Discount: -$34.50
    Standard Shipping (Standard Shipping): $7.15
    Florida State Sales Tax - 6.00%: $2.50
    Total: $46.22

    What I found it's doing is that the original tax (if no discount applied) is $4.57 and the difference between $2.57 and $2.50 is $2.07. Adding the CORRECT $44.15 TOTAL with the $2.07 makes $46.22. WHY is the Total ADDING the FULL SALES TAX as if a discount didn't apply ($4.57) while showing the correct $2.50 sales tax? I need it to show the correct sales tax and total.

    I can duplicate this EXACTLY with both Discount Coupons and Group Discounts. The results and testing is the same!!! It's all based around my Shipping being taxable.

    Here's my store requirments and what settings do I need?

    All products are taxable to sales Shipping to Florida (tax basis is Shipping)
    Shipping is Taxable to sales Shipping in Florida (tax basis is Shipping)
    Group Discount and Discount Coupon subtract the discount and the tax and total indicate correct values.

    How do I acheive this?

  5. #5
    Join Date
    Jul 2007
    Location
    Durham, NC
    Posts
    55
    Plugin Contributions
    1

    Default Re: Group Discount and Discount Coupon Tax Calculation Issue

    We have a similar (same?) problem showing up for us when a group discount is applied to an in-state (taxable) order. The sales tax is undercharged.

    For us, the problem is more hypothetical than practical, because the only group discount we offer is to dealers who are normally tax exempt. Mostly, this reply is to let the Zen wizards know that we had discovered the same kind of error cropping up during testing, on in-state orders when a group discount is applied. In case it helps someone in solving, here are the total lines from a test case:

    TOTAL LINES DISPLAYED DURING CHECKOUT:
    Sub-Total: $7.99
    US Postal Service (Priority Mail): $6.60
    Group Discount: -$1.20
    NC TAX: $0.84 [wrong!]
    Total: $14.23

    SOME OBSERVATIONS:
    Tax is charged based on the shipping address.
    Shipping charge is taxable.
    Group discount is 15% of the product sub-total.
    Tax rate is 6.75% (for this order; rate varies by county).
    Sub-total (product) plus shipping less discount is $13.39.
    Tax amount should be .90.
    The amount shown, .84, is actually 6.27% of $13.39.
    If the sub-total plus shipping less discount had been $12.44, then .84 tax would have been correct.
    Same error occurs in both 1.3.7 and 1.3.8a.

  6. #6
    Join Date
    Nov 2006
    Location
    Toronto, Ontario
    Posts
    65
    Plugin Contributions
    0

    Default Re: Group Discount and Discount Coupon Tax Calculation Issue

    Sounds like what is happening in my 1.3.8a store too. Funny thing is...it works fine on my current 1.3.7 store. Has anyone figured this one out yet?

  7. #7
    Join Date
    Sep 2005
    Posts
    460
    Plugin Contributions
    0

    Default Re: Group Discount and Discount Coupon Tax Calculation Issue

    Quote Originally Posted by Rebelwax View Post
    Sounds like what is happening in my 1.3.8a store too. Funny thing is...it works fine on my current 1.3.7 store. Has anyone figured this one out yet?
    I realised this happening in our 1.3.8a too:

    Without VAT tax: 31.89EUR
    With VAT: 38.90EUR
    Store pick up: 0.00EUR
    Group discount:-13.77EUR
    VAT 22%: 4.91EUR
    Total: 25.13EUR

    VAT: 4,91106

    Total should be 27,23 euro with discount of 30%.
    I may be blond but at least I found Zen.

  8. #8
    Join Date
    Dec 2007
    Posts
    35
    Plugin Contributions
    0

    Default Re: Group Discount and Discount Coupon Tax Calculation Issue

    i had exactly the same problem. Anyone found any solution on this?

  9. #9
    Join Date
    Dec 2007
    Posts
    35
    Plugin Contributions
    0

    Default Re: Group Discount and Discount Coupon Tax Calculation Issue

    anyone please help? This issue has been bugging me for few days. and my store is up and running now. please help.

  10. #10
    Join Date
    Mar 2005
    Location
    Finland
    Posts
    64
    Plugin Contributions
    0

    Default Re: Group Discount and Discount Coupon Tax Calculation Issue

    Same problem here. My 1.3.8a shop is up and running, and the tax calculation is wrong when discounts are used.

    Goods and postage are taxable goods, VAT 22 %, as required by our officials. The costs are fed into ZC without tax. Tax is set to show everywhere. Here only B-to-B prices are shown at 0 % VAT, for consumers the totals have to be shown.

    When a discount is applied, the VAT is undercharged. It should be 18.03 % calculated from the gross, but it varies around 17.5 %. I can't give those invoices to my bookkeeper, but have to rewrite them!

    Marianne in Finland

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. v151 Discount coupon and tax issue
    By jayplanedin in forum Bug Reports
    Replies: 0
    Last Post: 28 Mar 2014, 01:59 AM
  2. Discount Coupon Tax calculation problem
    By Amit001 in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 1
    Last Post: 1 Aug 2008, 02:00 PM
  3. Group Discount + Coupon = wrong tax calculation (Ontario store)
    By Rebelwax in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 1
    Last Post: 24 Mar 2008, 07:20 PM
  4. Discount Coupon AND Group Discount Tax Problem
    By mrkrinkle in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 11
    Last Post: 5 Apr 2007, 12:16 PM
  5. Replies: 7
    Last Post: 13 Nov 2006, 12:11 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