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 157247 - Asset account's "total" value should use most recent transaction prices
Asset account's "total" value should use most recent transaction prices
Status: RESOLVED FIXED
Product: GnuCash
Classification: Other
Component: General
unspecified
Other All
: Normal normal
: ---
Assigned To: gnucash-general-maint
Chris Lyttle
Depends on:
Blocks:
 
 
Reported: 2004-11-03 16:29 UTC by gjditchfield
Modified: 2018-06-29 20:47 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
Sample with one mutual fund purchase (1.74 KB, application/x-gnucash)
2013-12-15 14:24 UTC, gjditchfield
Details
Screenshot (74.74 KB, image/png)
2013-12-15 14:31 UTC, gjditchfield
Details
Screenshot of account page with a single buy transaction (91.80 KB, image/png)
2013-12-15 18:43 UTC, John Ralls
Details
Account file after creating a single buy transaction (4.15 KB, application/gnucash)
2013-12-15 18:48 UTC, John Ralls
Details

Description gjditchfield 2004-11-03 16:29:25 UTC
Create an asset account.  Create a commodity for a mutual fund.  Create a 
mutual fund account as a child of the asset account.  Open the mutual fund in a 
register and enter a transaction buying some number of units at some price.  
Close the register and look at GnuCash's main window.  The mutual fund account 
shows the number of units in the "Total" column, but the parent asset account 
shows 0 in the "Total" column, because no price has been entered through the 
Price Editor. 
   In this case the problem is obvious, but newcomers don't intuitively know 
how to fix it and get rid of that zero.  The problem bites me later on, when I 
add more transactions but forget to enter the new price into the price editor, 
so the "Total" column shows an out-of-date value.  (I haven't found 
Finance::Quote to be convenient.) 
   I'd like the "Total" column to use the price entered in the transaction if 
it is more recent than anything in the price database.
Comment 1 Derek Atkins 2004-11-04 04:33:38 UTC
A better solution is to make the register add prices to the pricedb.
Comment 2 John Ralls 2013-12-14 18:36:03 UTC
Fixed a long time ago, in the manner Derek suggested.
Comment 3 gjditchfield 2013-12-15 14:24:07 UTC
Created attachment 264219 [details]
Sample with one mutual fund purchase
Comment 4 gjditchfield 2013-12-15 14:25:31 UTC
How long ago was this fixed? I still see the problem with GnuCash 2.4.13
Comment 5 gjditchfield 2013-12-15 14:31:37 UTC
Created attachment 264222 [details]
Screenshot

Ubuntu 12.04, GnuCash 2.4.13 from http://www.ubuntuupdates.org/package/getdeb_apps/precise/apps/getdeb/gnucash.
Ubuntu 12.04's GnuCash 2.4.10 looks the same.
Comment 6 John Ralls 2013-12-15 18:43:05 UTC
Created attachment 264241 [details]
Screenshot of account page with a single buy transaction
Comment 7 John Ralls 2013-12-15 18:48:48 UTC
Created attachment 264242 [details]
Account file after creating a single buy transaction

And here is my file after creating a single buy transaction in GC2.4.13. It has a price, created by the transfer dialog, and as the screenshot shows, the values flow through to the accounts.

I suspect, then, that you entered the splits in split view from the mutual fund account in a way that doesn't trigger the transfer dialog. If that's the case, it's up to you to also create the price in the price editor.
Comment 8 gjditchfield 2013-12-17 03:27:21 UTC
Correct, no transfer dialog. What I did just now is
- Opened the previously attached tgc.gnucash.
- Opened the "mutual fund" account. The register appeared, with "split" not activated.
- Clicked in the "Transfer" field of the blank transaction and entered Assets:cash.
- Tabbed to "Shares" and entered "56".
- Tabbed to "Price" and entered "78".
- Hit enter and closed the Mutual Fund tab.
Out on the Accounts tab, Assets and cash both show -$4,776, but Investments and Brokerage Account both show $0.

Could direct entry in the register create a price? I thought that is what Derek meant in comment 1.
Comment 9 John Ralls 2013-12-17 04:47:40 UTC
Ah, the other direction. You're right, that doesn't fire the transfer dialog, and so it doesn't get the routine that puts the price into the Price table, even though it does calculate a price. That should be an easy fix.
Comment 10 John Ralls 2013-12-20 00:48:02 UTC
Which is committed in r23583.
Comment 11 John Ralls 2018-06-29 20:47: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=157247. Please update any external references or bookmarks.