Kryptronic Software Support Forum

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.

#1 05-22-2020 09:46:20

dharrison
Member
From: Essex
Registered: 05-16-2012
Posts: 83
Website

Problem with VAT being rounded up

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)


Deb Harrison

Offline

 

#2 05-26-2020 07:04:32

dharrison
Member
From: Essex
Registered: 05-16-2012
Posts: 83
Website

Re: Problem with VAT being rounded up

Hi

Please could anyone advise?


Deb Harrison

Offline

 

#3 05-26-2020 10:01:29

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Problem with VAT being rounded up

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?


Nick Hendler

Offline

 

#4 05-27-2020 03:23:38

dharrison
Member
From: Essex
Registered: 05-16-2012
Posts: 83
Website

Re: Problem with VAT being rounded up

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)


Deb Harrison

Offline

 

#5 05-27-2020 08:29:29

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Problem with VAT being rounded up

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.


Nick Hendler

Offline

 

#6 05-28-2020 09:32:34

dharrison
Member
From: Essex
Registered: 05-16-2012
Posts: 83
Website

Re: Problem with VAT being rounded up

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.


Deb Harrison

Offline

 

#7 05-28-2020 10:11:04

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Problem with VAT being rounded up

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.


Nick Hendler

Offline

 

#8 05-28-2020 10:12:32

dharrison
Member
From: Essex
Registered: 05-16-2012
Posts: 83
Website

Re: Problem with VAT being rounded up

Is this a free update that we get?


Deb Harrison

Offline

 

#9 05-28-2020 10:20:13

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Problem with VAT being rounded up

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.


Nick Hendler

Offline

 

#10 05-28-2020 10:37:18

dharrison
Member
From: Essex
Registered: 05-16-2012
Posts: 83
Website

Re: Problem with VAT being rounded up

Ok, will it be easy to update, or does it involve a lot of work (test sites again?)


Deb Harrison

Offline

 

#11 05-30-2020 05:33:59

dharrison
Member
From: Essex
Registered: 05-16-2012
Posts: 83
Website

Re: Problem with VAT being rounded up

Could I have an answer please?


Deb Harrison

Offline

 

#12 06-01-2020 11:59:30

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Problem with VAT being rounded up

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.


Nick Hendler

Offline

 

#13 06-19-2020 06:38:55

dharrison
Member
From: Essex
Registered: 05-16-2012
Posts: 83
Website

Re: Problem with VAT being rounded up

Are you any closer to releasing an update?

Please could you let me know?


Deb Harrison

Offline

 

Board footer