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.
We have an occasional VAT rounding error in the pricing that was not a problem in CCP8. Where do we go to adjust this?
Offline
If you can give some very specific examples that we can replicate, we can look at it and get a solution together. All of the pricing and tax calculation logic in K9 is based on what was in V8, but substantial parts of it are new. K9 has been tested and verified to work properly in production with VAT enabled, using different types of discount scenarios, etc. that were known to cause issues in V8. Please advise on this and we can figure it out. Thank you.
Offline
Here is an example. It is very simple order with no discounts. I have simplfied the item codes to make it easier to read. The discrepancy is that VAT in our accounts program is £16.18 and K9 is £16.19. K9 is rounding up £16.184 (20% of 80.92) to £16.19.
Order Totals
Item Subtotal +VAT £80.92
Delivery +VAT £0.00
VAT £16.19
Total £97.11
Payment -£97.11
Balance Due £0.00
SKU EU VAT Summary Qty Total+VAT VAT Rate
Item1 Item1 Description 1 £4.25 £0.85 20.00%
Item2 Item2 Description 1 £6.63 £1.33 20.00%
Item3 Item3 Description 1 £9.85 £1.97 20.00%
Item4 Item4 Description 1 £9.74 £1.95 20.00%
Item5 Item5 Description 1 £18.65 £3.73 20.00%
Item6 Item6 Description 4 £31.80 £6.36 20.00%
Last edited by sdn (03-20-2017 05:01:52)
Offline
Not sure what figure you mean that is not already provided in the example above. Here is another example:
Item Subtotal +VAT £51.11
Delivery +VAT £6.50
VAT £11.51
Subtotal is correct but 20% of 57.61 (51.11 + 6.50) is 11.522 not 11.51 calculated by the cart.
Offline
This may be due to individual items rounding up. It's not as simple as (shiptotal+subtotal)*.20. It's really (itemsubtotal*.20)+(itemsubtotal*.20)+(itemsubtotal*.20)+(shiptotal*.20). If you can demonstrate this with one item, I can look to see where we may not be holding enough decimal places. Is there a single item price that triggers this?
Offline
I am yet to find an example of just 1 item rounding up but why do I need to find one when you already know how the calculations are performed? It was not an issue in CCP8 so I assume you have changed the way VAT is calculated in K9.
All of our prices are to 2 decimal places (Pounds and Pence) and we do not use fractional quantities.
Why not just add one or more decimal places to resolve as you say?
Here is an example with only 2 line items:
Item Subtotal +VAT £66.63
Delivery +VAT £0.00
VAT £13.32
Total £79.95
Payment -£79.95
Balance Due £0.00
Number European Union VAT Summary Qty Total +VAT VAT Rate
Item1 1 £2.26 £0.45 20.00%
Item2 1 £64.37 £12.87 20.00%
My VAT Calculations
Item Subtotal £66.63 @ 20% = £13.326 rounding to £13.33 (as per our accounting software)
K9 line item calculations
£2.26 @ 20% = £0.452
£64.37 @ 20% = £12.874
So I guess K9 can only be using 2 decimal places to arrive at £13.32 VAT.
Last edited by sdn (03-30-2017 05:25:34)
Offline
A lot has changed in K9. Not the actual VAT calculations, but just about everything else as far as pricing formulation and storage. K9 uses a completely different 'pricemap' concept for pricing storage. Somewhere in there we're keeping too many decimal places. With a V8 to K9 comparison with the same pricing I can pinpoint where that may be. I am looking into this.
Offline
NIck, have you found an error?
I can add a single £18.30 item to cart, change qty to 2 and total correctly change to £36.30, but if I change quantity to 3 the total changes to £54.91(extra 1p). This happens on lots of products.
Don't want to waste time searching for problem if you have already resolved it.
Offline