HomeHome Product Discus... Product Discus...SmithCartSmithCartProblem with VAT being charged twiceProblem with VAT being charged twice
Previous
 
Next
New Post
6/21/2010 8:35 AM
 

In my cart settings I have:

Charge Tax All States

Tax Rate: 17.5

Enable VAT: Yes

When I add an item to my cart and place an order, I see the following in the order summary:

Sub Total :£49.00
Total (incl. VAT): £49.00
VAT included (GetMyCurrency(),17.50%):£7.30

When I go into the admin system and view the order, I see (HTML removed for clarity):

Sub Total: £49.00

Tax: 8.58

Order Total: £57.58

It looks like VAT is being added to my order in the admin system, even though it is included in the cart.

Also the GetMyCurrency() is also probably undesirable :)

Stu

 
New Post
6/21/2010 1:21 PM
 

I just tested this on my test system and it calculated correctly without the getcurrency(). Did you make any changes to the cart.ascx page that could have caused the getcurrency() to show up? Here is a screen shot of the subtotal area of my cart screen when vat/gst is enabled:

Sub Total : $110.00
Shipping Fee : Free
Handling Charge : $0.00
Surcharge : $22.00
Total (incl. VAT) : $132.00
VAT included (6.25%) : $6.47

Here is an excerpt from the cart users guide on how the vat/gst tax is calculated:

VAT/GST Tax – Value added tax (VAT), or goods and services tax (GST) is a tax used by non United States countries and is levied on any product that is added to the cart. When VAT/GST Tax is checked the cart will charge the tax rate entered in the “Tax Rate” textbox and implement the VAT/GST tax calculation. You will need to load all product pricing inclusive of VAT/GST tax. At checkout on the cart, confirmation pages and invoice the cart will display the VAT/GST tax as follows.

Example:

Product 1: $110
Product 2: $55
Sub-total: $165
Shipping: $22
Total (incl. VAT): $187
VAT included (10%): $17

The formula for the tax (VAT) is as follows:
VAT($) = Total($) * VAT(%) / (1 + VAT(%))

Hope this helps!

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
9/2/2010 8:23 PM
 

Scott, I think the OP was talking about the issue in the Order Total calculation when the admin refers to an order under the Manage Orders page of the store admin. I also got the same issue when I was testing out the module using tax inclusive prices in the products. The cart page gave the correct total as expected though.

The same issue was also mentioned here:

http://www.smith-consulting.com/forum...

 
New Post
9/3/2010 5:52 AM
 

Scott - this is the issue I have been emailing you about.

I am also getting the double tax calc - only after a purchase has been made.

I am ALSO getting the getMyCurrency issue - and it shows in $, even though the rest of my cart shows in R.

 
New Post
9/6/2010 8:28 PM
 

When VAT is enabled the tax is removed from the order total on the manage order details page. This item is fixed now in v3.07 of the cart available on the downloads page.


At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
9/7/2010 6:58 PM
 

The trial is still 3.06. Could you please update that as well so I can continue the evaluation? Thanks.

 
New Post
9/8/2010 12:38 AM
 

Just tried the update. The Order Total on the order page is now "correct" if I don't make any adjustments. But I'm afraid it's more of a quick-and-dirty fix. If I adjust the amount (say I want to apply a discount) and click recalculate, the calculation will take the tax amount into account which results in the "tax being charged twice" again as the line total amount is a tax inclusive amount.

Please also note that the Total amount in the invoice is still "double taxed".

I think a more proper fix is to keep the order total logic as in the previous version but to use a tax exclusive amount in the unit cost and line total of each item in the order page, regardless of whether the US sales tax or the VAT/GST is used. (After all only the admin cares about the manage orders page) But to give an option for the admin to display the price in tax exclusive or tax inclusive fashion in the product catalog, the cart, and the invoice as they are customer-facing.

 
New Post
9/8/2010 1:40 AM
 

I just emailed you a hot fix that fixes the recalculate button VAT tax issue you reported.

Thanks for the feedback!


Dave

i just attached the hotfix because the email bounced


At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
 Login to download attachment
New Post
9/9/2010 3:56 PM
 

Sorry Dave, but I couldn't find what you had fixed. All the issues I had described were still there after I applied the dll. But thanks very much for the quick response that I really appreciate.

Anyway, even though this is a high priority defect, it's more important to have the fix regression tested properly before releasing. After all we're more into dealing with subscriptions with recurring payments and we're currently evaluating whether to go for the cart module, the registration module, or both. Unfortunately we just hit a more critical issue with the reg module that is essentially a show-stopper for now.

 
New Post
9/10/2010 12:07 AM
 

Please copy the dll in the attached zip to your \bin folder to fix the vat recalc issue on the manager order details page.


At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
 Login to download attachment
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartProblem with VAT being charged twiceProblem with VAT being charged twice