TAX - still giving me a headache

[Guest]

Long discussions on tax for realease 1.6.0.11 recently and I had hoped it would solve the problems, but as far as I can see it still does not "add up"

 

Product details: as you can see the pre-tax value is 7.26 - this is the value we have typed in 

 

 

Now, having used Tuk's brilliant software to get more detail into the invoice you can see

 

 

The pre-tax is shown as 7.26, but buting 10 off changes that to £72.58. not 72.60 as it should be - it does show £72.60 in the detail totals. This looks so unprofessional. I have tried all the variations of the new tax calculations but cannot get it to be correct

 

And I think I know why. VAT is value ADDED tax and I think prestashop is doing it the other way in some places.

 

So for us base price £7.26  VAT at 20% = 1.452 giving a total of £8.712 rounded to £8.71 - Correct

 

However on the invoice it is taking £7.258 as the base price -  where is that coming - well go backwards. £8.71- VAT = £7.258!!!! so to calculate prestashop is going backwards to get the base price

 

No wonder our invoices are never right

 

I am at a loss really as to how to configure this correctly now. We have added issues when there are discounts and large volumes in the mix

 

Here was can see the pre-tax total is over £1 in error

 

 

I have tried rounding per item, per line, per total, 2DP, 3DP etc. 

 

Can anyone tell me what settings can use so that the invoices add up !

 

[tuk66]

Can you send me the Debug template outputs for both invoices? I will try it using your amounts and then we will see.

 

This must not be left unsolved!

[El Patron]

can you upgrade to 1.6.0.14?  This is highly recommended given your current version.

[Guest]

Can you send me the Debug template outputs for both invoices? I will try it using your amounts and then we will see.

 

This must not be left unsolved!

Hi

 

Thanks for offering to take a look

 

I have attached the details of the largest order, plus the standard Pretashop invoice. This is not to do with your module though, it is general I think. It is there all the time i think, but only really obvious when higher quantity orders  and when discounts are applied

orderdetailC27613.pdf

orderdetail27728A.pdf

IN007510 (1).pdf

[Guest]

can you upgrade to 1.6.0.14?  This is highly recommended given your current version.

But will that solve this issue? 

 

I am growing very weary of upgrading. Whenever I do it seems to be two steps forward and one back. Not sure if all of my modules are yet 1.6.0.14 compliant. I upgraded some standard prestashop modules the other day, and it has stopped PayPal from working. Once I get stable again i am NEVER going to upgrade again! (well for at least a few weeks)

[El Patron]

.11 has tax/pricing/rule bugs this is why I suggested this course of action.  I understand upgrade can be difficult and rather give my best advice...

 

I am hoping tuk can help you, if anyone can he can.  Chin up!

[tuk66]

Hi

 

Thanks for offering to take a look

 

I have attached the details of the largest order, plus the standard Pretashop invoice. This is not to do with your module though, it is general I think. It is there all the time i think, but only really obvious when higher quantity orders  and when discounts are applied

 

It was number of decimals (3) together with the template (m4_invoice_4.tpl). Number of decimals is new feature in v1.6.0.11.

 

I have fixed this template and will improve all other templates in the next release.

 

 

P.S. I can not attach tpl or zip file. Can you PM your email?

[JanM]

It was number of decimals (3) together with the template (m4_invoice_4.tpl). Number of decimals is new feature in v1.6.0.11.

 

I have fixed this template and will improve all other templates in the next release.

 

 

P.S. I can not attach tpl or zip file. Can you PM your email?

Can you also help me please. I am using v1.6.0.14, default-bootstrap on Live/Cloud Version and the tax (VAT) is calculating wrong. Tried to change rounding methods with no success.

Thank you in advance.