[Koha-bugs] [Bug 18736] Problems in order calculations (rounding errors)

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18736

Marcel de Rooy <m.de.rooy at rijksmuseum.nl> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Signed Off                  |Failed QA

--- Comment #144 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
(In reply to Nick Clemens from comment #140)
> >With the pref to nearest cent, the total ordered drops one cent, while it should >drop three cent (using your example where 78,83 becomes 78,80).
> 
> Can you let me know where you are seeing this? Apologies if I am missing
> something obvious

Still seeing this. Best to illustrate by two images (see atts).
The basket shows 78,80 and 15,33 tax. (94,13)
The budget shows 92,16 (note that includes a -2, so 94,16)
Three cents difference. This comes from rounding at different moments.

The db shows:
+-----------------------+
| tax_value_on_ordering |
+-----------------------+
|             15.326600 |
+-----------------------+
+--------------------+
| ecost_tax_excluded |
+--------------------+
|           9.854200 |
+--------------------+
+--------------------+
| ecost_tax_included |
+--------------------+
|          11.770842 |
+--------------------+

8 * 11,77 = 94,16
8 * 9,85[rounded] * 1,1945 (tax percentage ) = 94,13

Difference: For 94,16 tax is calculated on not rounded price (9,8542). But for
94,13 tax is based on rounded price (9,85).
How much tax do you want to pay ? ;)

Not a real blocker for me btw. But this shows that we are not making consistent
calculations in Acqui. If we still want to push, we should be aware of it at
least.

Will ask Joubu to comment on this finding too. Changing status for now.

-- 
You are receiving this mail because:
You are watching all bug changes.