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

[Maf. King]

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