0
Hello Germinal,
I stumbled upon a rounding issue in Invoice Manager. To illustrate I have attached 3 screenshots taken from the demo on joomlathat.com.
There are 2 products, both with 21% VAT. The first is 10,- ex. VAT and 12,10 incl. VAT.
The second is 6,50 ex.VAT and 7,865 incl. VAT. On the invoice-line this is rounded to 7,87 which is fine.
The total however is shown as 19,96. See attached invoice.jpg.
The payment is also 19,96.
This is not correct, because it should be 19,97.
In the PDF (see attached 2020-0041.pdf) this is shown correctly. However this causes a problem with the invoice-status: it is "partially paid", which is also visible in the PDF invoice.
Do you have a solution for this?
Regards,
Dennis
I stumbled upon a rounding issue in Invoice Manager. To illustrate I have attached 3 screenshots taken from the demo on joomlathat.com.
There are 2 products, both with 21% VAT. The first is 10,- ex. VAT and 12,10 incl. VAT.
The second is 6,50 ex.VAT and 7,865 incl. VAT. On the invoice-line this is rounded to 7,87 which is fine.
The total however is shown as 19,96. See attached invoice.jpg.
The payment is also 19,96.
This is not correct, because it should be 19,97.
In the PDF (see attached 2020-0041.pdf) this is shown correctly. However this causes a problem with the invoice-status: it is "partially paid", which is also visible in the PDF invoice.
Do you have a solution for this?
Regards,
Dennis
Responses (11)
-
Accepted Answer
0screenshot is attached in the first message in this thread. It is a screenshot of the demo on your site.
You can easily reproduce the issue:
I added 2 items to an invoice. 1 with value 10 (ex. VAT) and 1 with value 6,5 (ex. VAT). Both have VAT 21%.
The first item has a price of 12,10 incl. VAT.
The second item 7,87. This is 7,865 exactly, so 3 decimals (which really is just the first tier of rounding, thus should not be too difficult). On the invoice line this is shown as 7,87 so that is correct.
The rounded total should be 19,97 but instead is shown as 19,96.
When this occurs, it is always just 0,01 difference and it sounds too small of a problem to worry about. However it causes all kinds of inconveniences.
I think this is a pretty standard situation where rounding occurs and this should just work correctly. -
Accepted Answer
-
Accepted Answer
-
Accepted Answer
Your Reply
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »