GNOME Bugzilla – Bug 637740
Account Report on search results: funds in/funds out column totals incorrect
Last modified: 2018-06-29 22:49:37 UTC
Created attachment 176823 [details] Account report bug screenshots If you run the Account report on search results on an account that gets reconciled (like a credit card account in my case), and the search results include both reconciled and unreconciled transactions, the total of the Funds Out column will be the total of the unreconciled transactions, and the total of the Funds In column will be the total of the reconciled transactions. Example (see attached images): Picture 3 is a little view on my whole credit card account Picture 2 is the result of selecting all transactions with description = 'red clay' Picture 1 is the result of running Account Report from the result of the search The last two Red Clay transactions sum to $10.76; these two haven't yet been reconciled. The others have been, and they sum to $33.84. You can't quite see the bottom line of the report; it says "Net Change $23.08"
Can you verify this bug still exists in 2.3.17?
Some trials: (a) select all credit card transactions against Amazon. Total line shows $14.58 debits, $1745.74 credits, net change 1731.16. Each detail line is a simple expense/liability transaction. (b) run the Acccount Report for the whole account. The difference between total debits and total credits is the total unreconciled balance as of today. (c) select all Amazon transactions since 9/1/2010. Total line shows a number for Total Credits only, and a Net Change of the same amount. (d) Select all transactions since 9/1/2010. Total line shows total credits about twice the amount of total debits. (This might be the unreconciled transactions, since it's been a spendy month.)
Comment 2 trials run on 2.3.17 from dmg package, on Mac OS X 10.5.8
Just to add that I see the same behaviour running under win7 x64. Here's what I said in the mailing list: If I edit my search dates such that I only include reconciled transactions, then the 'Total debits' and 'net change' values are the same, and equal the total for all the searched for transactions. Total credits does not appear in the report. As soon as there is an unreconciled transaction in the search results this goes wrong; it seems that total debits shows the total for reconciled transactions, total credits shows the total for the unreconciled transaction, and net change shows debits minus credits.
Created attachment 182240 [details] Search results report example GnuCash XML file File used to give the results in the example. Add a transaction the other way round as a refund to show more odd behaviour
I'm getting similarly bizarre behaviour with 2.4.3. Not only does the reconcile status matter to the totalling of Total Credits and Total Debits in the report, the means by which the search results are obtained makes a difference. what I mean is that two search results registers with *identical* transactions in them give different totals when the Account Report is run from them. Example in my test file: Edit > Find Description > contains > shop Reconcile > is > cleared reconciled and Description > contains > shop Date Posted > is before > 02/03/2011 both create the same set of results. Run an account report on them and the reports are different. Playing around with differect scenarious can realut in some mind-boggling combinations. Add a refund transaction for example throws up another level of complexity. It all seems to boil down to reconcile status, but quite what it's doing is extremely confusing.
I tried to reproduce this bug with GnuCash 2.4.10 on Ubuntu 12.04, but I did not manage. The Debits and Credits totals look ok independent of the the reconciliation status. The behaviour from Comment 6 is not reproducible either. To the reporters Tony, Rich, and Ian: Assuming that meanwhile you have upgraded to a later release, can you try to reproduce this bug and confirm that it is either gone or still existing?
Had a very quick look in 2.4.11 on win8, and it does seem to be fixed.
Thanks for taking the time to report this bug. However, you are using a version that is too old and not supported anymore. GNOME developers are no longer working on that version, so unfortunately there will not be any bug fixes for the version that you use. By upgrading to a newer version of GNOME you could receive bug fixes and new functionality. You may need to upgrade your Linux distribution to obtain a newer version of GNOME. Please feel free to reopen this bug if the problem still occurs with a newer version of GNOME.
In comment #9: For GNOME read GnuCash.
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=637740. Please update any external references or bookmarks.