Problem with balance sheet and transaction reports

[Pierre Maitre]

[SOLVED]
Thanks to everyone for your answers.
I proceeded as Adrien suggested and found that there was a problem
each time I had a transaction in a different currency (EUR). In fact,
the transactions in foreign currency were not "translated" into the
local currency in the report, and therefore Gnucash could not
calculate the Total.

 I checked the Currency Exchange Rate with the Price Editor, and
everything was OK. In the Report Editor, the default choice for the
exchange rate was "Volume weighted average cost of purchase", and I
changed it for "Price recorded nearest in time to the report date"....
and that made it! My balance sheet is now OK.
Still, I believe that this is a bug in my version of Gnucash.

I still have Gnucash crashing with large transactions report involving
 many years (4 or more). This may be corrected if I upgrade to a newer
version, as Geert Janssens suggested. So far, I can live with it.

Thanks to everyone

Pierre


2017-06-07 20:19 GMT+02:00 Adrien Monteleone <adrien.monteleone at gmail.com>:
> For the balance sheet issue, I'd start with 12/31/10 as the target date and
> work my way backwards to 1/1/10 dividing the time span in half each run.
> That way you can quickly narrow down the date area to look for offending
> transactions. Likely something in a transaction is not right at the date
> where the report no longer works.
>
> Not sure about a total transaction limit. I'll leave that for someone else.
>
> Regards,
> Adrien