Re: Account report error for transactions the last 30 days

2017-10-23 Thread Tom
OK, guess I wasn't clear (my bad) the "find" action is am invoking is from the account hierarchy not from within a register. No account registers are open and only showing the account tab. I fail to understand why the total credits/debits at the bottom of the report are NOT equal when the search

Re: Account report error for transactions the last 30 days

2017-10-23 Thread Ronal B Morse
On 10/23/2017 03:38 AM, Geert Janssens wrote: Op maandag 23 oktober 2017 05:08:37 CEST schreef Christopher Lam: Edit > Find and CTRL+F are the same. The resulting search results register does not, in my view, produce very useful running balances. I'll add that Edit > Find behaves slightly

Re: Account report error for transactions the last 30 days

2017-10-22 Thread Christopher Lam
Edit > Find and CTRL+F are the same. The resulting search results register does not, in my view, produce very useful running balances. The standard Transaction Report cannot filter by Description. Doug Doughty has some custom reports I've kept at https://github.com/

Re: Account report error for transactions the last 30 days

2017-10-22 Thread Tom B
I am using both menu > edit > find or ctrl+f as it looks to be the same? I don't see where the transaction report allows me to filter transactions by description. Am I must missing it? I have not setup vendor accounts. I am simply running a find based on the vendor (shop name) and selecting

Re: Account report error for transactions the last 30 days

2017-10-22 Thread Christopher Lam
Are you using Edit > Find or CTRL-F to search description/account, and use the resulting register (which looks like a normal register) to calculate totals? If so, I think the running balance is rather meaningless. For your particular report I'd use the Transaction Report, depending on whether

Re: Account report error for transactions the last 30 days

2017-10-22 Thread Tom B
OK, problem has returned... it went away for a couple of weeks? Seems like the search results register > account report is unreliable at best. Although I would expect the search register results to balance (i.e. debits equal credits) this is not always the case. It is also calculating and

Re: Account report error for transactions the last 30 days

2017-10-14 Thread Frank H. Ellenberger
Am 14.10.2017 um 14:56 schrieb David Carlson: > I am surprised that GnuCash even allows the account report > to be run in the search results window. > > David C Perhaps we should trigger a warning, if the report is based on filtered data? Frank ___

Re: Account report error for transactions the last 30 days

2017-10-14 Thread Maf. King
On Saturday, 14 October 2017 13:56:05 BST David Carlson wrote: > I am surprised that GnuCash even allows the account report > to be run in the search results window. > > David C +1 if it really is G.I.G.O. Following Tom's report earlier that it was working again, I ran more Finds and reports,

Re: Account report error for transactions the last 30 days

2017-10-14 Thread David Carlson
I think that what you both are seeing is, in fact, as you have correctly asserted, Garbage In Garbage Out. Normally there are no running totals in search register views because they are an accumulation of transactions over an indeterminate sub set of the entire data set. Then a report derived

Re: Account report error for transactions the last 30 days

2017-10-13 Thread Tom B
Hi Maf, Well unfortunately the problem seems to have resolved itself. As of this morning the same search results account report appears to be correct. I have no clue as to why it is now different than first reported. It was consistently wrong for a couple of weeks. I did initially attempt to

Re: Account report error for transactions the last 30 days

2017-10-13 Thread Maf. King
On Thursday, 12 October 2017 20:00:41 BST Tom B wrote: > When performing a search to see how much I've spent with a particular vendor > (i.e. gas station, grocer) the search results register opens showing all > entries with the specific vendor and of course zero balance(s) in the > search

Re: Account report error for transactions the last 30 days

2017-10-13 Thread Colin Law
Hi Tom Can you provide a screenshot showing what you mean? Colin On 12 October 2017 at 20:00, Tom B wrote: > I have been using GnuCash for the past few months after importing from > Quicken. Great application and very pleased with it as a double-entry > system.

Account report error for transactions the last 30 days

2017-10-13 Thread Tom B
I have been using GnuCash for the past few months after importing from Quicken. Great application and very pleased with it as a double-entry system.  However, just over the past month or so I've noticed a very unexpected result. The file has in excess of 15,000 entries and includes 2005 to