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

[R. Victor Klassen]

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.