You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
Hi
We have noticed certain orders ending in .99 are being rounded up?? for example the screenshot shows the basket displaying £189.99 but the checkout is showing £190.00. It is incorrect and we need to resolve this .
Please advise where I can resolve this. There doesn't appear to be any settings in the back end.
https://www.dropbox.com/home/Mobile%20U … ew=ss1.png
Last edited by dharrison (05-22-2020 09:57:54)
Offline
OK. Please confirm you have 189.99 entered as the regular price. Also confirm that the tax rate is set to Standard Rate. Also confirm that VAT is active and you've set it up so prices are inclusive of VAT. What is your VAT rate for your EU Home Country?
Offline
The price was entered as £189.99. We have European Union VAT rules set which would be at 20% This applies to the areas we cover (all of the UK)
Catalog price include Tax is set and Country Tax: European Union VAT Rules - Display Tax Summary In Orders* Is set to true
Last edited by dharrison (05-27-2020 03:24:27)
Offline
I cannot replicate this on our dev server with version 9.1.0 (pending release). Entering 189.99 for an offer price, including tax, with the display set to show prices including tax, renders a price of 189.99 after backing out the 20% tax for calculations then adding it back in for displays. This may be a PHP config issue on your server, but I'm not sure how to track it down. There are a bunch of PHP.ini directives which are math-related and control things like rounding, etc. I believe the mathematical difference is due to the way the server is doing the math as the software is the same as what we have in dev and we're not seeing an issue here.
Offline
webmaster wrote:
I cannot replicate this on our dev server with version 9.1.0 (pending release). Entering 189.99 for an offer price, including tax, with the display set to show prices including tax, renders a price of 189.99 after backing out the 20% tax for calculations then adding it back in for displays. This may be a PHP config issue on your server, but I'm not sure how to track it down. There are a bunch of PHP.ini directives which are math-related and control things like rounding, etc. I believe the mathematical difference is due to the way the server is doing the math as the software is the same as what we have in dev and we're not seeing an issue here.
I have got in touch with our hosting support and they assure us that the server is running fine. Let me try again as this time I have examples:
webmaster wrote:
Are you entering 189.99 as the regular price?
The product (from my example https://www.thelivingstore.co.uk/Item/o … ll-in-blac) is entered under product offers including vat currently at 132.99. this includes vat
shopping cart reads the right amount https://www.dropbox.com/s/7g8fl8zzq0re1w7/ss1.jpg?dl=0 but when I go to the checkout, as you can see form both screenshot, the total is rounded up to 1p. https://www.dropbox.com/s/juz2trykbw3gkga/ss2.jpg?dl=0
No one has noticed this issue yet, but its incorrect and unacceptable.
webmaster wrote:
Also can you confirm that the tax rate is set to Standard Rate.
Country Tax: Active rules is set up to European Union VAT Rules not Standard Rate
webmaster wrote:
Also confirm that VAT is active and you've set it up so prices are inclusive of VAT.
Country Tax: European Union VAT Rules - Display Tax* is set up to Display Catalog Prices including Tax
Under Country Tax: European Union VAT Rules - Catalog Price Tax Entry* we have set to Catalogue Prices include Tax
webmaster wrote:
What is your VAT rate for your EU Home Country?
For the Uk, it should be set at 20%. I can confirm this is listed in the database.
I welcome your help on this issue as it does ipact our business.
Offline
We'll look at this in dev. I can replicate a change in the tax amount by 1p in checkout with the amount 132.99 on our dev server. There may be a misplacement of a rounded overage in the tax calculation. Will take some time to figure out, but we have what is needed to address. Expect a change in 9.1.0 for this, which will be released when ready - within the next month or two.
Offline
All minor version updates are issued and available for install at no charge. So if you're on 9.0.x, it's no charge. If you're on 8.x, etc, you'd need to upgrade to 9 and you'd get 9.1.0 if you did that.
Offline
dharrison wrote:
Ok, will it be easy to update, or does it involve a lot of work (test sites again?)
Just like any other software update. Easy. Follow the instructions and run your installer.
Offline