Solved

Magento 1.7 CE- Tax calculation is totally incorrect

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Need To Make Content Responsive 3 90
Advertising Gateway Solution 3 77
Adding shopping card to static website on Windows Server 2 71
What does Survey Monkey cost? 7 127
The aim of this article is to help you solve the error "Cannot insert the value NULL into column 'ShortDescription', table 'albert_store.dbo.Nop_Product'; column does not allow nulls. UPDATE fails." problem and allow you to continue updating your No…
Often people are aiming at development of perfect Magento websites. Though, it is easier said than done. You know what’s much easier? To ruin everything. It can be done in seconds. Many of us experimented with design, tried to change some values dir…
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.

832 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