[Koha-bugs] [Bug 13324] The fund values must be based on tax included values

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13324

--- Comment #4 from Jonathan Druart <jonathan.druart at biblibre.com> ---
(In reply to Francois Charbonnier from comment #3)

Bonjour François,

> For sure, it's not much, probably acceptable but I would like to know if
> there is an easy fix. What about managing more digits after the coma in the
> database and display just two?

Actually it's what it's done :)
Have a look at the data in the aqorders table for your order:
            ordernumber: 75
           biblionumber: 4996
              entrydate: 2015-01-12
               quantity: 2
              listprice: 10.000000
              unitprice: 9.520000
 unitprice_tax_excluded: 9.520000
 unitprice_tax_included: 9.996000
       quantityreceived: 2
               basketno: 35
              timestamp: 2015-01-12 18:21:52
                    rrp: 10.00
       rrp_tax_excluded: 9.523810
       rrp_tax_included: 10.000000
                  ecost: 10.00
     ecost_tax_excluded: 9.523810
     ecost_tax_included: 10.000000
   tax_rate_on_ordering: 0.0500
  tax_rate_on_receiving: 0.0500
  tax_value_on_ordering: 0.476190
 tax_value_on_receiving: 0.476000

The values are correct for the ordering.
But on receiving, the inserted value is the one displayed on the interface (the
rounded value, 9.52).
So the fund total spend (calculated on the unit price included tax) is correct:
9.996 * 2 = 19.992

I really don't know how we could get rid of this problem, I am open to all
ideas.

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