Re: General Journal - history limit and search
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 out a way to get the general journal back to showing all the transactions after doing a search other than by opening another general journal. Might be able to do it by changing the filter settings in view. I'll try that tomorrow. Thanks On Oct 31, 2017 7:20 PM, "David Carlson" wrote: > 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 need to close the > previous results views unless you do not expect to go back to them and you > would rather have less clutter on your desktop. > > David C > > On Tue, Oct 31, 2017 at 12:23 PM, Roger Oliver wrote: > >> 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 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 general journal the results are shows in the >> same >> >> journal, not in another register. Don't know how to get the general >> >> journal >> >> back to showing all the transactions. I just close it and open the >> general >> >> journal again from the tools menu. Is there a better way? Something I'm >> >> not >> >> doing correctly in the search criteria window? >> >> >> >> Thanks, >> >> Roger >> > >> > >> > With the General Ledger open, click "View" then "Filter By..." and >> adjust >> > the filter to your liking. It doesn't remember this setting, so you'll >> have >> > to do it any time you close then reopen gnucash. >> > >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > > ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: General Journal - history limit and search
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 need to close the previous results views unless you do not expect to go back to them and you would rather have less clutter on your desktop. David C On Tue, Oct 31, 2017 at 12:23 PM, Roger Oliver wrote: > 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 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 general journal the results are shows in the > same > >> journal, not in another register. Don't know how to get the general > >> journal > >> back to showing all the transactions. I just close it and open the > general > >> journal again from the tools menu. Is there a better way? Something I'm > >> not > >> doing correctly in the search criteria window? > >> > >> Thanks, > >> Roger > > > > > > With the General Ledger open, click "View" then "Filter By..." and adjust > > the filter to your liking. It doesn't remember this setting, so you'll > have > > to do it any time you close then reopen gnucash. > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: General Journal - history limit and search
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 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 general journal the results are shows in the same >> journal, not in another register. Don't know how to get the general >> journal >> back to showing all the transactions. I just close it and open the general >> journal again from the tools menu. Is there a better way? Something I'm >> not >> doing correctly in the search criteria window? >> >> Thanks, >> Roger > > > With the General Ledger open, click "View" then "Filter By..." and adjust > the filter to your liking. It doesn't remember this setting, so you'll have > to do it any time you close then reopen gnucash. > ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: General Journal - history limit and search
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 any > > transactions earlier than October either. Is there a setting I'm > > overlooking to include everything in the general journal? > > > > Hi, > > ISTR that the GL defaults to showing the current month only. View -> > Filter > By -> [Date] should get you going... > > HTH, > Maf. > > ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: General Journal - history limit and search
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 > overlooking to include everything in the general journal? > > Also, when I search the general journal the results are shows in the same > journal, not in another register. Don't know how to get the general journal > back to showing all the transactions. I just close it and open the general > journal again from the tools menu. Is there a better way? Something I'm not > doing correctly in the search criteria window? > > Thanks, > Roger With the General Ledger open, click "View" then "Filter By..." and adjust the filter to your liking. It doesn't remember this setting, so you'll have to do it any time you close then reopen gnucash. ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: General Journal - history limit and search
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 include everything in the general journal? > Hi, ISTR that the GL defaults to showing the current month only. View -> Filter By -> [Date] should get you going... HTH, Maf. ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: General Journal - history limit and search
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 gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: General Journal - history limit and search
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 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 account. I would think > the ledger either should have a limit, or have a specified date range. > > Regards, > Adrien > >> On Oct 31, 2017, at 11:39 AM, 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 include everything in the general journal? >> >> Also, when I search the general journal the results are shows in the same >> journal, not in another register. Don't know how to get the general journal >> back to showing all the transactions. I just close it and open the general >> journal again from the tools menu. Is there a better way? Something I'm not >> doing correctly in the search criteria window? >> >> Thanks, >> Roger >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: General Journal - history limit and search
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 account. I would think the ledger either should have a limit, or have a specified date range. Regards, Adrien > On Oct 31, 2017, at 11:39 AM, 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 include everything in the general journal? > > Also, when I search the general journal the results are shows in the same > journal, not in another register. Don't know how to get the general journal > back to showing all the transactions. I just close it and open the general > journal again from the tools menu. Is there a better way? Something I'm not > doing correctly in the search criteria window? > > Thanks, > Roger > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
General Journal - history limit and search
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 general journal the results are shows in the same journal, not in another register. Don't know how to get the general journal back to showing all the transactions. I just close it and open the general journal again from the tools menu. Is there a better way? Something I'm not doing correctly in the search criteria window? Thanks, Roger ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Bank reconciliation history
> 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 ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Bank reconciliation history
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 Cc: "gnucash-user@gnucash.org" Sent: Monday, 30 October 2017, 13:27 Subject: Re: Bank reconciliation history Don't think this information is stored in the database. I think the closest approach is use Transaction Report, enable Display/Reconciled Date, set Sorting/Primary Key to Reconciled date, Sorting/Secondary Key to None. But I don't think the 'reconciled balance at reconciliation date' is ever stored. Interestingly from the account register, there's View/Sort By... "Statement Date" which doesn't seem to do what the tooltip says. On 30 October 2017 at 18:00, Mark Roworth via gnucash-user wrote: Hi all, Is there anyway I can see a list of bank statements and which transactions were reconciled to which statements? For the life of me I can't find it? Thanks for any help received, Mark Mark roworthrowor...@yahoo.co.uk __ _ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/ mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
