Comment 3 for bug 1638064

Revision history for this message
Sebastien Coutaz (sebcou) wrote : Re: Reports show wrong values after upgrade to 5.1

Hi Maxime,

It is of course true that the initial balance must be taken into consideration otherwise it would be wrong anyway.

The problem with the report in 5.1 is that it now calculates the account balance as if the first date on the report was the creation date of the account. But it doesn't take into account the transactions that happened on the account since it's creation.

Example from my sample file with last quarter report on account 1:

Date = 01.07.2016
Expense = -5195.25 (right)
Income = 8804.25 (initial balance of the account --> wrong)
Balance = 3645.00 (wrong)

On 5.0.8 same reports show:

Date = 01.07.2016
Expense = -5195.25 (right)
Income = nothing (right)
Balance = 12991.30 (right. it is the balance of the account on 30.06.16 minus the expenses of 01.07.16)

If you look at the transactions on account 1, the balance of 12991.30 is right.

For your information, I simply updated from 5.0.8 to 5.1 without changing anything to the database and I noticed the problem appeared. I'm also always prompted to choose the currency when opening the database although I did it and verified that each account has the currency configured.

Thanks in advance and best regards,
Sebastien