Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Gilles Faessler 29 posts 53 karma points
    Aug 10, 2011 @ 14:14
    Gilles Faessler
    0

    VAT issue

    Hello,

    We have a problem with handling VAT correctly on our shop. The shop is based in switzerland and will sell products troughout europe. Swiss customers must pay 8% VAT, other country must not pay VAT.

    If an article without VAT costs 100 Euros, a Swiss customer must pay 108 Euros and customers from other countries must pay 100 Euros.

    We set up a VAT group 8% and defined Country specific VAT as follow :

    In the teacommerce general settings, we checked "Prices in DB incl. VAT" and set article price to 108 Euros. When configured like this the product price displayed is 108 Euros, which is correct. When the product is added to basket and customer country set to Switzerland, Price is 100 without VAT, 108 inc. VAT which is correct. If customer is out of Switerland, price is 108 Euros without VAT and 108 Euros inc. VAT, which is incorrect. VAT should be deducted and price without VAT should be 100 Euros.

    I tried to change  the configuration of "Prices in DB incl. VAT" to false and set article price to 100 Euros. When configured like this everything in the basket is correct, ie for swiss customers price is 108 Euros inc. VAT and for foreign customers final price is 100 Euros inc. VAT. The only problem with this solution is that on the product page the price is displayed without VAT, ie 100 Euros but we want to have price with VAT displayed by default ie 108 Euros and didnt find any method or property to calculate this on the product.

    Any help is welcome to configure and display this correctly on the Shop. As mentionned the goal is that foreign customers don't pay VAT and to have prices inc. VAT displayed on product page.

    Regards

    Gilles

     

  • Rune Grønkjær 1371 posts 3102 karma points
    Aug 10, 2011 @ 14:19
    Rune Grønkjær
    0

    Let me just have a look at that. I'll be back.

    /Rune

  • Rune Grønkjær 1371 posts 3102 karma points
    Aug 10, 2011 @ 14:43
    Rune Grønkjær
    0

    Hi Gilles,

    You found a bug in the country specific VAT's it seems. I have made a fix and uploaded it as "Tea Commerce 1.4.1.1 BETA for .NET 4.zip" to the package site here on Umbraco. You can just install it on your solution.

    Let me hear if it fixes your problem. It seemed to work on my own test app.

    /Rune

  • Gilles Faessler 29 posts 53 karma points
    Aug 11, 2011 @ 09:54
    Gilles Faessler
    0

    Hi,

    We installed the latest version but issue seems to remain.

    Prices in DB incl. VAT is enabled. Product price without VAT does not take into account specific VAT, the product price without VAT doesn't vary.

    Regards

    Gilles

  • Rune Grønkjær 1371 posts 3102 karma points
    Aug 11, 2011 @ 09:56
    Rune Grønkjær
    0

    Hi Gilles,

    I have not updated the latest version, only added a beta to the package files in the bottom of the package site.

    /Rune

  • Gilles Faessler 29 posts 53 karma points
    Aug 11, 2011 @ 09:58
    Gilles Faessler
    0

    Hi,

    Yep we updated to Tea Commerce 1.4.1.1 BETA for .NET 4.zip

    If you confirm issue is solved we will make a fresh Umbraco and Teacommerce install and retry

    Best regards

    Gilles

  • Rune Grønkjær 1371 posts 3102 karma points
    Aug 11, 2011 @ 10:02
    Rune Grønkjær
    0

    Super, then my fix must be wrong. I'll be back.

    /Rune

  • Rune Grønkjær 1371 posts 3102 karma points
    Aug 11, 2011 @ 10:12
    Rune Grønkjær
    0

    I have now doublechecked my results with the new BETA.

    VAT:

    Denmark selected:

    USA selected:

    That was with "Prices in DB incl. VAT" enabled. If I disable it the totalprice will be 110 for Denmark and 100 for USA.

    /Rune

     

  • Gilles Faessler 29 posts 53 karma points
    Aug 11, 2011 @ 10:33
    Gilles Faessler
    0

    Hi,

    Thank you for the quick response. In your example Total ex. VAT should be $90.91 for USA, not $100 as 9.09 VAT is included in the product price and for USA there is no VAT to pay

    Gilles

  • Rune Grønkjær 1371 posts 3102 karma points
    Aug 11, 2011 @ 10:38
    Rune Grønkjær
    0

    I don't believe that's right. If the VAT is 0% (like on USA) the total ex. VAT and the total should be the same. Or am I misunderstanding something?

    For Denmark $90.91 would be right as the price in the DB is with VAT and that the VAT is then deducted from the $100 to get the total without VAT.

    So I still think the problem has been solved :)

    /Rune

  • Gilles Faessler 29 posts 53 karma points
    Aug 11, 2011 @ 10:46
    Gilles Faessler
    0

    Maybe we have to proceed differently then. It's not really the VAT percentage which should change from a country to another but the fact that VAT applies or not.

    If you sell a product 100$ including 10%VAT that means the price without VAT is 90.91 and the VAT is 9.09. If a customers orders from a country where the VAT does not apply then he should pay 90.91 because VAT does not apply to him.

    When deactivating the mode Prices in DB incl. VAT and setting the product price to 90.91 then the price in basket is correct, ie USA customer will pay 90.91 and Denmark customer 100. The issue with this system is that on the product page the price displayed is 90.91, we would like to display the product price incl. VAT by default. Do you know how we could grab the product price VAT included when not running in Prices in DB incl. VAT?

    Hope it's understandable

    Gilles



  • Rune Grønkjær 1371 posts 3102 karma points
    Aug 11, 2011 @ 16:17
    Rune Grønkjær
    0

    Hi Gilles,

    That was some job you gave us there. A lot of discutions and coding have gone into solving the issue. Both Anders and me have been looking into it and the result is a new beta package, which I have uploaded.

    1. Use Prices in DB without VAT
    2. Then try our new library method GetPrices(node). This will give you all the products prices in a nice little XML wrapper. You have prices on all currencies AND with and without VAT. That should solve your presentation problem.

    Let me know how how it works

    /Rune

  • Gilles Faessler 29 posts 53 karma points
    Aug 16, 2011 @ 13:43
    Gilles Faessler
    0

     

    Hi Rune, sorry for the late response we were out for a few days. Thanks for the modification made.

    We removed Prices in DB incl. VAT in the General settings of TeaCommerce, republished all products and we tried the getPrices method in template "Product" of the productList-Product.xslt file :

     <xsl:variable name="product" select="./ancestor-or-self::Product[last()]"/>          

        <xsl:variable name="testGetPrices">

          <xsl:value-of select="teacommerce:GetPrices($product)"/>

        </xsl:variable>

        test <xsl:value-of select="$testGetPrices"/>            

    The GetPrices returns no values. When debugging with Visual Studio the xslt file, ($testGetPrices)[1] contains only the value "/".

     Are we doing something wrong when using the GetPrices method ?

    Thanks

    Gilles

  • Rune Grønkjær 1371 posts 3102 karma points
    Aug 17, 2011 @ 08:17
    Rune Grønkjær
    0

    Hi Gilles,

    It might be the "last()" part that is wrong. Check the $product to see what it is. It should be the product or variant selected, or else you will get no result.

    /Rune

  • Gilles Faessler 29 posts 53 karma points
    Aug 18, 2011 @ 08:22
    Gilles Faessler
    0

    Hi Rune,

    We made additional tests starting from a fresh Umbraco / Tea commerce starter kit install but the problem remains, probably we are missing something. I put complete configuration and debugging information below, could you please have a look at it to see if there is something wrong on the configuration side or if you can reproduce the issue ?

    Thanks

     

    Product configuration :

  • Anders Burla 2560 posts 8256 karma points
    Aug 22, 2011 @ 11:51
    Anders Burla
    0

    For some reason we cant access page 2 of this post. Could you mark this forum post as solved and start a new one with your last forum post again? Sorry for the trouble.

    /Anders

Please Sign in or register to post replies

Write your reply to:

Draft