After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 681225 - income statement displays blank base currency entries when trading account transactions are present during the report period
income statement displays blank base currency entries when trading account tr...
Status: RESOLVED FIXED
Product: GnuCash
Classification: Other
Component: Reports
2.4.x
Other Linux
: Normal normal
: ---
Assigned To: gnucash-reports-maint
gnucash-reports-maint
Depends on:
Blocks:
 
 
Reported: 2012-08-05 10:40 UTC by Sam Morris
Modified: 2018-06-29 23:09 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
data file for reproduction (9.83 KB, application/x-gnucash)
2012-08-05 10:40 UTC, Sam Morris
Details
screenshot (38.14 KB, image/png)
2012-08-05 10:41 UTC, Sam Morris
Details

Description Sam Morris 2012-08-05 10:40:16 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.
Comment 1 Sam Morris 2012-08-05 10:41:22 UTC
Created attachment 220354 [details]
screenshot

See the blank figure after the £ in the 'total expenses' line.
Comment 2 Sam Morris 2012-09-13 03:11:42 UTC
Other reports (e.g., balance sheet) also demonstrate the bug.
Comment 3 Stefan Söffing 2012-10-07 19:21:31 UTC
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)
Comment 4 Stefan Söffing 2013-01-17 18:12:48 UTC
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!
Comment 5 Carsten Rinke 2013-05-12 18:52:56 UTC
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?
Comment 6 Carsten Rinke 2013-05-12 19:08:50 UTC
Please forget about my previous comment.
I was looking at the wrong file. :-|
In fact, I do see the same behaviour.
Comment 7 Stefan Söffing 2015-05-17 19:20:50 UTC
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
Comment 8 Geert Janssens 2015-06-16 19:42:56 UTC
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 !
Comment 9 Stefan Söffing 2015-06-20 07:45:18 UTC
Very happy to hear that! Special thanks to you and all GnuCash developers for this great piece of software.

- Stefan
Comment 10 John Ralls 2017-09-24 22:42:11 UTC
Reassign version to 2.4.x so that individual 2.4 versions can be retired.
Comment 11 John Ralls 2018-06-29 23:09:59 UTC
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.