Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    15
    Plugin Contributions
    0

    Default Same Sub Totals - Different Tax calculation!

    Hello all,

    How is it possible that Zencart can calculate 2 different amounts of tax from exactly the same sub totals and shipping charges?

    Zen Cart v1.3.8a

    An order in my cart contains 35 items, there are multiples of the same product in different colours. So 2x blue products A's, 2x yellow products A's etc

    The sub total is £151.50.
    There is a £10.00 Delivery Charge, both are subject to tax (VAT 17.5%).

    The calculated VAT is

    151.50+10 = 161.50

    161.50 x 0.175 = £28.27

    it should be £28.26 (rounded from 28.2625)

    By varying the quantities of the items (but keeping the total quantities and values the same), the cart will calculate VAT of either £28.26 or £28.27! Somehow it is finding 0.04p difference!

    Any Ideas??

    Thanks

    Guy

  2. #2
    Join Date
    Feb 2005
    Location
    Lansing, Michigan USA
    Posts
    20,021
    Plugin Contributions
    3

    Default Re: Same Sub Totals - Different Tax calculation!

    Looking through the threads after searching for 'rounding' it looks like the problem is that Zencart calculates the tax on each item before it adds it to the total. If true, I'd consider that a bug.

    One suggestion was to extend your prices to 4 decimal places (or more). I have no idea if that will help.

  3. #3
    Join Date
    May 2006
    Posts
    15
    Plugin Contributions
    0

    Default Re: Same Sub Totals - Different Tax calculation!

    Hi Stevesh,

    Thanks for your reply. If we apply 4 decimal places to the currency options (so that 4 decimals appear on the site). The calculations come out the same!

    Even if zen cart is calculating tax on each individual item before adding them all together, changing the quantities of the items in the cart should not make a difference as they are the same price!

    I'm sure that the rounding is ok, just the changing calculations!

    Guy

 

 

Similar Threads

  1. Duplicate Orders with Same Order Number and Different Totals
    By sfuredi in forum General Questions
    Replies: 1
    Last Post: 3 May 2010, 04:59 AM
  2. Problem with tax calculation on Tax Exempt goods
    By vickula in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 3
    Last Post: 25 Mar 2009, 03:49 PM
  3. Order of subtotals /totals calculation
    By MikeyG in forum Built-in Shipping and Payment Modules
    Replies: 1
    Last Post: 12 Mar 2009, 12:57 AM
  4. Duplicate database sub-totals and totals
    By confused_aswell in forum General Questions
    Replies: 0
    Last Post: 28 Aug 2008, 08:01 AM

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