[Koha] Koha upgrade from 3.16 to 16.11

[Jonathan Druart]

Nicolas, what you describe can be ok, if the tax rate is 0.
You need to provide ALL the price values from aqorders (quantity,
listprice, unitprice, unitprice_tax_excluded, unitprice_tax_included,
quantityreceived, rrp, rrp_tax_excluded, rrp_tax_included, ecost,
ecost_tax_excluded, ecost_tax_included, tax_rate_bak, tax_rate_on_ordering,
tax_rate_on_receiving, tax_value_bak, tax_value_on_ordering,
tax_value_on_receiving, discount, uncertainprice).


On Wed, 19 Apr 2017 at 12:16 Nicolas Legrand <nicolas.legrand at bulac.fr>
wrote:

> Hey Jonathan, Hey Hugo,
>
> we also have trouble in 16.11 with tax calculation :
>
> mysql> select unitprice_tax_excluded, unitprice_tax_included from
> aqorders join aqinvoices on aqinvoices.invoiceid = aqorders.invoiceid
> where aqinvoices.invoiceid = 2674 limit 10;
> +------------------------+------------------------+
> | unitprice_tax_excluded | unitprice_tax_included |
> +------------------------+------------------------+
> |              80.400000 |              80.400000 |
> |              32.760000 |              32.760000 |
> |             110.700000 |             110.700000 |
> |              87.410000 |              87.410000 |
> |              23.290000 |              23.290000 |
> |             127.320000 |             127.320000 |
> |              28.940000 |              28.940000 |
> |              72.240000 |              72.240000 |
> |             205.670000 |             205.670000 |
> |              18.590000 |              18.590000 |
> +------------------------+------------------------+
> 10 rows in set (0.00 sec)
>
> We had a lot of errors while upgrading we unfortunately didn't pay
> attention to:
>
> Use of uninitialized value in multiplication (*) at
> ./installer/data/mysql/updatedatabase.pl line 13614.
> [A LOT MORE OF THE SAME THING]
> Use of uninitialized value in multiplication (*) at
> ./installer/data/mysql/updatedatabase.pl line 13619.
> Upgrade to 16.06.00.043 done (Bug 13323 - Change the tax rate on receiving)
>
>
> I'm going to investigate this, if someone as good ideas I'm eager to
> hear from them :).
>