Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 24
  1. #11
    Join Date
    Jan 2007
    Location
    Australia
    Posts
    6,166
    Plugin Contributions
    7

    Default Re: Tax calculation problem - help please!

    Quote Originally Posted by satphone View Post
    "Why - when there is no shipping fee the GST gets calculated on ONLY the item and not the surcharge."

    Completely stumped!
    And I'm somewhat perplexed. I made an observation that I thought you had missed, namely that it could perhaps be related to the shipping cost. If you had already determined this in your initial posts then why didn't you mention it? You probably would have gotten more responses if you had. It would have shown/demonstrated that you'd performed the diagnostics and narrowed it down to the shipping as being the dominant cause. Your initial posts came across as "here are the figures can someone work out what is wrong fo me because I don't have a clue" .... Well, apparently you *did* have a clue (shipping cost) but you kept it to yourself. I now wonder what other clues you are keeping to yourself?

    Cheers
    Rod
    Ozpost - The Ultimate Shipping module for Australian Merchants. Click these links for its Homepage, or Download from Zen-Cart.com.

  2. #12
    Join Date
    Jun 2014
    Location
    Australia
    Posts
    42
    Plugin Contributions
    0

    Default Re: Tax calculation problem - help please!

    Quote Originally Posted by RodG View Post
    What happens if you change the sort order of the order totals so that the surcharge is processed before the shipping?
    Hi the sort order is processed before the shipping, guess I'll try after the shipping and see what happens.

    You're concerns about me "holding back information" are not warranted. If I'm asking for help I'm trying to deliver the best information I can - why would I not?!!! It's only whilst staring at this thread for days that it became clear to me this seems to be a key factor. Secondly I did "almost" deliver the shipping issue concisely, "The only difference I can see is that it's a) a different product b) there is shipping involved."

    Let me correct that;

    "The only difference I can see is that with any product there is free shipping involved."

  3. #13
    Join Date
    Jun 2014
    Location
    Australia
    Posts
    42
    Plugin Contributions
    0

    Default Re: Tax calculation problem - help please!

    Update - changing the sort order made no difference. Still - with free freight - GST is not calculated and added on the surcharge.

  4. #14
    Join Date
    Jan 2007
    Location
    Australia
    Posts
    6,166
    Plugin Contributions
    7

    Default Re: Tax calculation problem - help please!

    Quote Originally Posted by satphone View Post
    Update - changing the sort order made no difference. Still - with free freight - GST is not calculated and added on the surcharge.
    Humour me. Please provide the figures that you are currently seeing for the test/example in message#3 with free shipping.

    Thx
    Rod
    Ozpost - The Ultimate Shipping module for Australian Merchants. Click these links for its Homepage, or Download from Zen-Cart.com.

  5. #15
    Join Date
    Jun 2014
    Location
    Australia
    Posts
    42
    Plugin Contributions
    0

    Default Re: Tax calculation problem - help please!

    Quote Originally Posted by RodG View Post
    Humour me. Please provide the figures that you are currently seeing for the test/example in message#3 with free shipping.

    Thx
    Rod
    OK - as posted in number 3, it's only happening where shipping is free. ie. The GST gets calculated on only the item price and not the item price + surcharge.

    Sub-Total: $80.00
    Credit Card / PayPal Fee: $1.09
    Free Shipping: $0.00
    GST 10%: $7.27 (This is the correct GST for $80, not the total of $80 + $1.09 surcharge, it should be $7.37)

    This is consistent across all products and categories.

    Total: $81.09

    Got me stumped as to how the shipping cost can change the way GST is calculated!

  6. #16
    Join Date
    Jan 2007
    Location
    Australia
    Posts
    6,166
    Plugin Contributions
    7

    Default Re: Tax calculation problem - help please!

    Quote Originally Posted by satphone View Post
    OK - as posted in number 3, it's only happening where shipping is free. ie. The GST gets calculated on only the item price and not the item price + surcharge.

    Sub-Total: $80.00
    Credit Card / PayPal Fee: $1.09
    Free Shipping: $0.00
    GST 10%: $7.27 (This is the correct GST for $80, not the total of $80 + $1.09 surcharge, it should be $7.37)

    This is consistent across all products and categories.

    Total: $81.09

    Got me stumped as to how the shipping cost can change the way GST is calculated!
    Please continue to humour me here... now change the sort order back to how it originally was (or if you already did that please switch them around again) and then show me the results again.

    Thx
    Rod

    (trust me, I do have good reason for asking this, which I will explain after next set of results).
    Ozpost - The Ultimate Shipping module for Australian Merchants. Click these links for its Homepage, or Download from Zen-Cart.com.

  7. #17
    Join Date
    Jun 2014
    Location
    Australia
    Posts
    42
    Plugin Contributions
    0

    Default Re: Tax calculation problem - help please!

    Quote Originally Posted by RodG View Post
    Please continue to humour me here... now change the sort order back to how it originally was (or if you already did that please switch them around again) and then show me the results again.

    Thx
    Rod

    (trust me, I do have good reason for asking this, which I will explain after next set of results).
    OK sort order:

    Subtotal 100
    Shipping 200
    CC Fee 250
    Tax 300
    Total 999

    produces exactly the same results as :

    Subtotal 100
    CC Fee 200
    Shipping 250
    Tax 300
    Total 999

  8. #18
    Join Date
    Jan 2007
    Location
    Australia
    Posts
    6,166
    Plugin Contributions
    7

    Default Re: Tax calculation problem - help please!

    Quote Originally Posted by satphone View Post
    OK sort order:

    Subtotal 100
    Shipping 200
    CC Fee 250
    Tax 300
    Total 999

    produces exactly the same results as :

    Subtotal 100
    CC Fee 200
    Shipping 250
    Tax 300
    Total 999
    <gggrrrrrr>. I asked you to *show* the results, just as you did in msg#3 and msg#15. Try again.
    Ozpost - The Ultimate Shipping module for Australian Merchants. Click these links for its Homepage, or Download from Zen-Cart.com.

  9. #19
    Join Date
    Jun 2014
    Location
    Australia
    Posts
    42
    Plugin Contributions
    0

    Default Re: Tax calculation problem - help please!

    Quote Originally Posted by RodG View Post
    <gggrrrrrr>. I asked you to *show* the results, just as you did in msg#3 and msg#15. Try again.
    Rod - I realise you are trying to help. But it is the SAME.

    Sub-Total: $80.00
    Credit Card / PayPal Fee: $1.09
    Free Shipping: $0.00
    GST 10%: $7.27 (This is the correct GST for $80, not the total of $80 + $1.09 surcharge, it should be $7.37)

    In both sort order case - actual values - the same.

  10. #20
    Join Date
    Jan 2007
    Location
    Australia
    Posts
    6,166
    Plugin Contributions
    7

    Default Re: Tax calculation problem - help please!

    Quote Originally Posted by satphone View Post
    Rod - I realise you are trying to help. But it is the SAME.

    Sub-Total: $80.00
    Credit Card / PayPal Fee: $1.09
    Free Shipping: $0.00
    GST 10%: $7.27 (This is the correct GST for $80, not the total of $80 + $1.09 surcharge, it should be $7.37)

    In both sort order case - actual values - the same.
    It isn't the actual values that I was interested in.

    You probably don't even realise this, but *all* of the examples that you've shown have the "wrong" sort order when referenced against the sort order that you wrote that you had/needed.

    To put it together without numbers let's take it like this:

    Product = Product Price inc GST
    Shipping - Shipping Price inc GST
    Surcharge = Surcharge Price inc GST
    GST = 10%
    GST Calculated = GST charge shown on Invoice / checkout
    Your examples are *ALL* showing a sort order of
    Subtotal 100
    CC Fee 200
    Shipping 250
    Tax 300
    Total 999

    What you are wanting is.
    Subtotal 100
    Shipping 200
    CC Fee 250
    Tax 300
    Total 999

    You have successfully demonstrated that your defined sort order isn't being acted upon (or more accurately, you have failed to demonstrate that it *is* being acted upon).

    I would suggest that you resolve/investigate this before delving further.

    Cheers
    Rod
    Ozpost - The Ultimate Shipping module for Australian Merchants. Click these links for its Homepage, or Download from Zen-Cart.com.

 

 
Page 2 of 3 FirstFirst 123 LastLast

Similar Threads

  1. Tax Calculation Problem with Discount Codes
    By fergusmacdonald in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 0
    Last Post: 10 Mar 2010, 07:19 PM
  2. Problem with Tax calculation
    By ianhg in forum General Questions
    Replies: 7
    Last Post: 27 Apr 2009, 09:09 PM
  3. 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
  4. 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

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