Destiny84 Posted December 6, 2013 Share Posted December 6, 2013 I have a problem with taxes on invoices. An example of the problem is the following; items cost 99 cents tax included. Tax rate is 21% , which cones to a price of 0.81818 tax excluded. The customer buys 30 items. The invoice shows Product total (tax excluded ) 0.82 * 30 = 24.60Product total (tax included) 0.99 * 30 = 29.70Total tax 29.70 - 24.60 = 5.10While the real tax exl. total should be 0.818181 * 30 = 24.545 The tax calculation is off by almost 6 cents in this case, which is a huge deal. I took a look in the order_detail and order_detail_tax tables in the database and noticed all values being stored were rounded which explains the errors. I think however that the unit_price_tax_excl should be equal to original_product_price (which are 0.820000 and 0.818182 resp.), OR the original_product_price should be used for tax calculation. Is there anything I can do about this? Is this by design because taxes work differently where Prestashop is developed (France I suppose), or is this a bug? Any help would be gladly appreciated. Link to comment Share on other sites More sharing options...
tuk66 Posted December 9, 2013 Share Posted December 9, 2013 I tried the same example using the M4 PDF Extensions module ("Invoices" template). The result is attached. invoice000005.pdf Link to comment Share on other sites More sharing options...
Destiny84 Posted December 9, 2013 Author Share Posted December 9, 2013 looks good, thanks a lot! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now