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 355660 - 'Advanced Portfolio' report confused by split transactions
'Advanced Portfolio' report confused by split transactions
Status: RESOLVED FIXED
Product: GnuCash
Classification: Other
Component: Reports
2.0.x
Other Linux
: Normal normal
: ---
Assigned To: Andrew Sackville-West
Chris Lyttle
Depends on:
Blocks:
 
 
Reported: 2006-09-12 21:22 UTC by Neil Williams
Modified: 2018-06-29 21:12 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
Jeroen's attachment (10.81 KB, text/plain)
2006-09-12 21:23 UTC, Neil Williams
Details
reworked test data showing a better way to enter txn. (2.19 KB, application/xml)
2007-12-17 19:05 UTC, Andrew Sackville-West
Details

Description Neil Williams 2006-09-12 21:22:22 UTC
Debian bug 387031:
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=387031

Package: gnucash
Version: 2.0.1-2
Severity: normal

With split transactions, the 'advanced portfolio' report takes a
random split as the 'money in'. If you load the attached file in
gnucash, and ask for the advanced portfolio report, it shows the money in
as GBP -148.00, a total gain of GBP 307.00, and a net gain of -207.43%...

This was ok with v1.8.xx

Jeroen Nijhof
Comment 1 Neil Williams 2006-09-12 21:23:27 UTC
Created attachment 72645 [details]
Jeroen's attachment

The same test file from the Debian report.
Comment 2 Christian Stimming 2006-09-13 08:34:03 UTC
Is this a duplicate of bug#115267 or one of the bugs mentioned in there?
Comment 3 Boris Zbarsky 2006-09-29 13:53:57 UTC
This doesn't look like a duplicate of bug 115267 for the simple reason that this bug is a regression from 1.8.x to 2.0.x, while bug 115267 occurs in 1.8.x.

Is there a way to flag bugs as regressions, by the way?
Comment 4 Richard Laager 2007-12-17 02:04:13 UTC
In trunk, specifically with the advanced portfolio file from r16637, I'm seeing $0 as the basis with the test file.

Should this be assigned to andrewsw, given the recent commits?
Comment 5 Andrew Sackville-West 2007-12-17 19:02:32 UTC
If I set my default currency to GBP and the report currency to GBP, I do not see this behavior (comment #4). In fact it appears to be "working" in that the report gives the best information it can in light of other known issues. 

Specifically, the test data includes a split txn with a direct income split. This just doesn't work at this point. The split from the OP's payroll should move through an interim account ("brokerage acct") before the buy is made. I'll attach a reworking of that file in which everything seems to work, to my eye. 

To explain, the report is rather dumb and can't tell that the Income in the original test file is salary income and is unrelated to the stock account. It also can't tell that the other split, into checking account, is also unrelated to the stock. There's simply not enough information at the moment to make those distinctions without getting into using the Action field which is currently not implemented. 
Comment 6 Andrew Sackville-West 2007-12-17 19:05:23 UTC
Created attachment 101136 [details]
reworked test data showing a better way to enter txn.

hmm... rounding error. but otherwise looks good to me. comments please!
Comment 7 Andrew Sackville-West 2007-12-19 22:20:05 UTC
This should be fixed in svn r16684, awaiting backport.
Comment 8 Andreas Köhler 2008-01-05 01:25:58 UTC
In the current state r16684 cannot be backported directly, so I remove the block on bug 486922.
Three possibilities:
1) wait for 2.4
2) backport other changes so that r16684 can be applied syntactically and semantically.
3) if r16684 is orthogonal to the changes in 2), branch off 2.2 and apply r16684 manually there.

Thanks!
Comment 9 John Ralls 2018-06-29 21:12:46 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=355660. Please update any external references or bookmarks.