Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Magento 1.7 CE- Tax calculation is totally incorrect

Posted on 2013-12-16
4
Medium Priority
?
2,923 Views
Last Modified: 2016-03-02
Hi All

We are migrating from Prestashop to Magento and used cart2cart to migrate.

Just testing now and Magento does not seem to add tax to the grand total even though this has been set.

1)  Subtotal                              £14.98
2)  Grand Total Excl. Tax       £9.98
3)  Tax                                        2.50
4)  Grand Total Incl. Tax       £12.48

Tax is 20% and the subtotal includes tax.  But the grand total 4) seems to not include tax, even though set in admin.  The tax of £2.50 is correct and the grand total 3) seems to have been calculated by 4) - 3)

We can get it to work by selecting in admin>tax> Apply tax before discount.  However whenever a discount is used the tax figure would be wrong.

Tried deleting and setting up tax rates again, imported all catalog prices to include vat, rounded down to 2 decimal places.  This seemed to have worked however it may have just been the action of backing up and maintenance mode.

Now it is back to the above example again after installing a loyalty reward module.  Tried disabling that in admin and no effect.

Any ideas greatly appreciated.
0
Comment
Question by:Zoo71
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 1

Expert Comment

by:matt-ecommistry
ID: 39723402
Hi
I haven't 100% grasped your problem however in version 1.8 there have been some improvements in tax calculations - have you seen these?

http://www.magentocommerce.com/knowledge-base/entry/ce-18-later-release-notes#tax-11310
0
 

Author Comment

by:Zoo71
ID: 39723439
Hi, thanks for the response!

Yes I have seen the updates but for some reason my developer seems to prefer custom coding a solution instead of upgrading.  I am not too keen as custom coding normally means other modules do not seem to work and upgrading in future becomes impossible.

Magento must have worked out the box.  These are not little rounding issues but the whole calculation is done on the wrong field.

Just switching  the admin>tax>apply before discounts makes it all work.  But no tax is applied on discounts.
0
 

Accepted Solution

by:
Zoo71 earned 0 total points
ID: 39739899
Seemed this was all due to a module J2T Auto-Add which when disabled in the xml file stopped these VAT / Grand Total problems.
0
 

Author Closing Comment

by:Zoo71
ID: 39747870
Went back to basics and disabled all extensions one by one, not just in admin, which was tried, but in all the xml files, and the guilty one is J2T Auto Add VA.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Businesses who process credit card payments have to adhere to PCI Compliance standards. Here’s why that’s important.
Original post  on Monitis Blog. Web performance monitoring is broken into two camps: passive and active. Passive monitoring is defined as looking at real-world historical performance by monitoring actual log-ins, site hits, clicks, requests for …
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question