Find/Report invoices with a particular line in a description field

[Tommy Trussell]

(sorry to top-post but everyone else has in this thread)

another option would be to use XML and set the preference in "Auto-save
time interval" to one minute.

If you do this, you will want to set the "Retain log/backup files" to some
small number of days, because GnuCash will likely generate many of them.

On Tue, Dec 2, 2014 at 8:33 AM, R. Victor Klassen <rvklassen at gmail.com>
wrote:

> I had the same thought a few minutes ago.  I may well do this.   It would
> be a nice to have feature year round, but right now, I’m thinking of annual
> planning, and for that, a save-as approach would then let me write code to
> parse and extract anything I want to dump to a spreadsheet.
>
> And one of these days I’ll get a working GNUcash development environment
> on my machine.  Failed to do so last year before the busy season came, but
> maybe this season…
>
>
> On Dec 2, 2014, at 8:09 AM, Maf. King <maf at chilwell.net> wrote:
>
> > You could always "save as" out of your master sql format file to a
> temporary
> > xml for the purposes of searching.... yeah, a bit kludgey.
> >
> > Just a thought,
> > Maf.
> >
> >
> >
> > On Tue 2 December 14 07:37:12 R. Victor Klassen wrote:
> >> I gather you use xml.  I’m using sqlite, because, despite the issues
> with
> >> possible corner cases not being fully tested and debugged, I prefer to
> have
> >> transactions committed when I hit enter.  I tried XML for awhile, and
> then
> >> we had two power outages in a month.  Switched to sqlite, and the power
> has
> >> been relatively stable ;-)
> >> On Dec 1, 2014, at 8:16 PM, Bob Brush <bobbrush3 at gmail.com> wrote:
> >>> I don't know if you are a Linux guy, but if so you can use a program
> >>> "zcat" and "grep" your file to find anything, it's a beautiful thing in
> >>> there, everything plain text, descriptions, so nice.. I had to once
> when
> >>> I was on a fishing trip for a customer name and I could only remember
> >>> part of the notes..>
> >>>> On Nov 29, 2014, at 10:46 AM, R. Victor Klassen <rvklassen at gmail.com>
> >>>> wrote:
> >>>>
> >>>> Greetings all,
> >>>>
> >>>> To give a concrete example, suppose 40 or so different income accounts
> >>>> associated with different things I sell.  One of these might be
> widgets
> >>>> of type A.  And so I have an account for type A widgets, and can
> easily
> >>>> see how much I’ve made in type A widgets, although not how many
> (unless
> >>>> they are always at the same price), nor whether the red, green or
> yellow
> >>>> ones generated the most income.  There are limits to how bushy I want
> to
> >>>> make the account tree, so I don’t have a separate account for each
> >>>> colour of type A widget.
> >>>>
> >>>> Oh, and I also sell these widgets singly, by the dozen, and by units
> of
> >>>> 100 and 1000, with the price each dropping as the volume goes up.   So
> >>>> it really doesn’t make sense to have an account for every way they get
> >>>> sold.
> >>>>
> >>>> But here’s my question.   How do I find the invoices containing at
> least
> >>>> one entry for a red type A widget?  I know the information is in
> there,
> >>>> but can I get all the type A widgets reported by what it says in the
> >>>> invoice description?
> >>>>
> >>>> This is a similar question to - I bought a case of bags in which to
> sell
> >>>> my widgets - once - and since it is a rare thing to do I recorded it
> >>>> under “supplies” - which isn’t at all rare - and now I don’t remember
> >>>> who the supplier was.  How do I search the bills to find one for bags?
> >>>> _______________________________________________
> >>>> 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.
> >
> > --
> > Maf. King
> > PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542
> >
> >
> >
>
>
> _______________________________________________
> 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.
>