Magento2: UK Catalog, Goods excluding VAT - rounding issues on front end display

Created on 27 Jun 2016  路  3Comments  路  Source: magento/magento2

On M2 7.0.7

We are storing catalog values without tax. We want the front end display to show 拢9.99 inc tax - as the product price.

I enter the prices ex-VAT in the backend, and have front-end display price+tax.

What value do i have to enter to get a price of 拢9.99 (front end)?
Answer: 拢9.99/1.2 (VAT @ 20%) = 拢8.325

So i have to put 拢8.325 into the back end so that:

拢8.325*1.2 = 拢9.99.

OK - so i do that......

But Magento only seems to store the price to 2DP. - so it stores

拢8.33 (rounded up without me wanting it to)

so taking Magento's 拢8.33

拢8.33*1.2 = 拢10.00 (displayed on front-end) <--- WRONG!!

because to achieve a 拢9.99 inc VAT price you need to store 拢8.325 - 3DP, but Magento 2 doesn't.

Tax Format is not valid bug report duplicate

Most helpful comment

We investigated this on behalf of @PushEngineering and came up with this solution - https://github.com/meanbee/magento2-tax-rounding, rounding to three decimal places. Thanks to @PushEngineering for recommending we release our solution.

All 3 comments

We are also facing this issue, M2 v2.1.2

Value in backend for product 24.16 desired front end price 29.00, First Item in cart = 29.00 second item in card 29.01 thus totalling, 58.01.

We cannot launch without this fix as a lot of product with error in this way.

Thanks

We investigated this on behalf of @PushEngineering and came up with this solution - https://github.com/meanbee/magento2-tax-rounding, rounding to three decimal places. Thanks to @PushEngineering for recommending we release our solution.

@PushEngineering thanks for bug report! Closing as duplicate in favor of another ticket with G2 Passed.

Was this page helpful?
0 / 5 - 0 ratings