Date ranges on General Reports/General Journal?

[Edward Doolittle]

I don't know the answer to your question about why the General Journal
cannot be date limited ... it seems like an oversight to me, and perhaps
someone (maybe me?) will eventually correct it.

I do, however, have two suggestions for you to work around the problem.

1) Open the General Journal report, and Export. It will save as an HTML
file. Open that HTML file in Excel or a similar editor, and delete the rows
which are outside your date range. I can verify that this worked for me,
with Excel 2016. It took a few minutes because the file size was large, but
eventually it completed.

2) Save your GnuCash file as SQL and query the database. I haven't tried
this myself but I understand from what others have written that this is a
nice, relatively easy way to get data out of your GnuCash file. Writing the
SQL query is almost certainly easier than patching the Scheme in which the
reports are written. I'm not familiar enough with this method to help you,
but others on this list are SQL masters and might be able to help you.

Method 2) is the direction in which GnuCash is moving, which may explain
why so many of the current reports are not well maintained: they will soon
be obsolete anyway.

Edward

On 16 January 2017 at 03:22, Jobjörn Folkesson <jobjorn at gmail.com> wrote:

> Yes, this I know. The General Ledger report is not as good as the General
> Journal for my purpose, however - all transactions are shown at least twice
> (one time for each account they're in) and split transactions show as
> "Split transaction" rather than information of which accounts are involved
> in the split. I want to save a paper copy of the entire year's records (and
> give one copy to the auditors), so it won't suffice.
>
> So my original question - why can't you date-limit the General Journal? -
> remains. Perhaps a developer could answer.
>
> Regards,
> Jobjörn
>
> On Sun, Jan 15, 2017 at 11:00 PM, david.carlson.417 at gmail.com <
> david.carlson.417 at gmail.com> wrote:
>
> > You found a report that I did not know about.  I agree that it is
> useless,
> >  but if you open the General Ledger register and adjust the view as I
> > suggested then run the Account Report you get a time interval limited
> > report that covers all accounts.  The General Ledger report just below
> the
> > General Journal report allows selection of dates, accounts and several
> > other features.
> >
> >
> > David C
> >
> >
> > Sent from my LG G Pad 7.0 LTE, an AT&T 4G LTE tablet
> >
> >
> > ------ Original message------
> >
> > *From: *Jobjörn Folkesson
> >
> > *Date: *Sun, Jan 15, 2017 1:32 PM
> >
> > *To: *david.carlson.417 at gmail.com;
> >
> > *Cc: *gnucash-user at gnucash.org;
> >
> > *Subject:*Re: Date ranges on General Reports/General Journal?
> >
> >
> > Do you mean opening an account view, filtering that, and then opening the
> > General Reports report? I don't see why that would work, and upon trying
> I
> > can verify that it does not.
> >
> > Just to be clear, the wiki (https://wiki.gnucash.org/
> > wiki/Using_GnuCash#General_Journal) explicitly says "This report is not
> > customizable by date", so I really think you can't customize it by date.
> I
> > am curious as to why you can't do that.
> >
> > Jobjörn Folkesson
> >
> >
> >
> > On Sun, Jan 15, 2017 at 7:54 PM, david.carlson.417 at gmail.com <
> > david.carlson.417 at gmail.com> wrote:
> >
> >> I guess I was not clear.  I meant to say to limit the register view to
> >> only show the transactions that are of interest before opening the
> report.
> >>
> >>
> >> David C
> >>
> >>
> >> Sent from my LG G Pad 7.0 LTE, an AT&T 4G LTE tablet
> >>
> >>
> >> ------ Original message------
> >>
> >> *From: *Jobjörn Folkesson
> >>
> >> *Date: *Sun, Jan 15, 2017 10:00 AM
> >>
> >> *To: *David Carlson;
> >>
> >> *Cc: *gnucash-user at gnucash.org;
> >>
> >> *Subject:*Re: Date ranges on General Reports/General Journal?
> >>
> >>
> >> When you've opened the "General Reports" report, "Filter by" isn't
> >> available in the View menu?
> >>
> >> Jobjörn Folkesson
> >>
> >> On Sun, Jan 15, 2017 at 1:17 AM, David Carlson <
> >> david.carlson.417 at gmail.com> wrote:
> >>
> >>> These reports include all transactions in the register.  You can select
> >>> View > Filter By > Date > Select Range to define the report date range.
> >>>
> >>> David C
> >>>
> >>> On Sat, Jan 14, 2017 at 7:06 AM, Jobjörn Folkesson <jobjorn at gmail.com>
> >>> wrote:
> >>>
> >>>> Hello!
> >>>>
> >>>> I'd like a list of all transactions from 2016, and the report "General
> >>>> Reports" (GnuCash 2.6.15, Windows) provides exactly what I want - but
> >>>> without any way to filter by date, as in all other reports. Why is
> this?
> >>>>
> >>>> The report is called "General Journal" here
> >>>> https://wiki.gnucash.org/wiki/Using_GnuCash#General_Journal and in
> >>>> Swedish
> >>>> it is called "Transaktionslista" (GnuCash 2.6.12, Ubuntu).
> >>>>
> >>>> Sincerely,
> >>>>
> >>>> Jobjörn Folkesson
> >>>> _______________________________________________
> >>>> gnucash-user mailing list
> >>>> gnucash-user at 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 at 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.
>



-- 
Edward Doolittle
Associate Professor of Mathematics
First Nations University of Canada
1 First Nations Way, Regina SK S4S 7K2

« Toutes les fois que je donne une place vacante, je fais cent mécontents
et un ingrat. »
-- Louis XIV, dans Voltaire, Le Siècle de Louis XIV, Chap. XXVI