Solved

Magento 1.7 CE- Tax calculation is totally incorrect

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I recently read an article which suggested that 60% of businesses in the U.S. that process credit card details online in order to accept payment for goods or services were not Payment Card Industry security standards (PCI) compliant. This statement …
Every business owner understands the significance of online customer reviews and the impact it can have on sales and revenues. With technology advancing at such a rapid pace, getting online reviews has never been easier, especially when many regions…
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.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now