GNOME Bugzilla – Bug 600194
Transaction dollar amount is not displayed when opening a saved file.
Last modified: 2018-06-29 22:30:12 UTC
I recently created a new set of accounts. I only input one transaction, which was to set an opening balance for one of the accounts. Right afterwards, I exited GnuCash and the next time I started GnuCash, all of my accounts where still there and so was the opening balance transaction. However, in the general ledger, the "Tot Funds In" and "Tot Funds Out" columns for the opening balance transaction where blank. Also, on the accounts tab the value in the total column for that account was $ (Only a dollar sign. The rest of my accounts have $0.00 in this column) I am using the sqlite backend. I looked in the database file, and the amount I originally entered for the opening balance is still listed in the splits table.
Can you e-mail me the file (plongstaff@rogers.com).
I have e-mailed you the file.
I'm not able to reproduce your problem. I see the values in the general ledger, and also see the amounts in the account page. It is possible that there is some other difference in my environment so that it works. I don't know what to suggest. Is there anything funny in /tmp/gnucash.trace which might indicate a problem? One change in 2.3.8 which will be released soon is a change in how transactions are loaded on startup. That might fix the problem. I'm not sure what to suggest.
I just tried again with the latest version of gnucash from svn (commit r18432). The dollar amounts for accounts in the account summary now display $0.00 (previously, the dollar amount was blank). However, they should be displaying the amount of the opening balance transaction. Also, the values for the opening balance transaction are still not showing up on the general ledger page. I did notice some errors in /tmp/gnucash.trace, which I have attached to this bug report.
Created attachment 148335 [details] Gnucash trace file when loading saved sqlite account.
Thank you for your report. I wonder if your issue is a duplicate of bug 611936. I have experienced the same problem on Mandriva 2010.0 and Fedora 12/13. In my case the problem was caused by an compiler optimization error in the libdbi library. To fix it, libdbi has to be recompiled without the optimization flag. Fedora at least has released updated libdbi packages to resolve this issue, which is not a GnuCash bug. What distribution do you use ? And what version of libdbi does it come with ? If on fedora, have you tried with the latest libdbi packages ?
Closing this bug report as no further information has been provided. Please feel free to reopen this bug if you can provide the information asked for. Thanks! (Or maybe this is indeed just a duplicate of bug 611936, meaning the libdbi installation in question has a problem.)
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=600194. Please update any external references or bookmarks.