Solved

Magento 1.7 CE- Tax calculation is totally incorrect

Posted on 2013-12-16
4
2,816 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Questions & experiences on Uber taxi driving 7 130
Not able to see segment 10 88
Need a really cheap CRM 5 166
syntax error, unexpected end of file 4 18
3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
This article was initially published on Monitis Blog, you can read it here . When it comes to deciding which approach to website performance monitoring is best for your business, unfortunately, like so many options in life . . . it depends. In th…
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 tutorial demonstrates a quick way of adding group price to multiple Magento products.

752 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