BizzMix
BizzMix
Offline
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
Attachments:
Responses (10)
  • Accepted Answer

    Friday, February 28 2020, 05:23 PM - #Permalink
    0
    rounding in JavaScript sometimes act funny. I'll check this.
    The reply is currently minimized Show
  • Accepted Answer

    BizzMix
    BizzMix
    Offline
    Tuesday, March 03 2020, 11:43 AM - #Permalink
    0
    Did you have the chance yet to check this?
    The reply is currently minimized Show
  • Accepted Answer

    BizzMix
    BizzMix
    Offline
    Thursday, March 12 2020, 11:44 AM - #Permalink
    0
    Hello Germinal,

    Did you check this yet?
    Rounding issues are also apparent when invoices are generated with the hikashop plugin; I attached a screenshot of some generated invoices. This is unlikely to be caused by javascript, or is it?
    Attachments:
    The reply is currently minimized Show
  • Accepted Answer

    BizzMix
    BizzMix
    Offline
    Wednesday, June 10 2020, 11:38 AM - #Permalink
    0
    Germinal, when are you going to check this?
    The reply is currently minimized Show
  • Accepted Answer

    BizzMix
    BizzMix
    Offline
    Monday, June 15 2020, 07:50 AM - #Permalink
    0
    Well?
    The reply is currently minimized Show
  • Accepted Answer

    BizzMix
    BizzMix
    Offline
    Wednesday, August 05 2020, 11:40 AM - #Permalink
    0
    ....
    The reply is currently minimized Show
  • Accepted Answer

    Friday, August 07 2020, 08:05 AM - #Permalink
    0
    Hello

    sorry for the delay

    can you show a screenshot of the detail of the invoie (in edit mode)? how many decimals are you using for calculation?
    The reply is currently minimized Show
  • Accepted Answer

    BizzMix
    BizzMix
    Offline
    Friday, August 07 2020, 08:58 AM - #Permalink
    0
    screenshot 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.
    The reply is currently minimized Show
  • Accepted Answer

    BizzMix
    BizzMix
    Offline
    Tuesday, September 29 2020, 01:03 PM - #Permalink
    0
    ???
    The reply is currently minimized Show
  • Accepted Answer

    BizzMix
    BizzMix
    Offline
    Wednesday, December 09 2020, 10:11 AM - #Permalink
    0
    ?!?
    The reply is currently minimized Show
Your Reply