GNOME Bugzilla – Bug 681225
income statement displays blank base currency entries when trading account transactions are present during the report period
Last modified: 2018-06-29 23:09:59 UTC
Created attachment 220353 [details] data file for reproduction The Income Statement report gets screwed up when there are transactions to/from currency trading accounts during the reporting period. The attached data file should demonstrate the problem. If 'use trading accounts' is disabled (and if the trading splits are removed from the cross-currency transactions) then the figures appear as normal.
Created attachment 220354 [details] screenshot See the blank figure after the £ in the 'total expenses' line.
Other reports (e.g., balance sheet) also demonstrate the bug.
I also experience this problem. One additional note: This appears only if "Average cost" is selected as price source (which unfortunately is exactly what I need to get balanced report in the end)
Is there any more information we can provide that would help fixing this bug? I'm quite unhappy, since I can't get a usable balance sheet any more. Thanks a lot for your work!
Hi Sam and Stefan, I tried to reproduce this on my machine with GnuCash 2.4.10 and 2.5.0 on Ubuntu 12.04, but I did not manage. I just loaded the attached data file and opened the Income and Expense Statement without further modifications. The output looks ok at the first glance, all cells are filled with values that appear plausible. It doesn't make a difference whether to check or uncheck the File->Properties->Accounts->Use Trading Accounts option. I am using English locale with default currency EUR. What I miss is how the exchange rate USD<->EUR is created. At least nothing shown in the price editor for me. I do not see and sign of GBP or CHF. Can you give some more details how to reproduce this behaviour from the attached data file?
Please forget about my previous comment. I was looking at the wrong file. :-| In fact, I do see the same behaviour.
All, this bug has been around for 3 years now and no progress has been made since. I'd be really happy to be able to use the "average cost" price source to create my balances - this is the way to go in my country and the alternative price sources are ok but pretty useless for me. I'm happy to provide any information that might help debugging the issue. Digging the archive, there's a conversation that might be relevant here, see http://lists.gnucash.org/pipermail/gnucash-devel/2008-July/023401.html In this post David Hamblen reports "With no current holdings in a stock, I get blanks for that stock and for the Total Assets, Liabilities, etc., just $ signs." In a follow-up comment, Charles Day reports that issue to be resolved (r17293). This is probably a slightly different issue since it was way before trading accounts were introduced. But maybe it sheds some light to where one need to look at. I appreciate any help! Thanks. - Stefan
Stephan, your note that this only happens with average cost was a good hint. I have changed the average cost calculation to skip splits in trading accounts which seems to make it work correctly on the test file attached to this bug. This fix will go into gnucash 2.6.7 which is planned for later this month. Sorry you had to wait more than 3 years for this to happen. Feel free to report additional bugs if you come across them in the future though !
Very happy to hear that! Special thanks to you and all GnuCash developers for this great piece of software. - Stefan
Reassign version to 2.4.x so that individual 2.4 versions can be retired.
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=681225. Please update any external references or bookmarks.