Re: General Journal - history limit and search

2017-10-31 Thread Roger Oliver
I thought so too but it doesn't seem to work that way. I keep the general journal open on the desktop. It isn't that difficult to open it again, just a curiosity that it didn't show the search results in a new window like the account journals. Once it shows the search results, I haven't figured

Re: General Journal - history limit and search

2017-10-31 Thread David Carlson
Roger, for your second question, I think that a search in the General ledger view should produce it's results in a new results view rather than the first General Ledger view. However, if I am wrong about that, it should be simple to open a new General Ledger view from the menu. You should not

Re: General Journal - history limit and search

2017-10-31 Thread Roger Oliver
Perfect. Thanks On Oct 31, 2017 11:08 AM, "Aaron Laws" wrote: > On Tue, Oct 31, 2017 at 12:39 PM, Roger Oliver wrote: > >> I notice my general journal only goes back to the beginning of Octuber. >> Transactions from September don't show. A search by date

Re: General Journal - history limit and search

2017-10-31 Thread Roger Oliver
Perfect. Thanks On Oct 31, 2017 11:01 AM, "Maf. King" wrote: > On Tuesday, 31 October 2017 16:39:28 GMT Roger Oliver wrote: > > I notice my general journal only goes back to the beginning of Octuber. > > Transactions from September don't show. A search by date doesn't find

Re: General Journal - history limit and search

2017-10-31 Thread Aaron Laws
On Tue, Oct 31, 2017 at 12:39 PM, Roger Oliver wrote: > I notice my general journal only goes back to the beginning of Octuber. > Transactions from September don't show. A search by date doesn't find any > transactions earlier than October either. Is there a setting I'm >

Re: General Journal - history limit and search

2017-10-31 Thread Maf. King
On Tuesday, 31 October 2017 16:39:28 GMT Roger Oliver wrote: > I notice my general journal only goes back to the beginning of Octuber. > Transactions from September don't show. A search by date doesn't find any > transactions earlier than October either. Is there a setting I'm > overlooking to

Re: General Journal - history limit and search

2017-10-31 Thread Colin Law
On 31 October 2017 at 16:39, Roger Oliver wrote: > I notice my general journal only goes back to the beginning of Octuber. Try View > Filter By and on the Date tab click Show All Colin ___ gnucash-user mailing list

Re: General Journal - history limit and search

2017-10-31 Thread Adrien Monteleone
That should have been “shouldn’t have a limit” - sorry. Regards, Adrien > On Oct 31, 2017, at 11:54 AM, Adrien Monteleone > wrote: > > Interesting. > > I’m noticing this too on 2.6.18 on El Capitan. > > I rarely use the General Ledger, so I can’t say if it

Re: General Journal - history limit and search

2017-10-31 Thread Adrien Monteleone
Interesting. I’m noticing this too on 2.6.18 on El Capitan. I rarely use the General Ledger, so I can’t say if it provided more history in the past or not. Personally, I enter everything directly in accounts anyway (save for business features) and can always see the full history for that

General Journal - history limit and search

2017-10-31 Thread Roger Oliver
I notice my general journal only goes back to the beginning of Octuber. Transactions from September don't show. A search by date doesn't find any transactions earlier than October either. Is there a setting I'm overlooking to include everything in the general journal? Also, when I search the

Re: Bank reconciliation history

2017-10-31 Thread William Jackson
> Am going to look at writing some SQL to pull this out of the GNU cash database You will be looking for the "reconcile_date" column on the "splits" table. I use PostgreSQL and I'm curious to hear about any fancy SQL you come up with! Wiliam ___

Re: Bank reconciliation history

2017-10-31 Thread Mark Roworth via gnucash-user
Thanks everyone with you help with this. Am going to look at writing some SQL to pull this out of the GNU cash database (I happen to be a SQL developer).  Mark roworthrowor...@yahoo.co.uk07870 575707 From: Christopher Lam To: Mark Roworth