Solved

Magento 1.7 CE- Tax calculation is totally incorrect

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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Suggested Solutions

E-commerce is quite a gambling world, and you should never entrust your business to a lucky chance. In order to outrun your competitors in a race to attract as many customers as possible, you need to have a well thought-out strategy under your belt.…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
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…

830 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